MS Excel Quizz

Formula in MS Excel starts with __________

• *

• -

• ?

• =

Which of the following keyboard shortcuts is used 'Autosum', a quick and easy way of adding multiple values?

• Ctrl + =

• Shift + =

• Tab + =

• Ctrl + 1

• Alt + =

What is the shortcut to enable filtering of selected cells in MS Excel?

• Ctrl + F

• Alt + Click + L

• Ctrl + Shift + L

• Shift + F

In MS Excel, to add numeric values in column D, from rows D10 to D15, the formula that should be used is :

• =SUM (D10, D15)

• =COUNT (D10, D15)

• =SUM (D10:D15)

• =COUNT (D10:D15)

Gridlines and formula bar which tab in MS Excel?

• Home Tab

• Insert Tab

• Data Tab

• View Tab

• Page Layout

When you right-click and select the 'Format Cells' option in MS Excel 2010, which of the following Tab is NOT visible

• Font

• Sheet

• Border

• Alignment

• Fill

To multiply items in Excel, you would use:

• /

• -

• *

• X

• =

A program using a table comprising of rows, columns and cells.

• MS Word

• MS Excel

• MS Outlook

• MS PowerPoint

You are not able to open, save, rename and close a file in Excel the way you would in MS Word.

• TRUE

• FALSE

The first cell in a worksheet is what?

• 1A

• FX

• A1

• Cell Name