
Microsoft Excel Concepts to Review
Authored by Macie Gregory
Business
University

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
31 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The VLOOKUP function in Excel is used to:
Find the average of a range of cells
Search for a value in the first column of a table and return a value in the same row from a specified column
Sort data in ascending order
Calculate the sum of a range of cells
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will the IF function return in Excel?
A value if a condition is true and another value if it's false
The sum of a range of cells
The average of a range of cells
The maximum value in a range of cells
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the Name Box in Excel?
A tool to format cells
A box to enter formulas
A box that displays the cell reference or name of the active cell
A feature to sort data
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The purpose of the Formula Bar in Excel is to:
Display the contents of the active cell and allow you to create and view formulas.
Format the cells in the worksheet.
Insert charts and graphs into the worksheet.
Change the worksheet's background color.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an Active Cell in Excel?
A cell that is currently selected
A cell that contains a formula
A cell that is locked
A cell that is hidden
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
List the different Number Formats available in Excel.
General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom
General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text
General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific
General, Number, Currency, Accounting, Date, Time, Percentage
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
True or False: Changing the number format in Excel changes the value of a cell.
True
False
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
30 questions
Revision (Chapter 7, 9 & 10)
Quiz
•
University
30 questions
Business Analytics
Quiz
•
University
30 questions
PLAN CONTABLE EMPRESARIAL 2024
Quiz
•
University
26 questions
Parcial N. 1_Transporte Multimodal
Quiz
•
University
27 questions
Repaso Gerencia Publicitaria
Quiz
•
University
35 questions
GCA Workforce Pathway Grade Recovery
Quiz
•
9th Grade - University
28 questions
BA 101 Midterm Review (Ch 1-5)
Quiz
•
University
28 questions
Capítulo 2 Comercio electrónico global y colaboración
Quiz
•
University
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 Business
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University