Microsoft Excel Test For Beginners! Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Anj
A
Anj
Community Contributor
Quizzes Created: 1 | Total Attempts: 700
Questions: 10 | Attempts: 700

SettingsSettingsSettings
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:A5
    Explanation
    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. True
    Explanation
    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. True
    Explanation
    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 sign
    Explanation
    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/5
    Explanation
    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 change
    Explanation
    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 painter
    Explanation
    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 heading
    Explanation
    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 + ENTER
    Explanation
    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:

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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 24, 2014
    Quiz Created by
    Anj
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.