Excel Formulas and Functions Quiz

Excel Formulas and Functions Quiz

10th Grade

20 Qs

quiz-placeholder

Similar activities

Excel: Module 1Test Review

Excel: Module 1Test Review

9th - 12th Grade

20 Qs

Word 1.06 Tables Review

Word 1.06 Tables Review

9th - 12th Grade

20 Qs

N5 AIT - Spreadsheets Quiz

N5 AIT - Spreadsheets Quiz

9th - 12th Grade

15 Qs

Excel Basics Test 2 (Basic Formulas)

Excel Basics Test 2 (Basic Formulas)

9th - 12th Grade

15 Qs

2016 MS Excel - Lesson 9 Vocats

2016 MS Excel - Lesson 9 Vocats

9th - 12th Grade

15 Qs

Excel Lesson 4 Quiz

Excel Lesson 4 Quiz

9th - 12th Grade

15 Qs

KUIS SPREADSHEET KELAS X AKL

KUIS SPREADSHEET KELAS X AKL

10th Grade

20 Qs

Excel Lesson 1 Quiz

Excel Lesson 1 Quiz

9th - 12th Grade

19 Qs

Excel Formulas and Functions Quiz

Excel Formulas and Functions Quiz

Assessment

Quiz

Business

10th Grade

Medium

Created by

Blake Riggs

Used 9+ times

FREE Resource

20 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 B1?

`=A1+B1`

`=SUM(A1:B1)`

`=ADD(A1, B1)`

`=A1*B1`

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function would you use to find the average of the numbers in cells C1 through C5?

`=SUM(C1:C5)`

`=AVERAGE(C1:C5)`

`=MEDIAN(C1:C5)`

`=COUNT(C1:C5)`

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How would you format a cell to display numbers as currency in Excel?

Use the "Number" format

Use the "Currency" format

Use the "Text" format

Use the "Percentage" format

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of an absolute cell reference?

`A1`

`A$1`

`$A1`

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the result of the formula `=B1*2` if B1 contains the value 5?

5

10

15

20

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the largest number in a range of cells?

`=MIN(range)`

`=MAX(range)`

`=LARGE(range)`

`=SUM(range)`

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you apply a conditional format to highlight cells greater than 100?

Use the "Data Validation" tool

Use "Conditional Formatting" with a rule "Greater than 100"

Use "Find and Replace"

Use "Sort and Filter"

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?