Page 205 - CA_165_V2.0_C9_Flipbook
P. 205
Solved Exercise
SECTION A
(Objective Type Questions)
A. Multiple choice questions.
1. What is a spreadsheet package primarily used for?
i. Writing essays ii. Analysing data and performing calculations
iii. Playing games iv. Sending emails
2. Which of the following is NOT a feature of a spreadsheet package?
i. Handling bulk data ii. Performing long calculations
iii. Writing programming code iv. Creating charts and graphs
3. What is the default number of worksheets in a new OpenOffice Calc spreadsheet?
i. 1 ii. 2
iii. 3 iv. 5
4. How are rows numbered in OpenOffice Calc?
i. A to Z ii. 1, 2, 3, …
iii. Roman numerals iv. Random numbers
5. Which key combination is used to save an OpenOffice Calc spreadsheet for the first time?
i. Ctrl + N ii. Ctrl + S
iii. Ctrl + Shift + S iv. Ctrl + O
Ans. 1. ii. 2. iii. 3. iii. 4. ii. 5. iii.
B. Fill in the blanks.
1. OpenOffice Calc is a .................................... software.
2. A spreadsheet is a .................................... of multiple sheets.
3. A .................................... is an intersection of a row and a column.
4. .................................... displays the content of the active cell.
5. .................................... displays the address of the active cell.
6. To view the current status of an active sheet we can refer to the .....................................
7. There are .................................... columns in a OpenOffice Calc spreadsheet.
Ans. 1. spreadsheet 2. combination 3. cell 4. Formula bar 5. Name box 6. Status bar
7. 1024
C. Assertion and Reasoning question:
The following questions consist of two statements – Assertion (A) and Reasoning (R). Answer these
questions by selecting the appropriate option given below:
i. Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).
ii. Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A).
iii. Assertion (A) is true, but Reason (R) is false.
Working with Spreadsheet 203

