Quiz 3 SEC A

20 Questions | Total Attempts: 65

SettingsSettingsSettings
Quiz 3 SEC A - Quiz

.


Questions and Answers
  • 1. 
    What is the intersection of a column and a row on a worksheet called ?
    • A. 

      Column

    • B. 

      Value

    • C. 

      Address

    • D. 

      Cell

  • 2. 
    Which of these data types is not in MS.excel?
    • A. 

      Number

    • B. 

      Currency

    • C. 

      Label

    • D. 

      Date/Time

  • 3. 
    In MS Excel, which menu does have Sort option
    • A. 

      Edit

    • B. 

      Format

    • C. 

      Tool

    • D. 

      Data

  • 4. 
    Which of these charts does not exist in MS Excel?
    • A. 

      Scatter

    • B. 

      Line

    • C. 

      Doughnut

    • D. 

      Graph

  • 5. 
    Which sign display when Formula Error in MS Excel
    • A. 

      $

    • B. 

      *

    • C. 

      \

    • D. 

      #

  • 6. 
    Functions in MS Excel must begin with ___
    • A. 

      An () sign

    • B. 

      An Equal Sign

    • C. 

      A Plus Sign

    • D. 

      A > Sign

  • 7. 
    What type of chart is useful for showing trends or changes over time ?.
    • A. 

      Pie Chart

    • B. 

      Column Chart

    • C. 

      Line Chart

    • D. 

      Dot Graph

  • 8. 
    The process of arrenging the items of a column in some sequence or order is known as :
    • A. 

      Arranging

    • B. 

      Autofill

    • C. 

      Sorting

    • D. 

      Filtering

  • 9. 
    The ____ feature of MS Excel quickly completes a series of data
    • A. 

      Auto Complete

    • B. 

      Auto Fill

    • C. 

      Fill Handle

    • D. 

      Sorting

  • 10. 
    What type of chart is useful for comparing parts of a whole ?
    • A. 

      Pie Chart

    • B. 

      Column Chart

    • C. 

      Line Chart

    • D. 

      Dot Graph

  • 11. 
    How many sheets are there, by default, when we create a new Excel file ?
    • A. 

      1

    • B. 

      3

    • C. 

      5

    • D. 

      10

  • 12. 
    In Excel, which one denoted a range from B1 through E5.
    • A. 

      B1 - E5

    • B. 

      B1:E5

    • C. 

      B1 to E5

    • D. 

      B1$E5

  • 13. 
    What type of chart will you use to compare performance of sales of two products ?
    • A. 

      Column Chart

    • B. 

      Line Chart

    • C. 

      Pie Chart

    • D. 

      Both A and B

  • 14. 
    A features that displays only the data in column (s) according to specified criteria
    • A. 

      Formula

    • B. 

      Sorting

    • C. 

      Filtering

    • D. 

      Pivot

  • 15. 
    On an excel sheet the active cell in indicated by ? ​​​​
    • A. 

      A dotted border

    • B. 

      A dark wide border

    • C. 

      A blinking border

    • D. 

      By italic text

  • 16. 
    In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
    • A. 

      A. You can automatically apply formatting to a data series

    • B. 

      B. You can change the position of a data marker and that automatically changes the data point value in the worksheet

    • C. 

      C. You can change a data point value and automatically that is drawn in  the chart

    • D. 

      D. Both (b) & (c)

  • 17. 
    The default style for new data keyed in a new workbook is ? ​​​​​
    • A. 

      Comma

    • B. 

      Normal

    • C. 

      Currency

    • D. 

      Percent

  • 18. 
    In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
    • A. 

      Workday

    • B. 

      Date

    • C. 

      Networkday

    • D. 

      Weekday

  • 19. 
    In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu
    • A. 

      Edit

    • B. 

      Format

    • C. 

      Tools

    • D. 

      All of the above

  • 20. 
      In MS-Excel 3-D reference in a formula
    • A. 

      Cannot be modified

    • B. 

      Only appears on summary worksheets

    • C. 

      Spans worksheets

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.