stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
GCSE Unit 1 Spreadsheet recap Flashcards | StudBud
Explore
/
GCSE Unit 1 Spreadsheet recap
GCSE Unit 1 Spreadsheet recap
15 terms
·
StudBud Administration
·
70 plays
#formula
Flashcards
15 cards
F
Practice quiz
P
Host live
L
Questions
15
Answers
1
What function will give the result
5.75
?
=AVERAGE(F5:F8)
=MIN(F5:F8)
=MAX(F5:F8)
=SUM(F5:F8)
2
SUM, MAX, MIN, AVERAGE, COUNT
are all examples of?
Formula
Functions
spreadsheets
Mathematical operations
3
What does the shaded area in the picture represent?
Cell
Column
Bar
Row
4
Which Symbol would you use to Divide?
\
*
/
^
5
What symbol do all spreadsheet formula start with?
/
@
+
=
6
Which of these is the correct cell reference?
22
5A
3.4
C5
7
Look at the example spreadsheet. What will be the result of
=SUM(F5:F8)
?
5
22
24
23
8
What function will give the result
1
?
=MAX(F5:F8)
=SUM(F5:F8)
=MIN(F5:F8)
=AVERAGE(F5:F8)
9
Which of these is
not
a reason for using formulas in a spreadsheet
=4+4 is a good example of a useful spreadsheet formula
Users don't have to recreate the same formula over & over
used to perform many operations & tasks automatically
Formulas can be copied and pasted to different cells
10
If you wanted to add together a row or column of numbers, what formula would you use?
=average()
=sum()
=cat()
=if()
11
What symbol do we use for multiplication?
*
$
/
&
12
What does the shaded area in the picture represent?
Row
Cell
Line
Column
13
If I wanted to find the highest number in a column what function would I use?
=sum
=max
=min
=countif
14
Which of the following formulae is correct?
=C5xC6
=5C*6C
=C6%C5
=C5*C6
15
What function will give the result
10
?
=MAX(F5:F6)
=MIN(F5:F8)
=MAX(F5:F8)
=MAX(E5:E8)
