Quiz: Excel Basics

Main.ExcelQuiz1 History

Hide minor edits - Show changes to markup

May 17, 2022, at 03:13 AM by 136.36.4.38 -
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?

Restore
May 17, 2022, at 03:13 AM by 136.36.4.38 -
Added lines 79-80:
Restore
April 28, 2022, at 02:54 PM by 10.35.117.248 -
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":)
Restore
April 28, 2022, at 02:41 PM by 10.35.117.248 -
Changed lines 1-4 from:

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

to:

(:title Quiz: 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
to:

1. What a spreadsheet workbook?

A. An individual spreadsheet page
Changed line 13 from:
Correct. Excel uses radians for trigonometric functions.
to:
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:
Incorrect. Excel uses radians for trigonometric functions.
to:
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:
Incorrect. Excel uses radians for trigonometric functions.
to:
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":)
to:

2. What a spreadsheet worksheet?

A. An individual spreadsheet page
(:toggle hide q1a button show="Select":)
Changed line 38 from:
Incorrect. The function counts only the numeric cells in a range, not the total number of cells.
to:
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":)
to:
B. A collection of spreadsheet pages
(:toggle hide q1b button show="Select":)
Changed line 45 from:
Correct. The COUNT function is for numeric values only.
to:
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":)
to:
C. A data cell within a spreadsheet
(:toggle hide q1c button show="Select":)
Changed line 52 from:
Incorrect. The COUNT function is for numeric values only.
to:
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
to:

3. What is the symbol to create an absolute cell reference?

A. The hash symbol (#)
Changed line 63 from:
Incorrect. Bar charts show categorical data. It can show two data sets but a scatter plot is better for a direct comparison.
to:
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:
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:
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:
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.
to:
Incorrect. The $ sign before the row or column coordinates makes an absolute cell reference.
Restore
April 26, 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