Advanced Excel - Midterms
Authored by Kriz Mantalaba
Information Technology (IT)
Professional Development
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
It is a system, which organizes data in columns and rows. It is a data visualization and analysis tool.
MS Powerpoint
MS Word
MS Excel
MS Teams
2.
DROPDOWN QUESTION
1 min • 1 pt
A (a) consists of a grid made from columns and rows.
3.
DROPDOWN QUESTION
1 min • 1 pt
MS Excel files have (a) extension.
4.
DROPDOWN QUESTION
1 min • 1 pt
MS Excel supports (a) .
5.
DRAG AND DROP QUESTION
1 min • 1 pt
A (a) consists of a grid made from columns and rows.
6.
MATCH QUESTION
10 mins • 5 pts
Match the description to the correct Microsoft Excel feature or function.
VLookup
This function is used for data lookup.
Drop-down List
Allows people to pick an item from a list that you create
Sum
This formula adds all the numeric values in a range of cells.
Line Chart
Used to automate tasks
Macros
This chart type displays trend over time.
7.
MATCH QUESTION
10 mins • 5 pts
Match the Microsoft Excel feature or function with its description.
Average
Lets you copy formatting from one cell to another.
Pivot Table
Useful for viewing the headers while scrolling
Freeze Panes
Changes the cell appearance based on format conditions.
Format Painter
This table is used for data analysis by summarizing large amounts of data.
Conditional Formatting
This formula calculates the average.
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
Already have an account?
