Practice MCQs for Computer Science MS Office
Review structured MCQ sets for Computer Science MS Office. Built according to official NCERT guidelines, these downloadable questions support daily revision and core concept reinforcement.
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 with answers on the Excel 2007 course: the Excel window and navigation, formulas and order of calculation, formatting, functions and filling cells, printing, charts, and the SUMIF, COUNTIF, IF, AND, FREQUENCY, TREND and ZTEST functions.
(a) Microsoft Office button
(b) Quick Access toolbar
(c) Status bar
(d) Name box
Show Answer & Explanation
Answer: (a) Microsoft Office button
Explanation:
1. The Office button menu holds the file commands.
2. The Quick Access toolbar holds frequently used commands.
Teacher's Note:
1. Office button = file menu.
(a) 65,536
(b) 256
(c) 16,384
(d) 1,048,576
Show Answer & Explanation
Answer: (d) 1,048,576
Explanation:
1. Excel 2007 rows are numbered 1 to 1,048,576.
2. Columns run A to Z, AA, AB and so on.
Teacher's Note:
1. More than a million rows.
(a) row E, column 10
(b) column 10, row E
(c) column E, row 10
(d) sheet E10
Show Answer & Explanation
Answer: (c) column E, row 10
Explanation:
1. The column letter comes first, then the row number.
2. A1 is the upper-left cell.
Teacher's Note:
1. Column letter plus row number.
(a) at the bottom of the window
(b) on the left side of the Formula bar
(c) on the Ribbon
(d) on the Title bar
Show Answer & Explanation
Answer: (b) on the left side of the Formula bar
Explanation:
1. It shows the address of the current cell.
2. Cell entries are shown on the right side of the Formula bar.
Teacher's Note:
1. Name box = cell address.
(a) Title bar
(b) Status bar
(c) Formula bar
(d) Quick Access toolbar
Show Answer & Explanation
Answer: (b) Status bar
Explanation:
1. The Status bar gives such information about the selected numbers.
2. The Title bar shows the workbook name.
Teacher's Note:
1. Status = summary at the bottom.
(a) Home
(b) End
(c) Page Up
(d) Tab
Show Answer & Explanation
Answer: (a) Home
Explanation:
1. Ctrl + Home goes to cell A1.
2. Page Up and Page Down move one page.
Teacher's Note:
1. Home = start.
(a) F2
(b) F8
(c) F4
(d) F5
Show Answer & Explanation
Answer: (d) F5
Explanation:
1. F5 or Ctrl + G opens Go To.
2. F2 edits a cell and F8 starts Extend mode.
Teacher's Note:
1. F5 to jump.
(a) edits the cell
(b) deletes the cells
(c) selects the range between them
(d) prints the sheet
Show Answer & Explanation
Answer: (c) selects the range between them
Explanation:
1. F8 anchors the cursor and turns on Extend Selection.
2. Esc turns the highlighting off.
Teacher's Note:
1. F8 = extend.
(a) F5
(b) F8
(c) F2
(d) F1
Show Answer & Explanation
Answer: (c) F2
Explanation:
1. F2 puts the cell in edit mode.
2. Double-clicking the cell does the same.
Teacher's Note:
1. F2 = edit.
(a) Center
(b) Wrap Text
(c) AutoSum
(d) Cut
Show Answer & Explanation
Answer: (b) Wrap Text
Explanation:
1. Wrap Text is on the Home tab.
2. Without it the text overlaps the next cell.
Teacher's Note:
1. Wrap = fold the text.
(a) an equal sign
(b) a plus sign only
(c) a quotation mark
(d) a colon
Show Answer & Explanation
Answer: (a) an equal sign
Explanation:
1. Formulas start with =.
2. Then operators such as + - * / ^ are used.
Teacher's Note:
1. No = no formula.
(a) *
(b) /
(c) %
(d) ^
Show Answer & Explanation
Answer: (d) ^
Explanation:
1. The caret ^ raises a number to a power.
2. * is multiplication.
Teacher's Note:
1. Caret for power.
(a) 36
(b) 24
(c) 90
(d) 30
Show Answer & Explanation
Answer: (d) 30
Explanation:
1. Division and multiplication come first: 12/2*4 = 24.
2. Then 3 + 3 + 24 = 30.
Teacher's Note:
1. Multiply and divide first.
(a) 30
(b) 24
(c) 36
(d) 18
Show Answer & Explanation
Answer: (c) 36
Explanation:
1. Parentheses first: 18.
2. Then 18 / 2 * 4 = 36.
Teacher's Note:
1. Brackets change the order.
(a) to the left
(b) to the right
(c) at the centre
(d) at the top
Show Answer & Explanation
Answer: (b) to the right
Explanation:
1. Text aligns left and numbers align right.
2. Alignment can be changed from the Home tab.
Teacher's Note:
1. Numbers right, text left.
(a) Delete Sheet Columns
(b) Delete Sheet Rows
(c) Delete Cells
(d) Delete Sheet
Show Answer & Explanation
Answer: (a) Delete Sheet Columns
Explanation:
1. After selecting the two columns this command removes them.
2. Delete Sheet Rows removes rows.
Teacher's Note:
1. Match the command to columns.
(a) cell B6 contains an entry
(b) B6 is empty
(c) A6 is bold
(d) the sheet is saved
Show Answer & Explanation
Answer: (a) cell B6 contains an entry
Explanation:
1. Text spills over only into empty cells.
2. The full text is still seen in the Formula bar.
Teacher's Note:
1. Neighbour has data, text is cut.
(a) 3
(b) 6
(c) 12
(d) 9
Show Answer & Explanation
Answer: (d) 9
Explanation:
1. It covers 3 columns and 3 rows.
2. 3 x 3 = 9 cells.
Teacher's Note:
1. Columns times rows.
(a) a range reference only
(b) an error
(c) a union reference
(d) a name
Show Answer & Explanation
Answer: (c) a union reference
Explanation:
1. Commas join several references or numbers.
2. A colon makes a range.
Teacher's Note:
1. Comma = union.
(a) 51
(b) 63
(c) 36
(d) 24
Show Answer & Explanation
Answer: (b) 63
Explanation:
1. 12 + 27 + 24 = 63.
2. AVERAGE of the same cells is 21.
Teacher's Note:
1. Add them.
(a) 63
(b) 21
(c) 27
(d) 12
Show Answer & Explanation
Answer: (b) 21
Explanation:
1. 63 divided by 3 is 21.
2. MIN is 12 and MAX is 27.
Teacher's Note:
1. Sum / count.
(a) fill handle
(b) Name box
(c) context tab
(d) AutoSum
Show Answer & Explanation
Answer: (a) fill handle
Explanation:
1. Dragging the fill handle fills a series.
2. Typing Sun and dragging gives the days of the week.
Teacher's Note:
1. Handle = drag.
(a) Section 1 only
(b) 1, 2, 3
(c) Sunday, Monday
(d) Section 1, Section 2, Section 3 and so on
Show Answer & Explanation
Answer: (d) Section 1, Section 2, Section 3 and so on
Explanation:
1. Excel increases the number in text that ends with a number.
2. Typing 1 and 2 and dragging gives 1, 2, 3.
Teacher's Note:
1. Text plus number continues.
(a) Insert
(b) Data
(c) Page Layout
(d) Review
Show Answer & Explanation
Answer: (c) Page Layout
Explanation:
1. They are in the Page Setup group.
2. Wide margins and Landscape are examples.
Teacher's Note:
1. Print setup is Page Layout.
(a) Editing
(b) Cells
(c) Page Setup
(d) Chart Layout
Show Answer & Explanation
Answer: (c) Page Setup
Explanation:
1. Page Setup group.
2. Editing and Cells belong to the Home tab.
Teacher's Note:
1. Page Setup for pages.
(a) A3
(b) 8 1/2 by 11
(c) 5 by 7
(d) legal 8 1/2 by 14
Show Answer & Explanation
Answer: (b) 8 1/2 by 11
Explanation:
1. Most business correspondence uses 8 1/2 by 11 paper.
2. It can be changed with the Size option.
Teacher's Note:
1. Letter size default.
(a) Column, line, pie, bar, area and scatter
(b) Only column
(c) Only pie
(d) Only line and bar
Show Answer & Explanation
Answer: (a) Column, line, pie, bar, area and scatter
Explanation:
1. A variety of chart types is offered.
2. Each type has sub-types.
Teacher's Note:
1. Many types.
(a) Home, Insert and Data
(b) File, Edit and View
(c) Review, View and Add-Ins
(d) Design, Layout and Format
Show Answer & Explanation
Answer: (d) Design, Layout and Format
Explanation:
1. They appear when a chart is clicked.
2. They are context tabs, shown only when needed.
Teacher's Note:
1. Design, Layout, Format.
(a) Type group
(b) Chart Styles group
(c) Page Setup group
(d) Location group
Show Answer & Explanation
Answer: (d) Location group
Explanation:
1. Move Chart is in the Location group of the Design tab.
2. Choose New Sheet and type a name.
Teacher's Note:
1. Location = where the chart lives.
(a) 900000
(b) 21000
(c) 63000
(d) 28000
Show Answer & Explanation
Answer: (c) 63000
Explanation:
1. The values above 160000 are 200000, 300000 and 400000.
2. Their commissions are 14000 + 21000 + 28000 = 63000.
Teacher's Note:
1. Add the matching commissions.
Free study material for Computer Science
MS Office Objective Questions & Solutions for Computer Science
Chapter MCQs with Answers for Computer Science
Review structured objective questions for Computer Science MS Office. Built according to official NCERT guidelines, these MCQ sets support daily revision and core concept reinforcement.
Expert Practice Material for Computer Science
Cross-reference your completed choices with comprehensive NCERT solutions for Computer Science to ensure absolute clarity across all sub-topics in this chapter.
Complete Your Chapter Revision
Explore our broader library of printable assignments, chapter notes, and mock tests designed to support continuous revision and secure higher marks in NCERT assessments.
FAQs
You can get most exhaustive Microsoft 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 Microsoft 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 Microsoft 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 Microsoft 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.