Excel 2016 Training & Testing
Which is an example of an absolute reference in Excel?
$K$1
Which item is used to tell the IF function that the user wants a field to remain blank?
""
Which item means a formula cannot perform its function in Excel?
#REF!
Which symbol is used to keep a formula variable constant?
$
Which are types of date filters in Excel 2016? Choose two answers.
After Before
Which character is always at the beginning of a formula in Excel 2016?
=
The MAX function is located in the ____________ drop-down menu.
AutoSum
Which is used to insert the Sum function into an Excel document?
AutoSum
Which items do not affect the AVERAGE function?
Blank cells
Which are types of COUNT functions in Excel 2016? Choose three answers.
COUNTA COUNTBLANK COUNTIF
Which best defines the purpose of the PROPER function?
Capitalizes the first letter of every word for each cell of a cell range
Users can clear any filters on a table in Excel 2016 using which tab on the ribbon?
Data
Users can add a total row to a table using which tab in Excel 2016?
Design
Which is a true statement concerning duplicate record removal in Excel 2016?
Excel will delete the bottommost duplicate records first
Data in Excel 2016 needs to be in a table in order for it to be sorted properly.
False
Which symbol tells a user that a filter is currently in use on a table, and what that filter is?
Funnel with an arrow next to it
Which is a best practice when dealing with formulas and functions in Excel?
Have an empty row and an empty column between data and totals
Which are configuration options for table styles in Excel 2016? Choose three answers.
Header Row Banded Rows First Column
Which is a true statement regarding adding data to a table in Excel 2016?
If a user types text next to a table, it will, by default, be added to the table
In order to edit an existing formula in Excel, the user can click which item?
Insert Function button
Which is a true statement about changing sort order in Excel 2016?
It is safe to change the sort order of a single column in a table.
The SUMIF function can be found under which drop-down menu in Excel?
Math & Trig
The COUNT function can only count which item in Excel?
Numbers
Where on the ribbon is the COUNTIF function located in Excel 2016?
The Statistical group under the More Functions drop-down menu
In a conditional function like SUMIF, which item refers to where the condition is located?
Range
Which is the first step to creating a chart in Excel 2016?
Select the data including the labels
Which MID function element specifies which character in the cell range will be the beginning of the extraction?
Start_num
Which best defines the CONCAT function?
Taking two pieces of text and combining them
The RIGHT function is located under which drop-down menu in the Formulas tab?
Text
Which is a sign that a user is working inside of a table in Excel 2016?
The Design tab will be visible
The IF function can be found in which are of Excel?
The Logical drop-down menu under the Formulas tab
Which is a true statement concerning basic formulas in Excel 2016?
The user does not need to alter the formula when entering new data into applicable cells
In addition to the AutoSum feature, users can simply type the SUM function in Excel.
True
When sorting information inside of a table on multiple columns, it is important to sort the most detailed column first.
True
By default, the LEFT function will only move the _______________ from the left to the new location.
first letter