CS 235 Exam 2

Created by reidb93 

Upgrade to
remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set