FBLA: Spreadsheet Applications Quiz Questions!

1. Which of the following calculates the smallest in a collection of numbers?

LOW()

MIN()

SMALL()

COUNT()

MIN() calculates the smallest value in a collection of numbers. It compares all the numbers in the collection and returns the smallest one. This function is commonly used in data analysis and programming to find the minimum value in a set of data. It is a mathematical function that helps in determining the lowest value among a group of numbers.

Explanation

MIN() calculates the smallest value in a collection of numbers. It compares all the numbers in the collection and returns the smallest one. This function is commonly used in data analysis and programming to find the minimum value in a set of data. It is a mathematical function that helps in determining the lowest value among a group of numbers.

2. The ____ is the number in the middle of a collection of numbers.

Mean

Average

Mode

Median

The median is the number in the middle of a collection of numbers. It is found by arranging the numbers in ascending order and selecting the middle value. If there is an even number of values, the median is the average of the two middle values. The median is a measure of central tendency that is not affected by extreme values or outliers, making it useful for representing the typical value in a dataset.

Explanation

The median is the number in the middle of a collection of numbers. It is found by arranging the numbers in ascending order and selecting the middle value. If there is an even number of values, the median is the average of the two middle values. The median is a measure of central tendency that is not affected by extreme values or outliers, making it useful for representing the typical value in a dataset.

3. The expression _____ returs the maximum value in the range A1:A100 and then divides the value by 100.

=MAX(A1:A100/100)

=MAX(100)/(A1:A100)

=MAX(A1:A100)/100

=MAXIMUM(A1:A100)/100

The correct answer is =MAX(A1:A100)/100. This expression calculates the maximum value in the range A1:A100 and then divides that value by 100.

Explanation

The correct answer is =MAX(A1:A100)/100. This expression calculates the maximum value in the range A1:A100 and then divides that value by 100.

4. What does the COUNT() function count?

Cell references

Formulas

Numbers

Text

The COUNT() function counts the number of cells in a range that contain numerical values. It does not count cell references, formulas, or text. This function is commonly used in Excel to determine the number of numerical entries in a dataset or range.

Explanation

The COUNT() function counts the number of cells in a range that contain numerical values. It does not count cell references, formulas, or text. This function is commonly used in Excel to determine the number of numerical entries in a dataset or range.

5. What is a predefined formula that claculates by using arguments in a specific order?

Analyze

Range

AutoSum

Function

A function is a predefined formula that calculates values by using arguments in a specific order. It is a built-in feature in most software programs, including spreadsheets and programming languages. Functions can perform various calculations and operations, such as mathematical calculations, text manipulation, date and time calculations, and more. They allow users to automate repetitive tasks and perform complex calculations by simply providing the necessary arguments.

Explanation

A function is a predefined formula that calculates values by using arguments in a specific order. It is a built-in feature in most software programs, including spreadsheets and programming languages. Functions can perform various calculations and operations, such as mathematical calculations, text manipulation, date and time calculations, and more. They allow users to automate repetitive tasks and perform complex calculations by simply providing the necessary arguments.

6. The _____ function returns the integer for the current date and time.

NOW()

CURRENT()

DATE()

TIME()

The NOW() function returns the current date and time as an integer value.

Explanation

The NOW() function returns the current date and time as an integer value.

7. Which function merely counts the cells that are empty?

ADD

COUNTBLANK

COUNT

SUM

The correct answer is COUNTBLANK. This function specifically counts the number of cells in a range that are empty. It does not take into account any other type of data or calculations, only the empty cells.

Explanation

The correct answer is COUNTBLANK. This function specifically counts the number of cells in a range that are empty. It does not take into account any other type of data or calculations, only the empty cells.