C268 WGU Exam with 100% Correct Answers 2023

Match the way information can be displayed in a spreadsheet with the type of information to be displayed. - Correct answer-In rows: 5,6 and 7 In columns: AA, BB, CA In clip art: 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. Match the category with its type of function. - Correct answer-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? - Correct answer-They can be a negative number. What two options are possible under "review" on the Excel ribbon? - Correct answerTrack Changes Protect Sheet An administer wishes to display the number $3.10 in Cell A4. How can this goal be met? - Correct answer-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? - Correct answer-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. 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-Click anywhere in the table, click the sort icon, click the name in the sort by drop box, 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 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". 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 patients 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, and then click on the strep throat option. 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 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? - Correct answer-=C4*A$1 (A1) Name - (B1) Sales - (C1) Commission (A2) Rep 1 - (B2) 12500 - (C2) (A3) Rep 2 - (B3) 15000 - (C3) (A4) Rep 3 - (B4) 17000 - (C4) The commission percent of 2% is located in cell A5. What should the formula be in cell C2 in order to calculate commission dollars and enable copying to cells C3 and C4? - Correct answer-=A$5*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 a table: name, age, hanicap, and score. Using the score column which function will yield the number of scores returned? - Correct answer-Total A table includes information about 1,000 adults who will be attending a sporting event. One column indicates the number of children who will be attending with each adult. If no children will be attending, the column contain an "N" for none. Which function returns the total number of children for all adults attending the event? - Correct answer-COUNT A table with information from a random survey includes a column indicating the age of the participants for 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 employees annual salary. The president of the company would like to know the total salary paid annually by the company. Which function will provide this information? - Correct answer-SUM An Individual wants to buy a boat. To obtain the money, the individual decides to save $100 per month at 5% interest rate. Which function will determine how much money the individual will have at the end of two years? - Correct answer-FV A client wants to borrow $10,000 and pay $200 per month over 5 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) An individual agrees to pay a friend $250 per month for 36 months at an interest rate of 4.99%. Which function will provide value of these payments? - Correct answer-=NPV An individual wants to purchase a golf cart from a neighbor fro %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 payments will be needed to complete the purchase. - Correct answer-=NPER