Excel Quiz
Authored by Makhwethe Letsoalo
Information Technology (IT)
University
Used 2+ 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
1 min • 1 pt
What does a cell in Excel represent?
A file
A worksheet
The intersection of a row and a column
A chart
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following is a correct basic formula in Excel?
A1 + B1
SUM = A1:A5
=A1 + B1
Add(A1, B1)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the purpose of formatting data in Excel?
To hide errors
To make data easier to read and understand
To delete cells
To calculate numbers
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which Excel function is used to find the average of a range of numbers?
=SUM()
=COUNT()
=AVERAGE()
=MAX()
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What does the IF() function do?
Finds text in a document
Filters rows
Makes a decision based on a condition
Sorts data alphabetically
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
You can have multiple sheets in one Excel workbook.
True
False — Filtering only hides rows temporarily.
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Filtering allows you to remove data permanently.
True
False — Filtering only hides rows temporarily.
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?
