Page 48 - KEC Khaitan C6 Flipbook
P. 48
Periodic Assessment 1
(Based on chapters A1 to A3)
1. Write 'T' for true and 'F' for false.
a. The Undo command in Excel allows you to reverse multiple actions.
b. A formula in Excel must always start with a "+" sign.
c. The Fill Handle helps to automatically enter a sequence of numbers in a column.
d. A Pie Chart is the best option to compare data between different categories.
e. The function =SUM(A1:A5) will multiply the values in the given range.
2. Match the following:
a. Absolute Reference i. Used to find the total of a given range
b. MAX() Function ii. Displays the relationship between two variables
c. Scatter Chart iii. Refers to a fixed cell using $ sign
d. AutoFill iv. Finds the highest value in a selected range
e. SUM() Function v. Helps in copying patterns in a sequence
3. Name the following:
a. _____________________________
b. _____________________________
46 Premium Edition-VI

