CGS2518 - EXAM 2 - FSU - Armstrong

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.