Open the workbook PB Financials.xlsx located in the Documents folder.

Correct

Open a workbook.

MS Excel 2019

9994

Use the Tell Me box to change the Fill Color of cells in range A3:C3 to Orange, Accent 6, Lighter 60% (Theme Colors, third row, last option).

Correct

Use the Tell Me box.

MS Excel 2019

9196

Select cell H8.

Correct

Select a cell.

MS Excel 2019

9197

Select non-adjacent cells D5, D10, and D13.

Correct

Select non-adjacent cells.

MS Excel 2019

8882

Rename the Sheet2 worksheet with the new name Sample Budget.

Correct

Rename a worksheet.

MS Excel 2019

9014

Change the zoom level of the worksheet to 80%.

Correct

Zoom a worksheet.

MS Excel 2019

9013

Reorder the worksheets so that the Sample Kitchen Budget worksheet is last worksheet in the workbook.

Correct

Move worksheets.

MS Excel 2019

9204

Insert a new worksheet to the right of the Sample Budget worksheet.

Incorrect

Insert a new worksheet.

MS Excel 2019

9222

Copy the Sample Kitchen Budget worksheet to the current workbook, placing the copied worksheet at the end of the workbook.

Incorrect

Copy a worksheet.

MS Excel 2019

9000

Change the value of 13 to 33 in cell D9.

Correct

Edit cell contents.

MS Excel 2019

9203

Delete the Sample Budget worksheet.

Correct

Delete a worksheet.

MS Excel 2019

9004

Change the font color of cell E12 to Orange, Accent 6, then undo that action.

Correct

Undo an action.

MS Excel 2019

9237

In cell F3, enter the value 2024 as text using the keyboard or keypad.

Incorrect

Enter a number as text.

MS Excel 2019

9240

Enter the number 55000 in cell C7.

Correct

Enter a number into a cell.

MS Excel 2019

8861

Change the width of column D to exactly 25 characters.

Correct

Change a column width to an exact value.

MS Excel 2019

8862

Use AutoFit to adjust the width of column D so all cell content is visible.

Correct

Format a column using Autofit.

MS Excel 2019

8883

Wrap the text in cell A4 so that all the text is visible in the cell.

Incorrect

Wrap text in a cell.

MS Excel 2019

8994

Change the height of row 3 to approximately 30 points (40 pixels).

Correct

Change a row height to an approximate value.

MS Excel 2019

8869

Without using parentheses, enter a formula in cell F4 that determines the Projected 2022 Take-Home Pay for the employee by taking the value in cell C4, adding the product of cell C4 multiplied by cell D4, and then subtracting the value in cell E4.

Incorrect

Create a formula using arithmetic operators.

MS Excel 2019

8870

Enter a formula using arithmetic operators and parentheses in cell D11 that adds the number of participants in cells D4, D5, D6, and D7, and then multiplies that result by 12.

Incorrect

Create a formula using order of operations.

MS Excel 2019

9001

In cell D13, use the keyboard to enter a formula that uses the SUM function to calculate the total of the values in range D4:D11.

Incorrect

Use the keyboard to enter a formula that uses a function.

MS Excel 2019

9223

In cell E10, create a formula by entering cell references that adds cells B9 and B10, and then subtracts cell E8.

Incorrect

Enter a formula by selecting cells.

MS Excel 2019

9199

Move the contents of cell G9 to cell A11.

Correct

Move cell contents.

MS Excel 2019

8872

In cell F18, create a formula using the COUNT function to count the number of values in the range F4:F16.

Incorrect

Create a formula using the COUNT function.

MS Excel 2019

10132

Cut and paste the contents of cell A18 into cell A15.

Correct

Cut and paste cell contents.

MS Excel 2019

8878

In cell E12, create a formula using the SUM function to total the values in the range E4:E11.

Correct

Create a formula using the SUM function.

MS Excel 2019

9217

Insert a new column to the left of column D.

Correct

Insert a column.

MS Excel 2019

10129

Insert a new row above row 9.

Correct

Insert a row.

MS Excel 2019

10130

Delete row 8 in the worksheet.

Correct

Delete a row.

MS Excel 2019

8997

Clear the contents of cell B8.

Correct

Clear cell contents.

MS Excel 2019

10947

Clear the formatting from cell C6.

Correct

Clear cell formatting.

MS Excel 2019

9201

Hide column C.

Correct

Hide a column.

MS Excel 2019

9202

Hide the Sample Budget worksheet, and then unhide the Sample Budget worksheet.

Correct

Hide a worksheet.

MS Excel 2019

9005

Use Flash Fill to fill range C4:C20 after typing LongKT in cell C4 and Han in cell C5.

Incorrect

Use Flash Fill.

MS Excel 2019

8990

Apply a Top and Double Bottom Border to range A12:D12.

Correct

Add a border to cells.

MS Excel 2019

10941

Change the view of the Workshop Participants worksheet to Page Layout view.

Correct

Change worksheet views.

MS Excel 2019

8867

Change the page orientation of the current worksheet to Portrait.

Correct

Change the page orientation.

MS Excel 2019

10110

Change the scale of the worksheet to 85%.

Correct

Scale a worksheet for printing.

MS Excel 2019

9016

Print range B3:D11.

Incorrect

Print a section of a worksheet.

MS Excel 2019

10108

Print the Attendance worksheet.

Correct

Print a worksheet.

MS Excel 2019

9006

In cell E4, enter a formula using relative cell references that multiplies cell C4 by cell D4.