Excel Formulas and Functions Quiz

Excel Formulas and Functions Quiz

University

25 Qs

quiz-placeholder

Similar activities

TCM SAFETY & SECURITY

TCM SAFETY & SECURITY

1st Grade - University

20 Qs

คำถาม Tourism Quiz ช่วงที่ 1

คำถาม Tourism Quiz ช่วงที่ 1

University

20 Qs

Scrabble Fun Quiz (2 letter words)

Scrabble Fun Quiz (2 letter words)

8th Grade - University

20 Qs

Posttest Modul 2 Bahasa Inggris Niaga

Posttest Modul 2 Bahasa Inggris Niaga

University

20 Qs

Computers

Computers

University

20 Qs

Bible Trivia

Bible Trivia

University

20 Qs

Grooming tools & equipment

Grooming tools & equipment

12th Grade - University

20 Qs

MUN QUIZ#2

MUN QUIZ#2

7th Grade - Professional Development

20 Qs

Excel Formulas and Functions Quiz

Excel Formulas and Functions Quiz

Assessment

Quiz

Education

University

Practice Problem

Hard

Created by

arfieen mokhtar

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following formulas correctly adds the values in cells A1 and A2?

=A1+A2

=SUM A1,A2

=ADD(A1,A2)

=TOTAL(A1:A2)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the formula =AVERAGE(B1:B5) do?

Sums the numbers in B1 to B5

Finds the largest value in B1 to B5

Returns the average of values in B1 to B5

Counts the values in B1 to B5

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function returns the highest value from a list?

=MAX(A1:A10)

=LARGE(A1:A10)

=HIGH(A1:A10)

=BIGGEST(A1:A10)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will =IF(5>3, "Yes", "No") return?

5

No

Yes

Error

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a correct way to multiply A1 by B1?

=A1*B1

=MULTIPLY(A1,B1)

=PRODUCT A1 B1

=A1xB1

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type is best used to show percentages of a whole?

Line chart

Pie chart

Column chart

Scatter chart

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which tab on the Ribbon allows you to insert a chart?

Page Layout

Data

Insert

View

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?