True/False
Indicate whether the statement is true or false.
|
| |
1. |
There are over a million rows in
an Excel worksheet.
|
| |
2. |
It is possible to change the width
of a single cell.
|
| |
3. |
If a label is truncated because it
extends beyond the width of the cell, the truncated data is deleted.
|
| |
4. |
Undo
 on the Quick Access Toolbar can be used to reverse an edit made by
mistake.
|
| |
5. |
Formatting is applied to cells to
make the data easier to understand.
|
| |
6. |
Companies typically use the same
theme for all of their documents.
|
| |
7. |
Data copied from Excel is pasted
as a table into a Word document.
|
| |
8. |
Additional protection can be added
to a worksheet by requiring a password to unprotected a sheet.
|
| |
9. |
Pointing is the best method for entering
a cell range into a function because typing errors are avoided.
|
| |
10. |
The SUM, AVERAGE, MIN, and MAX functions
ignore cells that contain text.
|
| |
11. |
An IF function makes a decision based
on a comparison.
|
| |
12. |
One way to fit more rows and columns
on a page is to increase the margins.
|
| |
13. |
A page break is indicated on the
screen by a dashed line.
|
| |
14. |
The principal of a loan increases
each time a payment is made.
|
| |
15. |
When pasting a range of cells, only
the upper-left cell of the destination range needs to be selected.
|
| |
16. |
In a pie chart, the size of a slice
varies with its percentage of the series total.
|
| |
17. |
Charts created in Excel can be copied
to a Word document.
|
|
|
|
| |
18. |
The chart above contains major gridlines.
|
| |
19. |
The data range of a chart can include
non-adjacent cells.
|
| |
20. |
The vertical (value) axis labels
must always start at the value 0.
|
| |
21. |
Excel stores dates as sequential
serial values.
|
| |
22. |
In Excel, a time cannot be
used in a formula.
|
| |
23. |
A password is required to unfreeze
cells.
|
| |
24. |
A macro is a type of Excel table
style.
|
| |
25. |
A macro name can contain spaces.
|
Multiple Choice
Identify the choice that best completes the statement or answers
the question.
|
| |
26. |
Which number format displays values
with a dollar sign aligned at the left edge of the cell and two decimal
places?
a. |
Accounting |
c. |
Number |
b. |
Currency |
d. |
Percentage |
|
| |
27. |
Which number format displays values
as a percentage with two decimal places?
a. |
Accounting |
c. |
Number |
b. |
General |
d. |
Percentage |
|
| |
28. |
Which view is a worksheet displayed
in when a header is inserted?
a. |
Normal view |
c. |
Page Break Preview view |
b. |
Page Layout view |
d. |
Web Layout view |
|
| |
29. |
When moving a range of cells, what
needs to be selected before Paste is selected?
a. |
cell A1 |
b. |
the Esc key |
c. |
a new range of cells |
d. |
the upper-left cell of the range where the data is to be pasted |
|
| |
30. |
Which type of application is required
to view an HTML file?
a. |
a word processor |
c. |
a browser |
b. |
a spreadsheet application |
d. |
a personal information manager |
|
|
|
|
| |
31. |
Using the data in the worksheet above,
what will be displayed by the formula =MIN(A1:B3)?
|
| |
32. |
Using the data in the worksheet above,
what will be displayed by the formula =IF(B1<>B2,0,–5)?
|
| |
33. |
Which error value indicates the formula
is trying to divide by zero?
a. |
#DIV/0! |
c. |
#NUM |
b. |
#REF |
d. |
#### |
|
| |
34. |
The first step when sorting data
in a worksheet is to
a. |
click Data 
Sort A to Z  . |
c. |
select the range to sort. |
b. |
click Data 
Sort Z to A  . |
d. |
select the entire workbook. |
|
| |
35. |
What will be displayed by the formula
=IF("blue"<"green","sky","water")?
a. |
sky |
c. |
blue |
b. |
water |
d. |
#DIV/O! |
|
| |
36. |
The chart title
a. |
describes what is charted. |
c. |
is the sum of the data range. |
b. |
is below the category labels. |
d. |
is also the vertical axis label. |
|
| |
37. |
Which type of chart is best for charting
data that is a percentage of a whole?
a. |
bar |
c. |
line |
b. |
column |
d. |
pie |
|
| |
38. |
Which type of chart would best illustrate
each department's sales as a percentage of the overall store sales?
a. |
bar |
c. |
pie |
b. |
line |
d. |
area |
|
| |
39. |
The first step in creating a pie
chart is to
a. |
select a location for the chart. |
c. |
select the chart type. |
b. |
select the data to be charted. |
d. |
verify the source data. |
|
| |
40. |
Which type of chart would best illustrate
price fluctuations over a period of time for three stocks?
a. |
bar |
c. |
pie |
b. |
line |
d. |
area |
|
|
|
|
| |
41. |
How many data series were used to
create the chart above?
|
| |
42. |
In the chart above, which is the
first horizontal axis label?
a. |
0 |
c. |
2009 |
b. |
Architecture |
d. |
Program |
|
| |
43. |
Which chart type shows changes in
values relative to a center point?
a. |
XY (scatter) chart |
c. |
surface chart |
b. |
stock chart |
d. |
radar chart |
|
| |
44. |
What format is used to display the
serial value of an existing date?
a. |
General |
c. |
Number |
b. |
Text |
d. |
Date |
|
| |
45. |
Which table option would remove a
row of data that is not unique to the table?
a. |
Remove Duplicates |
c. |
Convert
to Range |
b. |
Total Row |
d. |
Banded Columns |
|
| |
46. |
Which would be selected in the Allow list in the Data Validation dialog
box to allow only integers to be entered in selected cells?
a. |
Any value |
c. |
Decimal |
b. |
Whole numbers |
d. |
List |
|
| |
47. |
Which would be selected in the Allow list in the Data Validation dialog
box to create a drop-down list with entries that users can select from?
a. |
Any value |
c. |
Decimal |
b. |
Whole numbers |
d. |
List |
|
| |
48. |
If the value in cell A1 is
0, what will be displayed by =CHOOSE(A1,4,8,10)?
a. |
A1 |
c. |
4 |
b. |
0 |
d. |
#VALUE |
|
| |
49. |
If the value in cell A1 is 2,
what will be displayed by =CHOOSE(A1,4,8,10)?
|
|
|
|
| |
50. |
Using the data in the worksheet above,
what will be displayed by the formula =5+VLOOKUP(C3,$D$1:$E$4,2)
if cell C3 stores the value 205?
a. |
5.8 |
c. |
200 |
b. |
5.6 |
d. |
#N/A! |
|