Which function would you use to find the maximum value in a range of cells?
Quiz on Excel

Quiz
•
Computers
•
12th Grade
•
Hard
Arnoldo Cimafranca
Used 7+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A) MIN
B) AVG
C) MAX
D) SUM
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which keyboard shortcut can you use to select the entire column in Excel?
A) Ctrl + C
B) Ctrl + A
C) Ctrl + Spacebar
D) Ctrl + Enter
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the SUM function do in Excel?
A) Finds the maximum value in a range
B) Finds the average value in a range
C) Adds up all the numbers in a range
D) Finds the minimum value in a range
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to count the number of cells containing numerical values in a range?
A) COUNT
B) AVERAGE
C) SUM
D) MAX
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the ENTER key in Excel?
A) To confirm an entry or move to the next cell
B) To delete the contents of a cell
C) To undo the last action
D) To save the workbook
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the minimum value in a range of cells?
A) MIN
B) AVG
C) MAX
D) SUM
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using a named range in Excel?
A) To assign a specific name to a range of cells for easier reference
B) To automatically update the range when new data is added
C) To prevent other users from editing the range
D) To apply conditional formatting to the range
Create a free account and access millions of resources
Similar Resources on Quizizz
21 questions
Microsoft Excel Quiz 1 Grade 12

Quiz
•
12th Grade
15 questions
Spreadsheet

Quiz
•
4th Grade - University
20 questions
Excel Spreadsheet Intro

Quiz
•
KG - University
20 questions
Advanced Excel

Quiz
•
KG - University
20 questions
Microsoft Excel 2013 Survey (Basic)

Quiz
•
9th Grade - University
20 questions
Ms Excel Test

Quiz
•
1st - 12th Grade
15 questions
Mengenal Jendela dan Ikon Microsoft Excel

Quiz
•
7th Grade - University
15 questions
Excel

Quiz
•
10th - 12th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
Discover more resources for Computers
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
65 questions
MegaQuiz v2 2025

Quiz
•
9th - 12th Grade
10 questions
GPA Lesson

Lesson
•
9th - 12th Grade
15 questions
SMART Goals

Quiz
•
8th - 12th Grade
45 questions
Week 3.5 Review: Set 1

Quiz
•
9th - 12th Grade