CGS2518 Exam 2 Multiple Choice

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

c. 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

c. Scenario summary report

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 Solving

d. Backsolving

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 e. Result cell

d. Objective cell

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

d. Query

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

d. View tab

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

e. Descriptive statistics

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

e. Histogram

Which depicts how a value compares to a measure? a. timeline b. custom calculation c. relationship d. slicer e. Key performance indicator

e. Key performance indicator

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

e. Parameters

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

e. XML

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.

A 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.

A Data visualization.

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.

A Delimited file.

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

A External data

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.

A Header row.

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.

A Outline.

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

A Sorting.

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. A text file. c. A list. d. A table. e. A worksheet.

B A text file.

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.

B COUNTIFS.

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.

B Criteria range.

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.

B Find and Replace.

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

B List-type.

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.

B Number of payments.

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

B TEXTJOIN

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

B Text

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.

C Annuity.

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

C Deviation.

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

C Flash Fill.

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.

C Highlight Cells Rules.

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 e. AGGREGATE

C INDEX

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. A filter. c. A data design. d. A table style. e. A layout.

D A table style.

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

D 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

D Array.

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

D Conditional formatting

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

D Descending

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.

D SUMIFS.

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.

E Access.

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

E Nested.

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

E Statistical.

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.

E True.

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

a. Add-in

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

a. Data table

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

a. IF statement

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

a. One

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

b. Power Pivot

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

b. Analysis ToolPak

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

b. Excel Options dialog box

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

b. Filter

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

b. Future values

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

b. PivotTables Tools Analyze tab

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

b. Primary column

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

b. Refresh

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

b. Statistical

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. Pivot

b. Tour

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

b. Value field

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

b. named set

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

c. Custom column

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

c. Data model

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

c. M language