True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A worksheet is an electronic grid in which you can perform numeric
calculations.
|
|
|
2.
|
You can add more worksheets to a workbook if you need more than the default
number.
|
|
|
3.
|
When you first start Excel or open a workbook, the cell with the dark border in
the upper-right corner of the worksheet is called the active cell.
|
|
|
4.
|
Entering data in a worksheet requires you to first type data into the active
cell and then accept the entry by pressing [Enter], [Tab], or an arrow
key.
|
|
|
5.
|
Formulas can only contain numbers and mathematical operators.
|
|
|
6.
|
You can copy and move formulas just like other data in a worksheet.
|
|
|
7.
|
Sometimes a worksheet or workbook is referred to as a spreadsheet.
|
|
|
8.
|
When you enter data in a cell, Excel automatically right-aligns text and
left-aligns values.
|
|
|
9.
|
To increase the number of digits following a decimal, click the Increase Decimal
button.
|
|
|
10.
|
When you copy a formula from one cell to another, Excel automatically adjusts
the cell references in the copied formula to reflect the new formula location.
|
|
|
11.
|
When you create worksheets that contain many calculations, you rarely need to
create formulas that contain more than one mathematical operator.
|
|
|
12.
|
When a formula contains multiple operators, Excel uses standard algebraic rules
to determine which calculation to perform first.
|
|
|
13.
|
In a formula, addition and subtraction are performed before multiplication and
division.
|
|
|
14.
|
An absolute cell reference contains a # symbol before the column letter and row
number.
|
|
|
15.
|
All date and time functions produce recognizable text values that you can
display “as is” in your worksheets.
|
|
|
16.
|
When a worksheet contains a large amount of information, it can be helpful to
highlight certain cells that contain significant data points.
|
|
|
17.
|
A worksheet is a much more effective way to communicate data to an audience than
a chart.
|
|
|
18.
|
Excel provides many tools for creating charts to help you communicate key trends
and facts about your worksheet data.
|
|
|
19.
|
When you create a chart, it has a default layout and style setting for the chart
type applied.
|
|
|
20.
|
Excel only has a couple of styles and effects to improve the appearance of a
chart and increase its visual appeal and effectiveness.
|
Modified True/False
Indicate
whether the statement is true or false. If false, change the identified word or phrase to make the
statement true.
|
|
|
21.
|
Every new Excel workbook contains four worksheets.
_________________________
|
|
|
22.
|
A group of selected cells that share boundaries is called a(n) cell
range. _________________________
|
|
|
23.
|
You can quickly move to cell A1 by pressing [Ctrl]
[Home]. _________________________
|
|
|
24.
|
If more than one operator is used in a formula, Excel performs the calculations
following the order of precedence. _________________________
|
|
|
25.
|
Formulas are prewritten calculations. _________________________
|
|
|
26.
|
A(n) argument is information a function needs to make a calculation.
_________________________
|
|
|
27.
|
Data bars make it easy to quickly identify the large and small values in
a range of cells and also highlight the relative value of cells to each other.
_________________________
|
|
|
28.
|
An Excel table is similar to a table in a(n) database because you can
sort data in much the same way. _________________________
|
|
|
29.
|
Rows of data in Excel are called records.
_________________________
|
|
|
30.
|
In a table, the lead row is the row at the top that contains column
headings. _________________________
|
|
|
31.
|
Sort does not change the order of the items in your table.
_________________________
|
|
|
32.
|
According to the order of operations, exponents are calculated first.
_________________________
|
|
|
33.
|
A(n) data series is a sequence of related numbers that shows a trend.
__________________________
|
|
|
34.
|
When you create a chart, each chart object has default layout settings
applied. __________________________
|
|
|
35.
|
The Chart Tools Layout tab contains buttons and commands for changing the
layout of a selected chart. __________________________
|
|
|
36.
|
You can select an object by clicking it or by using the Chart Elements list
arrow on the Graph Tools Format tab. __________________________
|
|
|
37.
|
Pointing to a sizing handle of a chart allows you to move it.
__________________________
|
|
|
38.
|
A(n) worksheet is great for presenting and summarizing data.
__________________________
|
|
|
39.
|
Data series identify the values on each axis.
__________________________
|
|
|
40.
|
Legends are helpful when your chart contains data from another worksheet
or location. __________________________
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
41.
|
The ____ box shows the address of the selected cell.
a. | formula | c. | name | b. | data | d. | address |
|
|
|
|
|
|
42.
|
In the accompanying figure, item 2 points to the ____.
a. | Name box | c. | Formula bar | b. | Status bar | d. | Quick Access
toolbar |
|
|
|
43.
|
In a worksheet, the boxes at the top containing letters are known as ____
headings.
a. | data | c. | row | b. | sheet | d. | column |
|
|
|
44.
|
_____ referencing is when you copy a formula to a new cell and Excel
automatically replaces the original cell references with cell references that are in the same
relative position as those in the original formula.
a. | Relative cell | c. | Formula | b. | Absolute cell | d. | Relational |
|
|
|
|
|
|
45.
|
In the accompanying figure, item 2 points to the ____.
a. | data series | c. | Switch Row/Column button | b. | legend | d. | Chart Tools Design tab |
|
|
|
46.
|
In the accompanying figure, item 1 points to the ____.
a. | data series | c. | Switch Row/Column button | b. | legend | d. | Chart Tools Design tab |
|
|
|
47.
|
A ____ chart is an effective tool for comparing the relative values of parts to
a whole.
a. | Pie | c. | Bubble | b. | Column | d. | Circle |
|
|
|
48.
|
You should place sparklines close to the ____ containing the data they
illustrate.
a. | graph | c. | cells | b. | icon | d. | sparkboxes |
|
|
|
49.
|
There are ____ types of sparklines you can add to a worksheet.
a. | one | c. | two | b. | three | d. | you can’t add sparklines to a
worksheet |
|
|
|
50.
|
A(n) ____ chart compares values across categories, with minimal emphasis on
time.
|
Completion
Complete each
statement.
|
|
|
51.
|
In ____________________ orientation the page is taller than it is wide.
|
|
|
52.
|
Formulas that contain more than one operator are called ____________________
formulas.
|
|
|
53.
|
The chart _____________________ is the entire chart and all the chart
elements.
|
|
|
54.
|
To format a chart object, you first must _____________________ it.
|
|
|
55.
|
The vertical axis in a chart is sometimes called the _____________________
axis.
|