Excel Advanced Questions By Akshay Magre

20 Questions | Total Attempts: 212

Settings
Please wait...
Excel Quizzes & Trivia

This Set of Questions are for Target Audience already aware of Basic Excel Concepts. Questions : 20Time Limit : 40 minsPass Criteria : 60 %


Questions and Answers
  • 1. 
    Which of the following is correct Syntax in excel?
    • A. 

      =IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)

    • B. 

      =IF(LOGICAL TEST,FALSE RESULT,TRUE RESULT)

    • C. 

      =IF(LOGICAL TEST,TRUE RESULT)(LOGICAL TEST, FALSE RESULT)

    • D. 

      ALL OF THE ABOVE

  • 2. 
    Late for your investors meeting? How can you quickly apply professional formatting to your sales forecast worksheet?
    • A. 

      Apply special attributes using Format Painter

    • B. 

      Apply an Auto Format Style

    • C. 

      Apply a selected background color

    • D. 

      All of above

  • 3. 
    The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
    • A. 

      B1:G10

    • B. 

      B1-G10

    • C. 

      B1;G10

    • D. 

      B1&G10

  • 4. 
    Using the F11 shortcut key to create a chart on chart sheet creates
    • A. 

      A default chart

    • B. 

      A 2-dimensional column chart

    • C. 

      A 2-dimensional bar chart

    • D. 

      A 3-dimensional line chart

  • 5. 
    To add two cells (A1 and A2) together you use the following formula
    • A. 

      =A1+A2

    • B. 

      =Add(A1+A2)

    • C. 

      =together(A1:A2)

    • D. 

      A1 plus A2

  • 6. 
    • A. 

      By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

    • B. 

      By dragging a range of excel data to the Word button on the taskbar while pressing Shift key

    • C. 

      By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

    • D. 

      A and c

  • 7. 
    Excel uses the …. Function when creating a data table
    • A. 

      Average

    • B. 

      Count

    • C. 

      Sum

    • D. 

      Table

  • 8. 
     What chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?
    • A. 

      Category axis

    • B. 

      Data marker

    • C. 

      Data point

    • D. 

      Gridline

  • 9. 
    • A. 

      Multiplication and division, exponential positive and negative value

    • B. 

      Multiplication and division, positive and negative values, addition and subtraction

    • C. 

      Addition and subtraction, positive and negative values, exponentiation

    • D. 

      None of above

  • 10. 
     which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
    • A. 

      Workday

    • B. 

      Date

    • C. 

      Networkdays

    • D. 

      All of the above

  • 11. 
    • A. 

      Use Ctrl to select all three cells, then click the paste button on the standard toolbar

    • B. 

      Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

    • C. 

      Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

    • D. 

      All of above

  • 12. 
    You can group noncontiguous worksheets with
    • A. 

      The group button on the standard toolbar

    • B. 

      The shift key and the mouse

    • C. 

      The ctrl key and mouse

    • D. 

      The alt+enter key

  • 13. 
    • A. 

      Single-click the boundary to the left to the column heading

    • B. 

      Double click the boundary to the right of the column heading

    • C. 

      Press Alt and single click anywhere in the column

    • D. 

      All of above

  • 14. 
    • A. 

      Spreadsheet program

    • B. 

      Database program

    • C. 

      Word processor program

    • D. 

      Desktop publisher program

  • 15. 
    You can copy data or formulas
    • A. 

      With the copy, paste and cut commands

    • B. 

      With commands on a shortcut

    • C. 

      With buttons on the Qucik access toolbar

    • D. 

      All of the above

  • 16. 
    The LEN function does what?
    • A. 

      Compares the content in two cells

    • B. 

      Counts the numbers of characters in a cell

    • C. 

      Deletes extra space in text

    • D. 

      All of above

  • 17. 
    To move to previous sheet we need to use shortcut
    • A. 

      CTRL + A

    • B. 

      CTRL + PGUP

    • C. 

      CTRL + PGDOWN

    • D. 

      CTRL + HOME

  • 18. 
    A value used in a formula that does not change is called a
    • A. 

      Cell address

    • B. 

      Constant

    • C. 

      Function

    • D. 

      Range

  • 19. 
    Weight refers to
    • A. 

      The print density of characters

    • B. 

      The height of the printed character

    • C. 

      Upright or slanted shape

    • D. 

      The design and appearance of characters

  • 20. 
    Can we hide a sheet????
    • A. 

      True

    • B. 

      False