Exam #3 Practice Test    Instructor Jim Mollo

 

1.       All of the following are constants except:

          a.   100

          b.   (201) 555-1212

          c.   =B3+C3

          d.   Pete Dunegan

 

2.       How can you determine if a workbook contains more than one worksheet?

          a.   Check the worksheet tabs at the bottom of the window

          b.   Check the worksheet tabs at the top of the window

          c.   Check the Taskbar

          d.   Pull down the View menu

 

3.       How can you tell which cell in a worksheet is the active cell?

          a.   It is blinking

          b.   It is displayed in reverse video

          c.   It is surrounded by a heavy border

          d.   All of the above

 

4.       Which of the following may be included in a formula?

          a.   Cell references

          b.   Functions

          c.   Numeric constants

          d.   All of the above

 

5.       How can you change the active cell?

          a.   Only by clicking in a different cell

          b.   Only by using the arrow keys to move to a different cell

          c.   By clicking or by using the arrow keys

          d.   By using the Taskbar

 

6.       Assume that cell C4 contains a formula. Where would you see the formula displayed?

          a.   In cell C4

          b.   In the Formula bar

          c.   In the Name box

          d.   In the Status bar

 

7.       Where is the address of the active cell displayed?

          a.   In the Name box to the left of the formula bar

          b.   In the Status bar at the bottom of the window

          c.   In the Title bar at the top of the window

          d.   All of the above

 


     Page 2

 

8.       Which Excel screen element displays the Caps Lock indicator when it is on?

          a.   The Title bar

          b.   The Formula bar

          c.   The Status bar

          d.   The Name box

 

9.       Which command enables you to change the margins and/or orientation for a printed worksheet?

          a.   Options

          b.   Page Setup

          c.   View

          d.   Edit

 

10.     Which of the following commands will save the current workbook under a different name?

          a.   File New

          b.   Save

          c.   Save As

          d.   Open

 

11.     Which of the following commands will save the current workbook so that it is readable in both Excel 2000 and Excel 97?

          a.   File New

          b.   Save

          c.   Save As and change file type to Excel 97

          d.   Open

 

12.     Which of the following pull-down menus is used to print an Excel workbook?

          a.   File

          b.   Edit

          c.   Tools

          d.   Window

 

13.     Which part of the formula =B9/4+(C6*D7) is considered a constant?

          a.   B9

          b.   4

          c.   C6

          d.   D7

 

14.     Which of the following is a false statement about workbooks and worksheets?

          a.   A workbook contains one or more worksheets

          b.   The Open command references a worksheet rather than a workbook

          c.   The title bar displays the name of the open workbook

          d.   The same cell reference can be used for every worksheet within a workbook

 


     Page 3

 

15.     How do you display a context-sensitive menu?

          a.   By clicking the Context-sensitive Menu button on the Standard toolbar

          b.   By clicking the Context-sensitive Menu button on the Formatting toolbar

          c.   By double-clicking in the worksheet where you want to see the context-sensitive menu

          d.   By clicking the right mouse button on the part of the worksheet for which you want to see a context-sensitive menu

 

16.     What happens if you point to a cell and click the right mouse button?

          a.   The cell contents are erased

          b.   The entire row is erased

          c.   A context-sensitive menu pertaining to the cell is displayed

          d.   The TipWizard tip that relates to the current operation is displayed

 

17.     What is the character limit on Excel filenames?

          a.   8 characters

          b.   16 characters

          c.   25 characters

          d.   255 characters

 

18.     What happens if you double click the border between columns C and D?

          a.   Column C is hidden

          b.   Column D is hidden

          c.   The width of column C is changed to accommodate the widest entry in that column

          d.   The width of column D is changed to accommodate the widest entry in that column

 

19.     In the formula =C10-D10*(B3+B4)+2/B7, which expression would Excel evaluate first?

          a.   C10-D10

          b.   B3+B4

          c.   2/B7

          d.   It is not possible to determine without knowing the contents of the referenced cells

 

20.     Excel cell references refer to the row by letter and the column by number.

          a.   True

          b.   False

 

21.     An Excel workbook may be opened using either the File menu or an icon on the Standard toolbar.

          a.   True

          b.   False

 


     Page 4

 

22.     Which command will erase the contents of cell B10 without changing cell references throughout the rest of the worksheet?

          a.   Edit Clear

          b.   Edit Delete

          c.   Both Edit Clear and Edit Delete

          d.   Neither Edit Clear nor Edit Delete

 

23.     Which of the following actions will display the cell formulas in a worksheet?

          a.   Double click the border between any two columns

          b.   Select Unhide from the shortcut menu

          c.   Pull down the View menu and select Formulas

          d.   None of the above

 

24.     Which of the following are valid mathematical symbols in Excel?

          a.   *

          b.   ^

          c.   /

          d.   All of the above

 

25.     Cell formulas are usually displayed in the cell, while the contents are displayed in the Name box.

          a.   True

          b.   False

 

26.     If you use the Save As command to rename a worksheet, all subsequent editing will affect the original worksheet.

          a.   True

          b.   False

 

27.     Which command deletes cell B10 from a worksheet, which in turn changes cell references throughout the rest of the worksheet?

          a.   Edit Clear

          b.   Edit Delete

          c.   Both Edit Clear and Edit Delete

          d.   Neither Edit Clear nor Edit Delete

 

28.     A cell at the intersection of the first row and third column has the cell reference:

          a.   A3

          b.   3A

          c.   C1

          d.   1C

 


     Page 5

 

29.     Which of the following is not a valid mathematical symbol in Excel?

          a.   *

          b.   /

          c.   #

          d.   ^

 

30.     A cell formula will not be adjusted if a row or column is inserted in a worksheet.

          a.   True

          b.   False

 

31.     The value of a constant is changed by clicking in the cell containing the constant, entering a new value, then pressing the enter key.

          a.   True

          b.   False

 

32.     Which of the following commands will remove a selected row or column from a worksheet?

          a.   Edit Clear

          b.   Edit Delete

          c.   Both Edit Clear and Edit Delete

          d.   Neither Edit Clear nor Edit Delete

 

33.     The formula =B3+C4 is stored in cell D5. How will the formula change if a row is inserted above the second row in the worksheet?

          a.   =B3+C4

          b.   =B4+C5

          c.   =C3+D4

          d.   =B2+C3

 

34.     In the formula =D7/C4/B3*B2, which expression will Excel evaluate first?

          a.   D7/C4

          b.   C4/B3

          c.   B3*B2

          d.   Impossible to determine since no parentheses are specified

 

35.     A constant is preceded by an equal sign.

          a.   True

          b.   False

 

36.     The Undo command will undo the effects of only the last three commands issued.

          a.   True

          b.   False

 


     Page 6

 

37.     Which of the following is true regarding a printed worksheet?

          a.   It may be printed with or without the row and column headings

          b.   It may be printed with or without the gridlines

          c.   It may be printed in landscape or portrait orientation

          d.   All of the above

 

38.     The formula =B3+C4 is stored in cell D5. How will the formula change if row two is deleted from the worksheet?

          a.   =B2+C4

          b.   =B3+C3

          c.   =B3+C4

          d.   =B2+C3

 

39.     In the formula =B5*B6+C3/D4^2, which expression will Excel evaluate first?

          a.   B5*B6

          b.   B6+C3

          c.   C3/D4

          d.   D4^2

 

40.     All Excel formulas must be preceded by the equal sign (=).

          a.   True

          b.   False

 

41.     Inserting a row in an Excel worksheet will adjust the formulas using cell references.

          a.   True

          b.   False

 

42.     Which of the following commands will automatically adjust formulas in the affected cells?

          a.   Insert

          b.   Delete

          c.   Both Insert and Delete

          d.   Neither Insert nor Delete

 

43.     When you move your mouse over a button on a toolbar, a message will appear detailing what the button will do when clicked. What is that message called?

          a.   A tip from the Office Assistant

          b.   A screen tip

          c.   The Tip Wizard

          d.   None of the above

 


     Page 7

 

44.     The cell contents of B3 and B4 are 4 and 5 respectively. What will be the displayed value in cell B5 if you enter B3+B4 in cell B5 and then press the enter key?

          a.   B3+B4

          b.   =B3+B4

          c.   9

          d.   It is not possible to determine from the information given

 

45.     If cells B1, B2, and B3 contain the values 2, 3, and 4, respectively, what value will be displayed in a cell containing the formula =B3/B1+B2+1?

          a.   6

          b.   1.8

          c.   0.6667

          d.   An error message; the formula is invalid

 

46.     Excel functions such as AVERAGE(B9:B12) do not need to be preceded by the equal sign.

          a.   True

          b.   False

 

47.     The Page Setup command allows you to scale a worksheet to print on one page.

          a.   True

          b.   False

 

48.     Which of the following options is controlled through the Page Setup command?

          a.   Margins

          b.   Orientation (portrait or landscape)

          c.   Headers and footers

          d.   All of the above

 

49.     The purpose of the Office Assistant is to:

          a.   Provide easy access to a button where you can ask questions

          b.   Answer questions about tasks

          c.   Suggest tips for increasing your productivity using Excel

          d.   All of the above

 

50.     Which of the following is a valid Excel formula?

          a.   =C4*D4

          b.   B4*D4

          c.   Both =C4*D4 and B4*D4

          d.   Neither =C4*D4 nor B4*D4

 


     Page 8

 

51.     If cells C1, C2, and C3 contain the values 4, 2, and 5, respectively, what value will be displayed in a cell containing the formula =C3-C1/C2^2*C3?

          a.   20

          b.   1.25

          c.   -5

          d.   None of the above

 

52.     An Excel worksheet may contain several workbooks.

          a.   True

          b.   False

 

53.     The most recently used workbook can be opened by clicking on a list at the bottom of the File menu.

          a.   True

          b.   False

 

54.     What happens if you press the Ctrl+' key combination, given that the displayed values for each cell are shown in the worksheet?

          a.   The worksheet formulas are displayed

          b.   A new column is inserted in the worksheet

          c.   A new row is inserted in the worksheet

          d.   A duplicate worksheet is created in the workbook

 

55.     Which command in which menu enables you to display the row and column headings when printing a worksheet?

          a.   View command in the Print menu

          b.   View command in the File menu

          c.   Page Setup command in the File menu

          d.   Page Setup command in the View menu

 

56.     In Excel, a function is:

          a.   A predefined computational task such as averaging a group of cells

          b.   A command such as File Open

          c.   A mathematical operation such as =B6+B7

          d.   All of the above

 

57.     A blinking border shows the active cell.

          a.   True

          b.   False

 

58.     If you want to save an Excel 2000 worksheet to use in Excel 95 workbook, use the Save As command.

          a.   True

          b.   False

 


     Page 9

 

59.     Which of the following worksheet options is controlled through the Page Setup command?

          a.   Centering the worksheet horizontally on the page

          b.   Printing in landscape mode

          c.   Creating a header

          d.   All of the above

 

60.     A worksheet currently displays the cell contents rather than the displayed (computed) values of each cell. Which keystroke combination will change the worksheet view from displaying the cell contents to the displayed values?

          a.   Ctrl+'

          b.   Ctrl+F

          c.   Ctrl+DV

          d.   None of the above

 

61.     You deleted a row from the current worksheet three actions ago and realize you made a mistake. You entered two formulas and would like to keep those formulas intact. Which of the following actions should you take to correct your error?

          a.   Retrieve the row from the Recycle Bin

          b.   Click the Open button on the Standard toolbar to open a fresh copy of the worksheet

          c.   Click the Undo button on the Standard toolbar to restore the row

          d.   It is not possible to undo the row and not change the formulas too.

 

62.     The function =AVERAGE(A6:A8) is the equivalent of the formula:

          a.   A6+A7+A8/3

          b.   =(A6+A7+A8/3)

          c.   =(A6+A7+A8)/3

          d.   =(A6+A8)/2

 

63.     If you press the Caps Lock key on the keyboard, an indicator will appear on the Status bar.

          a.   True

          b.   False

 

64.     The Edit Clear command does not adjust cell references.

          a.   True

          b.   False

 

65.     Which of the following is the easiest way to reopen a workbook from the previous session?

          a.   Select the workbook from the appropriate list using the Open command

          b.   Pull down the File menu and select the file from the list at the bottom of the menu

          c.   Click the Open button on the Standard toolbar

          d.   All of these methods open the workbook with equal ease

 


     Page 10

 

66.     Which of the following actions will increase the column width of column B to fit the widest entry?

          a.   Click the border between columns A and B

          b.   Double click the border between columns A and B

          c.   Click the border between columns B and C

          d.   Double click the border between columns B and C

 

67.     Which of the following commands is available from the File menu?

          a.   Save

          b.   Print

          c.   Open

          d.   All of the above

 

68.     Which of the following will compute the average of cells B1 through B4?

          a.   (B1+B2+B3+B4)/4

          b.   =AVG(B1:B4)

          c.   AVERAGE(B1:B4)

          d.   None of the above

 

69.     The tabs at the bottom of an Excel window display the name(s) of the open workbook(s).

          a.   True

          b.   False

 

70.     A column may be inserted using a context-sensitive menu or a pull-down menu.

          a.   True

          b.   False

 

71.     Which chart type is the most appropriate to show percentages, such as how much of your total budget you spend on entertainment?

          a.   A pie chart

          b.   A column chart

          c.   A stacked column chart

          d.   A line chart

 

72.     Which of the following types of pie charts can be used to create three-dimensional charts?

          a.   Non-exploded only

          b.   Exploded only

          c.   Both exploded and non-exploded

          d.   Neither exploded nor non-exploded

 

73.     What is the maximum recommended number of categories for a column or pie chart?

          a.   3

          b.   7

          c.   15

          d.   25

 


     Page 11

 

74.     Which of the following statements about sizing and moving a chart is true?

          a.   A chart can be sized horizontally

          b.   A chart can be sized vertically

          c.   A chart can be moved to any location in the worksheet

          d.   All of the above

 

75.     All of the following are places you can find the Chart Wizard in Excel 2000 except:

          a.   Click on more button on the toolbar

          b.   Separate the Standard and Formatting toolbars and it will be on the Standard toolbar

          c.   Click on Tools and Chart Wizard

          d.   Click on Insert Chart and the Chart Wizard will appear

 

76.     Which of the following can be modified after a chart is created using the Chart Wizard?

          a.   The chart type

          b.   The legend

          c.   The formatting of the title

          d.   All of the above

 

77.     Which of the following is true about an embedded chart?

          a.   It can be moved elsewhere in the worksheet

          b.   It can be made larger or smaller

          c.   It can be deleted

          d.   All of the above

 

78.     What is the easiest way to delete a chart from a worksheet?

          a.   Click on the data range from which the chart was created, then click on Edit and drag to Delete Chart

          b.   Click on the chart, then press the Del key

          c.   Click on the chart, then press Ctrl+Del

          d.   Once a chart is created, it cannot be deleted

 

79.     How do you activate the context-sensitive menu for a selected item on a worksheet?

          a.   Press Ctrl+S

          b.   Point to the item, then click the right mouse button

          c.   Double click the right border of the object

          d.   Click the Tools button on the Standard toolbar

 

80.     What happens when you point to a cell and click the right mouse button?

          a.   A shortcut menu is displayed

          b.   The cell contents are deleted

          c.   The cell contents are displayed

          d.   The AutoFill command is executed

 


     Page 12

 

81.     Which of the following would you recommend to show both the number of cars sold and the revenues of six dealerships in the district?

          a.   Pie chart

          b.   Side-by-side column chart

          c.   Stacked column chart

          d.   Combination chart

 

82.     An embedded chart can be:

          a.   Moved

          b.   Copied

          c.   Sized

          d.   All of the above

 

83.     What happens if you select multiple data series in a worksheet and then press F11?

          a.   The cell formats are deleted

          b.   The Copy command is invoked

          c.   A default chart is created

          d.   The worksheet is recalculated

 

84.     Which technique would you use to include the same Excel chart in both a Word document and a PowerPoint presentation?

          a.   Linking

          b.   Embedding

          c.   Compounding

          d.   Multitasking

 

85.     A column chart with multiple data series can always display the series side by side or in stacked format with equally meaningful results.

          a.   True

          b.   False

 

86.     A Word document cannot contain both an Excel chart and the associated worksheet.

          a.   True

          b.   False

 

87.     The clipboard is not used to copy data between a worksheet and a word processing document during object linking and embedding.

          a.   True

          b.   False

 

88.     The title of a chart must be entered as a text box using the Charting toolbar; it cannot be entered using the Chart Wizard.

          a.   True

          b.   False

 


     Page 13

 

89.     Which of the following is true?

          a.   A linked object must be stored in its own file prior to including it in a compound document

          b.   An embedded object must be stored in its own file prior to including it in a compound document

          c.   An object must be stored in its own file regardless of whether it is linked or embedded

          d.   An object can not be stored in its own file if it is to be linked or embedded in a compound document

 

90.     If the data series in a chart are in columns, the Excel Chart Wizard will:

          a.   Use the first row for the X axis labels

          b.   Use the first column for the legend text

          c.   Use the first row for the X axis labels and the first column for the legend text

          d.   None of the above

 

91.     Which of the following is done using the Drawing toolbar?

          a.   Adding a text box

          b.   Changing the chart type

          c.   Adding gridlines to the chart

          d.   All of the above

 

92.     A combination chart is best when you need to show:

          a.   The proportions of more than one data series

          b.   Different scales for multiple data series plotted against the same X axis

          c.   Both horizontal and vertical data

          d.   Data that contain both relative and absolute cell references

 

93.     Which of the following chart types is the best to show the number of houses sold and the dollar volume of sales for six real estate agents?

          a.   A pie chart

          b.   A side-by-side column chart

          c.   A combination chart

          d.   A line chart

 

94.     Which of the following cannot be done using the Chart Wizard?

          a.   Adding an arrow and text to the chart

          b.   Adding a chart title

          c.   Removing the legend

          d.   Changing the data series to columns

 

95.     If the data series in a chart are in rows, the Excel Chart Wizard will:

          a.   Use the first row for the X axis labels

          b.   Use the first column for the legend text

          c.   Use the first row for the X axis labels and the first column for the legend text

          d.   None of the above

 


     Page 14

 

96.     The misuse of charts is common occurrence. What kinds of information, cited in the text, can be used to easily mislead the reader?

          a.   Chart type and chart labels

          b.   Chart labels and adding dissimilar quantities

          c.   Chart types and adding dissimilar quantities

          d.   All of the above can be used to mislead the reader.

 

97.     The location of a toolbar cannot be changed.

          a.   True

          b.   False

 

98.     Pressing Alt+Tab allows the user to move between open applications.

          a.   True

          b.   False

 

99.     Which of the following is most appropriate to show the trend of revenues and sales growth over a five-year period?

          a.   A line chart

          b.   A side-by-side column chart

          c.   A pie chart

          d.   A combination chart

 

100.   Which of the following chart types is available when using the Chart Wizard to create a chart?

          a.   Pie

          b.   3D column

          c.   Combination

          d.   All of the above

 

101.   If the data series in a chart are in columns, the Excel Chart Wizard will:

          a.   Use the first row for the X axis labels

          b.   Use the first column for the X axis labels

          c.   Use the first row for the Y axis labels

          d.   Use the first column for the legend text

 

102.   What is the best way to move between a floating toolbar and a docked toolbar?

          a.   Drag the border of the tool bar to the position you want it on the worksheet

          b.   Toggle between floating and docked by toolbars by double clicking on the background of the toolbar

          c.   Drag the toolbar background to the position you want on the worksheet

          d.   Click on Tools menu, select Customize, and check the Floating box next to the toolbar you want

 

103.   A chart created using the Chart Wizard cannot be modified.

          a.   True

          b.   False

 


     Page 15

 

104.   It is not possible to edit an Excel worksheet that is embedded in a Word document.

          a.   True

          b.   False

 

105.   Which of the following is used to distinguish one data series from another?

          a.   The labels on the X axis

          b.   The legend

          c.   The key

          d.   The labels on the Y axis

 

106.   Which of the following cannot be used to move an embedded chart?

          a.   Click anywhere in the chart, then click and drag the chart elsewhere in the worksheet

          b.   Double click anywhere in the chart, then click and drag the chart elsewhere in the worksheet

          c.   Point to the chart, click the right mouse button to select the chart, then click and drag the chart elsewhere in the worksheet after it has been selected

          d.   Select the chart, execute the Cut command, click elsewhere in the worksheet, then execute the Paste command

 

107.   If the data series in a chart are in rows, the Excel Chart Wizard will:

          a.   Use the first row for the X axis labels

          b.   Use the first row for the Y axis labels

          c.   Use the first row for the legend text

          d.   It is not possible to determine

 

108.   Assume that cells A1 through D5 have been selected, after which the Chart Wizard is used to create a side-by-side column chart. How many data series will there be, given that the data are to be plotted in rows?

          a.   Three

          b.   Four

          c.   Five

          d.   Impossible to determine

 

109.   Pressing the Del key after selecting an embedded chart erases the chart from the worksheet.

          a.   True

          b.   False

 

110.   When creating a linked object, both source and destination documents will be open.

          a.   True

          b.   False

 


     Page 16

 

111.   Which of the following commands is included in the command sequence to embed a chart in a word processing document if a dynamic link is required?

          a.   Copy

          b.   Paste Special

          c.   Paste Link

          d.   All of the above

 

112.   The same worksheet is the basis for an embedded pie chart, as well as a column chart in its own chart sheet. Which chart will change if the data points in the worksheet change?

          a.   Both the pie chart and the column chart

          b.   Only the pie chart

          c.   Only the column chart

          d.   Neither the pie chart nor the column chart

 

113.   Which of the following chart types emphasizes the totals for each category label on the X axis?

          a.   Bar chart

          b.   Column chart

          c.   Stacked column chart

          d.   Line chart

 

114.   Assume that cells A1 through E5 have been selected, after which the Chart Wizard is used to create a side-by-side column chart. Which of the following is true, given that the data are to be plotted in columns?

          a.   The category names are in cells B1 through E1

          b.   The legends are in cells A2 through E5

          c.   There are five data series

          d.   None of the above

 

115.   The size and/or location of an embedded chart cannot be changed once the chart has been created.

          a.   True

          b.   False

 

116.   A chart may be copied to another area of a workbook.

          a.   True

          b.   False

 

117.   Which of the following creates a dynamic link between an Excel worksheet and a word processing memo?

          a.   Cut and Paste

          b.   Object Linking and Embedding (OLE)

          c.   Both Cut and Paste, and OLE

          d.   Neither Cut and Paste, nor OLE

 


     Page 17

 

118.   Which type of chart is linked to the worksheet data on which it is based?

          a.   A chart that is embedded in the worksheet

          b.   A chart that is in its own chart sheet

          c.   Both the embedded chart and the one in its own chart sheet

          d.   Neither the embedded chart nor the one in its own chart sheet

 

119.   Which of the following will change if you switch from a side-by-side column chart to a stacked column chart?

          a.   The labels on the X axis

          b.   The scale on the Y axis

          c.   Both the labels on the X axis and the scale on the Y axis

          d.   Neither the labels on the X axis nor the scale on the Y axis

 

120.   Assume that cells A1 through E5 have been selected, after which the Chart Wizard is used to create a side-by-side column chart. Which of the following is true, given that the data are to be plotted in rows?

          a.   The category names are in cells B1 through E1

          b.   The legends are in cells A2 through A5

          c.   There are four data series

          d.   All of the above

 

121.   An embedded chart is not updated if the worksheet is modified unless the Edit Update command is used.

          a.   True

          b.   False

 

122.   The chart type may be changed using the Format menu, the Chart Wizard, or a shortcut menu.

          a.   True

          b.   False

 

123.   If you specify that data is to be charted in rows, Excel will use the first row for the legend text.

          a.   True

          b.   False

 

124.   If a chart is kept in a separate chart sheet, it will not be updated when the data points in the worksheet are updated.

          a.   True

          b.   False

 

125.   Another approach to multitasking in Windows 95/98 or Windows NT is to:

          a.   Use the Taskbar and click on the application you want

          b.   Minimize one application so you can work on another

          c.   Both using the Taskbar and Minimizing will work

          d.   Neither the Taskbar or Minimizing will work

 


     Page 18

 

126.   Which of the following will change if you switch from a side-by-side column chart to a stacked column chart?

          a.   The height of the columns

          b.   The number of columns

          c.   The scale on the Y axis

          d.   All of the above

 

127.   In which chart type is the data graphed horizontally?

          a.   Bar chart

          b.   Column chart

          c.   Both a bar and a column chart

          d.   Stacked column chart

 

128.   Assume you have used Paste Link to create a compound document using an Excel worksheet in a word processing document. Which of the following will change if the worksheet is modified?

          a.   The chart in the worksheet, but not the chart in the word processing document

          b.   The chart in the word processing document, but not the chart in the worksheet

          c.   The chart in the worksheet and the chart in the word processing document

          d.   Neither the chart in the worksheet, nor the chart in the word processing document

 

129.   Multiple data series may be contained in either rows or columns.

          a.   True

          b.   False

 

130.   You should limit the number of categories in a pie chart to seven or fewer.

          a.   True

          b.   False

 

131.   Which key combination allows you to switch back and forth between open applications?

          a.   Alt+Tab

          b.   Ctrl+Tab

          c.   Shift+Tab

          d.   Alt+Ctrl+Tab

 

132.   Which of the following will allow you to draw an arrow in a chart at a perfect 45ø angle?

          a.   Press Ctrl while dragging the mouse to create the arrow

          b.   Press Shift while dragging the mouse to create the arrow

          c.   Press Alt while dragging the mouse to create the arrow

          d.   This is not possible

 


     Page 19

 

133.   If you are creating a column chart to show monthly sales in each of three cities, which axis would contain the category labels (the city names)?

          a.   X axis

          b.   Y axis

          c.   Either X or Y axis

          d.   It is not possible to determine from the information given

 

134.   Which key will create a default chart type in its own worksheet after you select the range?

          a.   F2

          b.   F4

          c.   F5

          d.   F11

 

135.   Which of the following chart types explicitly totals the data series in each category?

          a.   Side-by-side columns

          b.   Stacked columns

          c.   Both side-by-side and stacked columns

          d.   Neither side-by-side nor stacked columns

 

136.   Which of the following can be used to add emphasis to a pie chart?

          a.   Arrows and text

          b.   The chart title

          c.   An exploded slice

          d.   All of the above

 

137.   You have created a workbook that includes a revenue worksheet containing two embedded charts. The workbook also includes one chart in its own worksheet. How many files does it take to store this workbook?

          a.   1

          b.   2

          c.   3

          d.   4

 

138.   The Drawing Toolbar allows for enhanced 3D effects. Which of the following cannot be converted to 3D by using the Drawing Toolbar?

          a.   AutoShapes

          b.   Styles

          c.   Chart type

          d.   Titles

 

139.   A column chart is the chart type best suited to display proportional data.

          a.   True

          b.   False

 


     Page 20

 

140.   A side-by-side column chart and a stacked column chart of the same data will use the same scale on the Y axis.

          a.   True

          b.   False

 

141.   Which of the following can be included in a PowerPoint presentation?

          a.   ClipArt

          b.   Text

          c.   WordArt

          d.   All of the above

 

142.   What happens if, while working on a presentation and after you have saved the presentation, you pull down the File menu and click the Close command?

          a.   The current presentation is closed

          b.   All open PowerPoint presentations are closed

          c.   PowerPoint and all open presentations are closed

          d.   Windows 98 and all open applications are closed

 

143.   What happens if you click the New Slide button while editing slide 3 in Slide view?

          a.   A new slide with the default layout will be inserted before slide 3

          b.   A new slide with the default layout will be inserted after slide 3

          c.   You will be asked to select the slide layout for a new slide which will be inserted before slide 3

          d.   You will be asked to select the slide layout for a new slide which will be inserted after slide 3

 

144.   Assume you are in Outline view and have collapsed the outline so that only the titles are visible. What happens if you click on the third slide and drag it to the end of the presentation?

          a.   The slide title is moved, but the bulleted items remain and are now included on slide two

          b.   The slide title remains, but the bulleted items are moved to the end of the last slide

          c.   The entire slide, including title, bullets, and graphics, is moved to the end of the presentation

          d.   This situation is not possible; it is not possible to drag a slide in Outline view

 

145.   Which of the following presentation elements can be displayed with a build effect?

          a.   Bullets

          b.   Graphic images

          c.   Both bullets and graphic images

          d.   Neither bullets nor graphic images

 

146.   Many of the buttons on the Standard and Formatting toolbars in PowerPoint are the same as those in Word and Excel.

          a.   True

          b.   False

 


     Page 21

 

147.   You cannot see graphic elements in Slide Sorter view.

          a.   True

          b.   False

 

148.   Which of the following print options are available in PowerPoint?

          a.   One slide per page

          b.   Two or three slides per page

          c.   Six slides per page

          d.   All of the above

 

149.   In which view are you working if, while editing a presentation, you see only text, but no graphics?

          a.   Notes Pages view

          b.   Outline view

          c.   Normal view

          d.   Slide Sorter view

 

150.   Which PowerPoint key combination indents text one level?

          a.   Tab

          b.   Ctrl+Tab

          c.   Shift+Tab

          d.   Alt+Tab

 

151.   Which key combination can be used to select all the slides in Outline view?

          a.   Ctrl+End

          b.   Ctrl+A

          c.   Alt+End

          d.   Alt+A

 

152.   Which of the following elements can have its color changed within a template?

          a.   The title text

          b.   The bullet text

          c.   The background

          d.   All of the above

 

153.   When you click the Save button, your PowerPoint presentation is saved to disk and removed from memory.

          a.   True

          b.   False

 

154.   Text you type in the notes area in Notes Pages view will be displayed in Slide Show view.

          a.   True

          b.   False

 


     Page 22

 

155.   Which toolbar is displayed by default in all views?

          a.   The Standard Toolbar

          b.   The Formatting Toolbar

          c.   Both (a) and (b)

          d.   Neither (a) nor (b)

 

156.   In which view are you working if you see Outline view, Slide view, and Notes Page view in a single window?

          a.   Outline view

          b.   Slide Sorter view

          c.   Notes Pages view

          d.   Normal view

 

157.   What happens when you press the Tab key when starting to enter the text for a bullet?

          a.   The bullet will be indented one level to the right

          b.   The bullet will be moved one level to the left

          c.   The bullet symbol changes to the previously used symbol

          d.   A new bullet is entered on the line below the current line

 

158.   Suppose you are working in Outline view and press Ctrl+A. What happens?

          a.   The PowerPoint annotation tool is displayed

          b.   The mouse pointer returns to an arrow

          c.   The presentation is checked for spelling

          d.   All the slides in the presentation are selected

 

159.   Which of the following is true?

          a.   Slides can be added to a presentation after a template has been selected

          b.   The template can be changed after all of the slides have been created

          c.   The template can be changed at any time when you are editing your presentation

          d.   All of the above

 

160.   PowerPoint file names can contain both spaces and commas.

          a.   True

          b.   False

 

161.   If you rearrange the order of slides in Slide Sorter view, you will see the new slide order when you look at the presentation in Outline view.

          a.   True

          b.   False

 

162.   Where are the boldface, italics, and underlining buttons?

          a.   On the Standard toolbar

          b.   On the Formatting toolbar

          c.   On the Menu bar

          d.   On the Status bar

 


     Page 23

 

163.   In which PowerPoint view can you see the text of multiple slides at one time?

          a.   Outline view

          b.   Slide Sorter view

          c.   Normal view

          d.   All of the above

 

164.   Which PowerPoint key combination moves indented text back one level to the left?

          a.   Tab

          b.   Shift+Tab

          c.   Shift+Left Arrow

          d.   Ctrl+Left Arrow

 

165.   Where will the insertion point be after you complete the text for a bullet in the Outline view and press the Enter key?

          a.   On the next bullet at the same level of indentation

          b.   On the next bullet at a higher level of indentation

          c.   On the next bullet at a lower level of indentation

          d.   Impossible to determine

 

166.   Which of the following can be printed for a presentation?

          a.   The slides in miniature (up to six to a page)

          b.   The notes pages

          c.   The outline

          d.   All of the above

 

167.   The Open command is used to create a new PowerPoint presentation.

          a.   True

          b.   False

 

168.   If you rearrange the order of slides in the Outline view, you will not see the new slide order when you view the presentation in Slide Show view.

          a.   True

          b.   False

 

169.   Where do you find the Open button (icon)?

          a.   On the Standard toolbar

          b.   On the Formatting toolbar

          c.   On the Status bar

          d.   On the Menu bar

 

170.   In which view can you rearrange the order of slides in a PowerPoint presentation?

          a.   Slide Sorter view

          b.   Outline view

          c.   Normal view

          d.   All of the above

 


     Page 24

 

171.   You are editing a PowerPoint presentation and have entered the text for a bullet on the current slide. What happens when you press the Enter key?

          a.   The insertion point moves to a new bullet indented one level to the right

          b.   The insertion point moves to a new bullet indented one level to the left

          c.   The insertion point moves to a new bullet at the same indent level as the current bullet

          d.   It is not possible to determine

 

172.   Which of the following is true?

          a.   Shift + Tab promotes an item to the next higher level

          b.   Shift + Tab demotes an item to the next lower level

          c.   Tab promotes an item to the next higher level

          d.   All of the above are false

 

173.   You are reviewing a PowerPoint presentation in Slide Show view and notice that the bullets are appearing from bottom to top. What is the most likely explanation for this?

          a.   The slide transition was incorrectly specified

          b.   The reverse order build effect was selected

          c.   The order of the slide was changed using Slide Sorter view

          d.   The slide master contains an error

 

174.   The Save As command can be used to create a copy of an existing PowerPoint presentation.

          a.   True

          b.   False

 

175.   It is not possible to delete a slide while in Slide Show view.

          a.   True

          b.   False

 

176.   Which of the following toolbars is available in PowerPoint?

          a.   The Standard toolbar

          b.   The Formatting toolbar

          c.   Both the Standard and the Formatting toolbars

          d.   Neither the Standard nor the Formatting toolbar

 

177.   Which PowerPoint view allows you to create speaker's notes for display during the slide show?

          a.   Slide Sorter view

          b.   Outline view

          c.   Slide view

          d.   None of the above

 


     Page 25

 

178.   What is the fastest way to replace existing text in a PowerPoint presentation?

          a.   Select the text, then type the new entry while the text is still selected

          b.   Select the text, pull down the Edit menu, press Delete, then type the new entry

          c.   Position the insertion point at the beginning of the text to be deleted, press Ctrl+Delete to delete each word, then type the new entry

          d.   Select the text, click the Cut button on the Standard toolbar, then type the new entry

 

179.   Which of the following PowerPoint features changes the way slides move on and off the screen?

          a.   Transitions

          b.   Builds

          c.   Slide Navigator

          d.   All of the above

 

180.   Using animation effects, you can:

          a.   Build the slide a bullet at a time

          b.   Build the bullets a letter at a time

          c.   Build the bullets a word at a time

          d.   All of the above

 

181.   It is possible to edit a slide in Slide view.

          a.   True

          b.   False

 

182.   To add clip art to a slide, you should single click the ClipArt placeholder.

          a.   True

          b.   False

 

183.   Which PowerPoint menu contains the Save, Open, and Print commands?

          a.   Edit

          b.   File

          c.   View

          d.   Insert

 

184.   Which PowerPoint view is best for viewing multiple slides on the screen at one time?

          a.   Slide Show view

          b.   Slide view

          c.   Slide Sorter view

          d.   Notes Pages view

 

185.   How can you determine which slide is selected when you are in Slide Sorter View?

          a.   The current slide number is shown on the status bar

          b.   The current slide is surrounded by a heavy border

          c.   The current slide is surrounded by a blinking marquee

          d.   The current slide number shows on the Standard toolbar

 


     Page 26

 

186.   Which of the following actions could you take to add a graphic element to a slide which currently contains only text bullets?

          a.   Click the Graphic button on the Formatting toolbar, then drag the crosshair to indicate the size and location of the graphic

          b.   Click the Slide Layout button on the status bar and select a layout with text and graphics

          c.   Switch to Slide Sorter view and drag a graphic element from another slide to this slide

          d.   It is not possible to add a graphic to an existing slide

 

187.   In which view do you see the animation effects for a slide?

          a.   Slide Show view

          b.   Outline view

          c.   Both Slide Show and Outline view

          d.   Neither Slide Show nor Outline view

 

188.   You can set up a PowerPoint slide show to advance automatically through the slides.

          a.   True

          b.   False

 

189.   When you execute the New Slide command, the slide will be added immediately before the current slide.

          a.   True

          b.   False

 

190.   Which of the following is a valid file name for a PowerPoint presentation?

          a.   History 201 Presentation

          b.   PresHist201

          c.   Both History 201 Presentation and PresHist201

          d.   Neither History 201 Presentation nor PresHist201

 

191.   It is possible to delete a slide while in any of the following views except:

          a.   Slide view

          b.   Slide Show view

          c.   Slide Sorter view

          d.   Normal view

 

192.   Assume you are in the middle of a PowerPoint slide show and want to add an annotation to the current slide. Where can you find the annotation pen?

          a.   On the Standard toolbar

          b.   On the Formatting toolbar

          c.   On the shortcut menu

          d.   On the status bar

 


     Page 27

 

193.   You are in the Slide Sorter view. How can you determine whether a slide includes a transition effect?

          a.   The slide title appears in boldface

          b.   The slide title blinks

          c.   A special slide icon appears below the slide

          d.   You cannot determine in Slide Sorter that a slide contains a transition effect

 

194.   You are working on a PowerPoint presentation and execute the command to apply a design template. Which slide(s) does the command affect?

          a.   Only the current slide

          b.   All slides in the current presentation

          c.   All new presentations subsequently created in this session

          d.   All existing presentations subsequently opened in this session

 

195.   Suppose you have just advanced to the next slide while viewing a PowerPoint presentation in Slide Show view. Pressing the Esc key will close the presentation, leaving you with an empty PowerPoint window.

          a.   True

          b.   False

 

196.   A template determines the slide color scheme and the arrangement of the placeholders only.

          a.   True

          b.   False

 

197.   You are working on a PowerPoint presentation and execute the Save command for the first time. Which of the following statements is true?

          a.   The presentation is saved to disk but is no longer in memory

          b.   The presentation is closed

          c.   The presentation is saved to disk and remains in memory

          d.   None of the above

 

198.   Which view enables you to use the Delete key to delete a slide?

          a.   Notes Pages view

          b.   Slide view

          c.   Slide Sorter view

          d.   All of the above

 

199.   Which of the following design specifications is preset in a PowerPoint template?

          a.   Color scheme

          b.   Arrangement of placeholders on each slide

          c.   Size of bulleted text

          d.   All of the above

 


     Page 28

 

200.   Where can you find the Slide Transition command?

          a.   Slide Show menu

          b.   Slide Sorter toolbar

          c.   On both the Slide Show menu and the Slide Sorter toolbar

          d.   On neither the Slide Show menu or Slide Sorter toolbar

 

201.   How do you select a slide in Outline view?

          a.   Click the slide icon

          b.   Click the slide number

          c.   Click either the slide icon or the slide number

          d.   It is not possible to select a slide in Outline view

 

202.   You can drag a slide to a new location in Slide Sorter view.

          a.   True

          b.   False

 

203.   Animation effects can be applied to bulleted lists only, not to charts or ClipArt.

          a.   True

          b.   False

 

204.   You open a PowerPoint presentation called Sample Presentation. You pull down the File menu, select Save As, and save the file with a new name, My First Presentation. Which of the following statements is true?

          a.   The presentation is stored twice in memory, and you can use the Window menu to toggle between the two files

          b.   The Sample Presentation is overwritten on disk by My First Presentation

          c.   The Title bar at the top of the PowerPoint window shows My First Presentation

          d.   All of the above

 

205.   In which view do you have to use the Delete Slide command on the Edit menu to delete a slide (the Delete key is not valid)?

          a.   Slide Sorter view

          b.   Slide view

          c.   Both Slide Sorter and Slide views

          d.   Neither Slide Sorter nor Slide views

 

206.   Which of the following statements is true about PowerPoint's ability to correct spelling?

          a.   It will automatically correct all misspelled words as you type them

          b.   It will automatically correct only those words in the main spell check dictionary

          c.   It will automatically correct only those words defined in the AutoCorrect feature

          d.   It cannot automatically correct any misspellings

 


     Page 29

 

207.   You are rehearsing a presentation in Slide Show view, but do not see any bullets on the current slide (which you know has three bullets). What is the most likely explanation?

          a.   The bullets are defined with a build effect and have not yet been displayed

          b.   The bullets on this slide are hidden

          c.   The option to suppress the bullets was selected

          d.   The Show Titles Only command was executed in the Outline view

 

208.   Which of the following is the most important element in a PowerPoint presentation?

          a.   The content

          b.   The template

          c.   The slide layout

          d.   The transition and build effects

 

209.   The Normal view displays Slide and Outline view only.

          a.   True

          b.   False

 

210.   Both transition and animation effects are available through the Slide Show menu.

          a.   True

          b.   False

 

211.   To select multiple slides while in Slide Sorter view, press and hold the Shift key then click each slide.

          a.   True

          b.   False

 

212.   Transitions control the way in which one slide moves off the screen and the next slide appears.

          a.   True

          b.   False

 

213.   A template will typically define different colors for the background, text, and title on a slide.

          a.   True

          b.   False

 

214.   Once you have selected a layout for a slide, you cannot change it to add a new object at a later time.

          a.   True

          b.   False

 

215.   Any markings made with the PowerPoint annotation pen will be removed when you advance to the next slide.

          a.   True

          b.   False


     Page 1

 

1.       c

2.       a

3.       c

4.       d

5.       c

6.       b

7.       a

8.       c

9.       b

10.     c

11.     b

12.     a

13.     b

14.     b

15.     d

16.     c

17.     d

18.     c

19.     b

20.     False

21.     True

22.     a

23.     d


     Page 2

 

24.     d

25.     False

26.     False

27.     b

28.     c

29.     c

30.     False

31.     True

32.     b

33.     b

34.     a

35.     False

36.     False

37.     d

38.     d

39.     d

40.     True

41.     True

42.     c

43.     b

44.     a

45.     a

46.     False


     Page 3

 

47.     True

48.     d

49.     d

50.     a

51.     a

52.     False

53.     True

54.     a

55.     c

56.     a

57.     False

58.     False

59.     d

60.     a

61.     d

62.     c

63.     True

64.     True

65.     b

66.     d

67.     d

68.     d

69.     False


     Page 4

 

70.     True

71.     a

72.     c

73.     b

74.     d

75.     c

76.     d

77.     d

78.     b

79.     b

80.     a

81.     d

82.     d

83.     c

84.     a

85.     False

86.     False

87.     False

88.     False

89.     a

90.     d

91.     a

92.     b


     Page 5

 

93.     c

94.     a

95.     c

96.     d

97.     False

98.     True

99.     a

100.   d

101.   b

102.   b

103.   False

104.   False

105.   b

106.   b

107.   a

108.   b

109.   True

110.   True

111.   d

112.   a

113.   c

114.   d

115.   False


     Page 6

 

116.   True

117.   b

118.   c

119.   b

120.   d

121.   False

122.   True

123.   False

124.   False

125.   c

126.   d

127.   a

128.   c

129.   True

130.   True

131.   a

132.   b

133.   a

134.   d

135.   b

136.   d

137.   a

138.   c


     Page 7

 

139.   False

140.   False

141.   d

142.   a

143.   d

144.   c

145.   c

146.   True

147.   False

148.   d

149.   b

150.   a

151.   b

152.   d

153.   False

154.   False

155.   c

156.   d

157.   a

158.   d

159.   a

160.   True

161.   True


     Page 8

 

162.   b

163.   d

164.   b

165.   a

166.   d

167.   False

168.   False

169.   a

170.   d

171.   c

172.   a

173.   b

174.   True

175.   True

176.   c

177.   d

178.   a

179.   a

180.   d

181.   True

182.   False

183.   b

184.   c


     Page 9

 

185.   b

186.   b

187.   a

188.   True

189.   False

190.   c

191.   b

192.   c

193.   c

194.   b

195.   False

196.   False

197.   c

198.   c

199.   d

200.   c

201.   c

202.   True

203.   False

204.   c

205.   b

206.   c

207.   a


     Page 10

 

208.   a

209.   False

210.   True

211.   True

212.   True

213.   True

214.   False

215.   True