Advanced Excel Course Mixed Topics MCQs Set 01

Practice MCQs for Computer Science MS Office

Access targeted multiple-choice questions for MS Office designed to align with the latest NCERT academic syllabus for Computer Science. These objective practice sets help students evaluate their conceptual understanding and improve exam readiness.

Access MS Office Questions and Solutions

Access the complete set of multiple-choice questions for MS Office below. This focused format allows students to isolate specific topics for thorough review and uninterrupted practice alongside official NCERT textbooks.

Thirty multiple choice questions on advanced Excel with answers and explanations: the Fill and Series options, sorting, Paste Special, Advanced Filter, text, logical, maths, statistical and lookup functions, financial functions, pivot tables and keyboard shortcuts.

Question 1: Which shortcut copies the cell above into the selected cells below (Fill Down)?
(a) Ctrl + D
(b) Ctrl + R
(c) Ctrl + E
(d) Ctrl + B
Show Answer & Explanation

Answer: (a) Ctrl + D

Explanation:
1. Ctrl + D is Fill Down.
2. Ctrl + R is Fill Right, Ctrl + E is Flash Fill and Ctrl + B is Bold.

Teacher's Note:
1. D for Down, R for Right.

Question 2: Which Fill command copies the same data to the same cells of several selected worksheets?
(a) Justify
(b) Series
(c) Flash Fill
(d) Across Worksheets
Show Answer & Explanation

Answer: (d) Across Worksheets

Explanation:
1. Across Worksheets copies the selected cells to the other selected sheets.
2. Its dialog box offers All, Contents and Formats.

Teacher's Note:
1. Select all the sheets first with Shift + click on the tabs.

Question 3: In the Series dialog box, a Growth series starting at 2 with Step value 2 gives
(a) 2, 4, 6, 8, 10
(b) 2, 22, 222
(c) 2, 4, 8, 16, 32
(d) 2, 3, 4, 5, 6
Show Answer & Explanation

Answer: (c) 2, 4, 8, 16, 32

Explanation:
1. In a Growth series each value is multiplied by the step value.
2. So 2 becomes 4, 8, 16, 32 and so on.

Teacher's Note:
1. Linear adds the step, Growth multiplies by it.

Question 4: With the Weekday date unit of the Series dialog box, which days are skipped?
(a) Monday and Tuesday
(b) Saturday and Sunday
(c) Only Sunday
(d) Friday and Saturday
Show Answer & Explanation

Answer: (b) Saturday and Sunday

Explanation:
1. Weekday fills only the working days.
2. Saturdays and Sundays are left out of the series.

Teacher's Note:
1. Weekday means Monday to Friday.

Question 5: Which button of the Sort dialog box adds a Then by row?
(a) Copy Level
(b) Add Level
(c) Options
(d) Delete Level
Show Answer & Explanation

Answer: (b) Add Level

Explanation:
1. Add Level creates another sorting level.
2. A second level is used when the first column has equal values.

Teacher's Note:
1. Level means one more sorting rule.

Question 6: If only one column is selected before sorting, Excel shows the Sort Warning. Which choice keeps the rows together?
(a) Expand the selection
(b) Continue with the current selection
(c) Cancel the data
(d) Delete the neighbouring data
Show Answer & Explanation

Answer: (a) Expand the selection

Explanation:
1. Expand the selection includes the neighbouring columns in the sort.
2. Continuing with the current selection sorts only that column and breaks the rows.

Teacher's Note:
1. Always expand the selection for tables.

Question 7: Which Sort Options setting is used to sort data that is arranged across a row?
(a) Sort top to bottom
(b) Case sensitive
(c) My data has headers
(d) Sort left to right
Show Answer & Explanation

Answer: (d) Sort left to right

Explanation:
1. Orientation Sort left to right sorts the columns of a row.
2. Sort top to bottom is the default for lists.

Teacher's Note:
1. Orientation decides the direction of sorting.

Question 8: Which key combination opens the Paste Special dialog box?
(a) Ctrl + Shift + V
(b) Ctrl + Alt + C
(c) Ctrl + Alt + V
(d) Alt + F4
Show Answer & Explanation

Answer: (c) Ctrl + Alt + V

Explanation:
1. Ctrl + Alt + V opens Paste Special.
2. Ctrl + V alone is the ordinary paste.

Teacher's Note:
1. V for paste plus Ctrl and Alt.

Question 9: Which Paste Special option pastes only the results of formulas, not the formulas?
(a) Formats
(b) Comments
(c) Values
(d) Validation
Show Answer & Explanation

Answer: (c) Values

Explanation:
1. Values pastes the calculated numbers or text only.
2. The formula bar then shows the number and not the formula.

Teacher's Note:
1. Values = results only.

Question 10: In Paste Special, copying a cell with 10 and pasting with Add on cells 1 to 10 gives
(a) 10 to 100
(b) 11 to 20
(c) 1 to 10
(d) 0 to 9
Show Answer & Explanation

Answer: (b) 11 to 20

Explanation:
1. Add adds 10 to every destination cell.
2. So 1 becomes 11 and 10 becomes 20.

Teacher's Note:
1. Operation changes the existing values.

Question 11: What does the Skip blanks option of Paste Special do?
(a) Blank copied cells do not overwrite the destination cells
(b) It deletes all blank rows
(c) It fills blanks with zero
(d) It hides the blank cells
Show Answer & Explanation

Answer: (a) Blank copied cells do not overwrite the destination cells

Explanation:
1. Skip blanks protects the destination data from blank cells of the copied range.
2. Only the non-blank copied cells are pasted.

Teacher's Note:
1. Skip = leave the old data alone.

Question 12: In the Advanced Filter dialog box, which action puts the filtered rows in a different place?
(a) Filter the list, in-place
(b) Unique records only
(c) Criteria range
(d) Copy to another location
Show Answer & Explanation

Answer: (d) Copy to another location

Explanation:
1. Copy to another location writes the result to the Copy to range.
2. Filter the list, in-place hides rows within the list itself.

Teacher's Note:
1. Copy to keeps the original list unchanged.

Question 13: Which function changes the first letter of every word to a capital letter?
(a) UPPER
(b) LOWER
(c) TRIM
(d) PROPER
Show Answer & Explanation

Answer: (d) PROPER

Explanation:
1. PROPER capitalizes each word and makes the other letters small.
2. UPPER makes all letters capital.

Teacher's Note:
1. Proper names start with capitals.

Question 14: Which function removes extra spaces from text?
(a) LEN
(b) EXACT
(c) TRIM
(d) MID
Show Answer & Explanation

Answer: (c) TRIM

Explanation:
1. TRIM removes leading, trailing and repeated spaces.
2. LEN only counts characters.

Teacher's Note:
1. Trim = cut away the spaces.

Question 15: What does =LEN(A2) return when A2 holds Jameson?
(a) 8
(b) 7
(c) 6
(d) Jameson
Show Answer & Explanation

Answer: (b) 7

Explanation:
1. Jameson has seven letters.
2. LEN counts all characters including spaces.

Teacher's Note:
1. Count the letters one by one.

Question 16: Which function returns TRUE only when two texts are exactly the same?
(a) EXACT
(b) LEFT
(c) RIGHT
(d) CONCATENATE
Show Answer & Explanation

Answer: (a) EXACT

Explanation:
1. EXACT compares two texts and gives TRUE or FALSE.
2. Paper and Paper give TRUE, Printer and Printers give FALSE.

Teacher's Note:
1. Exact means identical.

Question 17: In the bonus example with OR, an employee gets 45% if
(a) any one sale amount is 5000 or more
(b) all sale amounts are 5000 or more
(c) no sale amount is 5000
(d) the total is zero
Show Answer & Explanation

Answer: (a) any one sale amount is 5000 or more

Explanation:
1. OR is true when at least one condition is true.
2. If every sale is below 5000 the result is Not Bonus.

Teacher's Note:
1. OR = any one; AND = all.

Question 18: In the AND bonus example, 52% is given when
(a) any one sale amount is 12000 or more
(b) the first amount is zero
(c) all amounts are below 12000
(d) all the sale amounts are 12000 or more
Show Answer & Explanation

Answer: (d) all the sale amounts are 12000 or more

Explanation:
1. AND needs every condition to be true.
2. Otherwise the 12% result is returned.

Teacher's Note:
1. AND = all conditions.

Question 19: With =IF(H4>300,"PASS","FAIL"), a total of 293 gives
(a) PASS
(b) 300
(c) FAIL
(d) Error
Show Answer & Explanation

Answer: (c) FAIL

Explanation:
1. 293 is not greater than 300.
2. So the false value FAIL is returned.

Teacher's Note:
1. Check the condition first.

Question 20: What does =ODD(12) return?
(a) 12
(b) 13
(c) 11
(d) 14
Show Answer & Explanation

Answer: (b) 13

Explanation:
1. ODD rounds up to the next odd integer.
2. 12 is even, so the next odd number 13 is returned.

Teacher's Note:
1. ODD goes up, never down.

Question 21: What does =LCM(3,6,9) return?
(a) 9
(b) 18
(c) 3
(d) 54
Show Answer & Explanation

Answer: (b) 18

Explanation:
1. The smallest number divisible by 3, 6 and 9 is 18.
2. 9 is not divisible by 6.

Teacher's Note:
1. Check divisibility by every number.

Question 22: What does =GCD(15,25,35) return?
(a) 5
(b) 15
(c) 1
(d) 35
Show Answer & Explanation

Answer: (a) 5

Explanation:
1. The largest number dividing 15, 25 and 35 is 5.
2. 15 does not divide 25.

Teacher's Note:
1. GCD is the greatest common divisor.

Question 23: Which function adds only the quantities of rows that match a stated item name?
(a) SUMPRODUCT
(b) COUNTIF
(c) SUBTOTAL
(d) SUMIF
Show Answer & Explanation

Answer: (d) SUMIF

Explanation:
1. SUMIF adds the cells that meet a condition.
2. COUNTIF only counts them.

Teacher's Note:
1. SUM + IF.

Question 24: In SUBTOTAL, which function number gives the sum?
(a) 1
(b) 2
(c) 9
(d) 5
Show Answer & Explanation

Answer: (c) 9

Explanation:
1. SUBTOTAL(9, range) adds the visible cells of a filtered list.
2. 2 is COUNT and 5 is MIN.

Teacher's Note:
1. Nine means SUM.

Question 25: Which function counts the cells that are not empty?
(a) COUNT
(b) COUNTBLANK
(c) COUNTA
(d) MEDIAN
Show Answer & Explanation

Answer: (c) COUNTA

Explanation:
1. COUNTA counts numbers and text, every non-empty cell.
2. COUNT counts only numbers.

Teacher's Note:
1. A in COUNTA = all kinds of data.

Question 26: What does =LARGE(B2:E2,2) return?
(a) The largest value
(b) The second largest value
(c) The second smallest value
(d) The sum of two values
Show Answer & Explanation

Answer: (b) The second largest value

Explanation:
1. The second argument is the rank k.
2. k = 2 gives the second largest.

Teacher's Note:
1. SMALL counts from the bottom.

Question 27: In =VLOOKUP(A15,A1:E11,3,0) the number 3 means
(a) the third column of the table
(b) the third row
(c) the third match
(d) three decimal places
Show Answer & Explanation

Answer: (a) the third column of the table

Explanation:
1. VLOOKUP returns a value from the stated column of the table range.
2. The 0 asks for an exact match.

Teacher's Note:
1. V for vertical, look down column one.

Question 28: Which function finds the position of a value in a list?
(a) INDEX
(b) ROUND
(c) FACT
(d) MATCH
Show Answer & Explanation

Answer: (d) MATCH

Explanation:
1. MATCH returns the position number.
2. INDEX uses the position to return the value.

Teacher's Note:
1. Match gives position.

Question 29: How is the TRANSPOSE array formula confirmed?
(a) Enter
(b) Ctrl + Enter
(c) Alt + Enter
(d) Ctrl + Shift + Enter
Show Answer & Explanation

Answer: (d) Ctrl + Shift + Enter

Explanation:
1. Array formulas need Ctrl + Shift + Enter and show curly brackets.
2. A plain Enter would give one result only.

Teacher's Note:
1. Three keys for an array.

Question 30: Which function converts a decimal number to binary?
(a) BIN2DEC
(b) FACT
(c) DEC2BIN
(d) POWER
Show Answer & Explanation

Answer: (c) DEC2BIN

Explanation:
1. DEC2BIN gives the binary form, for example 25 becomes 11001.
2. BIN2DEC does the reverse.

Teacher's Note:
1. Dec to Bin.

Multiple Choice Questions (MCQs) for Computer Science MS Office

Computer Science MS Office Objective Test Questions

Explore reliable practice questions for MS Office tailored for Computer Science learners. Use these multiple-choice formats to evaluate preparedness and strengthen problem-solving skills.

NCERT-Aligned Objective Questions and Solutions

Built using the official NCERT book for , these Computer Science objective sets provide reliable academic guidance. Pair your practice with our recommended NCERT solutions to master optimal problem-solving approaches.

Next Steps in Your Exam Preparation

Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.

FAQs

Where can I access latest Advanced Excel Course Mixed Topics MCQs Set 01?

You can get most exhaustive Advanced Excel Course Mixed Topics MCQs Set 01 for free on StudiesToday.com. These MCQs for Computer Science are updated for the 2026-27 academic session as per examination standards.

Are Assertion-Reasoning and Case-Study MCQs included in the Computer Science [current-page:node:field_class] material?

Yes, our Advanced Excel Course Mixed Topics MCQs Set 01 include the latest type of questions, such as Assertion-Reasoning and Case-based MCQs. 50% of the paper is now competency-based.

How do practicing Computer Science MCQs help in scoring full marks in [current-page:node:field_class] exams?

By solving our Advanced Excel Course Mixed Topics MCQs Set 01, students can improve their accuracy and speed which is important as objective questions provide a chance to secure 100% marks in the Computer Science.

Do you provide answers and explanations for Advanced Excel Course Mixed Topics MCQs Set 01?

Yes, Computer Science MCQs for have answer key and brief explanations to help students understand logic behind the correct option as its important for 2026 competency-focused exams.

Can I practice these Computer Science [current-page:node:field_class] MCQs online?

Yes, you can also access online interactive tests for Advanced Excel Course Mixed Topics MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.