Spreadsheet Modeling Final Exam

A(n) ______ refers to a cell with a fixed position in the worksheet

absolute cell reference

Hold down the _____ key to select nonadjacent cells

ctrl

What is the name of the box that displays the selected cell?

name box

When you click a chart, you will see two additional tabs (______ and ______) for working with the chart

design tab and format tab

All formulas begin with a(n) ______

=

The Mini Tool Bar enables us to auto fill data or formula

false

There are commands to change style such as the Total or Heading 1 style on the ______

cell styles gallery

Comma Style format displays a number with _______

two decimal places

Which of the following sign is used to make an absolute cell reference?

$

_______ is the keyboard shortcut to the last cell in the last column of the active area

ctrl + end

The Percent Style button formats selected cells as a percentage with _____

zero decimal places

Sparklines cannot be formatted

false

The Formula Bar displays the value or formula in the active cell

true

What is the name of the small square that enables you to auto fill data or formulas?

fill handle

The Sum button resides on both the Home tab and the Formulas tab

true

When you type data in a cell and press Tab, what cell becomes the active cell?

the cell to the right

Auto Fill generates and extends a series of values into adjacent cells in a worksheet

true

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called _______

sparklines

Row headings are identified by ______

numbers

Where is the fill handle located?

in the lower right corner of a selected cell

The COUNTIF function has two arguments _______

the range of cells to check and the criteria

Where do sheet tabs display in a workbook?

lower area of the workbook window

Which of the following Excel features recognizes a pattern in the data of a worksheet?

flash fill

You can sort a table in ascending or descending order

true

We can group multiple worksheets by right-clicking on the sheet tab, and then click ______ on the shortcut menu

select all sheets

The keyboard shortcut Ctrl + semicolon(;) is to enter the _______

current date

Deleting the ______ of a cell deletes the value or formula, but does not clear the formatting

contents

We can find the _______ command button, which is used to apply the same formatting, in the clipboard group

format painter

The ______ function counts the number of cells within a range that meet the criteria entered

COUNTIF

In a summary worksheet, it is a good practice to use _____ to insert a total value from another worksheet

=

In the IF function, logical test includes one of three values designated in three different cells

false

The MEDIAN function finds ______

the middle value in a range of cells

When a new column is inserted into a worksheet, the remaining columns move to the right

true

Column sparkline command button is on the ________ tab

insert

In a conditional format, we use ______ to represent the value of a cell relative to other cells

data bar

When you select a single sheet that is part of a group, the grouping of the sheets is cancelled

true

Which of the following is a correct statement for the grouping?

we cannot cancel only one worksheet from all grouped worksheets at the same time

The values in parentheses in the SUM function (and other functions) are known as ranges

false

The _____ command enables you to specify rows and columns that will be duplicated on each printed page

print titles

What is an Excel table?

a series of rows and columns that are converted in Excel used to analyze a group of related data

A(n) _____ refers to a cell by its fixed position in the worksheet

absolute cell reference

The y-axis of a chart is also referred to as the category axis

false

On the shortcut menu to paste only values and number formatting, ________ should be selected

paste special

The axis range can be edited in the ______ pane

format axis

In Goal Seek, you enter the specific value that you want to achieve in the _______ box

to value

Where is the Format Painter button location?

on the home tab

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________

what-if analysis

If you edit data in a worksheet that is associated with a pie chart, _____

the pie slices will be automatically updated

______ is a group of related data points represented by data markers

a data series

Which of the following is not in the Goal Seek dialog?

cell reference

When you want to view a chart separately from your worksheet data, which button should you click?

move chart

Which of the following displays trends over time?

a line chart

A graphic image can be inserted into the background of a chart

true

Use the ____ key to select A5:A8 and D5:D8

ctrl

A ______ is a value that originates in a worksheet cell and is used in a chart

data point

Which of the following is different from others?

y-axis

Which symbol represents that a cell is an absolute cell reference in a function or formula?

$

______ is an Excel tool that finds the input needed to arrive at a desired result

goal seek

A ______ in a pie chart identifies the pie slices

data label

If you change the underlying data on which a PivotTable report is based, you must also ______ or update the PivotTable to reflect the new data

refresh

In a PivotTable, a single piece of information for every record is called a _____

field

When you import data from Microsoft Access to a PivotTable Report, the ______ displays on the right side of the worksheet

pivottable fields pane

A _____ can import data from an Excel workbook, from a Microsoft Access database, or from an external source such as a corporate database, a public data feed, or an analysis service

data model

A chart that illustrates the relationship of each part to a whole is called a _______

pie chart

Which of the following areas of a PivotTable field list enables you to display average values?

VALUES area

The ______ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of data in the PivotTable report

FILTERS area

The ______ is a window that lists all of the fields from the source data in a PivotTable and provides an area in which you can arrange the fields in the PivotTable

pivottable fields pane

Which of the following is a button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart?

field button

A PivotChart displays ______ that you can click to choose a filter and change the data displayed in the chart

field buttons

______ are filtering controls with buttons that enable you to drill down through large amounts of data

slicers

Which of the following is a report that is useful when you want to analyze related totals, such as when you have a long list of numbers to sum and you want to compare several facts about each total?

pivottable report

An area to position fields that you want to display as columns in the PivotTable is called _______

COLUMNS area

An area to position fields that you want to display as rows in the PivotTable reports is called the ______

ROWS area

The data for a PivotTable formatted in columns and rows is called

source data

An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the _______

VALUES area

When a numeric field is added to a PivotTable, it is placed in the _____ area of the PivotTable field list

VALUES

In the PivotTable field list, you can rearrange existing fields by using one of the four areas at the bottom of the layout section

true

A PivotTable is an interactive Excel report that summarizes large amounts of data, allowing you to more easily analyze it

true

In the PivotTable field section, you can rearrange existing fields by using which of the following areas in the layout section?

ROWS area

To tile multiple open worksheets on the screen, use the ________ command

arrange all

________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results

filtering

Clicking a ________ will take you to another location in the worksheet, another file location, a webpage on the intranet, or to your organization's Internet

hyperlink

To move to cells that have special characteristics, are blank, or contain constants, use the ________ command

go to special

To freeze column and row titles on the screen so that they are visible while you scroll, which of the following command(s) would you use?

freeze panes

To move to a specific cell or range of cells in a large worksheet use the ________ command

go to

You can create a custom table style by clicking ________

format as table

You can create a custom table style by clicking ________

format as table

To sort on multiple columns, use a(n) ________

add level

The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click

show and hide

________ is used to control the type of data or the values that are entered into a cell

validation list

A ________ is a list of values that are acceptable for a range of cells

validation list

A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value is called a ________

defined name

A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n) ________

data table

The ________ function looks up values in a table array arranged in vertical columns

VLOOKUP

In a lookup formula, the defined range is referred to as the ________

table array

________ cells are cells that contain formula that refers to other cells

dependent

A method to find a specific value for a cell by adjusting the value of one other cell is ________

goal seek

You cannot insert new data into a named range

false

________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value

lookup

In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________

rate