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