CGS Exam 2 MC

A forecast sheet calculates: a. Intervals. b. Future values. c. Moving averages. d. Summaries. e. Date and time.

Future values

In an Excel table, the first row of the table with unique descriptive titles or labels is called the: a. Header row b. Title row c. Field bar d. Ribbon e. Descriptor

Header row

The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell should be formatted is: a. Conditional Rules b. Conditional Selection c. Highlight Cells Rules d. DataFind e. Standard Deviation

Highlight Cells Rules

A column chart that illustrates the frequency of each data point in a data set is called a(n): a. Scene. b. 3D Map. c. Moving Range. d. Tour. e. Histogram.

Histogram

A conditional column uses a(n) _____ to display new data in a query. a. IF statement. b. Merge command. c. OR statement. d. Append command. e. Join.

IF statement

This function displays the contents of the cell at the intersection of an identified column and row: a. INTERSECT b. ADDRESS c. INDEX d. AUTOFIND AGGREGATE

INDEX

A combination of instructions, filters, and formats that establishes a connection to and displays data is a: a. Scenario. b. Report. c. Sorter. d. Query. e. Numerator.

Query

To update a Power Query Editor, choose: a. Recalculate. b. Refresh. c. Save As. d. Delimit. e. Transform.

Refresh

The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is: a. AVERAGEIFS. b. COUNTIFS. c. ROUNDIF. d. SUMIFS. e. RANK.EQ.

SUMIFS

A saved set of values in a worksheet that functions as a "what-if" analysis tool is a(n): a. Hypothetical. b. Condition. c. Scenario. d. Limited data. e. Comment.

Scenario

A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n): a. One-variable data table. b. Forecast sheet. c. Scenario summary report. d. Analysis report. e. Two-variable data table.

Scenario summary report

A Solver problem has three components, known as: a. Fields. b. Sectors. c. Conditions. d. Data models. e. Parameters.

Parameters

The Microsoft Office relational database application that works with Excel to import and export data is called: a. WordPad b. Backstage c. Office Wizard d. DataDrop e. Access

Access

Solver is an enhanced Excel tool that is an example of an Excel: a. Add-in. b. Cross link. c. Macro. d. XML command. e. Model.

Add-in

An Excel add-in with statistical and engineering functions is the: a. Forecast sheet. b. Analysis ToolPak. c. Solver. d. Goal Seek tool. e. Descriptive Statistics.

Analysis ToolPak

Like many financial functions, the PV function uses the concept of a(n): a. Compound interest. b. Fixed rate. c. Annuity. d. Present value. e. Deviation.

Annuity

Database functions all follow the same syntax and have three: a. Results. b. Formulas. c. Functions. d. Arguments. e. Variables.

Arguments

A range of cells that you select in which to apply a function is called a(n): a. Objective. b. Function range. c. Target. d. Array. e. Grid

Array

A problem-solving method that starts with a result and calculates the value to reach that result is: a. Forecasting. b. Constraining. c. Analysis. d. Backsolving. e. Goal Seeking.

Backsolving

The Statistical function that does computations only after data meets multiple criteria is: a. STDEV.S. b. COUNTIFS. c. ROUND. d. STDEV.P. e. RANK.EQ.

COUNTIFS

When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells, use this Excel feature: a. AutoFormat b. Shade and Fill c. Filter d. Conditional formatting e. Range formatting

Conditional formatting

To use an Advanced Filter in Excel, you first need to create a: a. Condition b. Criteria range c. Location d. Data definition e. Query

Criteria range

Calculated data that appears in the Power Query but is not a field in the source data is called a: a. Ghost field. b. Cell reference. c. Custom column. d. Dynamic field. e. Query field.

Custom column

The database function that counts the cells in the field that are not empty and that meet the criteria is: a. DCOUNTA. b. DCOUNT. c. COUNTIF. d. ECOUNT. e. DSUM.

DCOUNTA

The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is: a. Data visualization b. Graphic interface c. Gradient display d. Special formatting e. Data table

Data Visualization

A collection of tables and queries in a workbook is called a: a. Custom column. b. Power Query. c. Data model. d. PivotTable. e. Key field.

Data model

A range of cells that shows calculated results of one or more formulas is called a(n): a. Data table. b. Numerator. c. Range return. d. Net return. e. Scenario.

Data table

When you import a document into Excel that uses special characters, such as commas to separate columns, you are importing a: a. Delimited file b. Field file c. Table d. Grid defined file e. Source file

Delimited file

To sort numerical data from the largest to the smallest value, use this sort order: a. Ascending b. Conditional c. Filter d. Descending e. Down

Descending

Summary measures for a data range such as the mean or average, the maximum, the minimum, or a count are: a. Intervals. b. PivotTables. c. Sums. d. Moving averages. e. Descriptive statistics.

Descriptive statistics

Available Add-ins for Excel are found in the: a. Quick Access toolbar. b. Excel Options dialog box. c. Home tab. d. Excel OneDrive Preferences. e. Excel Developer tab.

Excel Options dialog box

Imported content in a worksheet that originated in another program or format is called: a. External data b. Imported content c. Matching sheets d. Exported files e. Access database

External data

The Slicer tool creates an on-screen window that acts as a(n): a. Editor. b. Filter. c. Scenario. d. Sorter. e. Query.

Filter

When you want to make the same change to many functions or formulas in a worksheet use this command: a. Sort and Filter. b. Find and Replace. c. Fill Series. d. Delete and Insert. e. Smart Lookup.

Find and Replace

An Excel command that recognizes a pattern and duplicates it is: a. AutoSum b. AutoComplete c. Flash Fill d. Copy Down e. Replicate

Flash Fill

In a calculation, the difference between actual values and predicted values is called: a. Distance. b. Margin of error. c. Forecast error. d. Derivation. e. Average.

Forecast error

Which depicts how a value compares to a measure? a. Timeline b. Custom calculation c. Relationship d. Slicer e. Key Performance Indicator

Key Performance Indicator

Web site data can be imported into Excel if the data is: a. Hyperlinked b. List-type c. Delimited d. Simplified e. CSS

List-type

The language that is specific to Power Query is: a. SQL. b. VBA. c. M language. d. Macro. e. XML.

M language

When you use Excel's subtotal command your list data is formatted as a(n): a. Outline b. Table c. Worksheet d. Record e. Group

Outline

To save a custom grouping or subset of items in a PivotTable, create a(n): a. Key field. b. Named set. c. Slicer. d. Custom calculation. e. Foreign column

Named Set

A function within a function is described as: a. Complex. b. Dependent. c. Secondary. d. Parenthetical. e. Nested.

Nested

In a financial function, nper stands for: a. New percentage rate. b. Number of payments. c. Nolo persona. d. Non-negotiable percentage. e. Null permitted.

Number of payments

A cell with a formula that will be solved for specific results is called a(n): a. Input cell. b. Analyzer. c. Prime cell. d. Objective cell. Result cell

Objective cell

How many scenarios can be displayed in a worksheet at any one time? a. One b. Two c. Three d. Four e. Eight

One

To create a slicer, click the Insert Slicer button in the Filter group on the: a. Review tab. b. PivotTable Tools Analyze tab. c. View tab. d. Power Query Tools tab. e. Formulas tab.

PivotTable Tools Analyze tab

A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n): a. Conditional column. b. Power Pivot. c. XML file. d. Power Query. e. Key Performance Indicator.

Power Pivot

The Create Relationship dialog box identifies a Table and a Related Table; the Related Table has a: a. Relationship field. b. Primary column. c. Calculated column. d. Foreign column. e. Matching column.

Primary column

The process of arranging rows of data in an identified order is called: a. Sorting b. Arranging c. Editing d. Formatting e. Aligning

Sorting

A forecast sheet inserts functions into its tables from which function category? a. Financial b. Statistical c. Logical d. Data and Time e. Text

Statistical

he Standard Deviation functions are found in this category: a. Financial. b. Logical. c. Text. d. Math & Trig. e. Statistical.

Statistical

What text function that includes a delimiter argument allows you to join or combine strings of text? a. CONCAT b. TEXTJOIN c. EXACT d. REPLACE e. TRIM

TEXTJOIN

When you apply a predesigned set of built-in format options such as borders, fill colors, and effects for an Excel table, you use a: a. Custom group b. Filter c. Data design d. Table style e. Layout

Table style

Which type of function would you use to format a value as a label? a. Logical b. Text c. Financial d. Math & Trig e. Lookup and Reference

Text

The type of importable document that includes raw data, no formatting, and uses commas or other characters to separate the data into columns and rows is a: a. Field b. Text file c. List d. Table e. Worksheet

Text file

A series of scenes created by 3D Map that visualize your data is a(n): a. Chart. b. Tour. c. Scenario. d. Power Map. e. Plot.

Tour

In an OR function, if any one of the arguments is true, the result is: a. Logical. b. False. c. Inconclusive. d. Circular. e. True.

True

What settings determine how data is summarized in a PivotTable? a. PowerPivot b. Value field c. Form box d. Text box e. Numeric range

Value field

To display the entire code for a Power Query, click the Advanced Editor button in the Advanced group of the: ? a. Review tab. b. Data tab. c. Formulas tab. d. View tab. e. Home tab.

View tab

A file format that is designed for exchanging data on the web is called: in OneDrive? a. XSD. b. SFX. c. XDE. d. CSS. e. XML.

XML