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.
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.
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 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.