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