# MS Excel 2007 - Pretest

25 Questions | Total Attempts: 259  Settings  This is a pre-requisite to the MS Excel Intermediate Course training. You can have EXCEL open while taking this pretest

• 1.
• 2.
A cell is a
• A.

Verticle space that goes up and down

• B.

Horizontal space going across

• C.

Grid made of columns and rows

• D.

Area where columns and rows intersect

• 3.
A row is
• A.

Horizontal and designated by a letter

• B.

Horizontal and designated by a number

• C.

Vertical and designated by a number

• D.

Vertical and designated by a letter

• 4.
A column is
• A.

Horizontal and designated by a number

• B.

Horizontal and designated by a letter

• C.

Vertical and designated by a letter

• D.

Vertical and designated by a number

• 5.
• A.

&

• B.

[

• C.

=

• D.

+

• 6.
In a spreadsheet formula which symbol is used to divide?
• A.

=

• B.

^

• C.

\

• D.

/

• 7.
In a spreadsheet formula which symbol is used to multiply ?
• A.

@

• B.

X

• C.

*

• D.

&

• 8.
I want to add cells value from C5 to C70, and show output of this addition in cell A3.Which formula should I use?
• A.

Write in Cell A3, =SUM(C5:C70)

• B.

Write in Cell A3, C5+C6+C7+C8+C9.....

• C.

Write in Cell A3, =Add C5:C70

• D.

Write in Cell A3, =add C5 to C70

• 9.
Which of these would add up the numbers from A3 to A6
• A.

=+(A3:A6)

• B.

=(A3:A6)

• C.

=Sum(a3+a6)

• D.

=Sum(A3:A6)

• 10.
Which shortcut could you use to save a workbook under a different name (save as)?
• A.

F2

• B.

F12

• C.

Ctrl+S

• D.

Shift+S

• 11.
Which shortcut could you use to repeat the last formatting action you performed in a worksheet?
• A.

F1

• B.

F4

• C.

F9

• D.

F12

• 12.
Can’t find a number or word in Excel?  Use the Find box to help you.  Which of the following is the shortcut for launching the Find Dialogue box?
• A.

Ctrl+H

• B.

Ctrl+G

• C.

Ctrl+F

• D.

Ctrl+A

• 13.
What happens when you press Ctrl+9 when a row is selected?
• A.

This inserts a new row above the selected row

• B.

This deletes the row

• C.

This hides the selected row(s)

• D.

This copies the content of the selected row to the clipboard

• 14.
Which shortcut can you use to quickly sum the values of cells using the AutoSum function?
• A.

Ctrl+S

• B.

Shift+A

• C.

Alt+=

• D.

Shift+S+=

• 15.
Let’s face it, the Ribbon can get in the way but when it’s gone, we miss it.  Which shortcut can you use to hide and display the Ribbon?
• A.

Ctrl+F1

• B.

Ctrl+H

• C.

Ctrl+Shift+R

• D.

Ctrl+R

• 16.
To quickly move back to the first cell of your worksheet (usually A1), which shortcut combination would you use?
• A.

Ctrl+Space

• B.

Ctrl+Home

• C.

Ctrl+Page Up

• D.

Ctrl+Up Arrow Key

• 17.
If you quickly want to undo or redo an action in Excel, which shortcut keys would you use?
• A.

Ctrl+u and Ctrl+r

• B.

Ctrl+z and Ctrl+y

• C.

Ctrl+un and Ctrl+re

• D.

All of the above shortcut keys will work.

• 18.
If you wanted to reformat your entire worksheet, for example to change the font, which shortcut key combination could you use to quickly select the whole worksheet?
• A.

Ctrl+Alt+Delete

• B.

Ctrl+a

• C.

Shift+a

• D.

Alt+a

• 19.
Which shortcut key combination allows you to quickly select multiple adjacent groups of cells?
• A.

Alt+Arrow Keys

• B.

Ctrl+a

• C.

Ctrl+Shift+Arrow Keys

• D.

Ctrl+Arrow Keys

• 20.
What is the keyboard shortcut to select a row of active cells?
• A.

Ctrl + Spacebar

• B.

Ctrl + End

• C.

Shift + End

• D.

Shift + Spacebar

• 21.
Which shortcut key combination can be used to insert the current date into a cell?
• A.

Ctrl+D

• B.

Ctrl+; (semicolon)

• C.

Ctrl+Shift+; (semicolon)

• D.

Ctrl+Shift+D

• 22.
What does the shortcut Ctrl+d achieve?
• A.

It formats the selected cell.

• B.

It repeats the last action (redo).

• C.

It inserts the current date.

• D.

It creates a copy of the cell contents from the above

• 23.
To quickly repeat your last number formatting action to a selected cell or cells, you could use which of the following shortcut key combinations?
• A.

Select the cell or cells to repeat the formatting on and press Ctrl+Shift+v

• B.

Select the cell or cells to repeat the formatting on and press Ctrl+Shift+r

• C.

Select the cell or cells to repeat the formatting on and press Ctrl+Shift+F4

• D.

Select the cell or cells to repeat the formatting on and press F4

• 24.
To ensure a cell reference becomes absolute and does not change when more rows or columns are added or if the cell containing the referenced value is moved, you need to:
• A.

Type the cell reference and press Ctrl+Shift+F4 to make the reference absolute.

• B.

Type the cell reference and press Ctrl+a to make the reference absolute.

• C.

Type the cell reference and press Ctrl+Shift+Enter to make the reference absolute.

• D.

Type the cell reference and press F4 to make the reference absolute.

• 25.
What will happen to all your worksheets in your current open workbook when you press F9?
• A.

The workbook will automatically be saved.

• B.

All formulas will automatically be calculated.

• C.

All cell references will become absolute.

• D.

None of the above options are correct.

Related Topics Back to top