End of year quiz: Spreadsheet Modelling

What is the Sum formula?

• Sum( )

• Sum( )=

• =Sum( )

• =( )Sum

When starting a formula what is the first thing you type in the cell?

• +

• -

• %

• =

The letters in Excel represent the _______?

• columns

• rows

• data

• functions

The numbers in Excel represent the _____?

• columns

• rows

• data

• functions

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

You can only work in one cell at a time. The actual cell that you are working in is called what?

• Column
• Name Box
• Active Cell
• Row

What is the term used where a column and row intersect?

• Toolbar
• Cell
• Name Box
• Formula Bar

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

If the cell contains hashtags (#), what do you need to do?

• Expand the column
• Expand the row
• Change the formula

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM