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
Which function would you use to find the maximum value in a range of cells?
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 Wayground
15 questions
Spreadsheets

Quiz
•
1st - 12th Grade
20 questions
Excel Quiz

Quiz
•
8th - 12th Grade
15 questions
Excel quizz (graphs, charts, cursor)

Quiz
•
9th - 12th Grade
18 questions
MOS Microsoft Excel

Quiz
•
12th Grade
21 questions
Microsoft Excel Quiz 1 Grade 12

Quiz
•
12th Grade
15 questions
L1 Formatting Basics

Quiz
•
9th - 12th Grade
20 questions
Pengenalan Microsoft Excel

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

Quiz
•
KG - University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade