Final Exam: Excel
If you resize a column narrower after entering a number, and the number no longer fits in the cell, _________________.
######## appears in the cell instead of the number
An absolute cell reference
$C$12
All Excel formulas begin with the _________ symbol.
=
To add the values in cells B1, B2, and B3, the formula would be ____________.
=B1+B2+B3
_____________ is the correct formula if you want to subtract the value in cell C15 from the value in F12.
=F12-C15
A relative reference
A5:A7
Cell references that remain fixed when a formula is copied to a new location are called ____________ references.
Absolute
The cell you are working in or the sheet you are viewing
Active
Double-click right border of a column
AutoFit
When you cut or copy a range, the selected cells are surrounded by a(n) __________________ border.
Blinking
Indicates a cell's column and row location
Cell Reference
A visual representation of a set of data values
Chart
A(n) ______________ sheet contains only a chart, and no worksheet cells.
Chart
____________ ______________ provide different options for displaying and arranging chart elements.
Chart Layouts
You want to demonstrate how car sales have changed over five years at three different area dealerships. You want the categories to be viewed from left to right and the values from bottom to top.
Column Chart
A ____________ ___________ rule specifies the type of condition, the type of formatting to be applied, and the cell or range to which the formatting is applied.
Conditional Formatting
A _______ is text for an individual data marker.
Data Label
Text for an individual data marker
Data Label
Represents each value in a data series
Data Marker
The __________ _____________ is the range of values plotted on a chart.
Data Series
Each chart has a(n) ____________, the range that contains the data to display in the chart.
Data Source
The range that contains the data to display in a chart
Data Source
_____________________- the bottom border of a row to AutoFit the row to the height of its tallest cell entry.
Double-Click
Of the following, the first in the order of operations is _______________.
Exponentiation
>= means "less than or equal to".
False
A group of cells is called a field
False
By default, Excel displays pages in landscape orientation.
False
The cell in which you are currently working is known as the live cell.
False
The formula =SUM(D28:D30) uses a(n) absolute cell reference.
False
When you select a chart, two buttons appear to its right.
False
A(n) _____________ function is a function related to monetary calculations.
Financial
Displays the contents of the active cell
Formula Bar
A named operation that returns a value
Function
By default, Excel formats numbers in the _______________ format.
General
Indicates the data markers associated with the data series
Legend
The chart ____________ identifies each of the data series in a chart.
Legend
You want to show the changing value of three stocks that you own, at monthly intervals over the past four years.
Line Chart
Any function that works with statements that are true or false
Logical Function
Only content from upper-left cell is retained
Merging
To change the order of operations, you can enclose parts of a formula within ____________.
Parenthesis
A group of cells
Range
Excel is _______ software used to enter, analyze, and present _________ data.
Spreadsheet, quantitative
When you finish typing data into a cell, you press the Enter or _________________ key to complete the data entry and move to the next cell.
Tab
"What-if" analysis lets you examine how changing values entered directly in a worksheet affect the calculated values.
True
$B$8 is a(n) absolute cell reference.
True
A legend is a rectangular area that indicates the data markers associated with the data series.
True
A(n) exploded pie chart moves one slice away from the others as if someone were taking the piece away from the pie.
True
After you select a cell or range, the fill handle appears in the lower-right hand corner of the selection.
True
Charts show trends or relationships that may not be readily apparent from numbers alone.
True
Each chart has a data source, which is the range that contains the data to display in the chart.
True
Functions in Excel begin with a(n) equal sign.
True
The AVERAGE, COUNT, and MEDIAN functions are examples of statistical functions.
True
The IF function is a(n) logical function.
True
The formula bar displays the contents of the active cell.
True
When you enter a date in a cell, Excel interprets it as a date and formats it appropriately.
True
With conditional formatting, the format applied to a cell depends upon the value or content of the cell.
True
Shows the range of series values from all of the data series plotted on a chart
Value Axis
Contains data, laid out in a grid of rows and columns
Worksheet
Conditional formatting applies formatting only when __________meets a specified condition.
a cell's value
Cell references that remain fixed when a formula is copied to a new location are called ____________ references.
absolute
Use ______ references when you want different formulas to refer to the same cell.
absolute
Each chart you create is inserted as __________.
an object in a worksheet
A group of ___________ is called a range.
cells
To select an entire column, you ________________.
click on its column header
You can edit cell contents directly in a cell by _______________.
double-clicking the cell
A logical function works with statements that are ____________.
either true or false
You can add background colors, known as _______________ colors, to a cell's background.
fill
Appears after you select a cell or range
fill handle
The ________________ bar displays the contents of the active cell.
formula
The first argument of the IF function is __________.
logical test
To develop a good workbook, you should determine the workbook's purpose, content, and ____________ before you start entering data.
organization
The goal of highlighting cells is to ________.
provide a strong visual clue of important data or results
The term A1:A5 is a(n) _____________.
range reference
Most Excel workbooks are created to _____________.
record and analyze data
A formula is a mathematical expression that ________________.
returns a value
After a formula has been entered into a cell, the cell displays _______________.
the results of the formula
If you see ####### instead of the value in a cell, the reason is most likely that ___________.
the value is an integer that is too long to fit in the cell
The main reason for using Excel is to display _______________.
values calculated from data
Excel store spreadsheets in files called ______________.
workbooks
