MS Excel 2016 Test: Quiz!

40 Questions | Total Attempts: 1015

SettingsSettingsSettings
MS Excel 2016 Test: Quiz! - Quiz

.


Questions and Answers
  • 1. 
    What is the keyboard shortcut command to move the mouse pointer to cell A1?
    • A. 

      Control + Home

    • B. 

      Control + F4 key

    • C. 

      Name box

    • D. 

      Control + A1

    • E. 

      Control + Tab key

  • 2. 
    A workbook contains:
    • A. 

      1 worksheet

    • B. 

      2 worksheets

    • C. 

      3 worksheets

    • D. 

      4 worksheets

    • E. 

      No worksheets

  • 3. 
    The feature that enables you to automatically complete a list of 12 months after you key one month is:
    • A. 

      Cell style

    • B. 

      Fill handle or Autofill

    • C. 

      Page layout

    • D. 

      Find

    • E. 

      Replace

  • 4. 
    What is the default alignment for values and dates in a cell?
    • A. 

      Justified

    • B. 

      Left aligned

    • C. 

      Centered

    • D. 

      Bottom aligned

    • E. 

      Right aligned

  • 5. 
    How would the cell reference $F$4 be described?
    • A. 

      Mixed reference

    • B. 

      Absolute reference

    • C. 

      Relative reference

    • D. 

      Additional reference

    • E. 

      Money reference

  • 6. 
    What type of operation is being performed in the formula =A4*B5?
    • A. 

      Addition

    • B. 

      Subtraction

    • C. 

      Division

    • D. 

      Percentage

    • E. 

      Multiplication

  • 7. 
    Which orientation is taller than it is wide?
    • A. 

      Landscape

    • B. 

      Portrait

  • 8. 
    What term describes a model workbook used as the basis for other workbooks?
    • A. 

      Form

    • B. 

      Demonstration

    • C. 

      Template

    • D. 

      Cell styles

    • E. 

      Page Layout

  • 9. 
    How can you start Edit mode to edit a formula?
    • A. 

      Tools

    • B. 

      Format

    • C. 

      F4

    • D. 

      F2 or double-click cell

    • E. 

      Find and replace

  • 10. 
    Three types of data visualation are:
    • A. 

      Tools, Columns, Styles

    • B. 

      Data bars, Color scales, Icon sets

    • C. 

      Cell styles, Bold, Italics

    • D. 

      Home, Edit, Fill

    • E. 

      Shapes, Arrows, Clip art

  • 11. 
    Name the function that adds cell values only if they meet your criteria.
    • A. 

      Average()

    • B. 

      Count()

    • C. 

      Mean()

    • D. 

      SumIF()

    • E. 

      Round

  • 12. 
    What function would display the highest sales amount in a column?
    • A. 

      Min()

    • B. 

      Avg()

    • C. 

      Max()

    • D. 

      Most()

    • E. 

      Sum()

  • 13. 
    Which logical function shows the opposite of the condition?
    • A. 

      NOT function

    • B. 

      False function

    • C. 

      Nper function

    • D. 

      Sum function

    • E. 

      PMT function

  • 14. 
    Which financial function would help you determine how much money will be in your account at the end of a year if you make regular payments?
    • A. 

      NPER function

    • B. 

      Sum function

    • C. 

      FV function

    • D. 

      PMT function

    • E. 

      Today function

  • 15. 
    What is the term used to describe a function inside a function?
    • A. 

      Conditional

    • B. 

      Argument

    • C. 

      Nested

    • D. 

      Double

    • E. 

      Hyperlink

  • 16. 
    What does a hyperlink do?
    • A. 

      Adds another argument

    • B. 

      Displays a website

    • C. 

      Formats worksheet

    • D. 

      Hides worksheets

  • 17. 
    Which function enters the current date?
    • A. 

      Now()

    • B. 

      Days()

    • C. 

      DDYYMM

    • D. 

      TODAY()

  • 18. 
    How would Excel display this value =ROUND(1.567) in the cell?
    • A. 

      1

    • B. 

      2

    • C. 

      1.57

    • D. 

      1.6

  • 19. 
    What does Excel do if a function is volatile?
    • A. 

      Renames the workbook

    • B. 

      Closes the program

    • C. 

      Recaculates it based on the computer where it is opened

    • D. 

      Nothing changes

  • 20. 
    What does the VLOOKUP function do?  
    • A. 

      Looks up text that contain ‘v’

    • B. 

      Checks whether text is the same in one cell as in the next

    • C. 

      Finds related records

    • D. 

      All of above

  • 21. 
    How are data organized in a spreadsheet?  
    • A. 

      Lines and spaces

    • B. 

      Layers and planes

    • C. 

      Rows and columns

    • D. 

      Height and width

  • 22. 
    Which types of charts can excel produce?
    • A. 

      Line graphs and pie charts only

    • B. 

      Only line graphs

    • C. 

      Bar charts, line graphs and pie charts

    • D. 

      Bar charts and line graphs only

  • 23. 
    Each excel file is called a workbook because:  
    • A. 

      It can contain text and data

    • B. 

      It can be modified

    • C. 

      It can contain many sheets including worksheets and chart sheets

    • D. 

      You have to work hard to create it

  • 24. 
    Excel is a:
    • A. 

      Graphic program

    • B. 

      None of these

    • C. 

      Word processor

    • D. 

      A spreadsheet

  • 25. 
    A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this? 
    • A. 

      Go to File-Save As – Save As Type – Excel worksheet

    • B. 

      Right click on the spreadsheet tab and select DELETE

    • C. 

      Right click on the spreadsheet and select Insert – Entire Column

    • D. 

      None of above

Back to Top Back to top