Quiz: Excel Plots and Functions

Main.ExcelQuiz2 History

Hide minor edits - Show changes to output

May 17, 2022, at 03:13 AM by 136.36.4.38 -
Added lines 104-105:

----
Restore
April 28, 2022, at 02:41 PM by 10.35.117.248 -
Changed line 3 from:
(:description Learning assessment on Introduction to Python with variables and expressions.:)
to:
(:description Learning assessment on Excel functions and data visualization.:)
Restore
April 28, 2022, at 02:32 PM by 10.35.117.248 -
Added lines 1-103:
(:title Quiz: Excel Plots and Functions:)
(:keywords quiz, test, Python, variable, expression, introduction, course:)
(:description Learning assessment on Introduction to Python with variables and expressions.:)

----

'''1.''' In Excel, the Cosine function COS(x) requires the value of "x" in:

->'''A.''' Radians

-->(:toggle hide q1a button show="Select":)
(:div id=q1a:)
-->%blue%Correct.%%  Excel uses radians for trigonometric functions.
(:divend:)

->'''B.''' Degrees

-->(:toggle hide q1b button show="Select":)
(:div id=q1b:)
-->%red%Incorrect.%%  Excel uses radians for trigonometric functions.
(:divend:)

->'''C.''' Other

-->(:toggle hide q1c button show="Select":)
(:div id=q1c:)
-->%red%Incorrect.%%  Excel uses radians for trigonometric functions.
(:divend:)

----

'''2.''' The Excel function COUNT(A, B, ...)

->'''A.''' Reports the number of cells in a range.

-->(:toggle hide q2a button show="Select":)
(:div id=q2a:)
-->%red%Incorrect.%%  The function counts only the numeric cells in a range, not the total number of cells.
(:divend:)

->'''B.''' Reports the number of numeric cells in a range.

-->(:toggle hide q2b button show="Select":)
(:div id=q2b:)
-->%blue%Correct.%%  The COUNT function is for numeric values only.
(:divend:)

->'''C.''' Reports the number of non-numeric cells in a range.

-->(:toggle hide q2c button show="Select":)
(:div id=q2c:)
-->%red%Incorrect.%%  The COUNT function is for numeric values only.
(:divend:)

----

'''3.''' What type of plot is commonly used to explore the relationship between two data sets?

->'''A.''' Bar chart

-->(:toggle hide q3a button show="Select":)
(:div id=q3a:)
-->%red%Incorrect.%%  Bar charts show categorical data. It can show two data sets but a scatter plot is better for a direct comparison.
(:divend:)

->'''B.''' Scatter plot

-->(:toggle hide q3b button show="Select":)
(:div id=q3b:)
-->%blue%Correct.%%  Scatter plots show the relationship between two variables where one variable is plotted on the x-axis and the other variable is plotted on the y-axis.
(:divend:)

->'''C.''' Pie chart

-->(:toggle hide q3c button show="Select":)
(:div id=q3c:)
-->%red%Incorrect.%%  Pie charts show fractional data. It can show two data sets but a scatter plot is better for a comparison of two data columns.
(:divend:)

----

'''4.''' If you are plotting multiple data sets on a scatter plot, how can you help distinguish between the data trends if it is printed in black and white? Select all that apply.

->'''A.''' Change the line style so that each is unique with solid, dashed, and dotted.

-->(:toggle hide q4a button show="Select":)
(:div id=q4a:)
-->%blue%Correct.%% Changing the line style does not rely on color to distinguish the trends.
(:divend:)

->'''B.''' Change the point style so that each is unique with square, circle, triangle, diamond, and others.

-->(:toggle hide q4b button show="Select":)
(:div id=q4b:)
-->%blue%Correct.%% Changing the point style does not rely on color to distinguish the trends. If there are too many points then it can mask the line style.
(:divend:)

->'''C.''' Create arrows from each legend entry to point at the associated line.

-->(:toggle hide q4c button show="Select":)
(:div id=q4c:)
-->%blue%Correct.%% This works well, especially if there is no overlay in the trends.
(:divend:)
Restore