# Assess Your MS Excel Skills! Trivia Quiz

9 Questions | Total Attempts: 1138

Settings

.

Related Topics
• 1.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
• 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.

• 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.
Which of the following is NOT a proper syntax for the SUM function?
• A.

SUM(number1, [number2]...)

• B.

SUM(range)

• C.

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

• 9.
Whis is a valid UDF (User Defined Function)?
• A.

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

• B.

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