BHS Excel Final Test

by: mburgess
  1. 1

    The formula =B4/3 will multiply the value in B4 by 3.

  2. 2

    Excel recognizes the contents of a cell as a formula when a quotation mark is the first character in a cell.

  3. 3

    Formulas are equations that calculate a value.

  4. 4

    Justified text moves text to a new line when it is longer than the width of a cell.

  5. 5

    A selected group of cells is a table.

  6. 6

    Excel allows you to boldface, italicize, or underline the contents of a cell.

  7. 7

    You can place borders on all sides of a cell.

  8. 8

    You can print a worksheet by choosing Print on the _______ menu and clicking OK.

  9. 9

    Which command copies data into adjacent cells?

  10. 10

    Which command will keep row or column titles on the screen?

  11. 11

    The intersection of a row and column is a

  12. 12

    Which of the following may be contained in worksheet cells?

  13. 13

    A __________________ is a grid of rows and columns containing numbers, text, and formulas.

  14. 14

    Begins the text at the right side of the cell.

  15. 15

    Displays text at an angle.

  16. 16

    Begins a new line within the cell.

  17. 17

    To let Excel determine the best width of a column, place the highlight in the cell, choose Column on the Format menu, and then choose __________ on the submenu.

  18. 18

    The function Maximum finds the sum of all the numbers in one column.

  19. 19

    A cell ____________ is a message that explains or identifies information contained in a cell.

  20. 20

    __________________ functions are used to analyze loans and investments.

  21. 21

    Which of the following displays the smallest number contained in the range A4:E4?

  22. 22

    A relative cell reference does not change when moved or copied to a new cell.

  23. 23

    Format _____________ allows you to copy the format of a worksheet cell without copying the contents of the cell.

  24. 24

    Once you have entered data into a cell, you cannot change or edit it in any way.

  25. 25

    Data copied into a cell will replace data already in the cell.

© 2019 Polarity Technologies

Invite Next Author

Write a short message (optional)

or via Email

Enter Quibblo Username


Report This Content