Absolute Cell Reference in Spreadsheet

When the data for a cell remains constant after it is copied, this cell reference is known as:

• Sum

• Average

• Absolute

• Total

Which function key from the keyboard(F1....F12) is used to automatically make a cell reference absolute.

Refer to your spreadsheet done for practice. Which item cost the least?

Refer to your spreadsheet done for practice. What percentage is used for Vat?

Refer to your spreadsheet done for practice. Which two items cost the same? Use a comma to separate your answer 'no space' eg rock,pencil

Write the Cell H20 as an absolute cell reference 'absolute value'.

Write the Cell B7 as an absolute cell reference 'absolute value'.

Which of the following answers are NOT absolute cell references? Choose all that applies.

• $G$5

• H2

• &D&7

• $K$56

• *L*71

Refer to your spreadsheet done for practice. Write the function you would type in cell D2 to arrive at that answer.

Refer to your spreadsheet done for practice. How many items were purchases from the store?