NEW
Font size
WorksheetsQ1 EMPOWERMENT TECHNOLOGIES SUMMATIVE TEST 2
Total questions: 10
Worksheet time: 5mins
A program designed to create spreadsheets that can later be used to analyze statistical data?
MS Word
MS Publisher
MS Excel
MS Powerpoint
Which of the following formula can be used to show the total scores of the students in the subject Empowerment?
=SUM(B3:B9)
=SUM(B3,B9)
=SUM(B3+B9)
=SUM(B3-B9)
This is an Excel function used to count the number of cells that contains something in them if the criteria are met.
COUNT
COUNTIF
COUNTA
COUNTBLANK
Microsoft Excel can perform mathematical equations.
True
False
A function that adds a range of cells
ADD
PLUS
SUM
TOTAL
A function that gets the average of a range of cells.
AVERAGE
SUM
MEAN
MEDIA
The shortcut key for inserting new slide.
Ctrl + E
Ctrl + H
Ctrl + K
Ctrl + M
C
It refers to the motion effects that occur in the Slide Show view when you move from one slide to the next during a presentation?
Animation
Custom Animation
Transition
Custom Slideshow
It is a powerful presentation software that helps you produce an effective presentation in the form of on-screen slides
Microsoft Excel
Microsoft Word
Microsoft PowerPoint
Microsoft Publisher
It is a set of effects which can be applied to text or graphics within a slide
Transitions
Presentation Views
Animation
Design Templates
