Sec 4 CPA - Spreadsheet Revision
Authored by ChangJin Chen
Computers
10th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
A spreadsheet is made up of
titles
table
rows and columns
templates
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
You always start a spreadsheet formula with?
=
+
-
*
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The count formula counts
the number of cells in the range as long as it contains text
the number of cells in the range
the number of cells outside the range
the number of cells in the range as long as it contains numbers
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
what does the formula COUNTA do?
Count the number of cells in a range that is empty
Count the number of cells in a range that is not empty
Count the number of cells in a range that contains numbers
Count the number of cells in a range that contains alphabets
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which formula can help you find the largest value from a range of data?
Average
Highest
Maximum
Minimum
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which formula do you use to key in the date for today?
=day()
=time()
=today
=today()
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
#### is seen in spreadsheet sometimes because
the formula is wrong
the cell has an error
the cell contains a longer message than the cell width
the formula is ####
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?
