Quiz: Excel Plots and Functions

Main.ExcelQuiz2 History

Hide minor edits - Show changes to markup

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:)

Correct. Excel uses radians for trigonometric functions.

(:divend:)

B. Degrees
(:toggle hide q1b button show="Select":)

(:div id=q1b:)

Incorrect. Excel uses radians for trigonometric functions.

(:divend:)

C. Other
(:toggle hide q1c button show="Select":)

(:div id=q1c:)

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:)

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:)

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:)

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:)

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:)

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:)

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:)

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:)

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:)

Correct. This works well, especially if there is no overlay in the trends.

(:divend:)

Restore