Grade 11 MidTerm Exam

What is a box called in a spreadsheet?

• Cell

• Box

• Rectangle

• Square

What are the labels for the columns?

• Letters

• Numbers

What tool do you use to colour cells?

• Fill colour

• Colour cell

• Paint Bucket

• Auto Fill

What command allows you to leap to the last row of the spreadsheet?

• CTRL + (Down Arrow)

• ALT + (Down Arrow)

• SHIFT + (Down Arrow)

• CTRL + SHIFT + (Down Arrow)

You hold which key on the keyboard to select separate groups of cells?

• CTRL

• SHIFT

• ALT

• DEL

How do you get back to the top of the spreadsheet?

• CTRL + (Up arrow)

• ALT + (Up arrow)

• SHIFT + (Up arrow)

• DEL + (Up arrow)

Which symbol is used for multiplication in formula?

• *

• /

• x

• @

What is the name of the function that adds up a list of numbers?

• SUM

• AVERAGE

• ALL

• ADDUP

Which function can you use to round numbers?

• SUM

• AVERAGE

• ROUND

• MAX

What symbol do all functions or formulas start with?

• =

• ^

• +

• !