Grade 9 - ICT : MS Excel - Lesson 3 - Quiz 02

Which of the following is the correct syntax of the IF function in Excel?

• = ( IF, Logical_Test , [value_if_TRUE] , [value_if_FALSE] )

• = IF ( Logical_Test , [value_if_TRUE] , [value_if_FALSE] )

• = IF ( [value_if_TRUE] , [value_if_FALSE], Logical_Test )

• = IF ( [value_if_TRUE] , Logical_Test , [value_if_FALSE])

If the value of the cell F2 is 120, what will this IF function give you as a result?

=IF (F2>120, ''Passed'', ''Failed'')

• Passed

• Failed

• #Error

• Not Passed

The Conditional Formatting function in Excel allows you to:

• Automatically apply formatting based on specific rules or conditions being met.

• Automatically apply highlighting to selected cell ranges based on specific rules or conditions being met.

• Automatically change the font of selected cell ranges based on specific rules or conditions being met.

• All of the options listed are correct.

What do you need to include when you are entering a text into your formula?

• Parentheses : ( )

• Quotes : " "

• Angular Brackets : < >

• Square Brackets : [ ]

Observe the given screenshot. Several Conditional Formatting rules have been applied to this worksheet. How can you ascertain which rules have been applied and where?

• Click on the Conditional Formatting button in the Styles group and select Manage Rules.

• Right click in an area of the worksheet that contains conditional formatting and select Format Cells.

• Click on the Conditional Formatting button in the Styles group and select More Rules.

• All of the options listed are correct.

Study the given screenshot. Many Conditional Formatting rules are applied. How can you remove conditional formatting, such as the colored font and blue, pink and green shading, from this worksheet?

• Select the worksheet or range of cells, right click and select Format Cells from the menu list. From here you can remove formatting.

• Select the worksheet or range of cells, click on Delete in the Cells group and select Delete Formatting Only.

• Select the worksheet or range of cells, click on Conditional Formatting and select the Clear Rules option.

• All of the options listed above are correct.

Which type of conditional formatting is shown in this picture ?

• Highlight Cells Rules

• Data Bars

• Color Scales

• Top/Bottom Rules

How many type of conditions are available in conditional formatting on Excel ?

• 4

• 5

• 6

• 8

Immediately after applying a conditional formatting rule, you realize it is a mistake. How do you fix it? Choose the best answer:

• You have to clear the rule you created by going to the Conditional Formatting Rules Manager dialogue box and deleting the rule.

• You have to clear all rules that have been applied to the worksheet or selected range, by clicking on the Clear Rules button.

• You can right click the area where the conditional formatting rule has been applied and select Clear Rule from the menu list.

• You can simply press the Undo button or use the shortcut Ctrl+Z to undo the last rule created.

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

• =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)

• =VLOOKUP(lookup_value, table_array, col_index_num, value)

• =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)