What is the formula to add the values in cells A1 and A2?

Mastering Spreadsheet Essentials

Quiz
•
Information Technology (IT)
•
9th Grade
•
Easy
S Uwadiae
Used 1+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
`=A1+A2`
`=SUM(A1:A2)`
`=ADD(A1,A2)`
`=A1-A2`
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a basic formula to subtract the value in cell B2 from B1?
`=B1+B2`
`=B1-B2`
`=SUBTRACT(B1,B2)`
`=B2-B1`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you multiply the values in cells C1 and C2?
`=C1*C2`
`=MULTIPLY(C1,C2)`
`=C1+C2`
`=C1/C2`
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to divide the value in cell D1 by D2?
`=D1*D2`
`=D1-D2`
`=D1/D2`
`=DIVIDE(D1,D2)`
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the average of cells E1 to E5?
`=SUM(E1:E5)`
`=AVERAGE(E1:E5)`
`=MEAN(E1:E5)`
`=MEDIAN(E1:E5)`
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format a cell to display numbers as currency?
Change the font
Use the currency format option
Use the percentage format option
Use the text format option
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a function to find the maximum value in a range of cells?
`=MIN()`
`=MAX()`
`=LARGEST()`
`=HIGHEST()`
Create a free account and access millions of resources
Similar Resources on Quizizz
20 questions
KUIS BAB V PENGEMBANGAN APLIKASI MOBILE

Quiz
•
9th - 12th Grade
16 questions
Mastering Excel Functions

Quiz
•
9th Grade
15 questions
CCDI Competition- First League - Cycle 3 -

Quiz
•
9th - 12th Grade
20 questions
Microsoft Excel Review Part 2

Quiz
•
8th Grade - University
21 questions
Form 3 - Information Technology Quiz

Quiz
•
9th Grade - University
15 questions
Grade 9-Exploring Input Devices

Quiz
•
9th Grade
20 questions
Info Pro 9 Spreadsheet Hot Key Quiz

Quiz
•
9th Grade
22 questions
Informatika Kelas 6

Quiz
•
6th Grade - University
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 Information Technology (IT)
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
24 questions
LSO - Virus, Bacteria, Classification - sol review 2025

Quiz
•
9th 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
10 questions
Exponential Growth and Decay Word Problems

Quiz
•
9th Grade