WorksheetsNHP ICT Workshop Quiz
Total questions: 10
Worksheet time: 5mins
What is the keyboard shortcut key to lock cell references in a formula?
CTRL
ALT
F4
F2
Which of the following is the correct formula to calculate the average score in cell C8 as shown below?
=SUM(C2:C4)
=SUM(B2:B4)
=AVG(B2:B4)
=AVERAGE(C2:C4)
Where will you find the Conditional Formatting command?
Home>Styles
Home>Format
Insert>Data
Home>Number
Which statement best describes Conditional Formatting?
Adding decimal places to numbers
Adding a preceding dollar sign to numbers.
Changing the font color.
Applying a rule to a cell or range of cells.
These pictorial represent data in Excel
Graphs
Gridlines
Charts
Legends
What symbol is used to start a formula in Excel?
=
&
#
@
The _____ function in Excel is used to count the number of cells that match a single condition applied.
ROUND
COUNT
COUNTIF
SUM
Which shortcut key is used to create a new workbook in Excel?
CTRL + O
CTRL + S
ALT + N
CTRL + N
Statistical calculations and preparation of tables and graphs can be done using
______________.
Powerpoint
Word
Excel
Notepad
Do you think this workshop will be useful for you?
*
**
***
****
*****
