Chapter Exam

Chapter 5: Introduction to MS Excel — Online MCQ Test

Q: Which of the following is the smallest unit in an Excel spreadsheet?

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.

Q: In the formula =A1*B1+C1, which operation is performed first according to order of operations?

Answer: A. A1*B1 — According to the order of operations (PEMDAS/BODMAS), multiplication is performed before addition, so A1*B1 is calculated first.

INFORMATION TECHNOLOGY · Grade 6 · CBSE(NCERT)

Practice Chapter 5: Introduction to MS Excel with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 6 INFORMATION TECHNOLOGY. 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.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter 5: Introduction to MS Excel — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 6 INFORMATION TECHNOLOGY — Chapter 5: Introduction to MS Excel, with answers and explanations. These are sample questions; the exam has its own separate question set.

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.

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.

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.

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.

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.