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 Wayground
20 questions
Microsoft Excel Review Part 2

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

Quiz
•
9th Grade - University
20 questions
Design Principles Quiz

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

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

Quiz
•
9th Grade
21 questions
Unit 3: Basic Python & Console Interaction

Quiz
•
9th - 12th Grade
20 questions
Class 9 Viva Questions 9B mideterm

Quiz
•
9th Grade
15 questions
Module 3 - Unity Scripting Basics

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade