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: 69,786

| Attempts: 1,098

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/13 Questions

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

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

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 F^_x 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

Excel Quiz 2 On Functions And Graphing

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

Quiz Preview

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

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

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

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

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

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.

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

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

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

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?

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

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

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