Microsoft Excel Test For Beginners! Quiz

10 Questions | By Achoudhuri | Updated: Mar 21, 2022 | Attempts: 645

Questions

Settings

Create your own Quiz

Microsoft Excel Test For Beginners! Quiz - Quiz

Questions and Answers

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.
  
  Click the column heading
- 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.

To add multiple cells together, your formula would be as follows:
- A.
  
  Cell 1 + Cell 2 + Cell 3
- B.
  
  A1:A3
- C.
  
  SUM(A1:A3)
- D.
  
  A1,A2,A3