Name: Std.
: Date:
Subject: ICT Classroom Organisation: Individual
Topic: – Spreadsheet-An Introduction
Q.I. Choose the correct option.
a. Which of the following shows the result of Wrap Text formatting applied to a
cell?
i. ii.
iii. iv
b. Your teacher wants to calculate the total marks obtained by Aarya in Science and
Mathematics. What formula will she type in D2?
i. =SUM(B2:D2) ii. =SUM(A2:C2)
iii. =SUM(A2:D2) iv =SUM(B2:C2)
Cambridge21-22 Page 1 of 3
c. Which format will be used to display a date in the following format?
23 January 2022.
i. Short ii. Long
iii. Number iv General
[Link]. Answer in one word.
a. Which cell format should be used to display the numbers as show below?
i. D9822.5
ii. 50.00%
Ans.
i. Accounting number format
………………………
ii. Percent style format
………………………
b. What is the cell address of the active cell in the given spreadsheet?
D5
Ans. ……………………
c. What is the address of the selected range highlighted in the following worksheet?
B1:B8
Ans. ………………………
Cambridge19-20 Page 2 of 3
d. List the shortcut keys for the following tasks
i. Arrow key
To go to a cell in the next column …………………………..
ii. Ctrl+C
To copy a selected cell or a range of cells ……………………
iii. Alt+enter
To type content in a new line in the same cell ……………………
[Link]. Answer in short.
a. What is the default alignment of data typed in a worksheet in Excel?
The left allignment is the default alligment.
Ans. …………………………………………………………………………………………………………
b. A cell contains the data 0.05. What will be the value displayed when you change
the number format to percentage?
5%
Ans. …………………………………………………………………………………………………………
c. How can you quickly calculate the sum of numbers in a range of cells without
typing the SUM function yourself?
We can use autosum to calculate the sum automatically.
Ans. …………………………………………………………………………………………………………
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Cambridge19-20 Page 3 of 3