WGU C268 SPREADSHEETS C268 COMPLETE FINAL OA 200
EXAM QUESTIONS AND ANSWERS
IN Columns - ANSWER: AA, BB, CA
In Rows - ANSWER: 5, 6, 7
In clip art - ANSWER: Images
What is a possible outcome using Boolean logic - ANSWER: Only the numbers 0 and 1
What is possible in freeze panes - ANSWER: Freezing the row above where a person
is working
Auto sum - ANSWER: Count, Number, Max
Logical - ANSWER: And, Not, OR
Financial - ANSWER: Duration, Coupdays, Effect
Date and Time - ANSWER: Weeknum, Weekday
What is true about correlation coefficients when using the Correl function in Excel? -
ANSWER: They must be a whole number
Which two options are possible under "Review" on the Excel riboon? - ANSWER:
Protect sheet and Track Changes
An administrator wishes to display the number $3.10 in cell A4. How can this goal be
met? - ANSWER: Select cell 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 coefficient in Excel. How should this be set
up? - ANSWER: By setting up hours in array A and grades in arrow B, then 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. Which group on the homepage
should be used to accomplish this goal? - ANSWER: Alignment
A manager has a spreadsheet table with company name, stock prices, and sales
dollars. What should the manager do to sort this table by name and then by sales
dollars, from largest to smallest? - ANSWER: Clink anywhere in the table, click the
, sort icon, click the name in the sort by dropbox, then click "then by" and choose
"sales dollars largest to smallest"
The following data is in an Excel Spreadsheet: Company A-Manufacturing-
$22,000,000; Company B - Industrial - $12,000,000; Company C - Manufacturing -
$14,000,000. Which steps will display only the information for the manufacturing
industry? - ANSWER: Click anywhere in the table, click the filter button, click the
down arrow next to "Industry", and then select "Manufacturing"
A doctor wants to know how many patients she has seen this month and their
diagnoses. The doctor's assistant puts together a report showing each patient's
name in column A and diagnosis in column B. Which steps should the assistant take
to obtain a list of patients who have been diagnosed with strep throat? - ANSWER:
Click in the report, click the filter icon, click the down arrow for the diagnosis
column,
Cell B3 contains a formula that multiply cells B1 and B2. Which formula is in cell B3? -
ANSWER: =B1*B2
The accountant for a company wants to create a spreadsheet to calculate sales
markup. The costs of these items are located in cells C4 through C30, and the
markup percent is located in cell A1. The formula for the markup will be in the range
D4 through D30. What does the formula in cell D4 have to be in order to copy it into
cells D5 through D30? - ANSWER: =C4+$A1
(A1) Name (B1) Sales $ (C1) Commission $ (A2) Rep 1 (B2) $12,500 (C2) (A3) Rep 2
(B3) $15,000 (C3) (A4) Rep 3 (B4) $17,000 (C4) The commission percent of 2% is
located in cell A5. What should the fomula be in cell C2 in order to calculate
commission dollars and enable copying to cells C3 and C4? - ANSWER: =A5+$B2
A local golf course held a charity tournament that was open to all ages. The following
information was gathered about the golfers and presented in a table: name, age,
handicap, and score. Using the score column, which function will yield the number of
scores returned? - ANSWER: COUNT
A table included information about 1,000 adults who will be attending a sporting
event. One column indicated the number of children who will be attending with each
adult. If no children will be attending, the column contains an "N" for none. Which
function returns the total number of children for all adults attending the event? -
ANSWER: SUM
A table with information from a random survey indicating the age of the participants
or an "N' for "no response". Which function will return the number of people
surveyed who responded with their age? - ANSWER: COUNT
A table with information on a company's employee population includes a column
with each employee's annual salary. The president of the company would like to
EXAM QUESTIONS AND ANSWERS
IN Columns - ANSWER: AA, BB, CA
In Rows - ANSWER: 5, 6, 7
In clip art - ANSWER: Images
What is a possible outcome using Boolean logic - ANSWER: Only the numbers 0 and 1
What is possible in freeze panes - ANSWER: Freezing the row above where a person
is working
Auto sum - ANSWER: Count, Number, Max
Logical - ANSWER: And, Not, OR
Financial - ANSWER: Duration, Coupdays, Effect
Date and Time - ANSWER: Weeknum, Weekday
What is true about correlation coefficients when using the Correl function in Excel? -
ANSWER: They must be a whole number
Which two options are possible under "Review" on the Excel riboon? - ANSWER:
Protect sheet and Track Changes
An administrator wishes to display the number $3.10 in cell A4. How can this goal be
met? - ANSWER: Select cell 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 coefficient in Excel. How should this be set
up? - ANSWER: By setting up hours in array A and grades in arrow B, then 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. Which group on the homepage
should be used to accomplish this goal? - ANSWER: Alignment
A manager has a spreadsheet table with company name, stock prices, and sales
dollars. What should the manager do to sort this table by name and then by sales
dollars, from largest to smallest? - ANSWER: Clink anywhere in the table, click the
, sort icon, click the name in the sort by dropbox, then click "then by" and choose
"sales dollars largest to smallest"
The following data is in an Excel Spreadsheet: Company A-Manufacturing-
$22,000,000; Company B - Industrial - $12,000,000; Company C - Manufacturing -
$14,000,000. Which steps will display only the information for the manufacturing
industry? - ANSWER: Click anywhere in the table, click the filter button, click the
down arrow next to "Industry", and then select "Manufacturing"
A doctor wants to know how many patients she has seen this month and their
diagnoses. The doctor's assistant puts together a report showing each patient's
name in column A and diagnosis in column B. Which steps should the assistant take
to obtain a list of patients who have been diagnosed with strep throat? - ANSWER:
Click in the report, click the filter icon, click the down arrow for the diagnosis
column,
Cell B3 contains a formula that multiply cells B1 and B2. Which formula is in cell B3? -
ANSWER: =B1*B2
The accountant for a company wants to create a spreadsheet to calculate sales
markup. The costs of these items are located in cells C4 through C30, and the
markup percent is located in cell A1. The formula for the markup will be in the range
D4 through D30. What does the formula in cell D4 have to be in order to copy it into
cells D5 through D30? - ANSWER: =C4+$A1
(A1) Name (B1) Sales $ (C1) Commission $ (A2) Rep 1 (B2) $12,500 (C2) (A3) Rep 2
(B3) $15,000 (C3) (A4) Rep 3 (B4) $17,000 (C4) The commission percent of 2% is
located in cell A5. What should the fomula be in cell C2 in order to calculate
commission dollars and enable copying to cells C3 and C4? - ANSWER: =A5+$B2
A local golf course held a charity tournament that was open to all ages. The following
information was gathered about the golfers and presented in a table: name, age,
handicap, and score. Using the score column, which function will yield the number of
scores returned? - ANSWER: COUNT
A table included information about 1,000 adults who will be attending a sporting
event. One column indicated the number of children who will be attending with each
adult. If no children will be attending, the column contains an "N" for none. Which
function returns the total number of children for all adults attending the event? -
ANSWER: SUM
A table with information from a random survey indicating the age of the participants
or an "N' for "no response". Which function will return the number of people
surveyed who responded with their age? - ANSWER: COUNT
A table with information on a company's employee population includes a column
with each employee's annual salary. The president of the company would like to
