Microsoft Excel

Question 1

Absolute cell referencing

Answer 1

A cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other

Question 2

Relative cell referencing

Answer 2

Basic cell reference that adjusts and changes when copied or when using autofill

Question 3

Data validation

Answer 3

Data validation is a feature in Excel which is used to control what users can enter into a cell. It allows you to dictate specific rules. It also allows users to display a custom message if users try to enter invalid data

Question 4

Data legend

Answer 4

a small visual representation of the chart’s data