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 does a workbook contain?
- A. Only one worksheet
- B. Multiple worksheets and charts
- C. Text documents and images
- D. Video files and audio clips
Answer: B. Multiple worksheets and charts
A workbook is an Excel file that can contain multiple worksheets, charts, and other elements for organizing related data.
A workbook is an Excel file that can contain multiple worksheets, charts, and other elements for organizing related data.
In Excel, rows are identified by ______.
- A. Letters (A, B, C, ...)
- B. Numbers (1, 2, 3, ...)
- C. Symbols (@, #, $, ...)
- D. Colors (Red, Blue, Green, ...)
Answer: B. Numbers (1, 2, 3, ...)
Rows in Excel are identified by numbers (1, 2, 3, etc.) that appear on the left side of the spreadsheet.
Rows in Excel are identified by numbers (1, 2, 3, etc.) that appear on the left side of the spreadsheet.
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.
Which of the following is an example of a function in Excel?
- A. =5+3
- B. =A1*B1
- C. =SUM(A1:A5)
- D. =10-2
Answer: C. =SUM(A1:A5)
SUM is a built-in function that adds up a range of cells. Functions are predefined operations that perform specific tasks in Excel.
SUM is a built-in function that adds up a range of cells. Functions are predefined operations that perform specific tasks in Excel.
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.
A student wants to calculate the total of cells A2, A3, A4, and A5. Which formula would be more efficient than writing =A2+A3+A4+A5?
- A. =ADD(A2:A5)
- B. =SUM(A2:A5)
- C. =TOTAL(A2:A5)
- D. =COUNT(A2:A5)
Answer: B. =SUM(A2:A5)
The SUM function is more efficient as it sums a range in one operation, whereas individual addition requires writing out each cell reference.
The SUM function is more efficient as it sums a range in one operation, whereas individual addition requires writing out each cell reference.
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.
If a student creates a formula =COUNT(A1:A10) that counts the number of cells containing numerical values, and then notices the count is lower than expected, what could be a possible reason?
- A. The range A1:A10 contains some text values or empty cells that are not counted
- B. The formula is incorrect and should use SUM instead
- C. Excel has a limit on counting values and cannot count more than 5 cells
- D. The workbook is too large to process the COUNT function
Answer: A. The range A1:A10 contains some text values or empty cells that are not counted
The COUNT function only counts cells containing numerical values; it ignores text, spaces, and empty cells, which explains why the count might be lower than expected.
The COUNT function only counts cells containing numerical values; it ignores text, spaces, and empty cells, which explains why the count might be lower than expected.