
Mastering Excel Functions
Quiz
•
Information Technology (IT)
•
9th Grade
•
Practice Problem
•
Medium
Romaine Cunningham
Used 2+ times
FREE Resource
Enhance your content in a minute
16 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does VLOOKUP do in Excel?
VLOOKUP calculates the sum of a range of cells.
VLOOKUP formats cells based on their values.
VLOOKUP searches for a value in the first column of a table and returns a corresponding value from a specified column.
VLOOKUP creates a new worksheet in Excel.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you calculate the sum of a range of cells?
Use the SUM function with the cell range, e.g., =SUM(A1:A10).
Use the COUNT function to sum the cells, e.g., =COUNT(A1:A10).
Add the values manually without using a function.
Use the AVERAGE function with the cell range, e.g., =AVERAGE(A1:A10).
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula would you use to find the average of a set of numbers?
Average = (Sum of all numbers) / (Count of numbers)
Average = (Sum of all numbers) + (Count of numbers)
Average = (Count of numbers) x (Sum of all numbers)
Average = (Largest number) - (Smallest number)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you count the number of cells that contain numbers?
Use the AVERAGE function to find the mean of the numbers.
Use the SUM function to add the numbers.
Use the COUNT function in your spreadsheet.
Count the cells manually one by one.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the COUNTIF function?
To sort a list of values in ascending order.
To count cells that meet a specific condition in a range.
To calculate the average of a range of cells.
To find the maximum value in a dataset.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you create a pivot table in Excel?
Select data, go to 'Data' > 'Sort', and apply filters.
Highlight data, click on 'Home' > 'Format', and choose a style.
Select data, go to 'View' > 'Freeze Panes', and adjust the layout.
Select data, go to 'Insert' > 'PivotTable', choose location, and arrange fields.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the SUM function?
SUM(number1 + number2)
SUM(number1; number2)
SUM(number1, number2, ...)
SUM(number1, number2)
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?
Similar Resources on Wayground
16 questions
HTML Level 1
Quiz
•
8th Grade - University
20 questions
Soal QuIz SMPIT IF Meningkatkan Kemampuan Berpikir
Quiz
•
9th Grade
20 questions
Keterampilan Informatika Kelas 9
Quiz
•
9th Grade
20 questions
KUIS TIK
Quiz
•
9th Grade - University
20 questions
ASESMEN DIAGNOSTIK INFORMATIKA KELAS 9
Quiz
•
9th Grade - University
20 questions
Math G7 Chapter 3 Mastering Significant Figures and Estimation
Quiz
•
7th Grade - University
15 questions
The 7 Soft Skills You Need to Be Successful
Quiz
•
9th Grade
20 questions
Citizenship Basics Final Assessment
Quiz
•
9th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Information Technology (IT)
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
18 questions
SAT Prep: Ratios, Proportions, & Percents
Quiz
•
9th - 10th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
