Excel Formulas and Functions

Excel Formulas and Functions

Assessment

Flashcard

Business

9th - 12th Grade

Practice Problem

Medium

Created by

Wayground Content

Used 3+ times

FREE Resource

Student preview

quiz-placeholder

19 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What excel function calculates the sum of values?

Back

=SUM, SUM

2.

FLASHCARD QUESTION

Front

Calculates the mean of a group of values

Back

AVERAGE

3.

FLASHCARD QUESTION

Front

True or False:

The IF function tests for a true or false condition and then returns one value or another.

Back

True

4.

FLASHCARD QUESTION

Front

Calculates a sum from a group of values, but just of values that are included because a condition is met. Options: COUNTIF, SUMIF, AVERAGEIF

Back

SUMIF

5.

FLASHCARD QUESTION

Front

Counts the number of cells in a range that match a criteria

Back

COUNTIF

6.

FLASHCARD QUESTION

Front

Extracts one or more characters from the left side of a text: string

Back

LEFT

7.

FLASHCARD QUESTION

Front

Extracts one or more characters from the right side of a text string

Back

RIGHT

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?