WorksheetsQ1-Module2-Lesson1:Developing ICT content for specific purposes (ETECH)
Total questions: 10
Worksheet time: 5mins
The following are formulas that MS-Excel can understand, EXCEPT.
=Sum(a1+a2)
=average(a1+a2)
=a1+b2
=1a+b2
Which of the following button do you select if you want to Open a new
document?
This error value refers to a cell that contains 0 value or blanks.
#N/A
#VALUE!
#NULL!
#DIV/0
Which of the following arithmetic operators is use for exponentiation?
+
-
^
*
Which of the following software are commonly used for presentation that
contains animation?
Microsoft Word
Microsoft Excel
LibreOffice Calc
PowerPoint
Which of the following errors will appear if Excel encounters invalid cell
reference.
#REF!
#N/A
#Value!
######
Which of the following errors will appear if Excel encounters invalid cell
has inappropriate value was given for the lookup value argument.
#REF!
#N/A
#Value!
######
Which of the following set of effects that can be found in PowerPoint
apps?
Mailings
Custom Animation
Layout group
Hyperlink
A function used to count the number of cells that contains something if
the criteria are met.
a. COUNT c. COUNTING
b. COUNTNOW d. COUNTIF
COUNT
COUNTNOW
COUNTING
COUNTIF
What button allows you to see the result of your mail merge even before
you print or send it out?
Address book
Preview Results
Greeting line
Start Mail Merge
