CS 235 Exam 2
Which of the following is NOT an important element when creating a PivotTable?
Create meaningful record names.
Which of the following is NOT one of the three parameters in Solver?
Input value
Click the ________ to sort or filter the chart representation based on the values.
Legend Field arrows
Where do you go to begin loading the Solver add-inn?
Options on the File tab.
Which of the following is NOT one of the major sections of a Solver report?
Original Value
Which of the following is NOT true about the Subtotal command?
The Subtotal dialog box can be used with tables.
Top Bottom Rules
format cells based upon their value in relation to the value of other cells such as the top 10%.
Ribbon Commands with arrows indicate
there are two or more sub-commands related to the command
To show a "hidden" row one (1) or a "hidden" column A.
type A1 in the name box and then press "Enter"
A PivotTable Report Filter filters data based:
upon a particular field.
A doughnut chart displays
values as percentages of the whole but may contain more than one data series.
If you change any of the Solver parameters:
you will need to create another Solver report
The maximum number of scenarios Scenario Manager can handle is:
32
The Show group includes all EXCEPT
Calculations
To create a calculated field select ________ located on the PivotTable Tools Options tab.
Calculations
Which of the following will NOT remove a field name from a PivotTable?
Click a field name in the Drag fields between areas below section and then drag it outside the PivotTable Field List
Which of the following is NOT an important element when creating a PivotTable?
Create meaningful record names
After creating a chart you can change the chart type by using
Design tab / Change Chart Type button.
Which of the following is FALSE about PivotTables?
Each row in the source data becomes a PivotTable field.
Which tools have the ability to change values in the original dataset?
Goal Seek & Solver
What is the main difference between Goal Seek and variable data tables?
Goal Seek uses the original worksheet data to change an input.
Which of the following is NOT a concern when adding subcategories to a PivotTable?
It improves the readability of the PivotTable.
The Sort by Value dialog box contains the following options EXCEPT:
Manual (you can drag items to rearrange them)
To build a PivotTable and PivotChart at the same time, click the PivotTable arrow and then select ________.
PivotChart
After a PivotChart has been created, the PivotTable Settings can still be changed by using the:
PivotTable Field List.
Which of the following is NOT required for Solver to generate a solution?
Precedent values
To insert the current date into an active cell use
The Ctrl and semicolon key combination.
The value you want to achieve in Goal Seek needs to be entered in the ________ box in the Goal Seek dialog box.
To value
The PivotChart Tools contextual tab includes all the following EXCEPT:
Type
A spreadsheet PROGRAM is defined as
a software application used to create and modify spreadsheets.
The Reports list in the Solver Results dialog box displays the:
available report types.
The PMT function
calculates the periodic payment for a loan with a fixed interest rate and fixed term.
After creating a scenario summary report, it is recommended that you do all the following EXCEPT
change the colors of the title row
To open a saved Solver model you must first:
click Load/Save in the Solver Parameters dialog box.
To add a record (row) to a table,
click in a cell and on the Home tab, click the Insert arrow in the Cells group.
To begin a sort in a PivotTable, you must first:
click in any cell in the column that you wish to sort
A nested function
contains another function embedded inside one or more of its arguments.
A mixed cell reference
contains both an absolute and a relative cell reference
The Table Style Options Group
contains check boxes to select format actions such as First Column which applies a different format to the first column when checked.
The Table Style Options Group
contains check boxes to select format actions such as Total Row which displays a Total Row when Checked.
A lookup table
contains data for the basis of the lookup and the data to be retrieved
The plot area
contains graphical representation of values in data series.
The first section of a Solver report:
displays information about the report.
The NOW function
displays the current date and time.
A surface chart
displays trends using two dimensions on a continuous curve.
After entering the substitution values and the reference to a formula, the next step to complete a two-variable data table and view the results is to:
drag to select the data table boundaries.
An area chart
emphasizes magnitude of changes over time by filling in the space between lines with a color.
When you see Sum of Total... in the Values area box, position the pointer over the ________ in the Values area to see a ScreenTip with the full name
field name
Conditional formatting
highlights or emphasizes cells that meet certain conditions
The Name Box (as it applies to Excel 2010)
identifies the address of the current cell.
One benefit of using range names in formulas is
if you copy the formula, you do not have to make the cell reference absolute
An icon set
is a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
The lookup value
is a reference to a cell containing a value to look up.
A table
is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
A field
is an individual piece of data, such as a last name.
The column index number
is the argument in a VLOOKUP function that identifies from which column to return a value.
A cell (as it applies to Excel 2010)
is the intersection of a column and a row.
The NPER
is the total number of payment periods.
The HLOOKUP function
looks up a value in a lookup table where the first row contains the values to compare with the lookup value.
A Pivot Table Style controls all EXCEPT:
number format.
A circular reference
occurs when a formula directly or indirectly refers to the cell containing the formula.
A one-variable data table must have at least ________ blank row and ________ blank column between the dataset and the data table.
one, one
Data mining techniques such as PivotTables can detect ________ of data.
patterns
A stacked column chart
places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
Excel displays a green arrow in the top left corner of a cell if it detects a
potential error.
A function is a
predefined formula that performs a calculation.
Each row in an Excel table
represents a record
Each row in an Excel table
represents a record.
The Show Iteration Results option allows you to:
see the values of each trial solution prior to reaching a final solution.
To ensure a PivotTable is up to date when the workbook opens:
select Refresh data when opening the file in the PivotTable Options dialog box on the Data tab.
An X Y (scatter) chart
shows a relationship between two variables.
For Subtotals to be useful and accurate, it is important that the data be ________ correctly
sorted
