
Excel Quiz
Authored by FASAKIN OLUWASEYI
Computers
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
23 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the difference between a formula and a function in Excel?
A formula is only used in basic Excel, while a function is used in advanced Excel.
A formula is used for text manipulation, while a function is used for numerical calculations.
A formula is entered manually, while a function is automatically generated by Excel.
A formula is an expression that performs calculations on values in a cell, while a function is a predefined formula that performs specific calculations.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you use the SUM function in Excel to add up a range of cells?
Manually add up each cell in the range
Input the range of cells as the argument for the SUM function.
Multiply the range of cells by 1
Use the AVERAGE function instead
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the VLOOKUP function in Excel?
The purpose of the VLOOKUP function in Excel is to create a new worksheet
The purpose of the VLOOKUP function in Excel is to search for a value in the first column of a table and return a value in the same row from another column.
The purpose of the VLOOKUP function in Excel is to change the font style of a cell
The purpose of the VLOOKUP function in Excel is to calculate the sum of a range of cells
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you create a bar chart in Excel?
By right-clicking on the data and choosing 'Bar Chart' from the shortcut menu
By typing the data into the cells and hoping a bar chart appears
By using the 'Format' tab and selecting 'Bar Chart' from the drop-down menu
By selecting the data and using the 'Insert' tab to choose 'Bar Chart' from the 'Charts' group.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of a pivot table in Excel?
To create a new spreadsheet
To change the font style of the data
To send emails from Excel
The purpose of a pivot table in Excel is to summarize and analyze large amounts of data from a database or spreadsheet.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply conditional formatting to highlight cells that meet a specific criteria?
By manually changing the cell color
By using the 'Sort' feature in the spreadsheet software
By applying a filter to the cells
By using the 'Conditional Formatting' feature in the spreadsheet software.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you sort data in Excel based on multiple criteria?
Use the 'Sort' feature in the 'Data' tab and add multiple levels of sorting criteria in the Sort dialog box.
Manually rearrange the data in the desired order
Use the 'Conditional Formatting' feature to sort data based on multiple criteria
Use the 'Filter' feature in the 'Data' tab and select multiple criteria for sorting
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
20 questions
Sistem Komputer
Quiz
•
10th Grade
20 questions
KIỂM TRA 15 PHÚT MÔN TIN HỌC 6
Quiz
•
6th Grade
20 questions
Ulangan Harian Analisis Data 8C
Quiz
•
8th Grade - University
20 questions
Skill Competition Quiz 2024
Quiz
•
10th Grade - University
20 questions
SOFTWARE 7I
Quiz
•
7th Grade - University
18 questions
TRAC NGHIEM 12
Quiz
•
12th Grade
20 questions
Spreadsheet Fundamentals - Quiz2
Quiz
•
University
18 questions
Numérique et moi
Quiz
•
Professional Development
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
12 questions
Presidents' Day
Quiz
•
KG - 5th Grade
11 questions
FOREST Growth Mindset
Lesson
•
KG
10 questions
THEME
Quiz
•
KG - University
7 questions
Copy of G5_U5_L14_22-23
Lesson
•
KG - Professional Dev...
10 questions
Add & Subtract Mixed Numbers with Like Denominators
Quiz
•
KG - University
10 questions
Long i- igh, ie, and y Quiz
Quiz
•
KG - 3rd Grade
10 questions
2D & 3D Shapes
Quiz
•
KG
20 questions
Capitalization in sentences
Quiz
•
KG - 4th Grade