Diagnostic Grade 9

To divide one cell into multiple cells we choose merge cells

• True

• False

The function that checks whether a condition is met and returns one value if true and another value if false, is called VLOOKUP

• True

• False

SUM is a logical function.

• True

• False

To move the sheet to another position right click on the sheet and choose

Select the cells you want to copy then press

• Crtl+C

• shift

• delete

Conditional Formatting It provides another way to visualize data and make worksheets easier to understand

• True

• False

this option lets you split your text into two or more columns______________

• Criteria

• Text layout- column

• Function

The paste result of the pasting option “Paste” is only the formula from the copied cell.

• True

• False

What is Conditional Formatting? 

• It allows you to make borders only. 

•     It is one of the many ways to apply color to your cell. 

•   It provides another way to visualize data and make worksheets easier to understand.

Conditional Formatting It provides another way to visualize data and make worksheets easier to understand

• True

• False