Chapter 7: Electronic Spreadsheet Advanced — Online MCQ Test
INFORMATION TECHNOLOGY · Grade 10 · CBSE(NCERT)
Practice Chapter 7: Electronic Spreadsheet Advanced with a free chapter-wise online MCQ test.
This chapter covers: LibreOffice Calc Spreadsheet Goal Seek Scenario Analysis Data Consolidation Worksheet Linking Macros Functions Charts Data Analysis.
AI-generated questions from basic to board-exam level, with instant results and explanations.
Chapter 7: Electronic Spreadsheet Advanced — Important Questions & Answers
In LibreOffice Calc, a cell is identified by the combination of ________.
- A. row number and column letter
- B. sheet name and file size
- C. font name and font size
- D. chart type and data range
Answer: A. row number and column letter
A cell address in Calc is formed by a column letter and a row number, such as A1 or C5.
A cell address in Calc is formed by a column letter and a row number, such as A1 or C5.
Which feature in LibreOffice Calc is used to find the input value needed to achieve a desired result in a formula cell?
- A. Goal Seek
- B. AutoFilter
- C. Freeze Panes
- D. Spell Check
Answer: A. Goal Seek
Goal Seek works backward from a desired result and changes one input cell to reach that result.
Goal Seek works backward from a desired result and changes one input cell to reach that result.
A Scenario in LibreOffice Calc is mainly used to store and compare ________.
- A. different sets of values for selected cells
- B. only spelling errors in a worksheet
- C. different font styles in a document
- D. printer settings for a spreadsheet
Answer: A. different sets of values for selected cells
Scenarios allow users to save different values for certain cells and compare possible outcomes.
Scenarios allow users to save different values for certain cells and compare possible outcomes.
Data Consolidation in LibreOffice Calc is used to ________.
- A. combine data from multiple ranges or sheets
- B. delete all duplicate files from the computer
- C. change text into a drawing object
- D. protect a computer from viruses
Answer: A. combine data from multiple ranges or sheets
Consolidation summarizes and combines data from different ranges, sheets, or files using functions like SUM or AVERAGE.
Consolidation summarizes and combines data from different ranges, sheets, or files using functions like SUM or AVERAGE.
In Goal Seek, which of the following must be a formula cell?
- A. Formula cell
- B. Variable cell
- C. Comment cell
- D. Header cell
Answer: A. Formula cell
The formula cell contains the formula whose result is to be changed to the target value using Goal Seek.
The formula cell contains the formula whose result is to be changed to the target value using Goal Seek.
A student wants to compare monthly savings under three conditions: low expense, normal expense, and high expense. Which Calc feature is most suitable?
- A. Scenario
- B. Page Break
- C. Mail Merge
- D. Find and Replace
Answer: A. Scenario
Scenarios are used to compare different sets of input values and observe their results in the worksheet.
Scenarios are used to compare different sets of input values and observe their results in the worksheet.
If cell C2 contains =A2*B2 and you want C2 to become 500 by changing B2, which Goal Seek setting is correct?
- A. Formula cell C2, target value 500, variable cell B2
- B. Formula cell B2, target value C2, variable cell 500
- C. Formula cell A2, target value B2, variable cell C2
- D. Formula cell 500, target value C2, variable cell A2
Answer: A. Formula cell C2, target value 500, variable cell B2
The result is in C2, the desired result is 500, and the input to be adjusted is B2.
The result is in C2, the desired result is 500, and the input to be adjusted is B2.
A company has sales tables for North, South, and East regions with the same row and column labels. Which option helps Calc match data correctly during consolidation?
- A. Use row and column labels for consolidation
- B. Remove all headings before consolidation
- C. Convert all numbers into text
- D. Insert blank rows between every record
Answer: A. Use row and column labels for consolidation
When tables have labels, using row and column labels helps Calc consolidate corresponding items correctly.
When tables have labels, using row and column labels helps Calc consolidate corresponding items correctly.
A user wants a spreadsheet model to achieve a target profit by changing both selling price and advertising cost at the same time. Why is simple Goal Seek not sufficient?
- A. Goal Seek changes only one variable cell for one target result
- B. Goal Seek can only format charts, not formulas
- C. Goal Seek works only with text labels
- D. Goal Seek cannot use any formula cell
Answer: A. Goal Seek changes only one variable cell for one target result
Goal Seek is designed to change one input cell to reach a desired result in one formula cell; multiple changing variables require a more advanced approach.
Goal Seek is designed to change one input cell to reach a desired result in one formula cell; multiple changing variables require a more advanced approach.
Cell A1 contains 10 and cell B1 contains 20. Cell C1 contains =A1+B1. If Goal Seek is used with formula cell C1, target value 50, and variable cell A1, what value should A1 become?
- A. 30
- B. 20
- C. 40
- D. 50
Answer: A. 30
To make C1 equal to 50 while B1 remains 20, A1 must be 30 because 30 + 20 = 50.
To make C1 equal to 50 while B1 remains 20, A1 must be 30 because 30 + 20 = 50.