Completion
Complete each sentence or
statement.
|
|
|
1.
|
The
____________________ is a value, cell reference, range, or text that acts as an operand in a function
formula.
|
|
|
2.
|
The
____________________ command removes data from its original place on the worksheet and places it on
the Clipboard.
|
|
|
3.
|
The
____________________ function displays the largest value contained in a range.
|
|
|
4.
|
The
Delete command can be found on the ____________________ menu.
|
|
|
5.
|
To
create a new spreadsheet file, click the ____________________ button on the Standard
toolbar.
|
|
|
6.
|
The
Greek letter sigma identifies the ____________________ button on the toolbar.
|
|
|
7.
|
As a
default, Excel will name a chart saved on a sheet as ____________________.
|
|
|
8.
|
Click
the arrow on the ____________________ button to enlarge a certain part of the spreadsheet on your
computer screen.
|
|
|
9.
|
A(n)
____________________ chart is ideal for illustrating trends over time.
|
|
|
10.
|
The
Chart ____________________ helps you to create a chart from worksheet data.
|
|
|
11.
|
A
graphical representation of data contained in a worksheet is referred to as a(n)
____________________.
|
|
|
12.
|
A(n)
____________________ chart appears directly on the spreadsheet rather than on a separate
sheet.
|
|
|
13.
|
A(n)
____________________ is a list that identifies patterns or symbols used in a chart.
|
Matching
|
|
|
Assume C3 contains the value of 5, C4 the value of 7, and C5 the value of 9. Match
the following functions with the value the function would display below. a. | =SUM(C3:C5) | b. | =COUNT(C3:C5) | c. | =MAX(C3:C5) | d. | =MIN(C3:C5) | e. | =AVERAGE(C3:C5) | | |
|
|
|
14.
|
7
|
|
|
15.
|
21
|
|
|
16.
|
5
|
|
|
17.
|
9
|
|
|
18.
|
3
|
|
|
Match the following chart names with its description below.
|
|
|
19.
|
shows
the relationship of parts to a whole
|
|
|
20.
|
uses
points on a grid
|
|
|
21.
|
uses
rectangles of varying heights to illustrate the values in a worksheet
|
|
|
22.
|
uses
segments connected by points to illustrate the values in a worksheet
|
|
|
Match the format name with the display description below. a. | General | b. | Scientific | c. | Text | d. | Number | e. | Special | | |
|
|
|
23.
|
Displays numerical data with a fixed number of places to the right of the decimal
point.
|
|
|
24.
|
Displays numerical data that requires a specific format.
|
|
|
25.
|
Displays numerical data in exponential notation.
|
|
|
26.
|
Displays either text or numerical data as keyed.
|
|
|
27.
|
Displays numerical data that will not be used for calculation.
|
True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
28.
|
You
must enter an ampersand (&) as the first character in a function formula so that Excel will
recognize it as a formula.
|
|
|
29.
|
The
AutoSum feature may be used to add a long column of numbers.
|
|
|
30.
|
Rotating will move text from the right side of the cell to the left side of the
cell.
|
|
|
31.
|
You
can use the DATE function to display dates in many different formats.
|
|
|
32.
|
To
replace the contents of a cell, you must first select the cell and then key in the new
data.
|
|
|
33.
|
You
would use a column chart to show the relationship of parts to a whole.
|
|
|
34.
|
Wrapping will create a new line of text within a cell.
|
|
|
35.
|
The
Merge and Center alignment button is commonly used to center a title across the top of a
worksheet.
|
|
|
36.
|
In a
formula containing a relative cell reference, the operators stay the same, but the cell references
change when the formula is copied.
|
|
|
37.
|
Borders may be placed on any or all sides of a cell or range.
|
|
|
38.
|
Moving data on a worksheet does not remove the data from its original
location.
|
|
|
39.
|
The
formula bar appears directly above the toolbar in the worksheet.
|
|
|
40.
|
If
you want to move the cursor to cell A1, press Ctrl+Home on your keyboard.
|
|
|
41.
|
If
you change the data in a worksheet, the changes will automatically be reflected in any charts that
are based on that data.
|
|
|
42.
|
You
can widen a column by using the Column Width dialog box.
|
|
|
43.
|
Data
that is copied is stored on the Clipboard until it is pasted or until you copy something
else.
|
|
|
44.
|
Formulas are recognized in a worksheet when a star sign (*) is the first character in
a cell.
|
|
|
45.
|
Once
you have keyed a formula, you can enter it by clicking the dollar sign ($) on the formula
bar.
|
|
|
46.
|
With
the point-and-click method of cell referencing, you click the cell instead of keying a cell
address.
|
|
|
47.
|
When
creating a new chart sheet, you must first cut and paste the data that is to be included in the
chart.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
48.
|
What
happens if data are copied in cells that have existing data? a. | Old data will be
replaced by new data. | b. | Old data will be placed on the
Clipboard. | c. | An error message will appear. | d. | New data will
not be copied. | | |
|
|
|
49.
|
Which
chart type shows values in what’s referred to as “slices?” a. | pie | c. | scatter | b. | column | d. | doughnut | | | | |
|
|
|
50.
|
Which
type of cell reference adjusts to its new location when copied or moved? a. | relative | c. | adapted | b. | stable | d. | absolute | | | | |
|
|
|
51.
|
Which
key combination do you press to move to the last cell containing data? a. | Ctrl +
End | c. | Ctrl + Down
Arrow | b. | Ctrl + Page Up | d. | Ctrl + Home | | | | |
|
|
|
52.
|
Which
type of cell reference does not change when it is moved or copied to a new cell? a. | stable | c. | relative | b. | absolute | d. | mixed | | | | |
|
|
|
53.
|
What
is the purpose of the COUNT function? a. | It determines the number of columns in a
range. | b. | It determines the number of filled cells in a
range. | c. | It determines the number of empty cells in a
range. | d. | It determines the number of cells in a
range. | | |
|
|
|
54.
|
Suppose that the value in B3 is equal to 3 and the value in C3 is 4. Which formula
would display the value of 24? a. | =B3*(C3+4) | c. | =B3*C3+4 | b. | =(B3*C3)+4 | d. | =(B3*C3+4) | | | | |
|
|
|
55.
|
Which
function determines the payment needed each period to repay a loan?
|
|
|
56.
|
Suppose that the value in B3 is equal to 12 and the value in C3 is 3. Which
formula would display the value of 3? a. | =B3/C3+1 | c. | =(B3/C3+1) | b. | =(B3/C3)+1 | d. | =B3/(C3+1) | | | | |
|
|
|
57.
|
What
is a collection of worksheets called? a. | spreadsheet | c. | workbook | b. | work
area | d. | notebook | | | | |
|
|
|
58.
|
To
edit data in a cell, select the cell and press the ____ key, referred to as the Edit
key.
|
|
|
59.
|
The
____ function displays the number of cells with numerical values in the argument
range. a. | COUNT | c. | MAX | b. | AVERAGE | d. | VAR | | | | |
|
|
|
60.
|
The
drag-and-drop method is the same for moving data as it is for copying data except that you do not
hold down the ____ key. a. | Ctrl | c. | Alt | b. | Shift | d. | Insert | | | | |
|
|
|
61.
|
Which
operator represents exponentiation?
|
|
|
62.
|
Data
stored on the ____ will remain until it is replaced with new data. a. | formula
bar | c. | Clipboard | b. | border | d. | toolbar | | | | |
|
|
|
63.
|
Which
calculation will be performed first in a formula that does not contain parentheses? a. | subtraction | c. | multiplication | b. | addition | d. | exponentiation | | | | |
|
|
|
64.
|
What
is the intersection of a worksheet column and a row called? a. | highlight | c. | range | b. | cell | d. | name box | | | | |
|
|
|
65.
|
Which
is not a method for copying data to another part of the worksheet? a. | drag-and-drop | c. | fill
down | b. | copy and
paste | d. | inserting | | | | |
|
|
|
66.
|
Which
function will display today's date in a worksheet? a. | DATE | c. | DAY | b. | PRESENT | d. | NOW | | | | |
|
|
|
67.
|
Which
key do you press to remove data from the selected cell? a. | Alt | c. | Delete | b. | Ctrl | d. | Shift + End | | | | |
|