True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
An Excel spreadsheet document is called a workbook.
|
|
|
2.
|
An Excel file is called a workbook.
|
|
|
3.
|
Individual rows on a worksheet are identified by a letter.
|
|
|
4.
|
Labels can be used in calculations.
|
|
|
5.
|
A label that extends beyond the width of the cell will be truncated if the next
cell contains data.
|
|
|
6.
|
If a label is truncated because it extends beyond the width of the cell, the
truncated data is deleted.
|
|
|
7.
|
Labels and values displayed in the same column are automatically aligned the
same.
|
|
|
8.
|
Long column headings can be wrapped to the next line of the same cell.
|
|
|
9.
|
Click the Headings Print
check box to include gridlines in a printout.
|
|
|
10.
|
In Excel, a formula must begin with an equal sign.
|
|
|
11.
|
The expression =(3+3)*2–2 evaluates to
10.
|
|
|
12.
|
A circular reference error occurs if a formula references the cell it is stored
in.
|
|
|
13.
|
When pasting a range of cells, any existing cell contents at the new location
are automatically moved to make room for the pasted data.
|
|
|
14.
|
The Fill handle is used to copy cell contents to adjacent cells.
|
|
|
15.
|
When a formula is copied, cell references automatically change relative to the
new row or column.
|
|
|
16.
|
Data copied from Excel is pasted as a table into a Word document.
|
|
|
17.
|
It is possible to choose formats that are applied only when a cell meets a
specific condition.
|
|
|
18.
|
Once protected, a worksheet can never be changed again.
|
|
|
19.
|
Additional protection can be added to a worksheet by requiring a password to
unprotected a sheet.
|
|
|
20.
|
A worksheet can be sent as an attachment from Excel.
|
|
|
21.
|
The SUM function adds up all values of the cells in a range.
|
|
|
22.
|
A function requires arguments to perform its calculation.
|
|
|
23.
|
An absolute cell reference changes when copied.
|
|
|
24.
|
$A$6 is an absolute cell reference.
|
|
|
25.
|
The range placed in a function by Formulas  AutoSum is always correct.
|
|
|
26.
|
Click Error
Checking  to display the reason for an error value in a cell.
|
|
|
27.
|
A #### error value indicates the formula is trying to
divide by 0.
|
|
|
28.
|
There is no difference between formatting and rounding.
|
|
|
29.
|
Sorting values in descending order places the values in order from lowest to
highest.
|
|
|
30.
|
The key sort column is the column that contains the values that a sort is based
on.
|
|
|
31.
|
The arguments of an IF function can only contain values.
|
|
|
32.
|
One way to fit more rows and columns on a page is to increase the
margins.
|
|
|
33.
|
The location of page breaks in a worksheet can be changed.
|
|
|
34.
|
A method for computing equal period payments for an installment loan is called
amortization.
|
|
|
35.
|
Pasted data will automatically update if the source data changes.
|
|
|
36.
|
When pasting a range of cells, any existing cell contents at the new location
are automatically moved to make room for the pasted data.
|
|
|
37.
|
When rows are inserted, Excel automatically changes the cell references in any
affected formulas.
|
|
|
38.
|
If a value or label in a chart data range is changed, the chart automatically
updates.
|
|
|
39.
|
A chart can be placed on a separate sheet in a workbook.
|
|
|
40.
|
A pie chart only includes only one series of data.
|
|
|
41.
|
Drag a corner handle to move a chart.
|
|
|
42.
|
A chart that appears as an object in a worksheet is printed when the worksheet
is printed.
|
|
|
43.
|
A header and footer can be added to a chart sheet.
|
|
|
44.
|
The average age of the freshman class, the average age of the sophomore class,
the average age of the junior class and the average age of the seniors class would best be charted in
a pie chart.
|
|
|
45.
|
A linked chart in a Word document is automatically updated if the source chart
is updated in Excel.
|
|
|
46.
|
A bar chart can only include one series of data.
|
|
|
|
|
|
47.
|
The chart above contains a legend.
|
|
|
48.
|
Pie charts have axes.
|
|
|
49.
|
All bar charts created in Excel have vertical bars.
|
|
|
50.
|
The value axis is vertical.
|
|
|
51.
|
Column, bar, and line are the only types of charts that can be created in
Excel.
|
|
|
52.
|
A 3-D column chart contains a chart floor.
|
|
|
53.
|
A database is given a descriptive name once all of the data has been
entered.
|
|
|
54.
|
A table is a database object that stores data.
|
|
|
55.
|
Each table in a database is related to another table by one field.
|
|
|
56.
|
In an RDBMS, repeated data between tables are in the columns that create a
relationship.
|
|
|
57.
|
Developing a database schema requires planning before working in Access.
|
|
|
58.
|
All data in a table must be the same type.
|
|
|
59.
|
Entering .5 in a field formatted as percent
displays 50%.
|
|
|
60.
|
The columns in a table are called records.
|
|
|
61.
|
A primary key prevents duplicate records in a table.
|
|
|
62.
|
A First Name field is a good candidate for a primary key field.
|
|
|
63.
|
The primary key column in a table can contain duplicate entries.
|
|
|
64.
|
A table should be created in Datasheet view in order to control all aspects of
the table.
|
|
|
65.
|
The  symbol is displayed next to a primary key in Design
view.
|
|
|
66.
|
A form displays all the fields for one record.
|
|
|
67.
|
In Datasheet view, the order in which fields appear can be changed by dragging a
field to a new location.
|
|
|
68.
|
Datasheet view displays one record at a time.
|
|
|
69.
|
If a filter has been applied to a datasheet, only the visible records will
print.
|
|
|
70.
|
A field can be renamed.
|
|
|
71.
|
Imported data can be appended to an existing table.
|
|
|
72.
|
PowerPoint presentations are used to enhance a speech.
|
|
|
73.
|
Miniature versions of slides are called thumbnails.
|
|
|
74.
|
The layout of the title slide should be exactly the same as the other slides in
the presentation.
|
|
|
75.
|
The content on a slide should contain everything the speaker is going to say
while that slide is displayed.
|
|
|
76.
|
New slides added to a presentation have the Title and Content layout.
|
|
|
77.
|
The same slide layout has to be applied to all the slides in a
presentation.
|
|
|
78.
|
The slide layout cannot be changed if text has been added to a
slide.
|
|
|
79.
|
A placeholder can be dragged to a new position on the slide.
|
|
|
80.
|
Sans serif fonts are a good choice for titles and headings.
|
|
|
81.
|
Slide order can be changed in both Normal and Slide Sorter view.
|
|
|
82.
|
The PowerPoint window is displayed in Slide Show view.
|
|
|
83.
|
Speaker notes are displayed when the presentation is displayed in Slide Show
view.
|
|
|
84.
|
Themes are used to maintain a consistent look throughout a presentation.
|
|
|
85.
|
The color scheme of a theme cannot be changed.
|
|
|
86.
|
Text typed in the Notes pane can be printed with the corresponding slide.
|
|
|
87.
|
Headers and footers can be added to the printout of a presentation.
|
|
|
88.
|
Pictures from a digital camera can be used in a PowerPoint presentation.
|
|
|
89.
|
Home 
Copy and Home  Paste
are used to copy a chart from an Excel workbook to a PowerPoint slide.
|
|
|
90.
|
A different transition should be applied to each slide in a presentation.
|
|
|
91.
|
It is possible to vary the speed of a transition.
|
|
|
92.
|
The same transition can be applied to all slides by clicking Animations  Apply to All.
|
|
|
93.
|
Bulleted items sliding in one by one is an animation example.
|
|
|
94.
|
Sound files in a PowerPoint presentation always start automatically.
|
|
|
95.
|
A sound icon must be visible on the slide during Slide Show view in order for
the sound to play.
|
|
|
96.
|
Animated GIFs are considered movie files in PowerPoint.
|
|
|
97.
|
On a slide, a movie can be sized like a picture.
|
|
|
98.
|
A PowerPoint presentation can be played in a continuous loop.
|
|
|
99.
|
A PowerPoint presentation can be published to the Web.
|
|
|
100.
|
PowerPoint can be used to create a slide show of pictures.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
101.
|
How many worksheets are in a new workbook?
|
|
|
102.
|
The intersection of a row and column is a
a. | label. | c. | cell. | b. | value. | d. | sheet tab. |
|
|
|
103.
|
Which of the following is an example of a cell reference?
|
|
|
104.
|
The sheet tabs are used to
a. | display the contents of the active cell. | b. | display the
worksheets in a workbook. | c. | identify a single cell. | d. | create a new
workbook. |
|
|
|
105.
|
Which key cancels data entry and restores the original contents of the
cell?
a. | the Enter key | c. | the right-arrow key | b. | the Tab key | d. | the Esc key |
|
|
|
106.
|
Which key enters data and makes the next cell in the column active?
a. | the Enter key | c. | the right-arrow key | b. | the Tab key | d. | the Esc key |
|
|
|
107.
|
When the pointer is moved onto the worksheet, it changes to
|
|
|
108.
|
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 |
|
|
|
109.
|
Which number format displays values as a percentage with two decimal
places?
a. | Accounting | c. | Number | b. | General | d. | Percentage |
|
|
|
110.
|
To select the entire worksheet
a. | click the Select All button. | b. | press the Worksheet button. | c. | press
Ctrl+End. | d. | drag the pointer from cell A1 to cell A1048576. |
|
|
|
111.
|
Which view should be used when preparing a worksheet for printing?
a. | Normal view | c. | Web Layout view | b. | Page Layout view | d. | Outline view |
|
|
|
112.
|
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 |
|
|
|
Assume cell C8 stores a value of 3 and cell D9
stores a value of 2.
|
|
|
113.
|
What will be displayed when the formula =2*C8+3*D9 is
entered?
a. | 18 | c. | #DIV/O! | b. | 2*C8+3*D9 | d. | 12 |
|
|
|
114.
|
What will be displayed when the formula =C8+D9/0 is
entered?
|
|
|
115.
|
Pressing Ctrl+`
a. | displays the formulas stored in cells. | b. | formats the active cell as
currency. | c. | selects the row that contains the active cell. | d. | enters a modified
formula. |
|
|
|
116.
|
The Fill handle is
a. | used to change the color of a cell. | b. | used to copy the contents of the selected cell
to adjacent cells. | c. | an icon used to scroll a
worksheet. | d. | a cell representing a column of labels. |
|
|
|
117.
|
Cell references that reflect the row or column they have been copied to are
called
a. | absolute cell references. | c. | copied cell
references. | b. | reflective cell references. | d. | relative cell references. |
|
|
|
118.
|
Data from Word can be copied to an Excel worksheet
a. | only if it contains numeric data. | b. | if it is formatted in
paragraphs. | c. | if it is organized in a table or aligned with tabs and tab stops. | d. | if it is all
uppercase letters. |
|
|
|
119.
|
Which of the following icons minimizes a
window?
|
|
|
120.
|
Which of the following icons removes a window from
the screen and memory?
|
|
|
121.
|
Which of the following icons resizes a window to
its previous size before it was maximized?
|
|
|
122.
|
What will the formula =SUM(A1:A10) change to if row 3
is deleted?
a. | it will not change | c. | =SUM(A1:A9) | b. | =SUM(B1:B10) | d. | =SUM(A1:A11) |
|
|
|
123.
|
A function performs a calculation that results in
a. | a cell reference. | c. | a range of values. | b. | a label. | d. | a single value. |
|
|
|
|
|
|
124.
|
Using the data in the worksheet above, what will be displayed by the
formula =MAX(A2:B3)?
|
|
|
125.
|
Using the data in the worksheet above, what will be displayed by the
formula =SUM(A1:A3)?
|
|
|
126.
|
Using the data in the worksheet above, what will be displayed by the
formula =SUM(B1:B3)?
|
|
|
127.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(B1<>B2,0,–5)?
|
|
|
128.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(A1<MIN(B1:B3),1,A1)?
|
|
|
129.
|
A cell reference that does not change when it is copied is called a(n)
a. | status reference. | c. | absolute cell reference. | b. | relative cell
reference. | d. | currency
reference. |
|
|
|
130.
|
Which key can be used to create an absolute cell reference?
|
|
|
131.
|
What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to cell C7?
a. | =B6*$B$1 | c. | =B7*$B$1 | b. | =B7*$B$2 | d. | =C6*$B$1 |
|
|
|
132.
|
To enter a function into a formula without typing,
a. | click a button in the Function
Library group on the Formulas tab. | b. | double-click a cell. | c. | select the function
from Function Styles gallery. | d. | use the name
box. |
|
|
|
133.
|
Which error value indicates the formula contains a reference that is not
valid?
a. | #DIV/0! | c. | #NUM | b. | #REF | d. | #### |
|
|
|
134.
|
What will be displayed by the formula =ROUND(C2, 0)
if the number 21.2534 is stored in C2?
a. | 22 | c. | 21 | b. | =ROUND(C2,0) | d. | 21.25 |
|
|
|
135.
|
What will be displayed by the formula
=ROUND(43.92,-1)?
a. | 43.9 | c. | 40 | b. | =ROUND(43.92,-1) | d. | #REF |
|
|
|
136.
|
What will be displayed by the formula
=ROUND(93.99,-2)?
|
|
|
137.
|
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. |
|
|
|
138.
|
The worksheet data below has been sorted in ascending order. Which column was
the key sort column when the data was sorted?  a. | column A | c. | column C | b. | column B | d. | Inventory |
|
|
|
139.
|
What will be displayed by the formula =IF("blue"<"green","sky","water")?
a. | sky | c. | blue | b. | water | d. | #DIV/O! |
|
|
|
Assume cell A1 stores a value of 5 and cell B1
stores a value of 10.
|
|
|
140.
|
What will be displayed by the formula
=IF(A1=B1,A1,"no")?
|
|
|
141.
|
What will be displayed by the formula
=IF(A1<B1,"yes","no")?
a. | yes | c. | yes no | b. | no | d. | #VALUE |
|
|
|
142.
|
Printing a worksheet in landscape orientation
a. | changes the order of the rows in the worksheet. | b. | fits more columns
and fewer rows on a page. | c. | fits more rows and fewer columns on a
page. | d. | prints the worksheet on both sides of the paper. |
|
|
|
143.
|
What can be used to control how a worksheet is divided into pages?
a. | page breaks | c. | rows | b. | columns | d. | functions |
|
|
|
144.
|
Page Layout  Print Area  Set
Print Area is used to
a. | freeze selected rows and columns. | b. | print only cells containing
formulas. | c. | print a selected part of a worksheet. | d. | print only cells containing
values. |
|
|
|
145.
|
Which formula calculates the monthly payment for a $200,000 loan taken out for
30 years at 5.25% interest (hint =PMT(<rate>, <nper>, <principal>)?
a. | =PMT(5.25%/12, 30, 200000) | b. | =PMT(5%/30, 360, –200000) | c. | =PMT(5.25/12%, 30,
-200000) | d. | =PMT(.0525/12, 360,
-200000) |
|
|
|
146.
|
Sheet order can be changed by
a. | clicking the Insert
Worksheet tab. | b. | dragging a sheet tab to a new
location. | c. | right-clicking a sheet tab and typing a new number for the sheet. | d. | using Home  Cut and Home  Paste. |
|
|
|
147.
|
Changing the data on one sheet automatically updates the data on the other sheet
when the cells are
a. | upgraded. | c. | linked. | b. | pasted. | d. | copied. |
|
|
|
148.
|
When moving a range of cells between sheets, what needs to be selected
before Home  Paste is clicked? 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 |
|
|
|
149.
|
Which key removes the dashed border around copied cells?
a. | the Esc key | c. | the Alt key | b. | the Ctrl key | d. | the Tab key |
|
|
|
150.
|
“What-If?” questions are answered by
a. | changing values and noting the results. | b. | inserting a series
of blank columns. | c. | using the IF function. | d. | changing the
formatting and noting the results. |
|
|
|
151.
|
Which allows different data sets to be defined and used within the same
worksheet?
a. | absolute references | c. | scenarios | b. | amortization table | d. | multiple sheets |
|
|
|
152.
|
In a worksheet sort, it is possible to sort by:
a. | Values | c. | Font Color | b. | Cell Color | d. | All of the
above |
|
|
|
153.
|
Which of the following SUM functions would add a total of 20 cells together
correctly?
a. | =SUM(A1:A10) | c. | =SUM(A1, A10, A20) | b. | =SUM(A1, A20) | d. | =SUM(A1:A10,
C1:C10) |
|
|
|
154.
|
Which chart object identifies each value in a data series?
a. | series name | c. | data labels | b. | plot area | d. | legend |
|
|
|
155.
|
Which chart object is the part of the chart that displays data?
a. | series name | c. | data labels | b. | Plot Area | d. | legend |
|
|
|
156.
|
Which type of chart is best for charting data that is a percentage of a
whole?
|
|
|
|
|
|
157.
|
Which type of chart is shown above?
|
|
|
158.
|
Which type of chart would best illustrate each department's sales as a
percentage of the overall store sales?
|
|
|
159.
|
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. |
|
|
|
160.
|
A chart is sized proportionately by dragging
|