BARU
Ukuran huruf
Lembar kerjaYear 5 - Unit 4 Quiz - Exploring Spreadsheet
Total soal: 15
Worksheet time: 8mins
What would be a correct formula for SUM in excel?
=ADD(B3:B9)
SUM(B3:B9)
=SUM(B3:B9)
=AUTOSUM(B3:B9)
Which formula gets the biggest value of a range of cells?
LARGE
MAX
COUNT
MIN
Which symbol must all formula begin with?
-
@
(
=
What does the Countif formula return?
Count the number of cells that contain numbers (value)
Biggest amount
Smallest amount
Rate
Which operator is used to multiply in Excel?
\
*
+
-
For dividing numbers in A1 AND B1, you use the following formula
=A1\B1
A!\B1
=A1/B1
=A/B
Which button allows you to 'Sort & Filter' the data in Excel?
A
B
C
D
Which tab has the function to insert 'Charts' in Excel?
A
B
C
D
What type of chart is this?
Pie chart
Line chart
Bar chart
Column chart
Which of the following formulas is not entered correctly?
=B3-B4
=25+37
=95x6
=15/F2
What function is used to find the lowest data ?
Sum
Average
Min
Max
Find the total number of peanut cookies from Day 1 to Day 5 (blue colored cell).
23
32
33
30
Find the MIN value for Day 1 (orange colored cell).
10
61
10
3
Find the MAX value for Day 4 (green colored cell).
61
24
3
24
What is the cell address for 'Peanut'?
6B
C6
F6
B6
