Page 50 - TrackpadV5.1_class7
P. 50
Periodic Assessment 1
(Based on chapters 1 to 3)
1. Match the following:
a. (11111) (i) (10111) 2
2
b. (23) (ii) (49) 10
10
c. (35) (iii) (31)
10
8
d. (110001) (iv) (11101) 2
2
2. Write the purpose of the following functions:
a. IF()
___________________________________________________________________
b. SUM()
___________________________________________________________________
3. Guess! Who am I?
a. I am a group of the Home tab that contains the Sort & Filter command. __________
b. I am a feature in Excel to separate unwanted data from a range of data. __________
c. I am a feature in Excel to arrange data in ascending or descending order. __________
d. I am a type of formatting that can be applied on the basis of criteria. __________
4. Match the functions with shortcut methods of doing it:
1. Panning a. Hold down Spacebar + Ctrl to turn your cursor into a
magnifying glass. Now drag your pen up and down to
zoom your canvas in and out.
2. Changing brush size b. Hold down the Ctrl key to turn your cursor into an eye
dropper. Now tap the pen on the canvas, the colour that
is underneath will be picked up for you to use.
3. Colour Selecting c. Hold down the Spacebar key to turn your cursor into a
hand. Now drag your pen around to move the canvas
left, right, up, or down.
4. Zooming in/out d. Activate the Freehand Brush tool from the Toolbar. Now
hold down Shift + drag your pen left or right, your brush
size will adjust until you lift your pen.
48 Pro (V5.1)-VII

