Excel Basics 101

10 Questions | Total Attempts: 105

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

This quiz is to enforce Excel fundamentals


Questions and Answers
  • 1. 
    If you want to add only A1 and D1 cells together, which answer is the best answer?  (Choose all that apply)
    • A. 

      =A1+D1

    • B. 

      =sum(A1+D1)

    • C. 

      =sum(A1:D1)

    • D. 

      Sum(A1+D1)

  • 2. 
    If you want to add the range of cells A1 through D1 cells together, which answer is the best answer?  (Choose all that apply)
    • A. 

      =A1:D1

    • B. 

      =sum(A1+D1)

    • C. 

      =sum(A1:D1)

    • D. 

      Sum(A1:D1)

  • 3. 
    If you want to add only A1 and B1 cells together and then subtract D1, which answer is the best answer?  (Choose all that apply)
    • A. 

      =sum(A1+B1)D1

    • B. 

      =sum(A1+B1)-D1

    • C. 

      =(A1+B1)-D1

    • D. 

      Sum(A1+B1)-D1

  • 4. 
    If you want to add A1 and B1 cells together and then subtract the sum of C1 and D1, which answer is the best answer?  (Choose all that apply)
    • A. 

      Sum(A1+B1)-(C1+D1)

    • B. 

      =(A1+B1)-(C1-D1)

    • C. 

      =(A1+B1)-(C1+D1)

    • D. 

      =sum(A1+B1)-(C1+D1)

  • 5. 
    The only time you need to use the sum function is when you want to add a range of cells?
    • A. 

      True

    • B. 

      False

  • 6. 
    What are the things you want to do when you sort data?  Choose all that apply
    • A. 

      Make sure you select all of your data

    • B. 

      Create a column with sequential numbers

    • C. 

      Select only the column of data that you want to sort

  • 7. 
    If you want to format a cell for Money with change, how do you do that?  Choose all that apply
    • A. 

      Right Click on cell, Click Format and change the format to Number with 2 decimal

    • B. 

      Right Click on cell, Click Format and change the format to Currency with 2 decimal

    • C. 

      Select all of the cells that you want to format and click the $ button in the toolbar

    • D. 

      Right Click on cell, Click Format and change the format to General

  • 8. 
    What does CSV stand for?
    • A. 

      Common Separated Values

    • B. 

      Comma Separated Values

    • C. 

      Colon Separated Values

    • D. 

      Colin K's SuperBowl 48 Victory