How can we help?

You can also find more resources in our Help Center.

73 terms

CS 235 Exam 2

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