Quiz: Excel Basics
Main.ExcelQuiz1 History
Hide minor edits - Show changes to output
Changed lines 7-8 from:
'''1.''' What a spreadsheet ''workbook''?
to:
'''1.''' What is a spreadsheet ''workbook''?
Changed line 32 from:
'''2.''' What a spreadsheet ''worksheet''?
to:
'''2.''' What is a spreadsheet ''worksheet''?
Changed line 36 from:
-->(:toggle hide q1a button show="Select":)
to:
-->(:toggle hide q2a button show="Select":)
Changed line 43 from:
-->(:toggle hide q1b button show="Select":)
to:
-->(:toggle hide q2b button show="Select":)
Changed line 50 from:
-->(:toggle hide q1c button show="Select":)
to:
-->(:toggle hide q2c button show="Select":)
Changed lines 1-4 from:
(:title Quiz: Excel Plots and Functions:)
(:keywords quiz, test,Python, variable, expression, introduction, course:)
(:description Learning assessment onIntroduction to Python with variables and expressions.:)
(:keywords quiz, test,
(:description Learning assessment on
to:
(:title Quiz: Excel Basics:)
(:keywords quiz, test, Excel, variable, expression, introduction, course:)
(:description Learning assessment on Excel Basics.:)
(:keywords quiz, test, Excel, variable, expression, introduction, course:)
(:description Learning assessment on Excel Basics.:)
Changed lines 7-10 from:
'''1.''' In Excel, the Cosine function COS(x) requires the value of "x" in:
->'''A.''' Radians
->'''A.''' Radians
to:
'''1.''' What a spreadsheet ''workbook''?
->'''A.''' An individual spreadsheet page
->'''A.''' An individual spreadsheet page
Changed line 13 from:
-->%blue%Correct.%% Excel uses radians for trigonometric functions.
to:
-->%red%Incorrect.%% One or more spreadsheet pages are in a workbook.
Changed lines 16-17 from:
->'''B.''' Degrees
to:
->'''B.''' A collection of spreadsheet pages
Changed line 20 from:
-->%red%Incorrect.%% Excel uses radians for trigonometric functions.
to:
-->%blue%Correct.%% A workbook is a collection of spreadsheet pages.
Changed lines 23-24 from:
->'''C.''' Other
to:
->'''C.''' A data cell within a spreadsheet
Changed line 27 from:
-->%red%Incorrect.%% Excel uses radians for trigonometric functions.
to:
-->%red%Incorrect.%% There are many data cells in a worksheet. Several worksheets are in a workbook.
Changed lines 32-36 from:
'''2.''' The Excel function COUNT(A, B, ...)
->'''A.''' Reports the number of cells in a range.
-->(:toggle hide q2a button show="Select":)
->
-->(:toggle hide q2a
to:
'''2.''' What a spreadsheet ''worksheet''?
->'''A.''' An individual spreadsheet page
-->(:toggle hide q1a button show="Select":)
->'''A.''' An individual spreadsheet page
-->(:toggle hide q1a button show="Select":)
Changed line 38 from:
-->%red%Incorrect.%% The function counts only the numeric cells in a range, not the total number of cells.
to:
-->%blue%Correct.%% A worksheet is an individual page in a workbook.
Changed lines 41-43 from:
->'''B.''' Reports the number of numeric cells in a range.
-->(:toggle hide q2b button show="Select":)
-->(:toggle hide q2b
to:
->'''B.''' A collection of spreadsheet pages
-->(:toggle hide q1b button show="Select":)
-->(:toggle hide q1b button show="Select":)
Changed line 45 from:
-->%blue%Correct.%% The COUNT function is for numeric values only.
to:
-->%red%Incorrect.%% A workbook is a collection of spreadsheet pages or worksheets.
Changed lines 48-50 from:
->'''C.''' Reports the number of non-numeric cells in a range.
-->(:toggle hide q2c button show="Select":)
-->(:toggle hide q2c
to:
->'''C.''' A data cell within a spreadsheet
-->(:toggle hide q1c button show="Select":)
-->(:toggle hide q1c button show="Select":)
Changed line 52 from:
-->%red%Incorrect.%% The COUNT function is for numeric values only.
to:
-->%red%Incorrect.%% There are many data cells in a worksheet.
Changed lines 57-60 from:
'''3.''' What type of plot is commonly used to explore the relationship between two data sets?
->'''A.'''Bar chart
->'''A.'''
to:
'''3.''' What is the symbol to create an absolute cell reference?
->'''A.''' The hash symbol (#)
->'''A.''' The hash symbol (#)
Changed line 63 from:
-->%red%Incorrect.%% Bar charts show categorical data. It can show two data sets but a scatter plot is better for a direct comparison.
to:
-->%red%Incorrect.%% The $ sign before the row or column coordinates makes an absolute cell reference.
Changed lines 66-67 from:
->'''B.''' Scatter plot
to:
->'''B.''' The dollar symbol ($)
Changed line 70 from:
-->%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.
to:
-->%blue%Correct.%% The $ sign before the row or column coordinates makes an absolute cell reference.
Changed lines 73-74 from:
->'''C.''' Pie chart
to:
->'''C.''' An exclamation mark (!)
Changed lines 77-102 from:
(: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.
to:
-->%red%Incorrect.%% The $ sign before the row or column coordinates makes an absolute cell reference.
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:)
(: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:)