Excel Functions Quiz

Quiz
•
Computers
•
6th Grade
•
Hard
shivana ramsawak
FREE Resource
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using built-in functions in Excel spreadsheets?
The purpose of using built-in functions in Excel spreadsheets is to format cells and apply styles.
The purpose of using built-in functions in Excel spreadsheets is to create charts and graphs.
The purpose of using built-in functions in Excel spreadsheets is to import and export data.
The purpose of using built-in functions in Excel spreadsheets is to automate calculations, manipulate data, analyze information, and simplify complex tasks.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel is used to calculate the sum of a range of cells?
MAX
COUNT
SUM
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the AVERAGE function in Excel do?
Calculates the sum of a range of numbers.
Calculates the median of a range of numbers.
Calculates the arithmetic mean of a range of numbers.
Calculates the maximum value in a range of numbers.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel is used to find the minimum value in a range of cells?
AVERAGE
MINIMUM
MIN
SUM
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the MAX function in Excel?
To find the smallest value in a range of cells or a set of values.
To calculate the average of a range of cells or a set of values.
To find the largest value in a range of cells or a set of values.
To count the number of cells in a range that contain numbers.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel is used to count the number of cells that contain data?
COUNTA
SUM
AVERAGE
COUNT
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the DATE function in Excel do?
The DATE function calculates the difference between two dates.
The DATE function rounds a number down to the nearest integer.
The DAT function converts a number to a text string.
The DATE function formats the date entered.
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
system software

Quiz
•
6th - 7th Grade
15 questions
Grade 5 (Third Quarter)

Quiz
•
6th Grade
15 questions
Advanced Functions and Formulas

Quiz
•
6th - 8th Grade
17 questions
Microsoft Office Quiz

Quiz
•
KG - 9th Grade
10 questions
CLASS 6 - CH 4 FORMATTING IN EXCEL

Quiz
•
5th - 7th Grade
10 questions
Digital Technology

Quiz
•
5th - 6th Grade
10 questions
Excel Ribbon

Quiz
•
6th - 12th Grade
10 questions
ICT - GRADE 6 - APRIL 2021

Quiz
•
6th Grade
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

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

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade