Excel Functions and Formulas

Quiz
•
Other
•
University
•
Medium
ADITYA KALUA
Used 15+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to add two numbers in Excel?
=PLUS(number1, number2)
=ADD(number1, number2)
=SUM(number1, number2)
=number1 + number2
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you subtract one number from another in Excel?
=A1+B1
=A1*B1
=A1/B1
=A1-B1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to multiply two numbers in Excel?
=A1^B1
=A1*B1
=A1/B1
=A1+B1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you divide one number by another in Excel?
You can divide one number by another in Excel by using the subtraction operator (-)
You can divide one number by another in Excel by using the addition operator (+)
You can divide one number by another in Excel by using the division operator (/) or the DIVIDE function.
You can divide one number by another in Excel by using the multiplication operator (*)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the average of a range of cells in Excel?
=MODE(range)
=MEDIAN(range)
=AVERAGE(range)
=SUM(range)/COUNT(range)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you find the maximum value in a range of cells in Excel?
MAX function
MIN function
AVERAGE function
SUM function
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to find the minimum value in a range of cells in Excel?
=SUM(range)
=MAX(range)
=MIN(range)
=AVERAGE(range)
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
MID Aplikasi Pengolah Angka 13 Oktober 2021

Quiz
•
1st Grade - University
9 questions
Examen del 3er trimestre de Aplicaciones

Quiz
•
11th Grade - University
10 questions
Introduction to MS Excel - Quiz

Quiz
•
University
7 questions
PROGRAM KEAHLIAN MP

Quiz
•
11th Grade - University
15 questions
Let's Play Excel Excel...!

Quiz
•
University
10 questions
Spreadsheets

Quiz
•
KG - University
10 questions
Chapter 2.6 to 2.10

Quiz
•
University
10 questions
EXCEL PODSTAWY

Quiz
•
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