Exam 2

The maximum number of scenarios scenario manager can handle is

32

A spreadsheet PROGRAM is defined as

A software application used to create and modify spreadsheets

Filtering the last_name column field to show only records that begin with the letter S is an application of

A text filter

The strength of a pivot table lies in its

Ability to easily and quickly rearrange data

A 3-D chart

Adds a third dimension to each data series, creating a distorted perspective of the data

Sorting arranges records in a table

By the value in fields within a table

To create a calculated field select ____ located on the pivot table tool options tab

Calculations

_____ are created to organize and summarize data in pivot tables

Categories

After creating a scenario summary report, it is recommended that you do all the following EXCEPT:

Change the colors of the title row

Which of the following will not remove a field name from a pivot table?

Click a field name in the drag fields between areas below section and then press the delete key

To adjust the column width and/or row height of many cells at once

Click and drag across the cells to select them and use any sizing method you choose

Which of the following will not delete a pivot chart?

Click and drag the pivot chart off the worksheet

To begin a sort in a pivot table you must first

Click in any cell in the column you wish to sort

To select a range in using the name box

Click in the name box and type the range address such as B15:D25 and then press enter

To open a saved solver model you must first

Click load/save in the solver parameters dialog box

To create a table from an existing range of data

Click the insert tab and then click table in the tables group

To convert a table back into a range

Click within the table, click the table tools design tab, and then select convert to range

A multiple data series chart

Compares two or more sets of data in one chart

A single data series

Compares values for one set of data

A chart sheet

Contains a single chart and no spreadsheet data

The table style options group

Contains check boxes to select format actions such as header row which displays the header 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 a data series

Which of the following is NOT an important element when creating a pivot table?

Create meaningful record names

The solver summary report is

Created in a new worksheet

In a data table, the ____ number format is used to disguise the formula reference in the first row as a label

Custom

The _____ dialog box contains the row and column input cell boxes

Data table

A print area

Defines the range of data to print

A total row appears as the last row of a table to

Display summary statistics, such as a sum

A column chart

Displays data comparisons vertically in columns

Sorting dates oldest to newest

Displays data in chronological order

The formula bar (as it applies to excel 2010)

Displays the content of the active cell

The TODAY function

Displays the current date

A sheet tab

Displays the name of a worksheet within a workbook

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 false about pivot tables?

Each row in the source data becomes a pivot table field

An area chart

Emphasizes magnitude of change over time by filling in the space between lines with a color

Previewing the worksheet in Backstage view

Enables you to adjust settings to control how the worksheet will print

A handle, indicated by faint dots on the outside border of a selected chart

Enables you to adjust the size of the chart

To create an effective outline in excel you must

Ensure the data has a hierarchical structure

A faster way to expand all categories at one time is to click

Expand entire field in the active field group

When you see the Sum of Total... in the values area box, position the pointer over the ___ in the values area to see a screen top with the full name

Field name

Top bottom rules

Format cells based upon their value in relation to the value of other cells such as the top 10%

For a basic mathematical expression it is best to use

Formulas such as +B4+C4

Which what if analysis tool would be best determining how much you can borrow for a car loan while paying only $250 a month?

Goal seek

Using conditional formatting to draw attention to cells containing errors

Helps locate errors in cells quickly

Using conditional formatting to draw attention to cells that are blank

Helps locate where data may be missing

Conditional formatting

Highlights or emphasizes cells that meet certain conditions

A cell address (as it applies to excel 2010)

Identifies a cell by a column letter and a row number

The name box

Identifies the address of the current cell

The MAX function

Identifies the highest value in a range

A relative cell reference

Indicates a cells relative location from the cell containing the formula; the reference changes when you copy the formula

An absolute cell reference

Indicates a cells specific location and the reference does not change when you the formula

To put a long text label on two or more lines within a single cell

Insert a line break with alt+enter key combination

In excel 2010, dataset

Is a collection of structured, related data in columns and rows

A color scale

Is a conditional format that displays a particular color based on the relative value of the cell contents to other selected cells

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

An axis title

Is a label that describes either the category axis or the value axis

A trendline

Is a line used to depict trends and forecast future data

The table array

Is a range containing a lookup value

The lookup value

Is a reference to a cell containing a value to lookup

Syntax

Is a set of rules that govern the structure and components for a function

The fill handle (as it applies to excel 2010)

Is a small black square at the bottom right corner of a cell that facilities fill operations

An argument (as it applies to excel 2010)

Is an input such as a cell reference or a value needed to complete a function

Row height

Is the adjustable vertical measurement of a row

The active cell

Is the location of the insertion point as indicated by a dark border

Semi-selection or pointing

Is the process of using the mouse to select cells while building a formula

Print order

Is the sequence in which pages print

The sort by value dialog box contains the following options EXCEPT:

Manual (you can drag items to rearrange them)

Filtering the cost column (field) to show only records greater than $10,000 is a

Number filter

A circular reference

Occurs when a formula directly or indirectly refers to the cell containing the formula

To build a pivot table or pivot chart at the same time, click the pivot table arrow and then

Pivot chart

Predefined styles to format a pivot table are available in the

Pivot table style gallery

A 100% stacked column chart

Places (stacks) data in one column per category with each column having the same height of 100%

Vertical alignment (as it applies to excel)

Refers to the up-down position of contents in a cell

To begin a filter based on a particular field, you drag the desired field to which area under drag fields between areas below?

Report file

To begin a filter based on a particular field, you drag the desired field to which are under drag fields between areas below?

Report filter

Each column in a table

Represents a field, which can contain an individual piece of data for a record

To modify the pivot table value settings you must first

SElect the value in the appropriate field in the pivot table

To transpose columns and rows

Select and copy the original range then clip the top left corner of the destination range, click the paste arrow then click transpose

To remove duplicate records

Select any cell in the table, then click remove duplicates from the tools group on the table tools design tab

To ensure a pivot table is up to date when workbook opens

Select refresh data when opening the file in the pivot table options dialog box in the data tab

An exploded pie chart

Separates one or more pie slices from the rest of the pie chart

It is wise to create a pivot table in a new worksheet because

Separating the pivot table from the original dataset will prevent accidental deletion of the original data set

Which of the following has to be loaded onto excel

Solver

Which of the following is NOT in the what if analysis command in the data tools group on the data tab?

Solver

The COUNT function

Tallies the number of cells in a range that contain values

The value you want to achieve in goal seek needs to be entered in the ___ box in the Goal Seek dialog box

To value

Which what if analysis tool would be best at comparing the combined effects of various interest rates and down payments?

Two variable data table

A pivot table report filter filters based

Upon a particular field

A pivot table group filter filters data based

Upon the row and column label groupings

To change the data source of a chart

Use the select data source dialog box from the select data button

To freeze columns and/or rows

Use the view tab, window group and click freeze panes

A line chart

Uses a line to connect in order to show trends over a period of time

If you change any of the solver parameters

You will need to create another solver report

An input are (as it applies to excel 2010) is defined as

a range of cells contacting values for variables used in formulas

The average function

calculates the arithmetic mean of values in a range

To add a record (row) to a table

click in a cell and on the home tab, click insert arrow in cells group

A nonadjacent range

contains two or more cells or ranges that are not touching each other

The order of precedence (as it applies to math operations in excel)

controls the sequence in which excel performs arithmetic operations