C268 WGU QUESTIONS & ANSWERS
Match the way information can be displayed in a spreadsheet with the type of
information to be displayed. - Answers - In rows: 5,6 and 7
In columns: AA, BB, CA
In clip art: Images
What is a possible outcome using Boolean Logic? - Answers - Only the numbers 0 and
1.
What is possible in freeze panes? - Answers - Freezing the row above where a person
is working.
Match the category with its type of function. - Answers - Logical: AND, NOR, OR
Auto Sum: COUNT, NUMBER, MAX
Date and Time: WEEKNUM, WEEKDAY
Financial: DURATION, COUPDAYS, EFFECT
What is true about correlation coefficients when using the CORREL function in Excel? -
Answers - They can be a negative number.
What two options are possible under "review" on the Excel ribbon? - Answers - Track
Changes
Protect Sheet
An administer wishes to display the number $3.10 in Cell A4. How can this goal be met?
- Answers - Select A4, select the currency category, then enter the number 3.1.
A student noted a correlation between hours of studying and test grades. The student
decides to track this correlation using the CORREL function in Excel.
How should this be set up? - Answers - By setting up hours in array A and grades in
array B, and the using the CORREL function.
A student wants to have text appear in Excel as it would in a business document, with
all of the text starting on the left-hand side.
The accountant for a company wants to create a spreadsheet to calculate sales
markup. The costs for these items are located in cells C4 through C30, and the markup
percent is located in cell A1. The formual for the markup will be in the rand D4 through
D30.
What does the formual in cell D4 have to be in order to copy it into cells D5 through
D30? - Answers - =C4*A$1
Match the way information can be displayed in a spreadsheet with the type of
information to be displayed. - Answers - In rows: 5,6 and 7
In columns: AA, BB, CA
In clip art: Images
What is a possible outcome using Boolean Logic? - Answers - Only the numbers 0 and
1.
What is possible in freeze panes? - Answers - Freezing the row above where a person
is working.
Match the category with its type of function. - Answers - Logical: AND, NOR, OR
Auto Sum: COUNT, NUMBER, MAX
Date and Time: WEEKNUM, WEEKDAY
Financial: DURATION, COUPDAYS, EFFECT
What is true about correlation coefficients when using the CORREL function in Excel? -
Answers - They can be a negative number.
What two options are possible under "review" on the Excel ribbon? - Answers - Track
Changes
Protect Sheet
An administer wishes to display the number $3.10 in Cell A4. How can this goal be met?
- Answers - Select A4, select the currency category, then enter the number 3.1.
A student noted a correlation between hours of studying and test grades. The student
decides to track this correlation using the CORREL function in Excel.
How should this be set up? - Answers - By setting up hours in array A and grades in
array B, and the using the CORREL function.
A student wants to have text appear in Excel as it would in a business document, with
all of the text starting on the left-hand side.
The accountant for a company wants to create a spreadsheet to calculate sales
markup. The costs for these items are located in cells C4 through C30, and the markup
percent is located in cell A1. The formual for the markup will be in the rand D4 through
D30.
What does the formual in cell D4 have to be in order to copy it into cells D5 through
D30? - Answers - =C4*A$1
