Excel Pre-Test Assessment
Authored by KALAIARASAN NADARAJAN
Others
Professional Development
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.
OPEN ENDED QUESTION
3 mins • 1 pt
Match the following Excel functions with their descriptions: SUM - b) Adds all numbers in a range AVERAGE - a) Returns the highest value in a range MAX - c) Returns the average of the numbers in a range MIN - d) Returns the lowest value in a range
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
What is a PivotTable used for?
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
3 mins • 1 pt
Write the formula to calculate the average of the numbers in cells A1 to A10.
Evaluate responses using AI:
OFF
4.
OPEN ENDED QUESTION
3 mins • 1 pt
Open a new Excel workbook and perform the following tasks: a) Enter the following data in cells A1 to A3: 10, 20, 30 b) Use a formula to calculate the sum of these numbers in cell A4 c) Format the numbers in cells A1 to A3 as currency d) Create a bar chart using this data
Evaluate responses using AI:
OFF
5.
OPEN ENDED QUESTION
3 mins • 1 pt
On a scale of 1 to 5, how would you rate your current proficiency in Excel? (1 = Beginner, 5 = Expert)
Evaluate responses using AI:
OFF
6.
OPEN ENDED QUESTION
3 mins • 1 pt
What specific Excel skills or topics would you like to improve or learn more about?
Evaluate responses using AI:
OFF
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is Microsoft Excel used for?
Word processing
Spreadsheets
Database management
Web browsing
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?
