Unit 4 Lesson 3 Test

155 Responses | Created by mpool913 |
  1. 1

    The AutoSum feature may be used to add a long column of numbers. 288

  2. 2

    The plus sign (+) is an example of an operand in a worksheet formula. 284

  3. 3

    After you have keyed a formula, you can enter it by tapping the Esc key. 284

  4. 4

    When a formula that contains a relative cell reference is copied or moved, the cell references change, but operators remain the same. 286

  5. 5

    A formula has four parts. 284

  6. 6

    A cell reference identifies a worksheet cell by the column letter and row number. 286

  7. 7

    An example of a formula with an absolute cell reference is =A6-B5. 287

  8. 8

    A formula can be copied from a cell by opening the Edit menu and selecting Copy. 288

  9. 9

    Excel recognizes the contents of a cell as a formula when an equal sign (=) is the first character in the cell. 283

  10. 10

    The AutoSum button is located on the Standard toolbar. 288

  11. 11

    __ will be performed first in a formula that does not contain parentheses. 286

  12. 12

    A(n) __ cell reference does not change when it is moved or copied to a new cell. 287

  13. 13

    A(n) __ cell reference adjusts to its new location when copied or moved. 286

  14. 14

    Which operator represents the first order of operation? 286

  15. 15

    The __ function displays the number of cells with numerical values in the argument range. 289

  16. 16

    Excel has more than __ function formulas. 289

  17. 17

    __ calculation can be used to check formula results. 289

  18. 18

    The __ is a value, cell, range, or text that acts as an operand in a function formula. 290

  19. 19

    To create an absolute cell reference, you need to insert a(n) ___ before the column letter and/or row number of the cell reference you want to stay the same. 287

  20. 20

    Which operator represents division? 284

Similar Quizzes

Users Also Took

Rating

0 votes
Take this first to vote!

Add to Favorites

Tags

© 2012 Miva AK, Inc.