Burgess ICT Spreadsheets

Question 1

the mathematical rules used for calculating the value of a formula

Accepted Answer

order of operations

Question 2

a symbol that indicates what mathematical operation to perform on the operands

Accepted Answer

operator

Question 3

cell reference that does not adjust to the new cell location when copied or moved

Accepted Answer

absolute cell reference

Question 4

a number or cell reference used in a formula

Accepted Answer

operand

Question 5

a chart that shows the realtionship of a part to a whole

Accepted Answer

pie chart

Question 6

a chart that uses points connected by a line to illustrate values in a worksheet

Accepted Answer

line graph

Question 7

cell reference that adjusts to a new location when copied or moved

Accepted Answer

relative cell reference

Question 8

a chart that uses bars of varying height to illustrate values in a worksheet

Accepted Answer

column chart

Question 9

a cell reference that contains both relative and absolute references

Accepted Answer

mixed cell references

Question 10

a unique identifier for a cell which is formed by combining the cell's letter and number

Accepted Answer

cell reference

Questions 10