Chapter 5: Introduction to MS Excel — Online MCQ Test
INFORMATION TECHNOLOGY · Grade 6 · CBSE(NCERT)
Practice Chapter 5: Introduction to MS Excel with a free chapter-wise online MCQ test.
This chapter covers: Workbook Worksheet Cell Row Column Cell reference Formula Functions AutoFill Spreadsheet basics.
AI-generated questions from basic to board-exam level, with instant results and explanations.
Chapter 5: Introduction to MS Excel — Important Questions & Answers
What is the primary purpose of MS Excel?
- A. To create presentations with slides
- B. To organize, analyze, and calculate data in a spreadsheet format
- C. To write and format text documents
- D. To create vector graphics and drawings
Answer: B. To organize, analyze, and calculate data in a spreadsheet format
MS Excel is a spreadsheet application designed for organizing, analyzing, and performing calculations on data arranged in rows and columns.
MS Excel is a spreadsheet application designed for organizing, analyzing, and performing calculations on data arranged in rows and columns.
Which of the following is the smallest unit in an Excel spreadsheet?
- A. Column
- B. Row
- C. Cell
- D. Worksheet
Answer: C. Cell
A cell is the intersection of a row and column, and it is the smallest unit where data can be entered in Excel.
A cell is the intersection of a row and column, and it is the smallest unit where data can be entered in Excel.
What is a formula in Excel?
- A. A predefined text that cannot be changed
- B. A mathematical or logical expression that performs calculations on data
- C. The title of a worksheet
- D. A type of chart or graph
Answer: B. A mathematical or logical expression that performs calculations on data
A formula is an expression that performs calculations, manipulates data, or returns results based on cell values and operators.
A formula is an expression that performs calculations, manipulates data, or returns results based on cell values and operators.
In the formula =A1*B1+C1, which operation is performed first according to order of operations?
- A. A1*B1
- B. B1+C1
- C. A1+C1
- D. None, all operations are performed simultaneously
Answer: A. A1*B1
According to the order of operations (PEMDAS/BODMAS), multiplication is performed before addition, so A1*B1 is calculated first.
According to the order of operations (PEMDAS/BODMAS), multiplication is performed before addition, so A1*B1 is calculated first.
Which statement is true about cell references in Excel formulas?
- A. Cell references cannot contain both letters and numbers
- B. Cell references are always absolute and do not change when copied
- C. Cell references can be relative (change when copied) or absolute (remain fixed when copied)
- D. Cell references only work within the same row
Answer: C. Cell references can be relative (change when copied) or absolute (remain fixed when copied)
Excel supports both relative references (like A1, which adjust when copied) and absolute references (like $A$1, which remain fixed), providing flexibility in formula design.
Excel supports both relative references (like A1, which adjust when copied) and absolute references (like $A$1, which remain fixed), providing flexibility in formula design.