Microsoft Excel Test For Beginners! Quiz

10 Questions | Total Attempts: 346  Settings  .

• 1.
Which of the choices demonstrates the correct way to reference a range of values?
• A.

A1-A5

• B.

A1A5

• C.

A1:A5

• D.

A1,A5

• 2.
CTRL + V is the shortcut combination for PASTE.
• A.

True

• B.

False

• 3.
Pressing ENTER on a cell will move the typing selection down a row.
• A.

True

• B.

False

• 4.
Every formula in Excel starts with _____
• A.

Numbers

• B.

An equal sign

• C.

A dash

• D.

Letters

• 5.
Which part of this math problem will Excel calculate first: =30/5*3?
• A.

Divide 30/5

• B.

Multiply 5*3

• 6.
If you want to add the values that are in cells C1 and C2 (93 and 14), why would you use cell references in the formula (=C1+C2) instead of just writing the formula like this: =93+14?
• A.

The formula is more professional looking

• B.

The formula will be more accurate

• C.

The formula result will automatically update when cell values change

• 7.
Which button allows you to copy cell formats from one cell to another?
• A.

Enter

• B.

Autofit

• C.

Format painter

• D.

Esc

• 8.
To select a column the easiest method is to:
• A.

Double-click any cell in the column

• B.

Drag from the top cell in the last cell in the column

• C.

• D.

Click the column label

• 9.
If you press____, the cell accepts your typing as its contents, but the focus stays in the cell.
• A.

ENTER

• B.

CTRL + ENTER

• C.

TAB

• D.

INSERT

• 10.
• A.

Cell 1 + Cell 2 + Cell 3

• B.

A1:A3

• C.

SUM(A1:A3)

• D.

A1,A2,A3

Related Topics Back to top