MS Excel Flashcardz

Front

Formula in MS Excel starts with __________

Back

=

Front

Which keyboard shortcut is used for 'Autosum', a quick and easy way of adding multiple values? Options: Ctrl + =, Shift + =, Tab + =, Ctrl + 1, Alt + =

Back

Alt + =

Front

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

Back

Ctrl + Shift + L

Front

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

Back

=SUM (D10:D15)

Front

Gridlines and formula bar which tab in MS Excel?

Back

View Tab

Front

When you right-click and select the 'Format Cells' option in MS Excel 2010, which Tab is NOT visible? Options: Font, Border, Alignment, Fill

Back

Sheet

Front

To multiply items in Excel, you would use: /, -, *, X, =

Back

*

Front

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

Back

MS Excel

Front

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

Back

FALSE

Front

The first cell in a worksheet is what?

Back

A1