Page 281 - TP_IT_V1.0_C10_flipbpookl
P. 281
Exercise
Solved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. Data available in other sheets in a workbook, can be consolidate by .
a. Row label b. Column Label
c. Both a & b d. None of the mentioned
2. What all operations can we perform using data consolidation?
a. Max b. Min
c. Average d. All of these
3. analysis tool works in reverse order, finding input based on the output.
a. Consolidate function b. Goal seek
c. What-if analysis d. Scenario
4. Goal seek is a Tool.
a. Comparison b. What-if analysis
c. consolidate d. Additional
5. What is the purpose of using macros in a computer?
a. To manually enter data b. To automate repetitive tasks
c. To increase the speed of internet browsing d. To create complex formulas
6. Which function cannot be performed through Subtotal in a Spreadsheet? [CBSE Sample Paper 2022]
a. Sum b. Product
c. Average d. Percentage
7. Which type of questions are tested by using the Scenarios?
a. Auto b. Short
c. What-if d. Long
8. It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to
calculate. [CBSE Sample Paper 2022]
a. Row b. Column
c. Autosum d. Cell Reference
9. Which of the following is more elaborate form of Goal Seek? [CBSE Sample Paper 2022]
a. Subtotal b. Scenario
c. Solver d. Consolidate
10 means combining data in a spreadsheet from different worksheets into master worksheet.
[CBSE Sample Paper 2022]
a. Hyperlinks b. Consolidating
c. Linking d. Filter
11. Which of the following is the correct step to record changes?
a. Edit → Track Changes → Record b. File → Track Changes → Record Changes
c. Tools → Track Changes → Record Changes d. Data → Track Changes → Record Changes
12. Which of the following menu contains the Subtotal option?
a. File b. Data
c. Tools d. Insert
Electronic Spreadsheet (Advanced) using LibreOffice Calc 279

