Question 1

The BIG function determines the nth largest value in a range. _________________________

Accepted Answer

LARGE

Question 2

To obtain the value for the lowest or highest Friction Coefficient values, the MIN and MAX functions would suffice. _________________________

Accepted Answer

The MIN and MAX functions can be used to obtain the lowest and highest Friction Coefficient values, respectively.

Question 3

To determine if a value is greater than or equal to another value, you can use syntax operators. _________________________

Accepted Answer

relational

Question 4

The RANDOM function randomly assigns a number between two specified values. _________________________

Accepted Answer

RANDBETWEEN

Question 5

The ADDIF function adds all the values in a range that meet specified criteria. _________________________

Accepted Answer

SUMIF

Question 6

The ____ is the arithmetic average of a set of numbers.

Accepted Answer

The mean is calculated by adding up all the numbers in a set and then dividing by the total number of values in the set. It represents the average value of the set. The other options (median, mode, standard deviation) do not necessarily represent the average of the set.

Question 7

The critical argument is essentially a test that the data must meet in order for it to be counted in the grouping. _________________________

Accepted Answer

criteria argument

Question 8

The ____ is the arithmetic value that occurs most frequently in a data set.

Accepted Answer

The mode is the value that occurs most frequently in a data set. The mean is the average of all values, the median is the middle value in a sorted set of data, and the standard deviation is a measure of the spread of the data. None of these options directly relate to the frequency of one specific value in the data set.

Question 9

The median is the arithmetic value that occurs in the middle of a data set when organized from lowest to highest, where half the values are less than and half the values are greater than the median value. _________________________

Accepted Answer

This is a correct definition of the median.

Question 10

The ____ is a measure of how widely the data values are dispersed from the arithmetic mean.

Accepted Answer

Standard deviation is a measure of the variability or dispersion of a data set. It measures how much the data values deviate from the mean, and provides a more accurate representation of the spread of the data than the range or interquartile range. A higher standard deviation indicates greater variability or dispersion in the data set.

Question 11

The COUNTIF function accommodates a(n) single contiguous range argument. _________________________

Accepted Answer

The COUNTIF function only accepts a single contiguous range argument, which means a range of cells that are adjacent to each other. If you want to count values in non-adjacent ranges, you need to use multiple COUNTIF functions or use other functions like SUMIF, AVERAGEIF, etc.

Question 12

Wingdings are symbols that you can use as part of the criteria to search for text strings; each symbol can be substituted for a character or set of characters. _________________________

Accepted Answer

Wildcards

Question 13

The Paste option called Paste Special pastes a connection to the original cells, including the applied formatting. _________________________

Accepted Answer

Paste Link
Paste link
paste link

Question 14

In the function RANK.EQ(number,ref,order), the number argument refers to the value to be ranked. _________________________

Accepted Answer

The number argument in the RANK.EQ function refers to the value that needs to be ranked.

Question 15

In the SUMIF function, the criteria argument identifies the cell range where the criteria are located. _________________________

Accepted Answer

range

Question 16

Excel uses the Goal Find tool to try various input values in order to calculate the required input to achieve your desired outcome. _________________________

Accepted Answer

Goal Seek

Question 17

The Format Cells dialog box, which can be opened from the Number group Dialog Box Launcher on the HOME tab, provides many options for changing the display of cell values. _________________________

Accepted Answer

The Format Cells dialog box does indeed provide many options for changing the display of cell values, and it can be accessed from the Number group Dialog Box Launcher on the HOME tab of the Excel ribbon.

Question 18

You can recalculate a worksheet at any time by pressing the F9 function key or by selecting the Refresh button found in the Calculation group on the FORMULAS tab on the ribbon. _________________________

Accepted Answer

Calculate Now

Question 19

Microsoft Excel allows you to use ____, such as LARGE, SMALL, and RANK.EQ, that help you to structure and analyze data in meaningful ways.

Accepted Answer

Functions are built-in formulas in Excel that perform specific calculations or tasks. They can help you analyze data and make sense of large amounts of information. Functions like LARGE, SMALL, and RANK.EQ are examples of statistical functions that help you organize and sort data in meaningful ways.

Question 20

The ____ is the arithmetic value that occurs in the middle of a data set when organized from lowest to highest, where half the values are less than and half the values are greater than the median value.

Accepted Answer

The median is the value that separates the lowest and highest half of a dataset, so half the values are greater than and half are less than the median. The mean is the arithmetic average of a dataset and may be affected by outliers. The mode is the most frequently occurring value in a dataset and may not exist or be unique in some datasets. The standard deviation measures the spread of data around the mean but does not indicate the central tendency of the data.

Quiz 2: Solving Problems with Statistical Analysis Tools