Studied by 95 people
Looks like no one added any tags here yet for you.
When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells, use this Excel feature:
Group of answer choices
AutoFormat
Shade and Fill
Filter
Conditional formatting
Range formatting
Conditional formatting
What text function that includes a delimiter argument allows you to join or combine strings of text?
Group of answer choices
CONCLAVE
TEXTJOIN
EXACT
REPLACE
TRIM
TEXTJOIN
In a financial function, nper stands for:
Group of answer choices
New percentage rate.
Number of periods.
Nolo persona.
Non-negotiable percentage.
Null permitted.
Number of periods.
This function displays the contents of the cell at the intersection of an identified column and row:
Group of answer choices
INTERSECT
ADDRESS
INDEX
AUTOFIND
AGGREGATE
INDEX
A range of cells that you select in which to apply a function is called a(n):
Group of answer choices
Objective.
Function range.
Target.
Array.
Grid
Array
The Statistical function that does computations only after data meets multiple criteria is:
Group of answer choices
STDEV.S.
COUNTIFS.
ROUND.
STDEV.P.
RANK.EQ.
COUNTIFS.
The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is:
Group of answer choices
AVERAGEIFS.
COUNTIFS.
ROUNDIF.
SUMIFS.
RANK.EQ.
SUMIFS.
Database functions all follow the same syntax and have three:
Group of answer choices
Results.
Formulas.
Functions.
Arguments.
Variables.
Arguments
An Excel add-in with statistical and engineering functions is the:
Group of answer choices
Forecast sheet.
Analysis ToolPak.
Solver.
Goal Seek tool.
Descriptive Statistics.
Analysis ToolPak.
A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n):
Group of answer choices
One-variable data table.
Forecast sheet.
Scenario summary report.
Analysis report.
Two-variable data table.
Scenario summary report.
A cell with a formula that will be solved for specific results is called a(n):
Group of answer choices
Input cell.
Analyzer.
Prime cell.
Objective cell.
Result cell.
Objective cell.
A saved set of values in a worksheet that functions as a “what-if” analysis tool is a:
Group of answer choices
Hypothetical.
Condition.
Scenario.
Limited data.
Comment.
Scenario.
Solver is an enhanced Excel tool that is an example of an Excel:
Group of answer choices
Add-in.
Cross link.
Macro.
XML command.
Model.
Add-in.
What settings determine how data is summarized in a PivotTable?
Group of answer choices
PowerPivot
Value field
Form box
Text box
Numeric range
Value field
A column chart that illustrates the frequency of each data point in a data set is called a(n):
Group of answer choices
Scene.
3D Map.
Moving Range.
Tour.
Histogram.
Histogram.
How many scenarios can be displayed in a worksheet at any one time?
Group of answer choices
One
Two
Three
Four
Eight
One
A range of cells that shows calculated results of one or more formulas is called a:
Group of answer choices
Data table.
Numerator.
Range return.
Net return.
Scenario.
Data table.
A Solver problem has three components, known as:
Group of answer choices
Fields.
Sectors.
Conditions.
Data models.
Parameters.
Parameters.
To create a slicer, click the Insert Slicer button in the Filter group on the:
Group of answer choices
Review tab.
PivotTable Tools Analyze tab.
View tab.
Power Query Tools tab.
Formulas tab.
PivotTable Tools Analyze tab.
Available Add-ins for Excel are found in the:
Group of answer choices
Quick Access toolbar.
Excel Options dialog box.
Home tab.
Excel OneDrive Preferences.
Excel Developer tab.
Excel Options dialog box.
A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n):
Group of answer choices
Conditional column.
Power Pivot.
XML file.
Power Query.
Key Performance Indicator.
Power Pivot.
A collection of tables and queries in a workbook is called a:
Group of answer choices
Custom column.
Power Query.
Data model.
PivotTable.
Key field.
Data model.
The Slicer tool creates an on-screen window that acts as a(n):
Group of answer choices
Editor.
Filter.
Scenario.
Sorter.
Query.
Filter.
Note 
Flashcard (156)