Page 208 - CA_165_V2.0_C9_Flipbook
P. 208
Ans. 1. AutoFill 2. Custom List
SECTION C
(Case-based/Passage-based Type Questions)
A company manager is using OpenOffice Calc to prepare an employee attendance sheet. He needs to:
● Enter employee names and their daily attendance (P for present, A for absent).
● Ensure that the names are fully visible within the cells.
1. Which feature should he use to display full employee names without changing the column width?
2. By default, where is text aligned in a Calc cell?
3. How can he quickly fill in attendance for multiple employees without typing manually?
Ans. 1. Wrap Text 2. Left alignment 3. AutoFill
Unsolved Exercise
SECTION A
(Objective Type Questions)
A. Multiple choice questions.
1. Which feature is used to display data graphically in spreadsheets?
i. Charts ii. Pivot Table
iii. Data Sort iv. Hyperlink
2. Which of the following is NOT a valid cell reference in OpenOffice Calc?
i. A1 ii. B2
iii. 1A iv. C3
3. Which menu option allows you to insert a new sheet in OpenOffice Calc?
i. File ii. Edit
iii. Insert iv. Tools
4. What is the shortcut key to save a document in OpenOffice Calc?
i. Ctrl + S ii. Ctrl + P
iii. Ctrl + O iv. Ctrl + N
5. Which type of data can be entered into a cell in OpenOffice Calc?
i. Text ii. Numbers
iii. Formulas iv. All of these
6. To enter a formula in OpenOffice Calc, which symbol must be used first?
i. # ii. =
iii. @ iv. $
B. Fill in the blanks.
1. A OpenOffice Calc sheet contains .................................... columns and 65,536 rows.
2. .................................... helps to change the direction of contents in a cell.
3. Series of numbers can be filled using .................................... feature.
4. .................................... button is used to enter or edit formula in OpenOffice Calc.
206 Touchpad Computer Applications (Ver. 2.0)-IX

