Excel day 1
Authored by 721920243023 SCIENCE
Computers
Professional Development
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
Which of the following is the correct syntax for the SUM function?
=SUM(A1; A5)
=SUM(A1:A5)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel function can be used to find the average of a range of values?
A) =SUM()
B) =AVERAGE()
C) =MEAN()
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the Fill function in Excel help with?
A) Create charts automatically
B) Copy a value or a sequence to adjacent cells
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to split text from one cell into multiple cells?
A) =SPLIT()
B) =TEXTTOCOLUMNS()
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the Transpose function do?
A) Combines data from multiple rows into one row
B) Converts rows to columns or columns to rows
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the Sort & Filter function in Excel?
A) Add numbers in a column
B) Sort data alphabetically or numerically and filter specific data
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you create a drop-down list in Excel?
A) Through data validation
B) With the SUM function
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?
