Which of the following formulas correctly adds the values in cells A1 and B1?
Excel Formulas and Functions Quiz

Quiz
•
Business
•
10th Grade
•
Medium

Blake Riggs
Used 9+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
`=A1+B1`
`=SUM(A1:B1)`
`=ADD(A1, B1)`
`=A1*B1`
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the average of the numbers in cells C1 through C5?
`=SUM(C1:C5)`
`=AVERAGE(C1:C5)`
`=MEDIAN(C1:C5)`
`=COUNT(C1:C5)`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you format a cell to display numbers as currency in Excel?
Use the "Number" format
Use the "Currency" format
Use the "Text" format
Use the "Percentage" format
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of an absolute cell reference?
`A1`
`A$1`
`$A1`
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of the formula `=B1*2` if B1 contains the value 5?
5
10
15
20
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the largest number in a range of cells?
`=MIN(range)`
`=MAX(range)`
`=LARGE(range)`
`=SUM(range)`
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply a conditional format to highlight cells greater than 100?
Use the "Data Validation" tool
Use "Conditional Formatting" with a rule "Greater than 100"
Use "Find and Replace"
Use "Sort and Filter"
Create a free account and access millions of resources
Similar Resources on Quizizz
15 questions
MS Excel Vocab 2

Quiz
•
10th Grade
23 questions
Excel Standard 7 Review

Quiz
•
9th - 12th Grade
25 questions
Ekonomi X

Quiz
•
10th Grade
20 questions
CSA Microsoft Excel

Quiz
•
9th - 12th Grade
20 questions
KUIS SPREADSHEET KELAS X AKL

Quiz
•
10th Grade
17 questions
Microsoft Word Ribbon (2019)

Quiz
•
7th - 12th Grade
20 questions
Ekonomi Bisnis

Quiz
•
10th Grade
20 questions
Excel Review

Quiz
•
9th - 12th Grade
Popular Resources on Quizizz
15 questions
Character Analysis

Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing

Quiz
•
9th - 12th Grade
10 questions
American Flag

Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
30 questions
Linear Inequalities

Quiz
•
9th - 12th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25

Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers

Quiz
•
6th - 8th Grade
Discover more resources for Business
17 questions
Chapter 12 - Doing the Right Thing

Quiz
•
9th - 12th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
30 questions
Linear Inequalities

Quiz
•
9th - 12th Grade
20 questions
Taxes

Quiz
•
9th - 12th Grade
17 questions
Parts of Speech

Quiz
•
7th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression

Quiz
•
9th - 12th Grade
20 questions
Inequalities Graphing

Quiz
•
9th - 12th Grade
10 questions
Identifying equations

Quiz
•
KG - University