Font size
WorksheetsExcel SpreedSheets
Total questions: 10
Worksheet time: 5mins
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 (a) 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
