Spreadsheet Basics
Authored by Vanessa Cannon
Computers
KG - University
Used 255+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
A rectangular group of cells treated as a unit is a spreadsheet
cell reference
column
range
row
2.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
The intersection of a row and a column and is identified by a cell reference
cell range
cell
cell reference
active cell
3.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Text, symbols, dates, or numbers not used in calculations are called
functions
labels
values
formulas
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
All functions and formulas begin with which symbol?
#
/
:
=
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the FUNCTION that will add cells D14, D15, D16, D17, D18, and D19?
-sum(D14:D19)
=D14:d19
=sum(D14-D19)
=D14+D15+D16+D17+D18+D19
6.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
In a spreadsheet, "=max(b3:b10)" is called a
function
cell range
formula
value
7.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
=sum(f4:g12) does what?
finds the average in a range of cells
finds the lowest value in a range of cells
add up a range of cells
finds the highest value in a range of cells
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
