Excel Test 1

45 Questions | Total Attempts: 177

Settings
Please wait...
Excel Test 1

Answer the following:


Questions and Answers
  • 1. 
     
    • A. 

      Tool bar

    • B. 

      Menu bar

    • C. 

      Instruction bar

  • 2. 
    • A. 

      Title bar

    • B. 

      Menu bar

    • C. 

      Tool bar

  • 3. 
    This is an example of ____________________________ headings.
  • 4. 
    Each row is named by a ____________.
  • 5. 
    A cell is an intersection of a column and row.
    • A. 

      True

    • B. 

      False

  • 6. 
    A Workbook defaults to three worksheets. A Workbook must contain at least two worksheets.
    • A. 

      True

    • B. 

      False

  • 7. 
    • Each Excel worksheet is made up of columns and rows.
  • A. 

    True

  • B. 

    False

  • 8. 
    The ___________ cell, or the cell that can be acted upon, reveals a dark border.
    • A. 

      Formula

    • B. 

      Live

    • C. 

      Active

  • 9. 
    The following cell is named_____________
    • A. 

      C3

    • B. 

      3C

    • C. 

      C-#3

  • 10. 
    • A darkened border, called the cell pointer, identifies it.
    • A. 

      True

    • B. 

      False

  • 11. 
    The _______ menu contains all the operations that we will discuss in this lesson: New, Open, Close, Save and Save As.
    • A. 

      File

    • B. 

      Save

    • C. 

      Title

  • 12. 
    Used when to save a new file for the first time or save an existing file with a different name.
    • A. 

      Save

    • B. 

      Open

    • C. 

      Save as

  • 13. 
    Used to open an existing file from a floppy disk or hard drive of your computer.
    • A. 

      Save

    • B. 

      Open

    • C. 

      Save as

  • 14. 
    Every workbook created in Excel must be saved and assigned a name to distinguish it from other workbooks.
    • A. 

      True

    • B. 

      False

  • 15. 
    If you're saving the file for the first time and you do not choose a file name, Microsoft Excel will not assign a file name for you.
    • A. 

      True

    • B. 

      False

  • 16. 
    Excel's______________ feature keeps track of previously-entered text. If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you.
    • A. 

      Autofinish

    • B. 

      Autofill

    • C. 

      AutoComplete

  • 17. 
    • Double-click on the cell that contains the information to be changed.
    • A. 

      True

    • B. 

      False

  • 18. 
     
    • A. 

      Undo button

    • B. 

      Redo button

    • C. 

      Backspace button

  • 19. 
    • Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.
    • A. 

      To work in a range of cells

    • B. 

      To delete a range of cells

    • C. 

      To choose a range of cells

  • 20. 
    Click the gray Row heading to select the entire row.
    • A. 

      True

    • B. 

      False

  • 21. 
    Click the gray rectangle in the upper left corner to select half worksheet.
    • A. 

      True

    • B. 

      False

  • 22. 
    If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select, and hold down the _______ key while selecting other ranges.
    • A. 

      Control

    • B. 

      Shift

    • C. 

      Alt

  • 23. 
    Excel requires every formula to begin with an equal sign (=).
    • A. 

      True

    • B. 

      False

  • 24. 
    • Type the ____________ to let Excel know that an add operation is to be performed.
  • 25. 
    Formulas can be created by using either numbers or cell references in the definition.
    • A. 

      True

    • B. 

      False

  • 26. 
    To multiply two cells the formula, B2 and B3, you would need to insert a multiplication operator the letter "x" between them.
    • A. 

      True

    • B. 

      False

  • 27. 
    _________________________ formulas involve more than one mathematical operation.
  • 28. 
    In Excel, never do math "in your head" and type the answer in a cell where you would expect to have a formula calculate the answer.
    • A. 

      True

    • B. 

      False

  • 29. 
    (5-2)*3
    • A. 

      Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. perform multiplication first

    • B. 

      Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. perform parenthesis first

    • C. 

      Perform subtraction first

  • 30. 
    Press ________ or click the Enter button on the Formula bar. This step ends the formula.
    • A. 

      Enter

    • B. 

      Control

    • C. 

      Shift

  • 31. 
    The__________________ method allows you to copy a formula and fill it into many different consecutive cells at the same time.
    • A. 

      Auto formula

    • B. 

      Auto save

    • C. 

      Fill formula

  • 32. 
    You cannot use copy and paste to copy a formula to other cells.
    • A. 

      True

    • B. 

      False

  • 33. 
    Click the Copy button. Marching "ants" appear around the copied cell(s).
    • A. 

      True

    • B. 

      False

  • 34. 
    You can revise any formula that was previously written in a worksheet.
    • A. 

      True

    • B. 

      False

  • 35. 
    ___________ cell references in a formula always refer to the same cell or cell range in a formula.
    • A. 

      Absolute

    • B. 

      Auto complete

    • C. 

      Fill

  • 36. 
    Identifies the largest number in a range of cells.
    • A. 

      MIN

    • B. 

      SUM

    • C. 

      MAX

  • 37. 
    • A. 

      Auto Sum Buttton

    • B. 

      Auto Average Button

    • C. 

      Both

  • 38. 
    Sheet tabs can be renamed by simply double clicking on the them and typing in the new name.
    • A. 

      True

    • B. 

      False

  • 39. 
    You do not have the ability to insert new worksheets if needed or delete others you no longer want.
    • A. 

      True

    • B. 

      False

  • 40. 
    ____________ worksheets allows you to apply identical formulas and/or formatting across all the worksheets in the group.
    • A. 

      Bunching

    • B. 

      Grouping

    • C. 

      Auto Select

  • 41. 
    _____________________ (double headed arrow) can be used to change a column width.
    • A. 

      Adjustment tool

    • B. 

      Redo button

    • C. 

      Auto Fill Button

  • 42. 
    The default font in a spreadsheet is ____________ points
    • A. 

      Ariel 12

    • B. 

      Times New Roman 10

    • C. 

      Arial 10

  • 43. 
    • A. 

      Font Color

    • B. 

      Cell Fill Color

    • C. 

      Font Size

  • 44. 
    Bold, Italize, highlight
    • A. 

      True

    • B. 

      False

  • 45. 
    Use to add a border around a range of cell
    • A. 

      True

    • B. 

      False

  • Back to top