Excel 2007 Engr 112 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 Makanzel
M
Makanzel
Community Contributor
Quizzes Created: 1 | Total Attempts: 166
| Attempts: 166
SettingsSettings
Please wait...
  • 1/11 Questions

    What is the correct cell entry for the following scenario (no spaces):You wish to add cell c46 and d53.

Please wait...
About This Quiz

This Excel 2007 ENGR 112 Quiz assesses skills in using Excel functions, formulas, and cell referencing. It helps learners verify their ability to manipulate data and understand Excel's basic operations, enhancing their proficiency in spreadsheet management.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    You can't change the chart type after you create a chart.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement "You can't change the chart type after you create a chart" is false. In most charting software, including popular programs like Microsoft Excel, you have the ability to change the chart type even after creating a chart. This flexibility allows users to experiment with different visual representations of their data and choose the one that best suits their needs.

    Rate this question:

  • 3. 

     The colon (:) in B3:B6 indicates a ______ in column B, rows 3 through 6. 

    • Cell argument

    • Cell range

    • Cell reference

    Correct Answer
    A. Cell range
    Explanation
    The colon (:) in B3:B6 indicates a range of cells in column B, specifically rows 3 through 6. It is used to specify a continuous set of cells in a column or row.

    Rate this question:

  • 4. 

    You create a chart. But later on you don't see the Chart Tools. What do you do to get them back?

    • Create another chart.

    • Click inside the chart.

    • Click the Insert tab.

    Correct Answer
    A. Click inside the chart.
    Explanation
    Once you click inside the existing chart, the Chart Tools will be at hand with three tabs: Design, Layout, and Format.

    Rate this question:

  • 5. 

    A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

    • Click in cell C6, and then press CTRL+SHIFT.

    • Click in cell C6, and then press F5.

    • Click in cell C6.

    Correct Answer
    A. Click in cell C6.
    Explanation
    To see the formula result in cell C6, you need to click on cell C6.

    Rate this question:

  • 6. 

    Cell references are __________ by default.

    • Absolute

    • Relative

    Correct Answer
    A. Relative
    Explanation
    Cell references are relative by default. This means that when a formula or function is copied to another cell, the reference to other cells will adjust accordingly. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically change to B2. This allows for easy replication of formulas across multiple cells without having to manually adjust each reference.

    Rate this question:

  • 7. 

    If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5?

    • =C4*$D$9

    • =C5*$D$9

    • =C5*$E$10

    Correct Answer
    A. =C5*$D$9
    Explanation
    As the formula is copied, the relative cell reference, C4, changes to C5. The absolute cell reference, $D$9, does not change; it remains the same in each row it is copied to.

    Rate this question:

  • 8. 

    What is a function?

    • A prewritten formula

    • A math operator

    Correct Answer
    A. A prewritten formula
    Explanation
    Functions are prewritten formulas, such as SUM, that save time.

    Rate this question:

  • 9. 

    Cell reference A10,A20 refers to values in:

    • The range of cells in column A and rows 10 through 20

    • The range of cells in columns A through E and rows 10 through 20

    • Cell A10 and A20

    Correct Answer
    A. Cell A10 and A20
    Explanation
    The cell reference A10, A20 refers to specific cells in a spreadsheet. It means that the values being referred to are located in cell A10 and cell A20.

    Rate this question:

  • 10. 

    What does ##### mean?

    • The column is not wide enough to display the content.

    • The cell reference is not valid.

    • You have misspelled a function name or used a name that Excel doesn't recognize.

    Correct Answer
    A. The column is not wide enough to display the content.
    Explanation
    This answer is correct because when ##### is displayed in a cell, it means that the column width is not wide enough to display the content. This typically happens when the content in the cell is too long or when the cell contains a date or time value that is not formatted properly. To fix this issue, the column width can be adjusted to make it wider or the content can be shortened.

    Rate this question:

  • 11. 

    You want to add data labels above each column to show a value for each column. How can you do this? (You learned this in the practice.)

    • Add the labels manually.

    • Change the chart style.

    • Change the chart layout.

    Correct Answer
    A. Change the chart layout.
    Explanation
    Layout 2 will add a data label above each column that shows a value for each.

    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
  • Nov 12, 2009
    Quiz Created by
    Makanzel
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.