Microsoft Excel 2007 Quiz: Formulas And Functions!

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 Zmolls
Z
Zmolls
Community Contributor
Quizzes Created: 7 | Total Attempts: 16,261
| Attempts: 1,646
SettingsSettings
Please wait...
  • 1/28 Questions

    You can reuse a chart style you've created for a weekly or monthly report.

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

Microsoft Excel, often called MS Excel, is a spreadsheet application for data processing and financial presentation. Do you know all the functions and formulas of excel? Are you an expert? To become an expert, one should learn specific complex formulas and functions. This quiz will test and increase your knowledge about the formulas and functions of MS Excel. Let's try it out.

Microsoft Excel 2007 Quiz: Formulas And Functions! - Quiz

Quiz Preview

  • 2. 

    Which cell reference refers to a range of cells in column B, rows 3 through 6?

    • (B3:B6)

    • (B3,B6)

    Correct Answer
    A. (B3:B6)
    Explanation
    The cell reference (B3:B6) refers to a range of cells in column B, specifically rows 3 through 6. This means that it includes all the cells in column B from row 3 to row 6, allowing you to perform calculations or apply formatting to this specific range of cells.

    Rate this question:

  • 3. 

    What do you type to start the formula in Excel?

    • A function

    • Mathematical operators

    • An equal sign (=)

    Correct Answer
    A. An equal sign (=)
    Explanation
    To start a formula in Excel, you need to type an equal sign (=). This is because the equal sign is used to indicate that you are entering a formula or function into a cell. By typing the equal sign, Excel knows that you want to perform a calculation or use a predefined function. Without the equal sign, Excel will treat the input as a text or value instead of a formula.

    Rate this question:

  • 4. 

    There are three worksheets with every new workbook. You can change that automatic number if you want to.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because when you create a new workbook in Excel, it automatically comes with three worksheets. However, if you want to change the number of worksheets that are automatically created, you have the option to do so.

    Rate this question:

  • 5. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because you can change the chart type after creating a chart. Most charting tools provide the option to modify the chart type, allowing users to switch between different types such as bar, line, pie, etc. This flexibility allows users to experiment with different visual representations of their data and choose the most suitable chart type for their needs.

    Rate this question:

  • 6. 

    You learned in practice how to undo a deletion. Press:

    • CTRL+Z

    • F4

    • ESC

    Correct Answer
    A. CTRL+Z
    Explanation
    The correct answer is CTRL+Z because it is the keyboard shortcut commonly used to undo the most recent action in many software applications. By pressing CTRL+Z, you can reverse the deletion and restore the deleted content or action. This shortcut is widely recognized and used across different platforms, making it a convenient and efficient way to undo a deletion.

    Rate this question:

  • 7. 

    In a new worksheet, you must start by typing in cell A1.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Starting a new worksheet does not require typing in cell A1. The user has the flexibility to start typing in any cell of their choice.

    Rate this question:

  • 8. 

    Pressing ENTER moves the selection of one cell to the right.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Pressing ENTER typically moves the selection of one cell down, not to the right. When working with a spreadsheet or a table, pressing ENTER allows the user to move to the cell directly below the current selected cell. This behavior is consistent across most spreadsheet software and is a common shortcut for navigating through data. Therefore, the statement that pressing ENTER moves the selection of one cell to the right is incorrect.

    Rate this question:

  • 9. 

    The same Chart Tools that are in Excel are in PowerPoint 2007.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that PowerPoint 2007 has the same Chart Tools as Excel. This means that users can access and use the same features and functions for creating and editing charts in PowerPoint as they can in Excel. This allows for consistency and familiarity for users who are already familiar with Excel's Chart Tools.

    Rate this question:

  • 10. 

    You learned in the practice that ###### means:

    • You've entered a number wrong.

    • You've misspelled something.

    • The cell is not wide enough.

    Correct Answer
    A. The cell is not wide enough.
    Explanation
    The correct answer is "The cell is not wide enough." This means that when entering data into a cell in a spreadsheet or table, the width of the cell may not be sufficient to display the entire content. This often occurs when the content is longer than the width of the cell, causing it to be cut off or displayed as "######" to indicate that it is not fully visible.

    Rate this question:

  • 11. 

    To add a column, click a cell in the column to the right of where you want the new column.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    To add a column in a table, you need to click on a cell in the column to the right of where you want the new column to be inserted. This means that the statement "To add a column, click a cell in the column to the right of where you want the new column" is true.

    Rate this question:

  • 12. 

    What is a function?

    • A prewritten formula.

    • A math operator.

    • A Utility Tool

    • None

    Correct Answer
    A. A prewritten formula.
    Explanation
    A function is a prewritten formula that performs a specific task or calculation. It is a predefined set of instructions that takes input values, processes them, and produces an output. Functions are commonly used in programming and mathematics to simplify complex tasks and make calculations more efficient. They can be called and used multiple times throughout a program or equation, saving time and effort by eliminating the need to rewrite the same code or formula repeatedly.

    Rate this question:

  • 13. 

    To enter the months of the year without typing each month yourself you'd use:

    • AutoComplete.

    • AutoFill.

    • CTRL+ENTER.

    • None

    Correct Answer
    A. AutoFill.
    Explanation
    AutoFill is the correct answer because it is a feature that automatically fills in a series of data based on a pattern or existing data. In this case, by entering the first few months of the year, the AutoFill feature can automatically fill in the remaining months without the need to manually type each month.

    Rate this question:

  • 14. 

    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
    Clicking in cell C6 allows you to select the cell and view its contents, including any formula that may have been used to calculate the result. By clicking in the cell, you can see the formula in the formula bar at the top of the Excel window.

    Rate this question:

  • 15. 

    Which of these is an absolute reference?

    • B4:B12

    • $A$1

    Correct Answer
    A. $A$1
    Explanation
    An absolute reference is indicated by the use of dollar signs before the column letter and row number. In this case, $A$1 is the only option that has dollar signs before both the column letter and row number, making it an absolute reference. The other option, B4:B12, is a range reference and does not have dollar signs, so it is not an absolute reference.

    Rate this question:

  • 16. 

    You've created a chart. Now you need to compare data another way. To do this, you must create a second chart.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    To compare data in a different way, it is not necessary to create a second chart. There are several other methods to compare data, such as using a table, graph, or even just analyzing the data directly. Creating a second chart is just one possible option, but it is not the only way to compare data in a different way. Therefore, the correct answer is false.

    Rate this question:

  • 17. 

    You learned in practice how to create a pie chart. There's no difference between a column and a pie chart, other than the pie shape.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because there is a significant difference between a column chart and a pie chart. While both types of charts are used to represent data visually, a column chart displays data using vertical bars, whereas a pie chart uses slices of a circle to represent different categories or proportions of a whole. The two chart types have different purposes and are used to convey different types of information.

    Rate this question:

  • 18. 

    How many arguments does the date function have?

    • One

    • Two

    • Three

    Correct Answer
    A. Three
    Explanation
    The date function typically has three arguments: year, month, and day. These arguments are used to specify a specific date and are separated by commas. The year argument represents the year, the month argument represents the month (usually in numeric form), and the day argument represents the day of the month. By providing these three arguments, the date function can accurately return the desired date.

    Rate this question:

  • 19. 

    In practice, you learned that if you misspell SUM in this formula =SUME(B4: B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    If you misspell SUM in the formula =SUME(B4: B7), you will not get an error value of #NAME. Instead, you will get a different error value such as #NAME?. To fix the formula, you can simply correct the spelling of SUM within the formula without needing to delete and start over again. Therefore, the statement "you must delete it and start over again" is false.

    Rate this question:

  • 20. 

    In practice, you learned how to apply data formats to serial numbers. After selecting a cell, go to the Home tab, and select the Number group. Click the arrow in the Number format box. Then click:

    • Short date

    • Long date

    • More number formats

    • Any of the above

    Correct Answer
    A. Any of the above
    Explanation
    The correct answer is "Any of the above" because after clicking the arrow in the Number format box, you have the option to choose from Short date, Long date, or more number formats. Therefore, you can select any of these options based on your specific formatting requirements.

    Rate this question:

  • 21. 

    Which function would you use to find the date that falls after a number of workdays?

    • NETWORKDAYS

    • WORKDAY

    • TODAY

    Correct Answer
    A. WORKDAY
    Explanation
    The WORKDAY function is used to find the date that falls after a number of workdays. It calculates the date by excluding weekends and any specified holidays. This function is useful for tasks that require determining a future date based on a certain number of working days.

    Rate this question:

  • 22. 

    8/22/2011 and 22-August-2011 are stored as different serial numbers.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because in Excel, dates are stored as serial numbers, where each date is assigned a unique number. The date format does not affect the serial number, so both "8/22/2011" and "22-August-2011" would be stored as the same serial number.

    Rate this question:

  • 23. 

    To add an Excel chart to a PowerPoint presentation you:

    • Click the Data tab.

    • Click the Insert tab.

    • Copy the chart.

    Correct Answer
    A. Copy the chart.
    Explanation
    To add an Excel chart to a PowerPoint presentation, you need to first create the chart in Excel. Once the chart is created, you can select it and use the copy function to copy the chart. Then, switch to the PowerPoint presentation and navigate to the slide where you want to add the chart. Finally, use the paste function to paste the copied chart onto the slide. This will insert the Excel chart into the PowerPoint presentation.

    Rate this question:

  • 24. 

    Which of these dates will Excel store as plain text rather than as a serial number?

    • June 23, 2012

    • 23-June-12

    • June 23 2012

    Correct Answer
    A. June 23 2012
    Explanation
    Excel will store the date "June 23 2012" as plain text rather than as a serial number. This is because the date format does not follow any of the standard date formats recognized by Excel. Excel recognizes dates in formats such as "mm/dd/yyyy" or "dd-mm-yyyy", but "June 23 2012" does not match these formats. Therefore, Excel treats it as plain text instead of converting it into a serial number.

    Rate this question:

  • 25. 

    To delete the formatting from a cell, you would:

    • Delete the cell contents.

    • Click the Font group on the Home tab.

    • Click the Editing group on the Home tab.

    Correct Answer
    A. Click the Editing group on the Home tab.
    Explanation
    To delete the formatting from a cell, you would click the Editing group on the Home tab. This is because the Editing group contains various options related to editing and formatting cells, such as clearing the formatting, clearing the contents, or clearing both. By selecting the Editing group, you can easily access the necessary tools to remove the formatting from a cell without affecting its contents.

    Rate this question:

  • 26. 

    You want to add data labels above each column to show a value for each column. How can you do this?

    • Add the labels manually.

    • Change the chart style.

    • Change the chart layout.

    Correct Answer
    A. Change the chart layout.
    Explanation
    By changing the chart layout, you can add data labels above each column in a chart to show a value for each column. This option allows you to automatically generate and display the data labels without having to add them manually. Changing the chart style only affects the visual appearance of the chart, while adding the labels manually would be a time-consuming and tedious task. Therefore, changing the chart layout is the most efficient and effective way to achieve the desired result.

    Rate this question:

  • 27. 

    The Name Box shows you the contents of the active cell.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The Name Box is a feature in Excel that allows users to easily navigate and select specific cells or ranges. It displays the name or reference of the active cell, not its contents. Therefore, the statement "The Name Box shows you the contents of the active cell" is false.

    Rate this question:

  • 28. 

    To enter a fraction such as 1/4, the first thing you enter is _____.

    • One

    • Zero

    • Minus Sign

    Correct Answer
    A. Zero
    Explanation
    To enter a fraction such as 1/4, the first thing you enter is zero. This is because fractions are represented as a whole number divided by another number, and the whole number is typically zero in this case. By entering zero, you indicate that the fraction you are entering starts with no whole number part.

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

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.