NHP ICT Workshop Quiz

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)

3. 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?

• *

• **

• ***

• ****

• *****