Basic Spreadsheet Formulas

Which formula would add the January and February profits?

• B2+B3

• B2+B3=

• B3+B4=

• =B2+B3

What value would the following formula return? =2+3*4-1

• 17

• 19

• 13

• 11

Now that the formula has parentheses, what value would the following formula return?

• 17

• 19

• 13

• 11

Which of the following is a relative cell reference?

• $C$2

• $C2

• !C2

• C2

If you wanted to make an absolute reference to cell E2, what would it look like?

• [E2]

• E2

• @E2

• $E$2

Which of the following functions is using the correct syntax?

• SUM=(A2:A8,E2:E8)

• =A2:A8(SUM)E2:E8

• =SUM(A2:A8,E2:E8)

• SUM(A2:A8,E2:E8)=

In this example, we want to use the formula =MAX(B3:D7)

What would that formula find?

• The total number of items sold between January and March

• The average number of cakes sold in March

• The smallest amount of an item ordered in March

• The largest amount of an item ordered between January and March

Someone is trying to find the average profit amount between January and July, using the formula in cell B9.

What mistake did this person make?

• The location of the equals sign

• Using the incorrect range

• Using an incorrect formula

• Using parentheses in the formula

What format is best for things like ID numbers, ZIP codes, and phone numbers?

• Text

• Date

• Percentage

• Currency

What is the formula in cell B3 doing?

• Multiplying inventory costs by the total budget

• Subtracting inventory costs from the total budget

• Subtracting the total budget from inventory costs

• Finding the average budget total