WGU C268 Spreadsheets | 160 REAL EXAM QUESTIONS WITH 100% RATED CORRECT ANSWERS 2 versions
incuded | 100% VERIFIED | 2025 LATEST UPDATED | GET A+
Version 1
IN Columns - correct answer AA, BB, CA
In Rows - correct answer 5, 6, 7
In clip art - correct answer Images
What is a possible outcome using Boolean logic - correct answer Only the numbers 0 and 1
What is possible in freeze panes - correct answer Freezing the row above where a person is
working
Auto sum - correct answer Count, Number, Max
Logical - correct answer And, Not, OR
Financial - correct answer Duration, Coupdays, Effect
Date and Time - correct answer Weeknum, Weekday
What is true about correlation coefficients when using the Correl function in Excel? - correct
answer They must be a whole number
Which two options are possible under "Review" on the Excel riboon? - correct answer Protect
sheet and Track Changes
An administrator wishes to display the number $3.10 in cell A4. How can this goal be met? -
correct 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? - correct 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? - correct 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? - correct 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? - correct answer Click
anywhere in the table, click the filter button, click the down arrow next to "Industry", and then
select "Manufacturing"
,WGU C268 Spreadsheets | 160 REAL EXAM QUESTIONS WITH 100% RATED CORRECT ANSWERS 2 versions
incuded | 100% VERIFIED | 2025 LATEST UPDATED | GET A+
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? - correct 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? - correct
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? - correct 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? - correct 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? -
correct 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? - correct 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? - correct 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 know the total salary
paid annually by the company. Which function will provide this function? - correct answer SUM
An individual wants to buy a boat. To obtain the money, the individual decides to save $100 per
month at a 5% interest rate. Which function will determine how much money the individual will
have at the end of two years? - correct answer FV = Future Value
A client wants to borrow $10,000 and pay $200 per month over five years to make a capital
purchase. Which function will tell the client the maximum annual interest rate that will meet
this payment budget - correct answer =RATE(60, -200, 10000)
, WGU C268 Spreadsheets | 160 REAL EXAM QUESTIONS WITH 100% RATED CORRECT ANSWERS 2 versions
incuded | 100% VERIFIED | 2025 LATEST UPDATED | GET A+
An individual agrees to pay a friend $250 per month for 36 months at an interest rate of 4.99%.
Which function will provide the present value of these payments? - correct answer NPV = Net
Present Value
An individual wants to purchase a golf cart from a neighbor for $3,500. The neighbor agrees to
accept monthly payments of $100 at an interest rate of 3%. The buyer would like to determine
how many $100 monthly payments will be needed to complete the purchase. Which function
will determine how many $100 monthly payments are needed to complete the purchase? -
correct answer NPER = returns the number of periods for an investment based on periodic,
constant payments and a constant interest.
A company's 4Q 2013 sales are as follows: A1 - Month; B1 - Sales $; A2 - October; B2 - 125,000;
A3 November; B3 142,000; A4 December; B4 162,500 Which two formulas will determine the
minimum monthly sales for the three months? - correct answer =MIN(B2:B4)
=MIN(B2,B3,B4)
Which three formulas will add the sales for 4Q? Info above. - correct answer =SUM(B2,B3,B4)
=+B2+B3+B4
=SUM(B2:B4)
Which two formulas count the number of unique part numbers with a quantity >0 - correct
answer =COUNTA (B2,B3,B4,B5,B,6,B7,B8)
=COUNTA (B2:B8)
Which formula reflects the present value of the investment? B1 - Rate 5%, B2- Years 30, B3 -
Monthly Payment $125.00 - correct answer PV(rate, nper, pmt)
=PV(5%/12,(30x12),15)
=PV(B1/12,B2*12,B3)
Rate - the interest rate, per period
NPER - the number of periods for the lifetime of the annuity or investment
PMT - an optional argument that specifies the payment per period.
The commission rate is stored in cell B2, the commission dollars are in cells D5 through D20.
The formulas to calculate the commission amount is in cells E5 through E20. The sales manager
does not believe the commission amounts is correct and wants to know which formulas
reference cell B2. Which steps should the sales manager take to get the desired information? -
correct answer Click on the Formulas tab, click cell B2, and then click the Trace Precedents icon
incuded | 100% VERIFIED | 2025 LATEST UPDATED | GET A+
Version 1
IN Columns - correct answer AA, BB, CA
In Rows - correct answer 5, 6, 7
In clip art - correct answer Images
What is a possible outcome using Boolean logic - correct answer Only the numbers 0 and 1
What is possible in freeze panes - correct answer Freezing the row above where a person is
working
Auto sum - correct answer Count, Number, Max
Logical - correct answer And, Not, OR
Financial - correct answer Duration, Coupdays, Effect
Date and Time - correct answer Weeknum, Weekday
What is true about correlation coefficients when using the Correl function in Excel? - correct
answer They must be a whole number
Which two options are possible under "Review" on the Excel riboon? - correct answer Protect
sheet and Track Changes
An administrator wishes to display the number $3.10 in cell A4. How can this goal be met? -
correct 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? - correct 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? - correct 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? - correct 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? - correct answer Click
anywhere in the table, click the filter button, click the down arrow next to "Industry", and then
select "Manufacturing"
,WGU C268 Spreadsheets | 160 REAL EXAM QUESTIONS WITH 100% RATED CORRECT ANSWERS 2 versions
incuded | 100% VERIFIED | 2025 LATEST UPDATED | GET A+
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? - correct 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? - correct
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? - correct 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? - correct 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? -
correct 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? - correct 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? - correct 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 know the total salary
paid annually by the company. Which function will provide this function? - correct answer SUM
An individual wants to buy a boat. To obtain the money, the individual decides to save $100 per
month at a 5% interest rate. Which function will determine how much money the individual will
have at the end of two years? - correct answer FV = Future Value
A client wants to borrow $10,000 and pay $200 per month over five years to make a capital
purchase. Which function will tell the client the maximum annual interest rate that will meet
this payment budget - correct answer =RATE(60, -200, 10000)
, WGU C268 Spreadsheets | 160 REAL EXAM QUESTIONS WITH 100% RATED CORRECT ANSWERS 2 versions
incuded | 100% VERIFIED | 2025 LATEST UPDATED | GET A+
An individual agrees to pay a friend $250 per month for 36 months at an interest rate of 4.99%.
Which function will provide the present value of these payments? - correct answer NPV = Net
Present Value
An individual wants to purchase a golf cart from a neighbor for $3,500. The neighbor agrees to
accept monthly payments of $100 at an interest rate of 3%. The buyer would like to determine
how many $100 monthly payments will be needed to complete the purchase. Which function
will determine how many $100 monthly payments are needed to complete the purchase? -
correct answer NPER = returns the number of periods for an investment based on periodic,
constant payments and a constant interest.
A company's 4Q 2013 sales are as follows: A1 - Month; B1 - Sales $; A2 - October; B2 - 125,000;
A3 November; B3 142,000; A4 December; B4 162,500 Which two formulas will determine the
minimum monthly sales for the three months? - correct answer =MIN(B2:B4)
=MIN(B2,B3,B4)
Which three formulas will add the sales for 4Q? Info above. - correct answer =SUM(B2,B3,B4)
=+B2+B3+B4
=SUM(B2:B4)
Which two formulas count the number of unique part numbers with a quantity >0 - correct
answer =COUNTA (B2,B3,B4,B5,B,6,B7,B8)
=COUNTA (B2:B8)
Which formula reflects the present value of the investment? B1 - Rate 5%, B2- Years 30, B3 -
Monthly Payment $125.00 - correct answer PV(rate, nper, pmt)
=PV(5%/12,(30x12),15)
=PV(B1/12,B2*12,B3)
Rate - the interest rate, per period
NPER - the number of periods for the lifetime of the annuity or investment
PMT - an optional argument that specifies the payment per period.
The commission rate is stored in cell B2, the commission dollars are in cells D5 through D20.
The formulas to calculate the commission amount is in cells E5 through E20. The sales manager
does not believe the commission amounts is correct and wants to know which formulas
reference cell B2. Which steps should the sales manager take to get the desired information? -
correct answer Click on the Formulas tab, click cell B2, and then click the Trace Precedents icon
