Page 237 - IT 402 v2.0 class 10
P. 237
5. Reviewers and authors can add their ............................. to explain their changes in the cell of Spreadsheet.
[CBSE Sample Paper, 2023]
i. Comments ii. Hyperlink
iii. Worksheet iv. Macros
6. In Calc, Arguments passed to a macro from Calc are always ............................. . [CBSE Sample Paper, 2023]
i. Cell Reference ii. Value
iii. Both a and b iv. Sheet Reference
B. State whether these statements are true or false.
1. Comments are once added cannot be deleted from the worksheet.
2. Comments appear only when mouse pointer is hovered over the Sheet tab.
. Macros are pre-defined steps to make the tasks of the users easy.
. rack hanges feature is available in OpenO ce for word processing documents and spreadsheets.
5. Macro recorded and saved in one worksheet can be used in other worksheets also.
Section B
(Subjective Type Questions)
A. Answer the following questions:
. hat is sorting ow do you sort data in OpenO ce alc using macro
2. What is the purpose of adding comments?
3. Write a short note on formatting comments.
. xplain in briefly the steps to start recording a macro.
5. hat are the steps to be followed to use a macro defined in an earlier worksheet
S ub j e ct E nr ich me nt
B. Application based questions:
he following data is from the final attendance of an organisation. nswer the following uestion.
Employee Attendance Report
Emp. ID Employee Name In-Time Out-Time Attendance
201 Sonia 09:30 06:15 Present
202 Atul 09:43 07:10 Present
203 Rajeshwari 08:45 05:45 Present
204 Rohit 10:15 02:20 Absent
205 Neha 09:03 06:43 Present
a. Increase the In-Time of Rajeshwari by 15 minutes. Apply the features of recording change to record this change.
b. Sort the In-Time column in ascending order.
Previous Years’ Questions
1. Macros are especially useful to ............................. the same way over and over again. [2023]
(a) repeat a task (b) reject a task
(c) report a task (d) comment a task
Ans. (a)
More About Spreadsheet 235

