Excel Quiz 2 On Functions And Graphing
Small excel quiz on functions and graphing
Questions and Answers
- 1.
When selecting data in a spreadsheet to be used in a graph or chart, one should never choose blank columns or rows.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 2.
When one wishes to select the largest number from a set of data, one should use which function?
- A.
Count
- B.
Max
- C.
Min
- D.
If
Correct Answer
B. MaxExplanation
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:
-
- 3.
Which of the following chart types would be used if one wanted to compare an individual contribution to the whole?
- A.
Column
- B.
Stacked column
- C.
Line
Correct Answer
B. Stacked columnExplanation
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:
-
- 4.
Linking means that the destination file will update everytime the source file is saved.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 5.
The second part of the "If" statement represents what happens if the condition is ......
Correct Answer
trueExplanation
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:
- 6.
The first part of the "If" statement is often referred to as the "condition" or the "logic statement".
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The first part of an "If" statement is indeed referred to as the "condition" or the "logic statement". This is because the condition determines whether the code inside the "if" block will be executed or not. If the condition is true, the code will be executed; otherwise, it will be skipped. Therefore, the statement "True" is correct.Rate this question:
-
- 7.
The easiest way to get started doing an "If" statement is to click the Fx on your toolbar.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 8.
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 9.
It is not possible to edit a graph/chart once it has been finished.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 10.
To do a sort or a filter, one could go to "Data" on the menu toolbar.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 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?
- A.
If statements
- B.
Sorting
- C.
Filtering
Correct Answer
C. FilteringExplanation
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.
One should highlight or select any or all data to be used, before using a function.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 13.
(b5:g5) is often referred to as the _______________________________ part of a function.
- A.
Condition
- B.
Range
- C.
Selection
Correct Answer
B. RangeExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 28, 2011Quiz Created by
Selena Skipper
Back to top