stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
KS3 NCCE Modelling data Lesson 5 starter Flashcards | StudBud
Explore
/
KS3 NCCE Modelling data Lesson 5 starter
KS3 NCCE Modelling data Lesson 5 starter
10 terms
·
StudBud Administration
·
735 plays
#NCCE #spreadsheets #modelling data
Flashcards
10 cards
F
Practice quiz
P
Host live
L
Questions
10
Answers
1
The cell references for the cells in rows 15–20 in column A, B and C
=A15 to C20
A15:C20
A15-C20
=A15:C20
2
A way to add values together in a spreadsheet
A3 + B3
SUM
= A3 + B3
A3 = B3 =
3
An expression *you* write that does mathematical operations on cells in a spreadsheet
Ratio
Sum
Function
Formula
4
A function that tells you the largest value in a range
MIN
MAX
COUNTA
SUM
5
The cell references for the cells in rows 15–20 in column A
=A15:A20
A15:A20
A15 - A20
=A15 to A20
6
The cell references for the first ten cells of column B
B1:B10
=B1+B10
=B1 to B10
B1 - B10
7
The symbol you must type to use a function or a formula
@
=
*
/
8
A function that tells you the smallest value in a range
SUM
COUNTA
MIN
MAX
9
A predefined expression that does mathematical operations on cells in a spreadsheet
Sum
Formula
Function
Ratio
10
A function that tells you the number of non-blank cells in a range
SUM
MAX
COUNTA
MIN