WGU D547 TASK EXCEL CERTIFICATION
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ To print more than one copy of your receipt which tab would you go to.
Answer: File
◍ Project 7/7 - Task 2.
Answer: On the Employee Bonuses worksheet, use Autofill to copy the
formula in cell G4 to calculate the Total Compensation for each employee.1.
On the Employee Bonuses worksheet, select cell G4.2. In the lower-right
corner of cell G4, click-drag the fill handle down the Total Compensation
column, beginning with cell G4 and ending with G11.
◍ To select a single worksheet cell so you can work with it, which of the
following would you do.
Answer: Click the cell
◍ Which of the following statements is true about counts functions.
Answer: The count function return is the number of calls in the range that
contains numeric data
◍ When you copy and paste a formula to a new location, the formulas relative
reference do not change.
Answer: False
◍ Project 5/7 - Task 3.
Answer: Configure Excel to always print cell range A1:F17 on the Q1 Sales
worksheet.1. On the Q1 Sales worksheet, select cell range A1:F17.2. Click
the Page Layout tab.3. In the Page Setup group, click Print Area and select
Set Print Area.
,◍ Project 2/7 - Overview.
Answer: Camping SuppliesA discount camping supply store is creating an
inventory report. They need help with charts, hyperlinks, and conditional
formatting. You've been asked to assist.
◍ Which of the following Option should one choose to prompt Excel to
calculate all open workbooks manually.
Answer: F9
◍ To print worksheet contents across the length of the page you can use
portrait orientation.
Answer: False
◍ Project 7/7 - Task 1.
Answer: On the Employee Bonuses worksheet, insert a mixed reference in
cell F4 so that the formula will correctly calculate the commission when
copied from F4 through F11. Copy the reference down the column to verify
it calculates correctly.1. On the Employee Bonuses worksheet, select cell
F4.2. Insert the mixed reference =B$15*E4 in cell F4.3. Click and drag the
fill handle in the lower-right corner of cell F4 down the Commission
column, beginning with cell F4 and ending with cell F11.
◍ Which of the following will you select as X in the following series of clicks
to Vance the chart style: chart > chart style > X > any chart style.
Answer: Style
◍ To apply a cell style you would use the cell styles command on the _ tab.
Answer: Home
◍ To have XL into the lowest price from a range of prices, which of the
following would you use.
Answer: MIN function
◍ When should you use relative cell reference.
Answer: When you want to preserve the relationship to the formula location
◍ To combine multiple cells into one combined cel which of the following do
, you use.
Answer: Merge and center button
◍ Project 5/7 - Task 2.
Answer: Add the Status of Draft to the document properties.1. Click the File
tab.2. In the bottom-right corner of the Info page, click the Show All
Properties link.3. In the Status field, type Draft.4. Click the return arrow in
the upper-left corner of the Info window to display the document.
◍ What features inserts a function that totals the cells above or to the left of
the selected cell.
Answer: AutoSum button
◍ To format a range so that all values greater than $500 appear in red, which
of the following can you use.
Answer: Conditional formatting
◍ To customize the status bar, right click on the status bar to open the
Customize Status Bar menu and uncheck the items that you don't want to
show.
Answer: True
◍ Which of the following is true about entering the function using the answer
function dialog box.
Answer: Search , dont need, select a function
◍ Project 7/7 - Task 4.
Answer: On the Parts worksheet, change the table's style to White, Table
Style Medium 1.1. At the bottom of the workbook, click the Parts worksheet
tab.2. Click anywhere within the table to select it.3. On the Home tab, in the
Styles group, click Format as Table and select White, Table Style Medium
1.(Hint: An alternate method is to click on the Table Tools Design tab. In
the Table Styles group, click the More down arrow to open the Table Styles
gallery. Beneath the Medium section, select White, Table Style Medium 1.)
◍ Which of the following tabs let you set worksheet print option.
Answer: File
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ To print more than one copy of your receipt which tab would you go to.
Answer: File
◍ Project 7/7 - Task 2.
Answer: On the Employee Bonuses worksheet, use Autofill to copy the
formula in cell G4 to calculate the Total Compensation for each employee.1.
On the Employee Bonuses worksheet, select cell G4.2. In the lower-right
corner of cell G4, click-drag the fill handle down the Total Compensation
column, beginning with cell G4 and ending with G11.
◍ To select a single worksheet cell so you can work with it, which of the
following would you do.
Answer: Click the cell
◍ Which of the following statements is true about counts functions.
Answer: The count function return is the number of calls in the range that
contains numeric data
◍ When you copy and paste a formula to a new location, the formulas relative
reference do not change.
Answer: False
◍ Project 5/7 - Task 3.
Answer: Configure Excel to always print cell range A1:F17 on the Q1 Sales
worksheet.1. On the Q1 Sales worksheet, select cell range A1:F17.2. Click
the Page Layout tab.3. In the Page Setup group, click Print Area and select
Set Print Area.
,◍ Project 2/7 - Overview.
Answer: Camping SuppliesA discount camping supply store is creating an
inventory report. They need help with charts, hyperlinks, and conditional
formatting. You've been asked to assist.
◍ Which of the following Option should one choose to prompt Excel to
calculate all open workbooks manually.
Answer: F9
◍ To print worksheet contents across the length of the page you can use
portrait orientation.
Answer: False
◍ Project 7/7 - Task 1.
Answer: On the Employee Bonuses worksheet, insert a mixed reference in
cell F4 so that the formula will correctly calculate the commission when
copied from F4 through F11. Copy the reference down the column to verify
it calculates correctly.1. On the Employee Bonuses worksheet, select cell
F4.2. Insert the mixed reference =B$15*E4 in cell F4.3. Click and drag the
fill handle in the lower-right corner of cell F4 down the Commission
column, beginning with cell F4 and ending with cell F11.
◍ Which of the following will you select as X in the following series of clicks
to Vance the chart style: chart > chart style > X > any chart style.
Answer: Style
◍ To apply a cell style you would use the cell styles command on the _ tab.
Answer: Home
◍ To have XL into the lowest price from a range of prices, which of the
following would you use.
Answer: MIN function
◍ When should you use relative cell reference.
Answer: When you want to preserve the relationship to the formula location
◍ To combine multiple cells into one combined cel which of the following do
, you use.
Answer: Merge and center button
◍ Project 5/7 - Task 2.
Answer: Add the Status of Draft to the document properties.1. Click the File
tab.2. In the bottom-right corner of the Info page, click the Show All
Properties link.3. In the Status field, type Draft.4. Click the return arrow in
the upper-left corner of the Info window to display the document.
◍ What features inserts a function that totals the cells above or to the left of
the selected cell.
Answer: AutoSum button
◍ To format a range so that all values greater than $500 appear in red, which
of the following can you use.
Answer: Conditional formatting
◍ To customize the status bar, right click on the status bar to open the
Customize Status Bar menu and uncheck the items that you don't want to
show.
Answer: True
◍ Which of the following is true about entering the function using the answer
function dialog box.
Answer: Search , dont need, select a function
◍ Project 7/7 - Task 4.
Answer: On the Parts worksheet, change the table's style to White, Table
Style Medium 1.1. At the bottom of the workbook, click the Parts worksheet
tab.2. Click anywhere within the table to select it.3. On the Home tab, in the
Styles group, click Format as Table and select White, Table Style Medium
1.(Hint: An alternate method is to click on the Table Tools Design tab. In
the Table Styles group, click the More down arrow to open the Table Styles
gallery. Beneath the Medium section, select White, Table Style Medium 1.)
◍ Which of the following tabs let you set worksheet print option.
Answer: File
