Spreadsheet Modeling Final Exam

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

$

Which of the following displays trends over time?

A line chart

All of the following are methods to define a name for a cell or group of cells EXCEPT. a. select the range, open Name Manager, click new and then type the name b. select the range, click in the formula bar, and then type the name c. select the range, click in the name box, and then type the name d. select the range, click the define name button, and then type the name

B. select the range, click in the formula bar, and then type the name

To Page break view shows where the page breaks will occur by displaying

Blue dashed lines and the page number on the worksheet

Which of the following is different from others a. look up b. protection c. goal seek d. validation

C. Goal Seek

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

COUNTIF Function

There are commands to change style such as the Total or Heading 1 style in the _____

Cell Styles Gallery

Hold down the ________ key to select nonadjacent cells.

Ctrl

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

Ctrl + End

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

Data bar

A _____ in a pie chart identifies the pie slices

Data label

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

Data table

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

Design tab and format tab

The y-axis of a chart is also referred to as the category axis (T/F)

False

You cannot insert new data into a named range (T/F)

False

What is the name of small square that enables you to auto full data or formula>

Fill Handle

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

Flashfill

You can create a custom table style by clicking

Format as table

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

Format painter

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

Go To

A method to find a specific value for a cell by adjusting the value on one other cell is ____

Goal seek

clicking a _____ will take you to another location in the worksheet, another file location, a webpage on the internet, or to your organization's Internet

Hyperlink

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

Lookup

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

Move chart

We can define a name to represent a range of cells in the ____

Name Box

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

Paste special

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

Printed titles

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

Rate

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

Select all sheets

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

Show and hide

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

The Name Box

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

The cell to the right

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

The pie slices will be automatically updated

The COUNTIF function has two arguments ______

The range of cells to check and the criteria

In goal seek, you enter the specific value that you want to achieve in the ____ box

To Value

Present value (Pv) represents the amount of the loan before any payments are made (T/F)

True

The Formula Bar displays the value or formula in the active cell (T/F)

True

The outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click (T/F)

True

To quickly locate specific text, formatting, or type of information within a workbook, use the Find Command (T/F)

True

When you select a single sheet that is a part of a group, the grouping of the sheets is canceled (T/F)

True

You can sort a table in ascending and descending order (T/F)

True

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

What-If analysis

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

arrange all

To freeze column and row titles on the screen so that they are visible while you scroll, which of the following commands would you use? a. hide b. freeze panes c. go to d. insert

b. freeze panes

Deleting the ____ of a cell deletes the value or formula but does not clear formatting of that cell

contents

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

filtering

An advantage to naming a range of cells is that you can use the name in a

formula

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

sparklines

In a lookup formula. the defined range is referred to as the

table array

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

validation list