MS Excel Quiz #3

25 Questions | Total Attempts: 89

SettingsSettingsSettings
Please wait...
MS Excel Quiz #3


Questions and Answers
  • 1. 
    Which menu option can be used to split windows into two?
    • A. 

      Format -> Window

    • B. 

      View -> Window-> Split

    • C. 

      Window -> Split

    • D. 

      View-> Split

  • 2. 
    How many worksheets can a workbook have?
    • A. 

      3

    • B. 

      8

    • C. 

      255

    • D. 

      None of above

  • 3. 
    You can activate a cell by
    • A. 

      Pressing the Tab key

    • B. 

      Clicking the cell

    • C. 

      Pressing an arrow key

    • D. 

      All of the above 

  • 4. 
    Which is used to perform what if analysis?
    • A. 

      Solver

    • B. 

      Goal seek

    • C. 

      Scenario Manager 

    • D. 

      All of the above 

  • 5. 
    To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
    • A. 

      Unfreeze panes command on the window menu

    • B. 

      Freeze panes command on the window menu 

    • C. 

      Hold titles command on the edit menu 

    • D. 

      Split command on the window menu 

  • 6. 
    What happens when you press Ctrl + X after selecting some cells in Excel?
    • A. 

      The cell content of selected cells disappear from cell and stored in clipboard

    • B. 

      The cell selected are marked for cutting 

    • C. 

      The selected cells are deleted and the cells are shifted left 

    • D. 

      The selected cells are deleted and cells are shifted up

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

      Number 

    • B. 

      Character 

    • C. 

      Label 

    • D. 

      Date/Time

  • 8. 
    You can use the format painter multiple times before you turn it off by
    • A. 

      You can use the format painter button on ly one time when you click it

    • B. 

      Double clicking the format painter button 

    • C. 

      Pressing the Ctrl key and clicking the format painter button 

    • D. 

      Pressing the Alt key and clicking the format painter button 

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

      Pmt

    • B. 

      Average 

    • C. 

      Max

    • D. 

      Sum

  • 10. 
    To activate the previous cell in a pre-selected range, press
    • A. 

      The Alt key 

    • B. 

      The Tab key 

    • C. 

      The Enter key 

    • D. 

      None of the above 

  • 11. 
    Which of the following formulas will Excel Not be able to calculate?
    • A. 

      =SUM(Sales)-A3

    • B. 

      =SUM(A1:A5)*.5

    • C. 

      =SUM(A1:A5)/(10-10)

    • D. 

      =SUM(A1:A5)-10

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

      Accessing 

    • B. 

      Referencing 

    • C. 

      Updating 

    • D. 

      Functioning 

  • 13. 
    Which Chart can be created in Excel? A. Area B. Line C. Pie D. All of the above
    • A. 

      Area

    • B. 

      Line

    • C. 

      Pie

    • D. 

      All of the above 

  • 14. 
    An Excel Workbook is a collection of .......
    • A. 

      Worksheets 

    • B. 

      Workbooks 

    • C. 

      Charts 

    • D. 

      Worksheets and Charts 

  • 15. 
    You can set Page Border in Excel from
    • A. 

      From Border tab in Format Cells dialog box

    • B. 

      From Border tool in Formatting toolbar

    • C. 

      From Line Style tool in Drawing toolbar 

    • D. 

      You can not set page Border in Excel 

  • 16. 
    You can check the conditions against __________ when applying conditional formatting
    • A. 

      Cell value

    • B. 

      Formula 

    • C. 

      Both of above 

    • D. 

      None of the above 

  • 17. 
    When the formula bar is active, you can see
    • A. 

      The edit formula button 

    • B. 

      The cancel button 

    • C. 

      The enter button 

    • D. 

      All of the above 

  • 18. 
    B7:B9 indicates:
    • A. 

      Cells B7and Cell B9 only

    • B. 

      Cells B7 through B9

    • C. 

      Cell B8

    • D. 

      None of the above 

  • 19. 
    What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?
    • A. 

      5430

    • B. 

      5436.80

    • C. 

      5436.8

    • D. 

      6.8

  • 20. 
    When a label is too long to fit within a worksheet cell, you typically must
    • A. 

      Shorten the label 

    • B. 

      Increase the column width 

    • C. 

      Decrease the column width 

    • D. 

      Adjust the row height 

  • 21. 
    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 

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

      $

    • B. 

      *

    • C. 

      %

    • D. 

      &

  • 23. 
    Excel displays the current cell address in the ........
    • A. 

      Formula Bar 

    • B. 

      Status Bar

    • C. 

      Name Box

    • D. 

      Title Bar

  • 24. 
    In Excel, a Data Series is defined as what?
    • A. 

      A type of chart

    • B. 

      A cell reference 

    • C. 

      A collection of related data 

    • D. 

      A division of results 

  • 25. 
    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

Back to Top Back to top