Excel Assessment

9 Questions

Settings
Please wait...
Assessment Quizzes & Trivia

Assess your Excel skills.


Questions and Answers
  • 1. 
    • A. 

      Click on Subtotals in the menu

    • B. 

      View the sum in the Formula Bar

    • C. 

      Press Alt++ on the keyboard

  • 2. 
    What's a quick way to extend these numbers to a longer sequence, for instance 23 through 40?
    • A. 

      Select the last two cells and drag the fill handle over the range you want, for instance 18 more rows.

    • B. 

      Select the range you want, including the three cells, point to Fill on the Edit menu, and then click Down.

    • C. 

      Copy the third cell, click in the cell below it, on the Standard toolbar click the down arrow on the paste button, and select Paste Special

  • 3. 
    • A. 

      Go to File->Save As->Save as Type->Excel 4.0 Worksheet

    • B. 

      Right-click on the spreadsheet tab and click Delete

    • C. 

      Right-clik on the spreadsheet and click Insert-Entire Column

  • 4. 
    Which of these will NOT select ALL cells in a document.
    • A. 

      Triple-clicking with the right mouse button in the spreadsheet.

    • B. 

      Using the Edit->Select All menu item.

    • C. 

      Pressing Ctl+A on the keyboard

  • 5. 
    Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
    • A. 

      Count

    • B. 

      Plus

    • C. 

      Sum

  • 6. 
    Which is NOT a way to open the Visual Basic Editor
    • A. 

      Press Alt+F11 on the keyboard

    • B. 

      Use the View->VB Editor menu

    • C. 

      Go to the Developer ribbon and select 'View Code'

  • 7. 
    To enter a formula in the formula bar, begin with
    • A. 

      =

    • B. 

      Formula(

    • C. 

      `

  • 8. 
    • A. 

      SUM(number1, [number2]...)

    • B. 

      SUM(range)

    • C. 

      SUM(number1, [number2],[TRUE])

  • 9. 
    • A. 

      Private Sub system32.msgbox.udf() msgbox "Hello World" End Sub

    • B. 

      Public Function Hola(one as integer) msgbox "You entered " & one End Function