Microsoft Excel Test For Beginners! Quiz
(149).jpg "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
Correct Answer
C. A1:A5Explanation
The correct way to reference a range of values is by using the format A1:A5. This notation represents a range starting from cell A1 and ending at cell A5, inclusive.Rate this question:
-
- 2.
CTRL + V is the shortcut combination for PASTE.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the shortcut combination CTRL + V is commonly used to paste text or other content from the clipboard onto a document or application. This combination is widely recognized and used in various operating systems and software programs.Rate this question:
-
- 3.
Pressing ENTER on a cell will move the typing selection down a row.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Pressing ENTER on a cell in a spreadsheet program such as Excel will indeed move the typing selection down a row. This is a commonly used shortcut to quickly move to the next row and enter data. It allows for efficient data entry in a tabular format, as users can simply press ENTER to move to the next row instead of manually clicking on the next cell.Rate this question:
-
- 4.
Every formula in Excel starts with _____
- A.
Numbers
- B.
An equal sign
- C.
A dash
- D.
Letters
Correct Answer
B. An equal signExplanation
In Excel, every formula must start with an equal sign. This is because the equal sign is used to indicate to Excel that the following characters are part of a formula and not just regular text. Without the equal sign, Excel will treat the characters as text and not perform any calculations. Therefore, it is essential to always remember to start a formula with an equal sign in Excel.Rate this question:
-
- 5.
Which part of this math problem will Excel calculate first: =30/5*3?
- A.
Divide 30/5
- B.
Multiply 5*3
Correct Answer
A. Divide 30/5Explanation
Excel follows the order of operations, which is also known as PEMDAS (Parentheses, Exponents, Multiplication and Division from left to right, Addition and Subtraction from left to right). In this problem, the division operation (30/5) will be calculated first, as it comes before the multiplication operation (5*3). Therefore, Excel will calculate the division 30/5 first, resulting in an answer of 6.Rate this question:
-
- 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
Correct Answer
C. The formula result will automatically update when cell values changeExplanation
By using cell references in the formula (=C1+C2), the formula result will automatically update when the cell values change. This means that if the values in cells C1 and C2 are modified, the formula will recalculate and reflect the updated result. This is beneficial in scenarios where the values in the cells are frequently changing, as it saves time and effort by not having to manually update the formula each time.Rate this question:
-
- 7.
Which button allows you to copy cell formats from one cell to another?
- A.
Enter
- B.
Autofit
- C.
Format painter
- D.
Esc
Correct Answer
C. Format painterExplanation
The format painter button allows you to copy cell formats from one cell to another. This feature is useful when you want to apply the same formatting, such as font style, color, and cell borders, to multiple cells without having to manually format each one. By selecting the format painter button, you can easily copy the formatting from one cell and apply it to another cell with a single click.Rate this question:
-
- 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
Correct Answer
C. Click the column headingExplanation
The easiest method to select a column is by clicking the column heading. The column heading is typically located at the top of the column and clicking on it will automatically select the entire column. This method is quick and efficient as it allows you to easily select the desired column without having to manually select each cell individually.Rate this question:
-
- 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
Correct Answer
B. CTRL + ENTERExplanation
Pressing CTRL + ENTER allows the cell to accept the typing as its contents, but the focus remains in the cell. This means that after typing in the cell, you can press CTRL + ENTER to confirm the input without moving to the next cell or losing focus on the current cell. This can be useful when you want to quickly enter data in multiple cells without constantly moving the focus to the next cell.Rate this question:
-
- 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
Correct Answer
C. SUM(A1:A3)Explanation
The correct answer is SUM(A1:A3) because the SUM function in Excel is used to add up the values in a range of cells. In this case, the range A1:A3 represents the cells A1, A2, and A3. By using the SUM function with this range, it will calculate the sum of the values in these three cells and give the result.Rate this question:
-
.jpg "CTRL + V is the shortcut combination for PASTE.")
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 24, 2014Quiz Created by
Anj
Back to top