Quiz 1
1. Question: (TCO 1) An Output Area (as it
applies to Excel 2016) is defined as _____.2. Question: (TCO 1) In Excel 2016, a cell
is best described by which of the following?3. Question: (TCO 1) Which of the following
best describes the AutoComplete function?4. Question: (TCO 1) In Excel a formula
_____.5. Question: (TCO 1) Which of the following
best describes the result of using the fill handle on a cell containing a
form..
Quiz 2: Excel's Advanced Formulas, Functions, and Charts
1. Question:
(TCO 2)
A(n) _____ is tested in an IF function to determine if it is true or false.2. Question:
(TCO 2)
Which of the following steps can be used to insert a SUM function?3. Question:
(TCO 2)
The _____ function displays the current date in a cell.4. Question:
(TCO 2)
The PMT function is best described by which of the following?5. Question:
(TCO 3)
A data series is a gr..
Quiz 3: Data Analysis Functions
1. Question:
(TCO 4)
How many possibilities exist when thinking about the freeze options?2. Question:
(TCO 4)
In Excel, a table is defined as _____.3. Question:
(TCO 4)
To create a table from an existing range of data, _____.4. Question:
(TCO 4)
Filtering the Cost column (field) to show only records greater than $10,000 is
an application of _____.5. Question:
(TCO 4)
To apply a red background color to..
Quiz 4: Consolidating Data
1. Question:
(TCO 5)
Excel's multiple worksheet abilities can do all of the following except2. Question:
(TCO 5)
In Excel, which of the following would you perform to group nonadjacent
worksheets?3. Question:
(TCO 5)
If the active cell is in column A, but not in row 1, when you click the Split
command, the worksheet will appear in two ________ panes.4. Question:
(TCO 5)
In Excel, which of the following is not a method for r..
Quiz 5: Excel's Advanced Functions and Statistical Functions
1. Question:
(TCO 9)
Which of the following is a nested function?2. Question:
(TCO 9)
If there are four possible outcomes, how many logical tests are required?3. Question:
(TCO 9)
When using the MATCH function looking for the largest value that is less than
or equal to the match lookup_value, the match type must be set to _____.4. Question:
(TCO 9)
Which of the following functions will return the interest paym..
Quiz 6: What-If Analysis
1. Question (TCO 6) Which of the following tools is an add-in?
2. Question (TCO 6) Which of the following is NOT in the What-If Analysis command in the
Data Tools group on the Data tab?
3. Question (TCO 6) In a data table, the _____ number format is used to disguise the
formula references in thefirst row as labels.
4. Question (TCO 6) A series of ______ indicates that which of a column is too narrow
to display the complete number
5. ..
Quiz 7: Importing and Macros
1. Question
(TCO 8)
Which of the following is a file type that cannot be imported into Excel?
(Points : 2) 2. Question
(TCO 8)
Which of the following file types uses tabs to separate data into columns?
(Points : 2) 3. Question
(TCO 8)
Where are web query tools and options located? (Points : 2) 4. Question
(TCO 8)
Which of the following are settings that control how imported data in cells
connect to their source data..