Excel - Formulas, Functions & Formatting

Excel - Formulas, Functions & Formatting

10th - 12th Grade

20 Qs

quiz-placeholder

Similar activities

Cyber Security KS4

Cyber Security KS4

8th - 12th Grade

15 Qs

Advantages and Disadvantages of Collecting Data

Advantages and Disadvantages of Collecting Data

10th Grade

20 Qs

Pretest TIK

Pretest TIK

10th Grade

20 Qs

ESBWB Workbook Domain 1 Lesson 2

ESBWB Workbook Domain 1 Lesson 2

9th - 12th Grade

15 Qs

Do You Know Your Keyboard?

Do You Know Your Keyboard?

5th - 10th Grade

15 Qs

Pointers

Pointers

12th Grade

20 Qs

Exam Style Questions

Exam Style Questions

10th - 11th Grade

18 Qs

Google Sheets

Google Sheets

12th Grade

21 Qs

Excel - Formulas, Functions & Formatting

Excel - Formulas, Functions & Formatting

Assessment

Quiz

Computers

10th - 12th Grade

Practice Problem

Medium

Created by

Rosella Sprow

Used 380+ times

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

In the picture, why is D2 through D5 placed in paranthesis?

So Excel knows to total the cells before performing the next operation.
So the total of the cells can be multiplied rather than added.

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Excel follows the ___________________ and first adds the values inside the parentheses.

Order of Operations
Formula Guidelines

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

By default, all cell references are _________ references. 

Absolute
Relative

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.

relative
relational

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

If you don't want a cell reference to change when copied to other cells, use _________ references

Absolute
relative

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What does the Average formula return?

Returns the lowest argument.

Returns the middle argument.

Returns the three highest arguments.

Returns the mean of all its arguments.

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What does the Max formula do?

Returns the highest three values in a set of values and ignores text.

Returns the largest value in a set of values and ignores text.

Returns the text that you are searching for.

Returns the smallest value in a set of values and ignores text.

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?