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