Excel Quiz

How is the COLUMN in a MS Excel Spreadsheet named?

• Numbers

• Letters

• Cells

• Columns

How are ROWS in MS EXCEL spreadsheet named?

• numbers

• letters

• cells

• columns

What is a rectangular box in a MS EXCEL Spreadsheet called?

• row

• column

• cell

What does every formula in MS EXCEL start with?

• +

• -

• =

• *

What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

• SUMMING

• SUM

• ALL

• None at all

What is an example of a RANGE in MS Excel.

• B2-F5

• F5:B2

• B2:5F

• (B2:F5)

The cell in a spreadsheet application in which data may be entered:

• cell reference
• name box
• active cell
• none of the above

What function was used to find the lowest grade?

• average

• sum

• min

• max

What function was used to find the highest grade?

• average

• min

• sum

• max

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

• user-defined functions

• online functions

• table functions

• predefined functions