Microsoft Excel Test For Beginners! Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Anj
A
Anj
Community Contributor
Quizzes Created: 1 | Total Attempts: 708
| Attempts: 708
SettingsSettings
Please wait...
  • 1/10 Questions
    CTRL + V is the shortcut combination for PASTE.      - ProProfs

    CTRL + V is the shortcut combination for PASTE.     

    • True
    • False
Please wait...
About This Quiz

The 'Microsoft Excel Test for Beginners!' assesses fundamental skills in Excel, focusing on formula creation, cell referencing, and basic shortcuts. It's designed to enhance proficiency in managing and analyzing data, ensuring learners can update and manipulate spreadsheets efficiently.

Microsoft Excel Test For Beginners! Quiz - Quiz

Quiz Preview

  • 2. 

    Every formula in Excel starts with _____

    • Numbers

    • An equal sign

    • A dash

    • Letters

    Correct Answer
    A. 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:

  • 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.  

    • True

    • 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. 

    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?

    • The formula is more professional looking

    • The formula will be more accurate

    • The formula result will automatically update when cell values change

    Correct Answer
    A. 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:

  • 5. 

    To add multiple cells together, your formula would be as follows:

    • Cell 1 + Cell 2 + Cell 3

    • A1:A3

    • SUM(A1:A3)

    • A1,A2,A3

    Correct Answer
    A. 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:

  • 6. 

    Which of the choices demonstrates the correct way to reference a range of values?

    • A1-A5

    • A1A5

    • A1:A5

    • A1,A5

    Correct Answer
    A. 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:

  • 7. 

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

    • Divide 30/5

    • 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:

  • 8. 

    Which button allows you to copy cell formats from one cell to another?

    • Enter

    • Autofit

    • Format painter

    • Esc

    Correct Answer
    A. 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:

  • 9. 

    To select a column the easiest method is to:

    • Double-click any cell in the column

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

    • Click the column heading

    • Click the column label

    Correct Answer
    A. 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:

  • 10. 

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

    • ENTER

    • CTRL + ENTER

    • TAB

    • INSERT

    Correct Answer
    A. 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:

Quiz Review Timeline (Updated): Mar 21, 2023 +

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.