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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
Free study material for Computer Science
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
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.
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.
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.
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.
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.