WGU C268 SPREADSHEETS C268 COMPLETE
FINAL OA 200 EXAM QUESTIONS AND
ANSWERS | VERIFIED ANSWERS LATEST
UPDATE 2022-2023
Match the way information can be displayed in a spreadsheet with the
type of information to be displayed. - ANSWER- In rows: 5,6 and 7
In columns: AA, BB, CA
In clip art: 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.
Match the category with its type of function. - 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? - ANSWER- They can be a negative number.
What two options are possible under "review" on the Excel ribbon? - ANSWER- Track Changes Protect Sheet
- / 3
An administer wishes to display the number $3.10 in Cell A4. How can this goal be met? - 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? - 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? - 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- 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? - ANSWER- Click anywhere in the table, click the filter button, click the down arrow next to "industry", and then select "Manufacturing".
- / 3
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? - 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? - 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? - 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? - 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? - ANSWER- Total
- / 3