N5 AIT - Spreadsheets Quiz
Authored by Chantelle Scott
Business, Education
9th - 12th Grade
Used 86+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An individual box within a worksheet is known as?
reference
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is normally used to perform calculations in a spreadsheet?
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
In Excel, what do all formula begin with?
4.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
What must bar charts have? Tick all that apply!
Heading (in caps)
Pie chart
Axis Labels
Heading (in lower case)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
We can use this function to count the number of cells containing words/letters
=COUNTA
=COUNTW
=COUNT
=COUNTN
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
We can use this function to perform a 'logical test' where the answer is a TRUE or FALSE outcome
=MAYBE
=WHEN
=LOGIC
=IF
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
We can use this function to add more than 2 cells together
=ADD
=SUM
=ANSWER
=COUNT
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
