Basic Excel Knowledge Quiz

30 Questions

Settings
Please wait...
Excel Quizzes & Trivia

Take this basic Excel skills that will help when you are using functions and formulas in Excel.


Questions and Answers
  • 1. 
    Multiple calculations can be made in a single formula using…..
    • A. 

      Standard Formulas

    • B. 

      Array Formula

    • C. 

      Complex Formulas

    • D. 

      Smart Formula

  • 2. 
    Concatenation of text can be done using
    • A. 

      Apostrophe (‘)

    • B. 

      Exclamation (!)

    • C. 

      Hash (#)

    • D. 

      Ampersand (&)

  • 3. 
    A numeric value can be treated as label value if …… precedes it.
    • A. 

      Apostrophe (‘)

    • B. 

      Exclamation (!)

    • C. 

      Hash (#)

    • D. 

      Tilde (~)

  • 4. 
    Which of the following is not a valid data type in Excel?
    • A. 

      Number

    • B. 

      Character

    • C. 

      Label

    • D. 

      Date/Time

  • 5. 
    Getting data from a cell located in a different sheet is called….
    • A. 

      Accessing

    • B. 

      Referencing

    • C. 

      Updating

    • D. 

      Functioning

  • 6. 
    Which menu option can be used to split windows into two?
    • A. 

      Format -> Window

    • B. 

      View -> Window-> Split

    • C. 

      Window -> Split

    • D. 

      View –> Split

  • 7. 
    Comments can be added to cells using …..
    • A. 

      Edit -> Comments

    • B. 

      Insert -> Comment

    • C. 

      File -> Comments

    • D. 

      View –> Comments

  • 8. 
    Which elements of a worksheet can be protected from accidental modification?
    • A. 

      Contents

    • B. 

      Objects

    • C. 

      Scenarios

    • D. 

      All of the above

  • 9. 
    Comments put in cells are called …..
    • A. 

      Smart Tip

    • B. 

      Cell Tip

    • C. 

      Web Tip

    • D. 

      Soft Tip

  • 10. 
    Which area in an Excel window allows entering values and formulas?
    • A. 

      Title Bar

    • B. 

      Menu Bar

    • C. 

      Formula Bar

    • D. 

      Standard Tool Bar

  • 11. 
    Microsoft Excel is a powerful………..
    • A. 

      Word processing package

    • B. 

      Spreadsheet package

    • C. 

      Communication S/W Package

    • D. 

      DBMS package

  • 12. 
    Which function is not available in the Consolidate dialog box?
    • A. 

      Pmt

    • B. 

      Average

    • C. 

      Max

    • D. 

      Sum

  • 13. 
    To return the remainder after a number is divided by a divisor in EXCEL we use the function?
    • A. 

      ROUND ( )

    • B. 

      FACT ( )

    • C. 

      MOD ( )

    • D. 

      DIV ( )

  • 14. 
    In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
    • A. 

      AutoFill

    • B. 

      Auto correct

    • C. 

      Auto sum

    • D. 

      Auto format

  • 15. 
    MS-EXCEL is based on ……….?
    • A. 

      WINDOWS

    • B. 

      DOS

    • C. 

      UNIX

    • D. 

      OS/2

  • 16. 
    What do you mean by a Workspace?
    • A. 

      Group of Columns

    • B. 

      Group of Worksheets

    • C. 

      Group of Rows

    • D. 

      Group of Workbooks

  • 17. 
    An Excel Workbook is a collection of …….
    • A. 

      Workbooks

    • B. 

      Worksheets

    • C. 

      Charts

    • D. 

      Worksheets and Charts

  • 18. 
    Which is not the function of “Edit, Clear” command?
    • A. 

      Delete contents

    • B. 

      Delete notes

    • C. 

      Delete cells

    • D. 

      Delete formats

  • 19. 
    To select an entire column in MS-EXCEL, press?
    • A. 

      CTRL + C

    • B. 

      CTRL + Arrow key

    • C. 

      CTRL + S

    • D. 

      None of the above

  • 20. 
    How do you rearrange the data in ascending or descending order?
    • A. 

      Data, Sort

    • B. 

      Data, Form

    • C. 

      Data, Table

    • D. 

      Data Subtotals

  • 21. 
    What is the correct way to refer the cell A10 on sheet3 from sheet1?
    • A. 

      Sheet3!A10

    • B. 

      Sheet1!A10

    • C. 

      Sheet3.A10

    • D. 

      A10

  • 22. 
    Excel displays the current cell address in the ……….
    • A. 

      Formula bar

    • B. 

      Status Bar

    • C. 

      Name Box

    • D. 

      Title Bar

  • 23. 
    In the formula, which symbol specifies the fixed columns or rows?
    • A. 

      $

    • B. 

      *

    • C. 

      %

    • D. 

      &

  • 24. 
    What is the short cut key to highlight the entire column?
    • A. 

      Ctrl+C

    • B. 

      Ctrl+Enter

    • C. 

      Ctrl+Page Up

    • D. 

      Ctrl+Space Bar

  • 25. 
    What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
    • A. 

      5,430.00

    • B. 

      5,436.80

    • C. 

      5,436.8

    • D. 

      6.8

  • 26. 
    How do you display current date and time in MS Excel?
    • A. 

      Date ()

    • B. 

      Today ()

    • C. 

      Now ()

    • D. 

      Time ()

  • 27. 
    Which Chart can be created in Excel?
    • A. 

      Area

    • B. 

      Line

    • C. 

      Pie

    • D. 

      All of the above

  • 28. 
    What does COUNTA () function do?
    • A. 

      Counts cells having alphabets

    • B. 

      Counts empty cells

    • C. 

      Counts cells having number

    • D. 

      Counts non-empty cells

  • 29. 
    How do you wrap the text in a cell?
    • A. 

      Format, cells, font

    • B. 

      Format, cells, protection

    • C. 

      Format, cells, number

    • D. 

      Format, cells, alignment

  • 30. 
    How do you display current date only in MS Excel?
    • A. 

      Date ()

    • B. 

      Today ()

    • C. 

      Now ()

    • D. 

      Time ()