Excel Ch 3 SG

Document Sample
Excel Ch 3 SG Powered By Docstoc
					Computer Applications - Study Guide Excel Ch. 3

Multiple Choice
Identify the choice that best completes the statement or answers the question.

____    1. Cell references in a formula are called _____.
           a. assumptions                                   c. numbers
           b. values                                        d. content
____    2. When you set up a worksheet, you should use cell references in formulas whenever possible, rather than
           _____ values.
           a. logical                                       c. consistent
           b. constant                                      d. calculated
____    3. You can ensure correctness in your formulas by carefully checking them using _____.
           a. Range Finder                                  c. the requirements document
           b. the Ribbon                                    d. Backstage view
____    4. Which of the following is a suggested decision to make when you plan a workbook?
           a. determine how to manipulate the               c. determine what to add to the requirements
               worksheets                                      document
           b. determine the necessary functions and         d. determine whether to use the Format
               formulas needed                                 Painter button
____    5. With a solid understanding of the requirements document, an understanding of the necessary decisions, and a
           sketch of the worksheet, the next step is to _____.
           a. use Excel to create the worksheet             c. perform calculations
           b. design the 3-D Pie chart                      d. create the 3-D Pie chart
____    6. _____ text often provides a strong visual appeal.
           a. Underlined                                    c. Large
           b. Tiny                                          d. Rotated
____    7. To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells _____.
           a. button                                        c. option button
           b. check box                                     d. Dialog Box Launcher
____    8. When you first enter text, its angle is _____ degrees, and it reads from left to right in a cell, as shown in the
           accompanying figure.
           a. 45                                            c. 0
           b. 90                                            d. 125
____    9. The _____ Auto Fill Option that fills the destination area using the format of the source area; no content is
           filled.
           a. Copy Cells                                    c. Fill Without Formatting
           b. Fill Formatting Only                          d. none of the above
____   10. Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
           a. Quarter 1                                     c. Qtr2
           b. Qtr1                                          d. Quarter4
____   11. Which of the following patterns extends the fill series to 575, 550, 525?
           a. 650, 600                                      c. 560, 580
           b. 625, 600                                      d. 500, 475
____   12. Which of the following is an extension of the fill pattern Sunday, Tuesday?
           a. Wednesday, Thursday, Saturday                 c. Saturday, Sunday, Monday
           b. Thursday, Saturday, Monday                    d. Monday, Wednesday, Friday
____ 13. In the accompanying figure, the split double arrow mouse pointer _____.
         a. indicates a hidden column                      c. is the result of moving the mouse pointer
                                                               to the boundary between column heading
                                                               A and column heading B
         b. allows text to be entered at that location     d. indicates the proposed width of column A
____ 14. Which of the following is the path to the Increase or Decrease Indent button?
         a. (Home tab | Clipboard group)                   c. (Home tab | Alignment group)
         b. (Home tab | Editing group)                     d. (Home tab | Number group)
____ 15. The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
         a. three                                          c. two
         b. four                                           d. five
____ 16. The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the
         computer’s memory.
         a. Ribbon                                         c. Folder
         b. Clipboard                                      d. File
____ 17. Pressing the _____ key(s) removes the marquee from the source area.
         a. TAB                                            c. CTRL+V
         b. CTRL+X                                         d. ESC
____ 18. An alternative to clicking the Paste button is to press the _____ key.
         a. ENTER                                          c. CTRL
         b. ALT                                            d. SHIFT
____ 19. Using the mouse to move or copy cells is called _____.
         a. drop and drag                                  c. drag and copy
           b. drag and drop                                   d. drag and paste
____ 20.   Which of the following is the path to the Insert button?
           a. (Home tab | Editing group)                      c. (Home tab | Cells group)
           b. (Home tab | Number group)                       d. (Home tab | Inserting group)
____ 21.   Which of the following is not a valid format symbol?
           a. semi-colon (;)                                  c. dollar sign ($)
           b. percent sign (%)                                d. comma (,)
____ 22.   If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell
           references but instead displays the _____ error message.
           a. #NULL!                                          c. #N/A
           b. #DIV/0!                                         d. #REF!
____ 23.   When assigned to a cell, the _____ function returns a number that corresponds to the system date and time
           beginning with December 31, 1899.
           a. SYSDATE                                         c. DATETIME
           b. NOW                                             d. CURRENT
____ 24.   Which of the following formulas contains an absolute cell reference?
           a. =$B4                                            c. =$B$4
           b. =B$4                                            d. =B4
____ 25.   The _____ function is useful when you want to assign a value to a cell based on a logical test.
           a. IF                                              c. AND
           b. NOW                                             d. OR
____ 26.   Which comparison operator means “not equal to”?
           a. <=                                              c. <
           b. >                                               d. <>
____ 27.   _____ refers to cells not wide enough to display the entire entry.
           a. #####                                           c. $$$$$
           b. &&&&&                                           d. +++++
____ 28.   Error messages begin with the _____ symbol.
           a. ?                                               c. !
           b. =                                               d. #
____ 29.   A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF
           function.
           a. included                                        c. nested
           b. other                                           d. duplicate
____ 30.   A(n) _____ chart provides a simple way to show trends and variations in a range of data within a single cell.
           a. Sparkie                                         c. Special
           b. Sparkline                                       d. Sparkle
____ 31.   You can press the _____ keys to open the Format Cells dialog box.
           a. CTRL+1                                          c. CTRL+3
           b. CTRL+2                                          d. CTRL+4
____ 32.   The path to the Format Painter button is _____.
           a. (Home tab | Number group)                       c. (Home tab | Painting group)
           b. (Home tab | Clipboard group)                    d. (Home tab | Font group)
____ 33.   _____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the
           ranges.
           a. Click                                           c. Double-click
           b. Press                                           d. Triple-click
____ 34.   You should use a _____ chart to show the relationship or proportion of parts to a whole.
            a. Column                                         c. Line
            b. Bar                                            d. Pie
____ 35.    A(n) _____ is a separate sheet in a workbook that contains only a chart.
            a. worksheet                                      c. chart sheet
            b. dialog box                                     d. range
____ 36.    A Pie chart with one of more slices offset is called a(n) _____.
            a. maximized Pie chart                            c. imploded Pie chart
            b. exploded Pie chart                             d. moving Pie chart
____ 37.    Which of the following is the path to the Zoom button?
            a. (View tab | Zoom group)                        c. (Insert tab | Zoom group)
            b. (Home tab | Zoom group)                        d. (Zoom tab | View group)
____ 38.    When working with a large worksheet, you can split the window into _____ panes.
            a. three or four                                  c. two or six
            b. four or five                                   d. two or four
____ 39.    Which of the following is the path to the Goal Seek button?
            a. (Insert tab | Goal Seek group)                 c. (Data tab | Data Tools group)
            b. (Home tab | Data Tools group)                  d. (Analyses tab | Goal Seeking group)
____ 40.    _____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a
            specific goal for another cell.
            a. Goal                                           c. Option
            b. Formula                                        d. Function


True/False
Indicate whether the statement is true or false.

____ 41. Studies have shown that more than 25 percent of all business worksheets have errors.
____ 42. Rotated text also allows you to fit more text into a smaller column width.
____ 43. The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.
____ 44. In the accompanying figure, worksheet titles are frozen above and to the left of cell B13.
____ 45. A date stamp shows the date a workbook, report, or other document was created or the period it represents.
____ 46. In the accompanying figure, the formula in cell B14 contains an absolute reference.
____ 47. The <= comparison operator means less than or equal to.
____ 48. The path to the Logical button is (Formulas tab | Function Library group).
____ 49. If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by
         pressing CTRL+HOME.
____ 50. A nested IF function is one in which the action to be taken for the true or false case includes yet another IF
         function.
____ 51. The NETWORKDAYS function checks a formula for correctness.
____ 52. You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic
         becomes difficult to follow.
____ 53. Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.
____ 54. Many Ribbon commands, galleries, and shortcut keys function as toggles or switches.
____ 55. You can select nonadjacent ranges using the SHIFT key.
____ 56. The range of entries that determines the size of the slices in a Pie chart is called the category names.
____ 57. When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing
         the name of the item.
____ 58. If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it,
         leaving the remaining slices unexploded.
____ 59. Changing the order of sheets in a workbook allows you to position the most important worksheets first.
____ 60. When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more
         rows and columns.
Computer Applications - Study Guide Excel Ch. 3
Answer Section

MULTIPLE CHOICE

      1.   ANS:   A      PTS:   1         REF:    EX 138
      2.   ANS:   B      PTS:   1         REF:    EX 138
      3.   ANS:   A      PTS:   1         REF:    EX 140
      4.   ANS:   B      PTS:   1         REF:    EX 141
      5.   ANS:   A      PTS:   1         REF:    EX 143
      6.   ANS:   D      PTS:   1         REF:    EX 144
      7.   ANS:   D      PTS:   1         REF:    EX 145
      8.   ANS:   C      PTS:   1         REF:    EX 145
      9.   ANS:   B      PTS:   1         REF:    EX 148
     10.   ANS:   C      PTS:   1         REF:    EX 149
     11.   ANS:   B      PTS:   1         REF:    EX 149
     12.   ANS:   B      PTS:   1         REF:    EX 149
     13.   ANS:   C      PTS:   1         REF:    EX 149
     14.   ANS:   C      PTS:   1         REF:    EX 150
     15.   ANS:   A      PTS:   1         REF:    EX 150
     16.   ANS:   B      PTS:   1         REF:    EX 151
     17.   ANS:   D      PTS:   1         REF:    EX 152
     18.   ANS:   A      PTS:   1         REF:    EX 153
     19.   ANS:   B      PTS:   1         REF:    EX 153
     20.   ANS:   C      PTS:   1         REF:    EX 156
     21.   ANS:   A      PTS:   1         REF:    EX 156
     22.   ANS:   D      PTS:   1         REF:    EX 156
     23.   ANS:   B      PTS:   1         REF:    EX 159
     24.   ANS:   C      PTS:   1         REF:    EX 162
     25.   ANS:   A      PTS:   1         REF:    EX 164
     26.   ANS:   D      PTS:   1         REF:    EX 165
     27.   ANS:   A      PTS:   1         REF:    EX 169
     28.   ANS:   D      PTS:   1         REF:    EX 169
     29.   ANS:   C      PTS:   1         REF:    EX 170
     30.   ANS:   B      PTS:   1         REF:    EX 170
     31.   ANS:   A      PTS:   1         REF:    EX 176
     32.   ANS:   B      PTS:   1         REF:    EX 178
     33.   ANS:   C      PTS:   1         REF:    EX 179
     34.   ANS:   D      PTS:   1         REF:    EX 180
     35.   ANS:   C      PTS:   1         REF:    EX 181
     36.   ANS:   B      PTS:   1         REF:    EX 181
     37.   ANS:   A      PTS:   1         REF:    EX 196
     38.   ANS:   D      PTS:   1         REF:    EX 198
     39.   ANS:   C      PTS:   1         REF:    EX 200
     40.   ANS:   A      PTS:   1         REF:    EX 202
TRUE/FALSE

    41.   ANS:   T   PTS:   1   REF:   EX 140
    42.   ANS:   T   PTS:   1   REF:   EX 144
    43.   ANS:   T   PTS:   1   REF:   EX 150
    44.   ANS:   T   PTS:   1   REF:   EX 158
    45.   ANS:   T   PTS:   1   REF:   EX 159
    46.   ANS:   T   PTS:   1   REF:   EX 163
    47.   ANS:   T   PTS:   1   REF:   EX 165
    48.   ANS:   T   PTS:   1   REF:   EX 166
    49.   ANS:   T   PTS:   1   REF:   EX 169
    50.   ANS:   T   PTS:   1   REF:   EX 170
    51.   ANS:   F   PTS:   1   REF:   EX 170|EX 177
    52.   ANS:   T   PTS:   1   REF:   EX 170
    53.   ANS:   F   PTS:   1   REF:   EX 170
    54.   ANS:   T   PTS:   1   REF:   EX 177
    55.   ANS:   F   PTS:   1   REF:   EX 180
    56.   ANS:   F   PTS:   1   REF:   EX 181
    57.   ANS:   T   PTS:   1   REF:   EX 181
    58.   ANS:   F   PTS:   1   REF:   EX 192
    59.   ANS:   T   PTS:   1   REF:   EX 194
    60.   ANS:   F   PTS:   1   REF:   EX 196

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7679
posted:9/29/2012
language:English
pages:9