Excel Quiz 1: Chp 3-6
If none of the conditions specified in the IFS function are met, the function will return ________.
#N/A
An absolute cell reference is denoted by?
$ (a dollar sign)
If cell A2 contains a value that is less than 75, and "SEND" will be displayed when the logical test is FALSE, which of the following contains the correct IF function syntax?
=IF(A2<75,"DONT SEND","SEND")
Which of the following is the correct syntax when using the AND function within the IF function?
=IF(AND(B3<5,C1>7),"Pass","Fail")
If cell B7 contains a value that is greater than 20, and "ORDER" will be displayed when the logical test is TRUE, which of the following contains the correct IF function syntax?
=IF(B7>20,"ORDER","OK")
When cell B2 containing the formula =A4*B6 is copied to cell C1, the formula in cell C1 is ________.
B3*C5
____ allows a user to select an individual piece of data in a PivotTable and then create a copy on another worksheet of the individual records that were used to get that summary data.
Drilling down
Instead of typing the $ symbol in a cell reference, you can press the ___ key.
F4
The ____ function is an array function that allows you to easily filter a range of data based on criteria that you define.
FILTER
____ variables are fields within a data set that can be used to categorize data for comparison.
Grouping
The ____ function is the most commonly used logical function in Excel
IF
Which of the following is NOT an area in the Fields area?
List
____ are interactive tables that extract, organize, and summarize source data.
PivotTables
____ allows a user to import up to one million rows of data from multiple sources, such as large corporate databases, public data feeds, spreadsheets, and text files onto your computer.
Power Pivot
The ____ function will run calculations only on data that is in a subset when a filter is applied.
SUBTOTAL
The ____ function allows for the data to be organized vertically or horizontally - the orientation of the data does not matter for the function.
XLOOKUP
The AND function returns TRUE if ____ logical tests are true.
all
The inputs used by an Excel function to calculate a result are called ________.
argument
The OR function returns TRUE if ____ of the logical tests are true.
at least one
A(n) ____ chart is similar to a column chart except the data is horizontal instead of vertical.
bar
The process of removing unwanted characters, rearranging data in a cell, or correcting erroneous data in text is called _____.
cleansing
A(n) ____ chart is useful for comparing data sets that are categorized.
column
A(n) ____ chart displays two different types of data by using multiple chart types in a single chart object.
combination
The following function is an example of a(n) ____ function =IF(SUM(H2:J7)>High_Sales,.05,IF(SUM(H2:J7)>Medium_Sales,.025,"No Commission"))
complex
AND, OR, and NOT are examples of Excel ___ functions.
conjunction
A(n) ____ set is a collection of related data consisting of observational units, variables, and organized data.
data
A group of related data values to be charted is a(n) ____.
data series
An example of a ____ is =(C5+D5)/100
formula
An example of a ____ is =SUM(A1:A10)
function
____ is the data that has context, meaning, and relevance.
information
A ____ chart is used to communicate trends over time.
line
All arguments in a function are enclosed in a pair of...
parentheses ( )
A ____ chart is used to show the relationship of parts to a whole
pie
An individual data value in a data series is a data _____.
point
A ____ is a visual mechanism for quickly filtering data in a PivotTable
slicer
Optional arguments in a function are enclosed within
square brackets [ ]
A(n) ____ chart is useful when the sum of the data values is as important as the individual items
stacked bar charts
When creating a chart, best practices indicate that you first consider ____.
the basic design of the chart
Which of the following is an alternative to using a space when naming a range?
use an underscore
The combination of the graphical presentation of data with a focus on qualitative understanding is called data ____.
visualization
