Microsoft Excel Test For Beginners! Quiz
10 Questions
| Total Attempts: 346
(149).jpg "Microsoft Excel Test For Beginners! 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.
- ProProfs]( "CTRL + V is the shortcut combination for PASTE.")
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.
- ProProfs]( "Pressing ENTER on a cell will move the typing selection down a row.")
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
.jpg "CTRL + V is the shortcut combination for PASTE.")
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 66566 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 61002 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 45182 | Last updated: Feb 12, 2021
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top