MS Excel Advanced Functions Quiz
Authored by Kavitha GRGSMS
Business
Professional Development
Used 2+ 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
30 sec • 1 pt
What is the purpose of the VLOOKUP function?
Sorting data in a table
Searching for a value in a table and returning a corresponding value
Performing mathematical calculations
Formatting cells in Excel
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the [range_lookup] parameter in the VLOOKUP function determine?
Whether to include empty cells in the search
Whether to search vertically or horizontally
Whether to look for an approximate or exact match
Whether to ignore case sensitivity in the search
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of the HLOOKUP function?
Sorting data in a table
Searching for a value vertically in a table
Searching for a value horizontally in a table
Calculating averages of rows in a table
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type is best suited for comparing quantities or values across different categories or groups, and can also be used for showing trends over time?
Pie Chart
Line Chart
Column Chart
Bar Chart
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What chart type is effective for visualizing trends and patterns over time or across ordered categories by connecting data points with straight lines?
Bar Chart
Pie Chart
Line Chart
Area Chart
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When is a pie chart most commonly used?
To compare quantities across different categories
To visualize trends over time
To show accumulated totals
To illustrate numerical proportions and distributions
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the COUNT function in Excel?
To find the sum of numbers in a range
To calculate the average of numbers in a range
To count the number of cells in a range that contain numbers
To round a number to a specified number of digits
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?
