Spreadsheet Modelling

Question 1

The formula =B12/7 is

Accepted Answer

Correct

Question 2

What is the spreadsheet symbol for Division?

Accepted Answer

/

Question 3

What is the spreadsheet symbol * used for?

Accepted Answer

Multiplication

Question 4

This function works out the average of a range of cells

Accepted Answer

=AVERAGE()

Question 5

Which is an example of a cell reference (address)?

Accepted Answer

A1

Question 6

The formula that calculates the TOTAL of a range of cells

Accepted Answer

=sum(A1:D1)

Question 7

A spreadsheet can do the calculations for you if set up correctly?

Accepted Answer

TRUE

Question 8

What symbol does a formula begin with?

Accepted Answer

=

Question 9

What function do you use to find the largest value in a range of cells?

Accepted Answer

MAX

Question 10

A spreadsheet is made up of...

Accepted Answer

columns, rows, cells

Questions 10