Excel SpreedSheets

What is the correct absolute cell reference format?

• =D4*F3$$

• =D3*$R$3

• =$D£3*$F$3

• =$L3*F4$

What is the correct symbol to add something in excel?

• +

• /

• *

• -

What is the correct sum for addition?

• =D3*D4

• =D3/D4

• D2-D1

• =D3+D12

What would you use if you wanted to find the minimum of a set of numbers.

• =MIN

• =MAX

• =Average

• =CountIF

fill in the blank for the sum to work

5__6= 30

what are the two non excel functions?

• insert a new slide

• insert a new column

• Insert Table

• animations/transitions

If you make a business and you need to total up your earnings what way would you do it?

• make a table

• make a chart

• make a spreadsheet

• make a graph

how do you select more than one column

• hold shift

• hold CTRL

• hold alt

• alt and F4

If I want to organise some names in alphabetical order, how would you do that,

• Filter A to Z

• Filter Z to A

• Sort

• Count

Which two options are existing functions?

• Currency £

• Percentage %

• text

• paragraph