Fill This Form To Receive Instant Help
Homework answers / question archive / Open the workbook PB Financials
Open the workbook PB Financials.xlsx located in the Documents folder. 
Correct 


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 


MS Excel 2019 
9196 
Select cell H8. 
Correct 


MS Excel 2019 
9197 
Select nonadjacent cells D5, D10, and D13. 
Correct 


MS Excel 2019 
8882 
Rename the Sheet2 worksheet with the new name Sample Budget. 
Correct 


MS Excel 2019 
9014 
Change the zoom level of the worksheet to 80%. 
Correct 


MS Excel 2019 
9013 
Reorder the worksheets so that the Sample Kitchen Budget worksheet is last worksheet in the workbook. 
Correct 


MS Excel 2019 
9204 
Insert a new worksheet to the right of the Sample Budget worksheet. 
Incorrect 


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 


MS Excel 2019 
9000 
Change the value of 13 to 33 in cell D9. 
Correct 


MS Excel 2019 
9203 
Delete the Sample Budget worksheet. 
Correct 


MS Excel 2019 
9004 
Change the font color of cell E12 to Orange, Accent 6, then undo that action. 
Correct 


MS Excel 2019 
9237 
In cell F3, enter the value 2024 as text using the keyboard or keypad. 
Incorrect 


MS Excel 2019 
9240 
Enter the number 55000 in cell C7. 
Correct 


MS Excel 2019 
8861 
Change the width of column D to exactly 25 characters. 
Correct 


MS Excel 2019 
8862 
Use AutoFit to adjust the width of column D so all cell content is visible. 
Correct 


MS Excel 2019 
8883 
Wrap the text in cell A4 so that all the text is visible in the cell. 
Incorrect 


MS Excel 2019 
8994 
Change the height of row 3 to approximately 30 points (40 pixels). 
Correct 


MS Excel 2019 
8869 
Without using parentheses, enter a formula in cell F4 that determines the Projected 2022 TakeHome 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 


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 


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 


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 


MS Excel 2019 
9199 
Move the contents of cell G9 to cell A11. 
Correct 


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 


MS Excel 2019 
10132 
Cut and paste the contents of cell A18 into cell A15. 
Correct 


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


MS Excel 2019 
9217 
Insert a new column to the left of column D. 
Correct 


MS Excel 2019 
10129 
Insert a new row above row 9. 
Correct 


MS Excel 2019 
10130 
Delete row 8 in the worksheet. 
Correct 


MS Excel 2019 
8997 
Clear the contents of cell B8. 
Correct 


MS Excel 2019 
10947 
Clear the formatting from cell C6. 
Correct 


MS Excel 2019 
9201 
Hide column C. 
Correct 


MS Excel 2019 
9202 
Hide the Sample Budget worksheet, and then unhide the Sample Budget worksheet. 
Correct 


MS Excel 2019 
9005 
Use Flash Fill to fill range C4:C20 after typing LongKT in cell C4 and Han in cell C5. 
Incorrect 


MS Excel 2019 
8990 
Apply a Top and Double Bottom Border to range A12:D12. 
Correct 


MS Excel 2019 
10941 
Change the view of the Workshop Participants worksheet to Page Layout view. 
Correct 


MS Excel 2019 
8867 
Change the page orientation of the current worksheet to Portrait. 
Correct 


MS Excel 2019 
10110 
Change the scale of the worksheet to 85%. 
Correct 


MS Excel 2019 
9016 
Print range B3:D11. 
Incorrect 


MS Excel 2019 
10108 
Print the Attendance worksheet. 
Correct 


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