CGS1060.txt

Card Set Information

Author:
aly2490
ID:
142401
Filename:
CGS1060.txt
Updated:
2012-04-19 12:45:30
Tags:
EXCEL
Folders:

Description:
2nd Exam
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user aly2490 on FreezingBlue Flashcards. What would you like to do?


  1. The first step in creating an effective worksheet is to make sure you_______
    A) apply font formatting
    B) insert a chart
    C) enter the data
    D) understand what is required
    D) understand what is required
    (this multiple choice question has been scrambled)
  2. ____is/are used to add worksheet, column, and row titles on a worksheet
    A) color
    B) text
    C) links
    D) tabs
    B) text
    (this multiple choice question has been scrambled)
  3. To cancel an entire entry before entering it into the cell, press the _____ key.
    A) TAB
    B) CTRL
    C) ALT
    D) ESC
    D) ESC
    (this multiple choice question has been scrambled)
  4. Clicking the ______ box completes an entry
    A) cancel
    B) formula
    C) enter
    D) tab
    C) enter
    (this multiple choice question has been scrambled)
  5. The ___ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
    A) auto-format
    B) autocomplete
    C) autocorrect
    D) auto-typing
    C) autocorrect
    (this multiple choice question has been scrambled)
  6. Pressing the ____ key to complete an entry activates the adjacent cell to the right
    A) left arrow
    B) down arrow
    C) right arrow
    D) up arrow
    C) right arrow
    (this multiple choice question has been scrambled)
  7. In excel, a number can contain the characters ____
    D) all of above
  8. To enter a number such as 6,000,000,000,000,000, you can type the whole number or
    D) 6E15
  9. A____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure
    A) nearby cell
    B) range
    C) bunch
    D) neighbor
    B) range
    (this multiple choice question has been scrambled)
  10. You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____
    Colon (:)
  11. To enter a number as text, precede it with a (n) ____.
    A) apostrophe
    B) plus(+)
    C) quotation mark
    D) colon
    A) apostrophe
    (this multiple choice question has been scrambled)
  12. The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the___.
    A) final cell
    B) receiver cell
    C) destination area(or paste area)
    D) receiving range
    C) destination area(or paste area)
    (this multiple choice question has been scrambled)
  13. You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand
    A) save
    B) format
    C) print
    D) clear
    B) format
    (this multiple choice question has been scrambled)
  14. In general, use no more than ___ font types in a worksheet.
    A) eight
    B) four
    C) two
    D) six
    C) two
    (this multiple choice question has been scrambled)
  15. Combining two or more selected cells into one cell is called _____ cells
    A) mixing
    B) merging
    C) combining
    D) spanning
    B) merging
    (this multiple choice question has been scrambled)
  16. Which of the following is the ribbon path to the cell styles button?
    A) home tab| styles groups
  17. How many chart types does Excel offer?
    • A) 5
    • B) 11
    • C) 29
    • D) 50
  18. In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet
    A) color code
    B) explanation
    C) identifier
    D) legend
    D) legend
    (this multiple choice question has been scrambled)
  19. The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet
    A) autoCalculate
    B) auto function
    C) auto-format
    D) autocomplete
    A) autoCalculate
    (this multiple choice question has been scrambled)
  20. The___ button is located on the quick Access Toolbar, as shown un the accompanying figure.
    A) Increase Decimal
    B) Cell Style
    C) Bold
    D) Undo
    D) Undo
    (this multiple choice question has been scrambled)
  21. Worksheet titles and subtitles should be as wordy as possible.
    False
  22. Both the cancel box and the Enter box appear on the formula bar when you begin typing in a cell.
    True
  23. The AutoCorrect feature can automatically capitalize the first letter in the names of days.
    True
  24. The text is longer than the wodth of a column, Excel displays the overflow characters in adjacent cells to the right.
    True
  25. Excel recognizes the following as text
    401AX21,921-281,619 628, 883XTY
    True
  26. 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 SUM button is clicked
    True
  27. A single point is about 1/32 of one inch height
    False
  28. Excel can display characters in only three font colors: black, red and blue.
    False
  29. A character with a point size of 10 is about 10/72 of one inch in height.
    True
  30. You can turn off the Bold formatting for selected text by clicking the Bold Off(Home Tab|Font group)
    False
  31. You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position
    True
  32. To use the AutoCalculate area, select the range of ells containing the numbers flr a calculation you want to verify and then double click the AutoCalculate area to display the Customize Status Bar shortcut menu.
    False
  33. With Excel in Edit mode, you can edit cell contents directly in the cell
    True
  34. You can press the RIGHT ARROW of LEFT ARROW keys to position the insertion point during in cell editing.
    True
  35. To clear the entire worksheet, click the clear All Button on the worksheet
    False
  36. You can clear cell contests and formatting by clicking Clear Contents on the Clear button menu.
    False
  37. You should press the Spacebar to clear a cell.
    False
  38. Careful ________ can reduce your effort significantly and result in a worksheet that is accurate , easy to read, flexible, and useful.
    Planning
  39. The easiest way to select a cell is to move the block plus sign ____ to a cell and then click
    Mouse pointer
  40. Worksheet ____ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet
    Columns
  41. While typing in a cell, you can press the _____ key to delete all the characters back to and including the incorrect character you just typed
    Backspace
  42. As you type, Excel displays the entry in the _____ and also displays the Cancel box and the Enter box on the formula bar
    Formula bar
  43. If the next entry you want to make is in the adjacent cell, use the ______ keys to complete the entry in the current cell and activate the adjacent cell.
    Arrow
  44. Excel's _____, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total
    SUM function
  45. The default font for a new workbook is _______ 11-point regular black.
    Calibri
  46. _________ cell involves creating a single cell by combining two or more selected cells
    Merging
  47. A(n) ______ chart often is used to illustrate changes in data over time
    Line
  48. To start a new line in a cell, press the ____ keys.
    A) SHIFT+ENTER
    B) TAB+ENTER
    C) ALT+ENTER
    D) CTRL+ENTER
    C) ALT+ENTER
    (this multiple choice question has been scrambled)
  49. All of the following are valid Excel arithmetic operators exepct_____.
    A) %
    B) >
    C) ^
    D) *
    B) >
    (this multiple choice question has been scrambled)
  50. Which of the following calculations multiplies 23 by 0.01?
    A) =23+.01
    B) =24-.01
    C) =23
    D) =23%
    D) 23%
    (this multiple choice question has been scrambled)
  51. When Excel follows the order of operations, the formula 8*3+2 equals_____.
    B) 26
  52. Which of the following happens when you enter the formula =G15 into a cell?
    Excel assigns the value in cell G15 to the active cell.
  53. The _____ option button lists formatting options following an insertion of cells, rows, or columns .
    A) Insert
    B) Paste
    C) AutoCorrect
    D) AutoFill
    A) Insert
    (this multiple choice question has been scrambled)
  54. A_____ cell in Excel has a numerical value of zero
    A) copied
    B) blank
    C) filled
    D) formatted
    B) blank
    (this multiple choice question has been scrambled)
  55. The____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
    A) equal
    B) formula
    C) calculate
    D) function
    B) formula
    (this multiple choice question has been scrambled)
  56. Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
    A) left parenthesis
    B) left bracket
    C) right parenthesis
    D) right bracket
    C) right parenthesis
    (this multiple choice question has been scrambled)
  57. Which of the following is the path to the Sum button?
    B) (Home tab| Editing group)
  58. You should _____ a function nMe in the Formula AutoComplete list to select the function.
    A) click
    B) right click
    C) double click
    D) none of above
    C) double click
    (this multiple choice question has been scrambled)
  59. Clicking the ____ opens the Insert Function dialog box shown in the figure.
    A) Insert function box or formula bar
  60. The _____ function determines the lowest number in range.
    A) MIN
    B) AVERAGE
    C) SUM
    D) MAX
    A) MIN
    (this multiple choice question has been scrambled)
  61. A_____ is a predefines set of colors, fonts, chart styles, cell styles and fill effects
    C) theme
  62. You can open the Format Cells dialog box by pressing the ___ keys.
    A) alt+1
    B) shift+F1
    C) shift+tab
    D) Ctrl+1
    D) Ctrl+1
    (this multiple choice question has been scrambled)
  63. The ______ displays numbers with a fixed dollar sign to the left of the number, a comma every thre positions to the left of the decimal point, and displays numbers to the nearest cent.
    A) accounting number format
    B) currency style format
    C) comma style formal
    D) percent style format
    A) accounting number format
    (this multiple choice question has been scrambled)
  64. Te ranges E4:14 and F13:113 are formatted with a ___ dollar sign.
    A) formatted
    B) floating
    C) fixed
    D) none of above
    C) fixed
    (this multiple choice question has been scrambled)
  65. Which if the following is the path to the Comma Style button?
    D) (Home Tab |Number group)
  66. Which of the following is the path to the Conditional Formatting burrin?
    D) (Home tab| Styles Group)
  67. When you decrease the row height to _____, the row is hidden.
    A) 2
    B) 3
    C) 1
    D) 0
    D) 0
    (this multiple choice question has been scrambled)
  68. An asterisk (*) following a cell reference un a formula is the arithmetic operator that directs Excel to perform the division operation
    False
  69. Pressing the F9 Key instructs eExcel to recalculate all formulas
    True
  70. The arithmetic operator ^, directs Excel to perform the division operation
    False
  71. As in Algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations
    False
  72. The insert options button lists formatting options.
    True
  73. You can use the arrow keys to complete an entry in Point mode
    False
  74. Clicking the Insert Function box opens the Function Arguments dialog box
    False
  75. The Sum button menu allows you to enter one of five often-used functions easily into. Cell
    True
  76. Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data
    True
  77. To use Range Finder to veriffy that the formula contains te intended cell references click cell in the formula you want to check
    False
  78. To use of a fill color in a cell or range of cells sets off the cell range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range
    True
  79. When you click the Decrease Font Size button, Excel assigns the next highest font size in the font size gallery
    False
  80. You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box
    True
  81. A floating dollar sign appears immediately to the left of the first digit in a dollar value with in spaces
    True
  82. You can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear
    True
  83. Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting
    True
  84. Best fit means that the width of the column will be increased or decreased by a percentage you specify
    False
  85. Worksheet______ typically contain items analogous to items in a list
    Rows
  86. If you have a long text entry, such as a paragraph, you can instruct Excel to ______ text in the cell.
    Wrap
  87. One of the reasons Excel is such a valuable tool is that you can assign a (n) _______ to a cell, and Excel will calculate the result
    Formula
  88. The / arithmetic operator_____
    Division
  89. In the order of operations, the last operation Excel performs is ________
    • Subtraction
    • Addition
  90. You can press the _____ key to quit Range Fknder
    ESC
  91. A(n) ______ is a dot on the screen that contains a color
    Pixel
  92. To set row height to best fit,______ the bottom boundary of the row heading.
    Double click
  93. Excel included a (n) ______ you can use to check a worksheet fir spelling errors
    Spell checker
  94. Always take time to check the ______ of a worksheet before submitting it to your supervisor
    Formulas

What would you like to do?

Home > Flashcards > Print Preview