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