Page 30 - 2403_Trackpad_V5.1_C6_Fb
P. 30
Periodic Assessment 1
(Based on chapters 1 & 2)
1. Define the following components of a chart:
a. Legend
______________________________________________________________________________
______________________________________________________________________________
b. Gridlines
______________________________________________________________________________
______________________________________________________________________________
c. Plot Area
______________________________________________________________________________
______________________________________________________________________________
2. Identify the type of referencing used in the following:
a. = A2 + B2 ____________________________________________________
b. = $C$1 - $D$1 ____________________________________________________
c. =($B3*$C3)*$E1 ____________________________________________________
d. = C2 * F2 ____________________________________________________
3. Look at the given chart and answer the following questions:
The Fault in our Stars
October November December January February
a. In which month were the sales of ‘The Fault in our Stars’ highest? ______________
b. In which month were the sales of ‘The Fault in our Stars’ lowest? ______________
4. Guess! Who am I?
a. I help you represent data pictorially. ______________
b. I am also known as XY plot chart. ______________
c. I am an operator used to do basic mathematical operations. ______________
d. I am a predefined formula in Excel. ______________
e. I am a sign used to start a formula. ______________
28 Premium Edition-VI

