Excel Quiz 2 On Functions And Graphing

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 Selena Skipper
Selena Skipper, Business teacher
Selena, a dedicated Business Teacher with 26 years of experience, currently imparts knowledge at the Cullman Area Technology Academy. Her passion lies in guiding students to discover their career paths and achieve valuable certifications.
Quizzes Created: 12 | Total Attempts: 70,031
| Attempts: 1,098
SettingsSettings
Please wait...
  • 1/13 Questions

    The first part of the "If" statement is often referred to as the "condition" or the "logic statement".

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

Excel Quiz 2 on Functions and Graphing tests knowledge on selecting data for charts, utilizing functions like Max, understanding chart types for data representation, and mastering Excel's If statements. Essential for enhancing spreadsheet skills.

Excel Quiz 2 On Functions And Graphing - Quiz

Quiz Preview

  • 2. 

    To do a sort or a filter, one could go to "Data" on the menu toolbar.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    To perform a sort or a filter, one can access the "Data" option on the menu toolbar. This suggests that the statement is true, as it correctly states the location to find the necessary options for sorting or filtering data.

    Rate this question:

  • 3. 

    When one wishes to select the largest number from a set of data, one should use which function?

    • Count

    • Max

    • Min

    • If

    Correct Answer
    A. Max
    Explanation
    The correct answer is "Max". When selecting the largest number from a set of data, the "Max" function is used. This function compares all the numbers in the set and returns the highest value. It is commonly used in programming and data analysis to find the maximum value in a given dataset.

    Rate this question:

  • 4. 

    The second part of the "If" statement represents what happens if the condition is ......

    Correct Answer
    true
    Explanation
    The second part of the "If" statement represents what happens if the condition is evaluated as true. In programming, an "If" statement is used to execute a block of code only if a certain condition is true. If the condition is true, the code inside the "If" statement will be executed, otherwise it will be skipped. Therefore, if the condition is true, the code in the second part of the "If" statement will be executed.

    Rate this question:

  • 5. 

    It is not possible to edit a graph/chart once it has been finished.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because it is possible to edit a graph or chart even after it has been finished. Graphs and charts can be edited by adding or removing data, changing labels, adjusting the formatting, or modifying the design elements. Editing allows for updates, improvements, or corrections to be made to the graph or chart based on new information or feedback.

    Rate this question:

  • 6. 

    Linking means that the destination file will update everytime the source file is saved.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Linking refers to the process of connecting or associating two files or documents together. In this context, if the destination file is linked to the source file, it means that any changes made to the source file will automatically update the destination file. Therefore, the statement "Linking means that the destination file will update every time the source file is saved" is correct.

    Rate this question:

  • 7. 

    One is given three tabs when they open a workbook.  If you use these three tabs, then you must open another workbook because you cannot add anymore tabs.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because in most spreadsheet programs, such as Microsoft Excel or Google Sheets, you are not limited to only three tabs when you open a workbook. You can add as many tabs as you need within the program's limitations. Therefore, there is no need to open another workbook if you want to add more tabs.

    Rate this question:

  • 8. 

    When selecting data in a spreadsheet to be used in a graph or chart, one should never choose blank columns or rows.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When creating a graph or chart in a spreadsheet, it is important to select data that is complete and does not contain any blank columns or rows. Including blank columns or rows can lead to inaccurate representation of the data and may result in misleading or incorrect conclusions. Therefore, it is advisable to only choose data that is filled in and does not have any missing values when creating graphs or charts.

    Rate this question:

  • 9. 

    (b5:g5)  is often referred to as the _______________________________  part of a function.

    • Condition

    • Range

    • Selection

    Correct Answer
    A. Range
    Explanation
    The expression (b5:g5) represents a range of cells in a spreadsheet. In the context of a function, this range is often referred to as the "range" part. This is because the range specifies the set of cells that the function will operate on or analyze. It is used to define the input data for the function and determine the scope of its calculations. Therefore, the correct answer is "Range."

    Rate this question:

  • 10. 

    The easiest way to get started doing an "If" statement is to click the Fx  on your toolbar.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement suggests that the easiest way to begin creating an "If" statement is by clicking the Fx button on the toolbar. This implies that there is a specific function or feature associated with the Fx button that simplifies the process of creating an "If" statement. Therefore, the correct answer is True.

    Rate this question:

  • 11. 

    Using a gradebook spreadsheet, if Mrs. Skipper wishes to print out only those students who are in the 9th grade, she is using which feature?

    • If statements

    • Sorting

    • Filtering

    Correct Answer
    A. Filtering
    Explanation
    Mrs. Skipper is using the filtering feature in the gradebook spreadsheet to print out only those students who are in the 9th grade. Filtering allows her to apply specific criteria or conditions to the data in the spreadsheet and display only the rows that meet those criteria. In this case, she is filtering the data based on the grade level of the students, so that only the students in the 9th grade will be printed out.

    Rate this question:

  • 12. 

    Which of the following chart types would be used if one wanted to compare an individual contribution to the whole?

    • Column

    • Stacked column

    • Line

    Correct Answer
    A. Stacked column
    Explanation
    A stacked column chart would be used to compare an individual contribution to the whole. In this chart type, each column represents a category or variable, and the height of each segment within the column represents the contribution of that individual category to the whole. This allows for easy visual comparison and understanding of how each category contributes to the overall total.

    Rate this question:

  • 13. 

    One should highlight or select any or all data to be used, before using a function.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Before using a function, it is not necessary to highlight or select any data. Functions can be applied to a range of data without the need for prior selection. Therefore, the given statement is false.

    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
  • Jan 28, 2011
    Quiz Created by
    Selena Skipper
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.