Matching
|
|
|
Match each item with the correct statement.
|
|
|
1.
|
Total number of payments.
|
|
|
2.
|
Total amount of loan.
|
|
|
3.
|
Amount of each payment.
|
|
|
4.
|
Description of this function
|
|
|
5.
|
Function’s name.
|
|
|
6.
|
Interest rate for loan.
|
|
|
Match each item with the correct statement.
 a. | =SUM(C21:F21) | e. | 0 | b. | =AVERAGE(C8:F8) | f. | =MAX(C15:F15) | c. | F18 | g. | B2 | d. | =SUM(C10:F10) |
|
|
|
7.
|
Function that would calculate the total amount of Boston Crab Meat bought by
VAFFE over the entire four quarters.
|
|
|
8.
|
Cell that is currently selected.
|
|
|
9.
|
Contains a hyperlink.
|
|
|
10.
|
The amount of Aniseed Syrup that VAFFE purchased in the second quarter.
|
|
|
11.
|
Function that would calculate the average amount of Boston Crab Meat bought by
SAVEA for the four quarters.
|
|
|
12.
|
Function that would determine the largest quarterly amount of Filo Mix
purchased by DUMON.
|
|
|
Match each item with the correct tool name.
|
|
|
13.
|
Places the contents of a selected cell on the Clipboard.
|
|
|
14.
|
Sorts a list in ascending order.
|
|
|
15.
|
Creates a column chart.
|
|
|
16.
|
Sorts a list in descending order.
|
|
|
17.
|
Creates a line chart.
|
|
|
18.
|
Allows you to access functions such as COUNT and NOW.
|
|
|
19.
|
Lets you add axis titles to a chart.
|
|
|
20.
|
Pastes the contents of the Clipboard to a selected cell.
|
|
|
Match each item with the correct statement.
|
|
|
21.
|
Text is vertically centered in cell.
|
|
|
22.
|
Border has been applied.
|
|
|
23.
|
Text is left-aligned in cell.
|
|
|
24.
|
Font style has been applied.
|
|
|
25.
|
Cell style has been applied.
|
|
|
Match each item with the correct statement.
a. | Margin | e. | Template | b. | Freeze | f. | Print area | c. | Arrange | g. | Split | d. | Page
orientation |
|
|
|
26.
|
To keep headings in place while scrolling through a worksheet.
|
|
|
27.
|
Amount of space between the text and the edge of the page.
|
|
|
28.
|
To divide a window into two panes.
|
|
|
29.
|
Worksheet area that prints.
|
|
|
30.
|
A workbook that is used as a basis for other workbooks.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
31.
|
You can exit the Excel program by ____.
a. | choosing Office>Save As | b. | choosing Office>Close | c. | choosing
Office>Exit Excel | d. | clicking the Close Window button in a
workbook’s upper-right corner |
|
|
|
32.
|
Which of these symbols cannot be used to perform arithmetic in Excel?
|
|
|
33.
|
Which of the following explains what happens when you double-click a
cell?
a. | The cell’s contents are placed on the Clipboard. | b. | The cell’s
contents appear in the formula bar. | c. | The cell’s contents are
erased. | d. | The entire cell is removed from the worksheet. |
|
|
|
34.
|
Worksheets are made up of boxes called ____.
a. | formulas | c. | columns | b. | cells | d. | cell references |
|
|
|
35.
|
Cells can contain ____.
a. | words | c. | functions | b. | numbers | d. | All of the
above. |
|
|
|
36.
|
The following step in the Convert Text to Columns Wizard lets you specify
____.  a. | the width and formatting of the two columns being manipulated | b. | the number of
characters that should appear in each of the two new columns | c. | how two columns in a
worksheet should be combined into a single column | d. | how a single column should be divided
into two columns |
|
|
|
37.
|
If you apply a table style to a range of cells and then add an additional row of
data, you can increase the table size by ____.
a. | choosing Home>Cell Style>New Cell Style | b. | double-clicking the
last cell in the table | c. | dragging the resize handle at the lower-right
corner of the table to include the new row | d. | choosing Page
Layout>Themes>Themes |
|
|
|
38.
|
The text in a cell will ____ to indicate the presence of a hyperlink.
a. | be bolded | c. | turn gray | b. | be enlarged | d. | turn blue |
|
|
|
39.
|
If you want to quickly see what percentage of zoom the screen is at, look at the
____.
a. | title bar | c. | vertical scroll bar | b. | status bar | d. | horizontal scroll
bar |
|
|
|
40.
|
What button would you click to create a pie chart?
|
|
|
41.
|
Which of the following best explains the purpose of the IF function?
a. | If the value in B3 is over $20,000, the total charge will be decreased by
10%. | b. | If the value in B3 is over $20,000, the total charge will be increased by
10%. | c. | If the discount is more than 10%, the total charge will be decreased by
1%. | d. | If the discount is more than 10%, the total charge will be increased by
1%. |
|
|
|
42.
|
One way to make a column wider is to choose ____.
a. | Home>Cells>Format and click Column Width | b. | Home>Styles>Cell Styles and click the desired width | c. | Home>Alignment>Center | d. | Page Layout>Page
Setup>Columns |
|
|
|
43.
|
Which of the following steps allows you to move the contents of cell A11 to cell
C30?
a. | Position the pointer at the edge of cell A11 so that it turns into a four-headed
arrow pointer, hold down the mouse button, and drag to C30. | b. | Position the pointer
at the lower-right corner of cell A11 so that turns into a plus sign, hold down the mouse button, and
drag to C30. | c. | Click in cell A11, click the Copy button, click in cell C30, and click the Paste
button. | d. | Click in cell A11, press [DELETE], click in cell C30, and click the Paste
button. |
|
|
|
44.
|
To create a bar chart, select the range of data and click the Bar button on the
____ tab.
a. | Home | c. | Formulas | b. | Insert | d. | Data |
|
|
|
45.
|
A ____ is a preset formula.
a. | filter | c. | chart | b. | function | d. | cell reference |
|
|
|
46.
|
What function could return the value shown in cell E2? 
|
|
|
47.
|
You can rename a worksheet by choosing ____, clicking Rename Sheet, and keying
the new name.
a. | Home>Styles>Cell Styles | c. | Page Layout>Sheet
Options | b. | Home>Cells>Format | d. | Page Layout>Page Setup |
|
|
|
48.
|
Which of the following is not something you can do in the Move or Copy
dialog box?
a. | Move the third worksheet in a workbook to be the first worksheet. | b. | Make a copy of a
worksheet. | c. | Move the third column in a worksheet to the first column. | d. | Move a worksheet to
a different workbook. |
|
|
|
49.
|
To set up a print area on a worksheet, choose ____.
a. | Office>Print>Print Area | c. | Page Layout>Page Setup>Print
Area | b. | Office>Print>Print Preview | d. | Page Layout>Page
Setup>Margins |
|
|
|
50.
|
The data in cell C2 is ____.  a. | right-aligned | c. | bottom-aligned | b. | left-aligned | d. | centered |
|
|
|
51.
|
When using the PMT function, which of the following stands for the total number
of payments required to pay off the loan?
|
|
|
52.
|
When creating a budget, you must estimate both your ____ and your
expenses.
a. | income | c. | time | b. | costs | d. | savings |
|
|
|
53.
|
Where would you click to specify the folder in which this workbook should be
stored? 
|
|
|
54.
|
The following is the ____.  a. | title bar | c. | QAT | b. | Office menu | d. | status bar |
|
|
|
55.
|
If you know a worksheet is in the current workbook but you cannot see it, choose
____.
a. | View>Window>Hide | c. | View>Window>Arrange All | b. | View>Window>Unhide | d. | View>Zoom>Zoom |
|
|
|
56.
|
Changing font color affects ____.
a. | only the tab color of the current worksheet | b. | only the contents of
the currently selected cells | c. | all of the cells in the current
worksheet | d. | all of the worksheets in the current the workbook |
|
|
|
57.
|
Which of the following must be true before you can use the Delete Cells command
to delete an entire column from a worksheet?
a. | The cells in that column must all be empty. | b. | The column cannot
contain any formulas. | c. | It must be the last column in the
worksheet. | d. | The column must be selected. |
|
|
|
58.
|
Which of the following is not contained in the Office menu?
a. | New | c. | Page Setup | b. | Save As | d. | Print |
|
|
|
59.
|
You can exit a slide show by ____.
a. | clicking Stop on the Home tab | c. | pressing
[ESC] | b. | choosing Office>Save | d. | pressing the spacebar |
|
|
|
60.
|
The rectangles pointed to by label “A” are ____.  a. | grouped | c. | in the header | b. | joined by connectors | d. | an example of a
transition |
|
|
|
61.
|
If you were in Print Preview, which button would you click to go to the next
page of a worksheet?
|
|
|
62.
|
To use Hide & Unhide, choose Home>Cells>Format, and look under ____.
a. | Cell Size | c. | Organize Sheets | b. | Visibility | d. | Background |
|
|
|
63.
|
In the Print dialog box, the ____ box lets you specify the slides to be
printed.
a. | Print what | c. | Name | b. | Print range | d. | Number of
copies |
|
|
|
64.
|
To move a chart to another sheet, choose ____.
a. | Layout>Properties>Move Chart | c. | Design>Type>Change Chart
Type | b. | Home>Cells>Insert Sheet | d. | Design>Location>Move
Chart |
|
|
|
65.
|
The ____ dialog box lets you specify which slides will appear in a particular
slide show.
a. | Open | c. | Save As | b. | Set Up Show | d. | Print |
|
|
|
66.
|
To place a table on a slide, choose ____.
a. | Home>Insert>Table | c. | Insert>Tables>Table | b. | Home>Slides>Table | d. | Insert>Text>Table |
|
|
|
67.
|
You are writing a formula when you realize it is incorrect and you want to
quickly erase it. Which of these methods would erase it the fastest?
a. | Choosing Home>Cells>Delete. | b. | Clicking Undo. | c. | Pressing
[BACKSPACE] repeatedly until the formula was gone. | d. | Pressing
[ENTER]. |
|
|
|
68.
|
Which of these buttons lets you quickly zoom in?
|
|
|
69.
|
Which of the following cannot have Quick Styles applied to it?
a. | a Clip Art image | c. | a table | b. | a SmartArt diagram | d. | a chart |
|
|
|
70.
|
When you are in Normal View, the PowerPoint screen is divided into two sections:
the ____ and the ____.
a. | Slide Show pane; slide pane | c. | Slide Sorter pane; slide
pane | b. | Slides and Outline tab; slide pane | d. | Notes Page pane; slide
pane |
|
|
|
71.
|
The following shows the ____.  a. | AutoSum drop-down list | c. | Insert drop-down list | b. | Find and Replace
dialog box | d. | Insert Hyperlink
dialog box |
|
|
|
72.
|
Which of the following statements is true concerning these two lightening
bolts?  a. | The one on the left is in front of the red circle whereas the one on the right is
behind the red circle. | b. | The one on the right is in front of the red
circle whereas the one on the left is behind the red circle. | c. | The one on the left
is more transparent than the one on the right. | d. | The one on the right is more transparent than
the one on the left. |
|
|
|
73.
|
Excel is excellent for tasks such as ____.
a. | creating pictures and illustrations | c. | making personal
stationery | b. | writing business letters | d. | keeping track of a budget |
|
|
|
74.
|
To delete text from a slide, select the text and press ____.
a. | [ENTER] | c. | [TAB] | b. | [BACKSPACE] | d. | [ESC] |
|
|
|
75.
|
In this slide, label “A” points to the arrow’s
____. 
a. | rotation handle | c. | sizing handle | b. | move handle | d. | border |
|
|
|
76.
|
If you want to save an existing workbook in a different format, open the ____
box in the Save As dialog box and choose the desired file type.
a. | Search | c. | Save as type | b. | File name | d. | New folder |
|
|
|
77.
|
A background can be ____.
a. | a solid color | c. | a picture | b. | a pattern | d. | All of the
above. |
|
|
|
78.
|
If you want to see how your presentation will look when printed, choose
____.
a. | Slide Show>Start Slide Show>From Beginning | b. | Slide Show>Set
Up>Set Up Slide Show | c. | Office>Print>Print
Preview | d. | View>Presentation Views>Normal |
|
|
|
79.
|
If you are currently at slide 14, which of these methods will take to you slide
15?
a. | Pressing the [PAGE UP] key. | b. | Clicking the Next Slide
button. | c. | Clicking the up arrow on the scroll bar once. | d. | Clicking Slide 15 on
the status bar. |
|
|
|
80.
|
Which of the following can be applied to a transition?
a. | a sound | c. | a connector | b. | a background | d. | a fill color |
|
True/False
Indicate whether the
statement is true or false.
|
|
|
81.
|
The NOW function displays the date and time that a workbook was created.
|
|
|
82.
|
Both Sort and Filter serve the same purpose.
|
|
|
83.
|
You can split the Excel window into two panes.
|
|
|
84.
|
To maintain consistency, you should limit the number of fonts and font styles
you use in a presentation.
|
|
|
85.
|
Excel automatically adjusts a formula that contains relative references when the
formula is copied from one cell to another.
|
|
|
86.
|
After you give a workbook a name and save it, you cannot rearrange its
worksheets.
|
|
|
87.
|
While you can use AutoFit for columns, there is no AutoFit feature for
rows.
|
|
|
88.
|
Headers are text that appears at the top of notes pages or presentation
handouts.
|
|
|
89.
|
Using folders is a good way to organize your presentation files.
|
|
|
90.
|
The Sort A to Z button can be used to sort the cells in a single column in
alphabetical order.
|
|
|
91.
|
A synonym for the verb “to illustrate” is “to
show.”
|
|
|
92.
|
You should assign names to worksheets that are meaningful to you.
|
|
|
93.
|
You can import documents created in other applications, such as Microsoft Word,
into your presentations.
|
|
|
94.
|
Templates often contain formulas.
|
|
|
95.
|
The same slide layout must be applied to all slides in a presentation.
|
|
|
96.
|
If you insert a footer into a presentation, it must appear on every slide in
that presentation.
|
|
|
97.
|
When you double-click a word in a slide, the Mini Toolbar appears.
|
|
|
98.
|
When you use the Insert Sheet Columns command, the Insert dialog box lets you
specify where the new column is to be located.
|
|
|
99.
|
The cell reference $D$3 will not change when the formula is copied to a new
cell.
|
|
|
100.
|
Once you have inserted a Clip Art image onto a slide, you cannot change its
size.
|