Excel Functions and Formulas

Excel Functions and Formulas

University

10 Qs

quiz-placeholder

Similar activities

Spreadsheet Part 3

Spreadsheet Part 3

University

10 Qs

Підсумковий тест за II семестр

Підсумковий тест за II семестр

7th Grade - University

12 Qs

Controle e Automação Quiz

Controle e Automação Quiz

University

10 Qs

Informatica

Informatica

University

7 Qs

Komputer

Komputer

University

14 Qs

Spreadsheet Formula dan Fungsi Excel

Spreadsheet Formula dan Fungsi Excel

University

15 Qs

Quiz

Quiz

8th Grade - University

5 Qs

Virtual to Germany ( Quiz )

Virtual to Germany ( Quiz )

University

8 Qs

Excel Functions and Formulas

Excel Functions and Formulas

Assessment

Quiz

Other

University

Medium

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?