Grade 6-7 Term 4 Quiz

What do you call an application which consists of rows and columns?

• Powerpoint

• Spreadsheet

• Worksheet

• Excel

What option to choose to arrange data in descending order?

• AutoSum

• Sort & Filter

• Conditional Formatting

• Merge & Center

Which tool will you use to display only selected data in a worksheet?

• AutoSum

• Conditional Formatting

• Filter

• Format as Table

What do you call the function that provides that highest data in selected cells?

• Min

• Max

• High

• Best

What do you call the function that provides that lowest data in selected cells?

• Min

• Max

• Low

• Down

If Grade 6-7 is at cell F8 and we transfer it to the right 11 times, what will be the cell after?

• F19

• G19

• Q8

• P8

Which menu we can select AutoSum?

• File

• Home

• Insert

• Formulas

Which menu we can select Sort & Filter?

• Home

• Insert

• Formulas

• View

Which option we need to choose to get Max function?

• AutoSum

• Sort & Filter

• Conditional Formatting

• Home

Which ribbon you can insert rows?

• Home

• Insert

• Page Layout

• Formulas