Multiple Choice Questions (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.
Practice MS Office MCQs for Computer Science
Navigate directly to the 50 objective questions for MS Office using the digital viewer below. Each practice set includes verified answer keys, allowing students to instantly cross-check their work and identify areas requiring further revision.
Eight multiple choice and true or false questions on the Excel spreadsheet, covering workbooks, inserting a sheet, default alignment, rows and columns, the active cell, formulas and formatting. Answers are given with brief reasons.
Spreadsheet Questions
(a) it contains text and data
(b) it can be modified
(c) it can contain many sheets including worksheets and chart sheets
(d) it can be used for calculation
Show Answer & Explanation
Answer: (c) it can contain many sheets including worksheets and chart sheets
Explanation:
1. A workbook is a collection of sheets, such as worksheets and chart sheets.
2. Containing data, being editable or calculating are true of any file and do not explain the name.
Teacher's Note:
1. Workbook = book of sheets.
2. Excel gives three worksheets by default.
(a) F11
(b) Alt+F11
(c) Shift+F11
(d) Ctrl+F11
Show Answer & Explanation
Answer: (c) Shift+F11
Explanation:
1. Shift+F11 inserts a new worksheet in Excel.
2. Alt+F11 opens the Visual Basic editor and the others do not insert a sheet.
Teacher's Note:
1. Remember Shift+F11 = new sheet.
2. A sheet can also be added by right-clicking a sheet tab and choosing Insert.
(a) left aligned
(b) right aligned
(c) centre aligned
(d) justified
Show Answer & Explanation
Answer: (b) right aligned
Explanation:
1. Numbers, formulas and dates are values and are right aligned by default.
2. Text is the one aligned to the left.
Teacher's Note:
1. Text left, numbers right.
2. Alignment buttons are in the Alignment group of the Home tab.
(a) Lines and spaces
(b) Layers and planes
(c) Rows and columns
(d) Height and width
Show Answer & Explanation
Answer: (c) Rows and columns
Explanation:
1. A spreadsheet is a grid made of rows and columns.
2. The crossing of a row and a column is a cell.
Teacher's Note:
1. Rows run across, columns run down.
2. Cell address = column letter + row number.
(a) a dotted border
(b) a dark wide border
(c) a blinking border
(d) italic text
Show Answer & Explanation
Answer: (b) a dark wide border
Explanation:
1. The active cell is shown with a dark, wide outline.
2. A dotted or blinking border shows a copied or other state, not the active cell.
Teacher's Note:
1. The active cell is where typing goes.
2. Its contents appear in the formula bar.
(a) True
(b) False
Show Answer & Explanation
Answer: (a) True
Explanation:
1. Formulas use cell values with operators such as +, -, * and /.
2. They always begin with an equal sign.
Teacher's Note:
1. Start every formula with =.
2. Functions are predefined formulas.
(a) True
(b) False
Show Answer & Explanation
Answer: (a) True
Explanation:
1. Formatting changes how data looks (font, alignment, number format) without changing its meaning.
2. It is done mainly from the Home tab.
Teacher's Note:
1. Formatting = appearance.
2. Every cell can be formatted differently.
(a) True
(b) False
Show Answer & Explanation
Answer: (b) False
Explanation:
1. The dark outline marks the active cell, not the formula bar.
2. The formula bar is a separate area above the grid that shows the active cell's contents.
Teacher's Note:
1. Dark outline = active cell.
2. The formula bar carries the fx label.
Free study material for Computer Science
Multiple Choice Questions (MCQs) for Computer Science MS Office
Download Multiple Choice Questions: MS Office ( 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.
Concept Clarification for MS Office
Cross-reference your completed choices with comprehensive NCERT solutions for Computer Science to ensure absolute clarity across all sub-topics in this chapter.
Additional Study Resources for Computer Science
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 IT Tools and Business Systems Chapter 05 Spreadsheet 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 IT Tools and Business Systems Chapter 05 Spreadsheet 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 IT Tools and Business Systems Chapter 05 Spreadsheet 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 IT Tools and Business Systems Chapter 05 Spreadsheet MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.