
Mastering Excel Skills
Authored by Kaleem Baig
Computers
8th Grade
Used 2+ times

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.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the average of a range of cells in Excel?
AVERAGE
MAX
SUM
COUNT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you create a pie chart in Excel?
Select data, go to 'File' > 'New Chart', choose pie.
Select data, go to 'Insert' > 'Pie Chart', choose style.
Right-click data, choose 'Create Chart', and select pie style.
Highlight data, click on 'Data' > 'Chart Options', select pie.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the shortcut key to sort data in ascending order?
Ctrl + S
Alt + S + A
Alt + A + S + A
Shift + A + S
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would you use to count the number of cells that contain numbers?
MAX(range)
COUNT(range)
SUM(range)
AVERAGE(range)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply conditional formatting to highlight cells greater than a certain value?
Select cells > Data > Filter > Set criteria > Apply filter.
Right-click cells > Format Cells > Choose color > Click OK.
Select cells > Home > Styles > Cell Styles > Choose a style.
Select cells > Home > Conditional Formatting > New Rule > Format cells that are greater than > Enter value > Set formatting.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the VLOOKUP function in Excel?
To calculate the sum of a range of cells.
To format cells based on their values.
To create a chart from a data set.
To search for a value in a table and return a corresponding value from another column.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you filter data to show only specific entries in a table?
Sort the table to rearrange the data.
Use a query with conditions to filter entries, e.g., SELECT * FROM table WHERE condition.
Export the table to a different format.
Use a spreadsheet to manually delete unwanted entries.
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
10 questions
Konsep Routing
Quiz
•
1st - 10th Grade
17 questions
Email Lớp 6
Quiz
•
6th Grade - University
13 questions
Quiz 3: Internet safety, cyber security and encryption
Quiz
•
7th - 8th Grade
15 questions
Cyber Security Homework 1
Quiz
•
7th - 9th Grade
14 questions
Introduction to Networks
Quiz
•
6th - 8th Grade
20 questions
ÔN TẬP HỌC KỲ 2 - TIN HỌC 8
Quiz
•
8th Grade
12 questions
JUEGO - UNIDADES DE MEDIDA DE ALMACENAMIENTO
Quiz
•
1st - 10th Grade
10 questions
Паскаль. Основные команды
Quiz
•
8th - 11th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
20 questions
Laws of Exponents
Quiz
•
8th Grade
11 questions
Valentines Day
Quiz
•
6th - 8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
25 questions
7th Reading STAAR Vocabulary
Quiz
•
6th - 8th Grade
25 questions
Valentine's Day Trivia
Quiz
•
8th Grade