FBA-Lab6-Working with Functions MCQs

(Tab to RIGHT OPTION to see the answer.)

What is the purpose of GEOMEAN in business analytics?

Count values

Add numbers

Find maximum

Calculate growth rate

Correct! Wrong!

Which function returns the largest value?

MIN()

COUNT()

MAX()

AVERAGE()

Correct! Wrong!

Which function counts numeric values in a range?

MIN()

SUM()

AVERAGE()

COUNT()

Correct! Wrong!

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

Formula is predefined

Function cannot calculate

Function is predefined

Both are same

Correct! Wrong!

Which function finds the middle value in a dataset?

MEDIAN()

AVERAGE()

COUNT()

MAX()

Correct! Wrong!

Which function calculates the mean of values?

AVERAGE()

MAX()

MIN()

SUM()

Correct! Wrong!

Which function is used to add a range of numbers?

MAX()

COUNT()

AVERAGE()

SUM()

Correct! Wrong!

Which measure is best for average speed?

Median

Geometric Mean

Harmonic Mean

Correct! Wrong!

Which function calculates harmonic mean?

AVERAGE()

GEOMEAN()

COUNT()

HARMEAN()

Correct! Wrong!

Which AutoSum function calculates total revenue?

MAX()

SUM()

COUNT()

MIN()

Correct! Wrong!

Which function calculates geometric mean?

AVERAGE()

GEOMEAN()

MEDIAN()

HARMEAN()

Correct! Wrong!

What does AutoSum provide quick access to?

Only SUM

Charts

Formatting tools

Five core functions

Correct! Wrong!

Which function counts the number of days in a dataset?

AVERAGE()

COUNT()

SUM()

MAX()

Correct! Wrong!

Which function identifies the lowest number of units sold?

MIN()

SUM()

MAX()

COUNT()

Correct! Wrong!

Which formula represents midrange correctly?

(MAX + MIN) / 2

MIN / MAX

MAX + MIN

MAX / MIN

Correct! Wrong!

Which function is used to find average daily sales?

COUNT()

AVERAGE()

SUM()

MAX()

Correct! Wrong!

Which of the following is NOT part of AutoSum functions?

COUNT()

IF()

Correct! Wrong!

Which formula calculates total frames sold?

=MAX(B2:B31)

=COUNT(B2:B31)

=AVERAGE(B2:B31)

=SUM(B2:B31)

Correct! Wrong!

Which function returns the smallest value?

MIN()

SUM()

MAX()

COUNT()

Correct! Wrong!

What is the correct syntax of a function?

FUNCTION_NAME(argument1, argument2)

FUNCTION_NAME argument

FUNCTION_NAME=argument

=FUNCTION_NAME argument

Correct! Wrong!

What is a function in Excel?

A worksheet name

A formatting option

A chart tool

A predefined formula

Correct! Wrong!

Which of the following is an example of a function?

B2*C2

Correct! Wrong!

FBA-Lab6-Working with Functions MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements