FBA-Lab6-Working with Functions MCQs

(Tab to RIGHT OPTION to see the answer.)

Which measure is best for average speed?

Median

Harmonic Mean

Geometric Mean

Correct! Wrong!

Which function is used to find average daily sales?

COUNT()

AVERAGE()

SUM()

MAX()

Correct! Wrong!

What is a function in Excel?

A formatting option

A worksheet name

A chart tool

A predefined formula

Correct! Wrong!

Which formula represents midrange correctly?

MIN / MAX

MAX / MIN

MAX + MIN

(MAX + MIN) / 2

Correct! Wrong!

Which function calculates geometric mean?

GEOMEAN()

AVERAGE()

HARMEAN()

MEDIAN()

Correct! Wrong!

Which function calculates harmonic mean?

HARMEAN()

COUNT()

GEOMEAN()

AVERAGE()

Correct! Wrong!

Which function calculates the mean of values?

SUM()

MAX()

AVERAGE()

MIN()

Correct! Wrong!

Which function counts the number of days in a dataset?

AVERAGE()

SUM()

COUNT()

MAX()

Correct! Wrong!

Which AutoSum function calculates total revenue?

MIN()

MAX()

SUM()

COUNT()

Correct! Wrong!

Which function is used to add a range of numbers?

MAX()

AVERAGE()

COUNT()

SUM()

Correct! Wrong!

What is the correct syntax of a function?

FUNCTION_NAME=argument

FUNCTION_NAME argument

FUNCTION_NAME(argument1, argument2)

=FUNCTION_NAME argument

Correct! Wrong!

Which function identifies the lowest number of units sold?

SUM()

COUNT()

MAX()

MIN()

Correct! Wrong!

Which formula calculates total frames sold?

=COUNT(B2:B31)

=SUM(B2:B31)

=MAX(B2:B31)

=AVERAGE(B2:B31)

Correct! Wrong!

Which of the following is an example of a function?

B2*C2

Correct! Wrong!

What does AutoSum provide quick access to?

Charts

Only SUM

Five core functions

Formatting tools

Correct! Wrong!

Which function returns the smallest value?

COUNT()

MAX()

MIN()

SUM()

Correct! Wrong!

Which function returns the largest value?

AVERAGE()

MIN()

MAX()

COUNT()

Correct! Wrong!

Which of the following is a key difference between formula and function?

Formula is predefined

Function is predefined

Function cannot calculate

Both are same

Correct! Wrong!

Which function finds the middle value in a dataset?

MEDIAN()

COUNT()

AVERAGE()

MAX()

Correct! Wrong!

Which of the following is NOT part of AutoSum functions?

COUNT()

IF()

Correct! Wrong!

Which function counts numeric values in a range?

SUM()

COUNT()

AVERAGE()

MIN()

Correct! Wrong!

What is the purpose of GEOMEAN in business analytics?

Calculate growth rate

Add numbers

Count values

Find maximum

Correct! Wrong!

FBA-Lab6-Working with Functions MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements