Multiple Choice

1.__________, a primary part of Excel, pictorially represent(s) data.

    1. Worksheets
    2. Charts
    3. Databases
    4. Web support

2.A __________, which is the intersection of a column and row, is the basic unit of a worksheet into which data is entered.

    1. cell
    2. window
    3. range
    4. split box

3.The active cell can be identified in all of the following ways except __________.

    1. a heavy border surrounding the cell
    2. the active cell reference displayed in the Name box
    3. the lit up column heading and row heading
    4. a block plus sign displaying in the center of the cell

4.The mouse pointer turns into the __________ whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns.

    1. block plus sign
    2. I-beam
    3. block arrow
    4. two-headed arrow

5.Below and to the right of a worksheet are __________ that can be used to move the window around to view different parts of the active worksheet.

    1. scroll bars
    2. scroll arrows
    3. scroll boxes
    4. all of the above

6.An alternative to sliding one toolbar over another is to use the __________ on a toolbar to display the buttons that are hidden.

    1. More Buttons button
    2. Name Box button
    3. ScreenTip button
    4. Question Mark button

7.The status bar displays __________.

    1. names representing a lists of commands that can be used to retrieve, store, print, and manipulate data
    2. buttons that can be used to perform frequent tasks more quickly than using the menu bar
    3. arrows and boxes that can be used to move the window around to view different parts of the worksheet
    4. a brief description of the selected command in a menu, the function of a button, or the activity in progress

8.An alternative method to using the mouse to select a cell is to use the __________ located just to the right of the typewriter keys on the keyboard.

    1. alphabetic keys
    2. function keys
    3. arrow keys
    4. special keys

9.Excel positions text __________ the cell.

    1. left-aligned, which means the text is positioned at the far left in
    2. right-aligned, which means the text is positioned at the far right in
    3. centered, which means the text is positioned in the middle of
    4. justified, which means the text is spread across the width of

10.  If a wrong letter is typed and the error is noticed before clicking the Enter box, use the __________ to erase all the characters back to and including the one that is wrong.

    1. enter key
    2. backspace key
    3. esc key
    4. delete key

11.  Excel’s AutoCorrect feature makes all the following corrections except __________.

    1. corrects two initial capital letters by changing the second letter to lowercase
    2. adds a final s or es to nouns that should be plural
    3. capitalizes the first letter in the names of the days
    4. replaces commonly misspelled words with their correct spelling

12.  Excel’s __________ provides a convenient means to add the numbers in a range of cells.

    1. MAX function
    2. AVERAGE function
    3. COUNT function
    4. SUM function

13.  A range can be entered by typing the beginning cell reference, a __________, and the ending cell reference.

    1. colon (:)
    2. hyphen (-)
    3. slash (/)
    4. tilde (~)

14.  Font size is measured in points; a single point is about __________ of one inch in height.

    1. 1/12
    2. 1/18
    3. 1/36
    4. 1/72

Note:         If you are preparing an examination using your own word processor, for Multiple Choice questions 15 through 17 you must use the Picture command on the Insert menu to insert FigE01.bmp. The figure is referenced when students answer the questions. When the Insert Picture dialog box displays, select FigE01.bmp from the Instructor’s Materials folder and make sure the Link to File check box is not checked.

15.  In the AutoFormat dialog box shown in the accompanying figure, the __________ terminates current activity without making any changes.

    1. Close button or Cancel button
    2. Question Mark button
    3. OK button
    4. Options button

16.  In the AutoFormat dialog box shown in the accompanying figure, the __________ can be used to obtain Help on any box or button located in the dialog box.

    1. Close button or Cancel button
    2. Question Mark button
    3. OK button
    4. Options button

17.  In the AutoFormat dialog box shown in the accompanying figure, the __________ allows additional formats to be assigned as part of the selected customized format.

    1. Close button or Cancel button
    2. Question Mark button
    3. OK button
    4. Options button

18.  To select any cell, click the __________ located on the left side of the formula bar and enter the cell reference of the desired cell.

    1. AutoSum area
    2. Name box
    3. AutoCalculate area
    4. Scroll box

19.  The small __________ at the corners and sides along the selection rectangle indicate a chart is selected.

    1. sizing handles
    2. sheet tabs
    3. block arrows
    4. table formats

20.  The __________ identifies each bar in a chart.

    1. title
    2. x-axis
    3. legend
    4. y-axis

21.  When a file is saved, Excel automatically appends the extension __________ to the entered file name, which stands for Excel workbook.

    1. .exc
    2. .wbk
    3. .exw
    4. .xls

22.  The __________, on the left of the Save As dialog box, displays a list of shortcuts (pointers) to the most recently used files in a folder titled Recent.

    1. Favorites button
    2. History button
    3. Desktop button
    4. Web Folders button

23.  A total, an average, or other information about numbers in a range easily can be obtained by using the __________ on the status bar.

    1. AutoSum area
    2. Name box
    3. AutoCalculate area
    4. scroll box

24.  The __________ not only deletes the contents from a range, but also copies the range to the Office Clipboard.

    1. Undo button or Undo command
    2. Cut button or Cut command
    3. Delete button or Delete command
    4. all of the above

25.  An unsaved workbook can be cleared by clicking the workbook’s Close button or by clicking Close on the __________ menu.

    1. File
    2. Edit
    3. Tools
    4. Data
True/False

T    F

26.  Web support allows Excel to save workbooks or parts of a workbook in HTML format so they can be viewed and manipulated using a browser.

T    F

27.  Inside an Excel workbook are sheets, called booksheets.

T    F

28.  A new Excel workbook opens with three worksheets, but, if necessary, additional worksheets can be added to a maximum of 255.

T    F

29.  A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.

T    F

30.  The menu bar, Standard toolbar, and Formatting toolbar display at the bottom of the screen just above the status bar.

T    F

31.  When a menu name on the menu bar is clicked, a short menu displays listing the most recently used commands.

T    F

32.  If the arrows at the bottom of a short menu are clicked, a full menu displays that lists all the commands associated with a menu.

T    F

33.  A hidden command displays in a faint type, which indicates it is not available for the current selection.

T    F

34.  A dimmed command does not display on the short menu.

T    F

35.  As data is typed, the data displays in the Name box, and Excel displays the active cell reference in the formula bar.

T    F

36.  Mode indicators, such as num (Num Lock), caps (Caps Lock), and scrl (Scroll) show which keys are engaged.

T    F

37.  When the mode indicator reads Ready, Excel is ready to accept the next command or data entry.

T    F

38.  When the mode indicator reads Enter, Excel is in the process of accepting data through the keyboard into the active cell.

T    F

39.  Keyboard indicators, such as Enter and Ready, display on the status bar and specify the current mode.

T    F

40.  In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered text.

T    F

41.  The insertion point is a blinking vertical line that indicates where the next character typed will display.

T    F

42.  Clicking the Enter box completes an entry, and clicking the Cancel box cancels the entry.

T    F

43.  When the text entered is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the left as long as these adjacent cells contain data.

T    F

44.  When an arrow key is pressed to complete an entry in a cell, the adjacent cell in the direction of the arrow (up, down, left, or right) becomes the active cell.

T    F

45.  Numbers can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e.

T    F

46.  Numbers entered into a worksheet are right-aligned, which means Excel displays the cell entry to the far right in the cell.

T    F

47.  When proposing a range of cells to sum, Excel first looks for a range of cells with numbers below the active cell and then to the right.

T    F

48.  The range of cells receiving a copy is called the copy area.

T    F

49.  The cell being copied is called the paste area.

T    F

50.  If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the AutoSum button is clicked.

T    F

51.  A worksheet is formatted to emphasize entries and make the worksheet easier to read and understand.

T    F

52.  The font type indicates how characters are formatted, such as regular, underlined, or italicized.

T    F

53.  A character with a point size of 10 is about 10/72 of one inch in height.

T    F

54.  Font style defines the appearance and shape of letters, numbers, and special characters.

T    F

55.  When Excel begins, the preset font type for the entire workbook is Arial with a size and style of 10-point regular.

T    F

56.  You bold an entry in a cell to camouflage it or make it blend into the rest of the worksheet.

T    F

57.  When the Merge and Center button is clicked to center a worksheet title across the range A1:F1, Excel not only centers the title but also merges cells A1 through F1 into one cell, cell A1.

T    F

58.  Most formats assigned to a cell will display on the Standard toolbar when the cell is selected.

T    F

59.  Excel derives the scale along the vertical axis (also called the y-axis or value axis) of a Column chart on the basis of the values in the worksheet.

T    F

60.  Excel automatically selects the entries in the topmost row of a selected range as the titles for the horizontal axis (x-axis or category axis) of a Column chart and draws a column for each cell in the range containing numbers.

T    F

61.  When Excel is installed on a computer, the default chart type, or the type of chart Excel draws if the Finish button is clicked in the first Chart Wizard dialog box, is the 3-D (three-dimensional) Pie chart.

T    F

62.  If the computer is turned off or if power is lost while building a workbook, the computer stores the workbook in memory.

T    F

63.  In the list box that displays when the Tools button is clicked in the Save As dialog box, the General Options command allows a backup copy of the workbook to be saved, a password to be created to limit access to the workbook, and other functions to be carried out.

T    F

64.  Saving a backup workbook means that each time the workbook is saved, Excel copies the current version of the workbook on disk to a file with the same name, but with the words, Backup of, appended to the front of the file name.

T    F

65.  Case sensitive means that Excel cannot differentiate between uppercase and lowercase letters.

T    F

66.  If a print area is not selected, Excel automatically selects a print area on the basis of used cells.

T    F

67.  The Close button and Control-menu icon on the title bar close the workbook, and the Close button and Control-menu icon on the menu bar close Excel.

T    F

68.  If the entry in a cell is long and the errors are minor, Edit mode may be a better choice than selecting the cell and retyping the entire entry.

T    F

69.  To delete a character in a cell, move the insertion point to the right of the character to be deleted and then press the delete key, or place the insertion point to the left of the character to be deleted and then press the backspace key.

T    F

70.  In Insert mode, Excel overtypes the character to the right of the insertion point.

T    F

71.  In Overtype mode, as a character is typed, Excel inserts that character and moves all characters to the right of the typed character one position to the right.

T    F

72.  Excel provides the Undo command on the Edit menu and the Undo button on the Standard toolbar to repeat previous actions.

T    F

73.  The Redo button on the Standard toolbar and the Redo command on the Edit menu can be used to erase the most recent cell entry.

T    F

74.  Always press the spacebar to clear a cell.

T    F

75.  With the Office Assistant active, a question, word, or phrase can be typed in a text box and the Office Assistant provides immediate help on the subject.
Short Answer

76.  __________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.

Note:      If you are preparing an examination using your own word processor, for Short Answer questions 1317 through 1324 you must use the Picture command on the Insert menu to insert FigE02.bmp. The figure is referenced when students answer the questions. When the Insert Picture dialog box displays, select FigE02.bmp from the Instructor’s Materials folder and make sure the Link to File check box is not checked.

77.  As shown in the accompanying figure, when Excel starts it creates a new empty __________, called Book1, which is like a notebook.

78.  As shown in the accompanying figure, each worksheet name displays on a(n) __________ at the bottom of the workbook.

79.  As shown in the accompanying figure, a letter above the grid, called the __________, identifies each column.

80.  As shown in the accompanying figure, a number on the left side of the grid, called the __________, identifies each row.

81.  In the accompanying figure, cell A1 is designated the __________ and is the cell into which data can be entered.

82.  The horizontal and vertical lines on the worksheet shown in the accompanying figure are called __________.

83.  As shown in the accompanying figure, the mouse pointer displays as a(n) __________ whenever it is located in a cell on the worksheet.

84.  As shown in the accompanying figure, the portion of the worksheet displayed on the screen is viewed through a(n) __________.

85.  To the right of the sheet tabs at the bottom of the screen is the __________, which can be dragged to increase or decrease the view of the sheet tabs.

86.  The menu bar that displays when Excel is started is the __________.

87.  When working with a chart sheet rather than a worksheet, the __________ displays with names that reflect charting commands.

88.  When the mouse pointer is moved over a toolbar button or box, the name of the button or box displays below it in a(n) __________.

89.  The easiest way to __________ (make it active) is to use the mouse to move the block plus sign to the cell and then click.

90.  The __________ is an Excel feature that works behind the scenes, correcting common mistakes when a text entry is completed in a cell.

91.  The __________ on the Standard toolbar can be used to enter the SUM function.

92.  A(n) __________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

93.  When cell references are copied and adjusted for each new position, each adjusted cell reference is called a(n) __________.

94.  The __________ is the small black square located in the lower-right corner of the heavy border around the active cell.

95.  The heavy border and transparent (blue) background indicating a selected range is called __________.

96.  The __________ specifies the size of the characters on the screen.

97.  Excel has several customized format styles called __________.

98.  The __________ on the Format menu can be used to format the body of a worksheet automatically.

99.  A 3-D Column chart drawn on the same worksheet as the data is called a(n) __________.

100.With the range to chart selected, the __________ on the Standard toolbar is clicked to initiate drawing the chart.

101. The area on a worksheet where a chart displays is called the __________.

102. A saved workbook is referred to as a(n) __________.

103. The General Options command in the Tools list can be used to assign a(n) __________ to a workbook so others cannot open it.

104. A printed version of a worksheet is called a(n) __________.

105.When columns and rows in a worksheet are selected prior to clicking the Print button, the range of cells chosen to print is called the __________.

106. An editing procedure called __________ is used to edit the contents directly in a cell.

107. The __________ next to the column headings can be used to select the entire worksheet.

108. At any time while using Excel, answers to questions can be obtained by using the __________.

109. The __________ answers questions and suggests more efficient ways to complete a task.

110. The Office Assistant tip feature is part of the __________ that is built into Excel, which understands what a user is trying to do and suggests better ways to do it.