Formulas and Functions in Excel

Formulas and Functions in Excel

University

6 Qs

quiz-placeholder

Similar activities

velykos

velykos

University

10 Qs

Teaching terminologies

Teaching terminologies

University

10 Qs

Merchandising

Merchandising

University

10 Qs

United Nations

United Nations

5th Grade - University

10 Qs

Learning with movies/Coraline

Learning with movies/Coraline

University

10 Qs

Infancy

Infancy

4th Grade - Professional Development

10 Qs

HUSTer! Rung chuông vàng TOEIC!

HUSTer! Rung chuông vàng TOEIC!

University

9 Qs

EPP201

EPP201

University

10 Qs

Formulas and Functions in Excel

Formulas and Functions in Excel

Assessment

Quiz

Education

University

Practice Problem

Hard

Created by

Paola Miranda

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

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

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

The formula used to do additions

SUMIF

SUMIFS

SUM

SUBTOTAL

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Average Concept

The sum of the numbers divided by how many numbers are in the list

The value that occurs the most

The sum of the number divided by 100

The value in the middle of a data set. Meaning that 50% of data points are under the average and the other 50% are over the average.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Use the COUNT function to get

Use the COUNT function to count the number of selected characters (numeric or alphanumeric)

Use the COUNT function to count the number of alphanumeric characters.

Use the COUNT function to count the number of numeric characters.

Use the COUNT function to make an addition (the total of all numeric characters selected)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

True or False. The minimum and maximum value can be identified organizing the data from largest to smallest or vice versa, and enabling the option min and max in the Sum function.

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

False or True. Organizing the data of a column from the Largest to the Smallest is the faster way to now the minimum and maximum value of the column.

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

It is the quickest and more practical functionality to do an interactive summary of data in Excel.

Filters

Pivot Table

Count Function

Sum (Addition) Function