Spreadsheet Basics Quiz
Authored by poula kamal
Information Technology (IT)
7th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of a spreadsheet?
To create presentations
To store and analyze data
To write documents
To browse the internet
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a spreadsheet, what does a cell refer to?
A row of data
A column of data
The intersection of a row and a column
A formula
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a common function in spreadsheets?
SUM
AVERAGE
COUNT
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does conditional formatting allow you to do?
Change the font style of the entire spreadsheet
Automatically format cells based on their values
Delete rows and columns
Create charts
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used to start a formula in a spreadsheet?
@
#
$
=
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the effect of applying conditional formatting to a cell that contains a value greater than 100?
The cell will be deleted
The cell will change color based on the rule set
The value will be halved
The cell will be locked
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following functions would you use to find the highest value in a range?
MIN
MAX
AVERAGE
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?
