Open the workbook PB Financials

Subject:MS ExcelPrice: Bought3

Share With

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	•   Introducing Excel and Spreadsheets EX 1-6	Use the Tell Me box.
MS Excel 2019	9196	Select cell H8.	Correct	•   Exploring a Workbook EX 1-12	Select a cell.
MS Excel 2019	9197	Select non-adjacent cells D5, D10, and D13.	Correct	•   Exploring a Workbook EX 1-13	Select non-adjacent cells.
MS Excel 2019	8882	Rename the Sheet2 worksheet with the new name Sample Budget.	Correct	•   Creating a Table of Figures EX 1-16	Rename a worksheet.
MS Excel 2019	9014	Change the zoom level of the worksheet to 80%.	Correct	•   Updating Fields before Printing EX 1-16	Zoom a worksheet.
MS Excel 2019	9013	Reorder the worksheets so that the Sample Kitchen Budget worksheet is last worksheet in the workbook.	Correct	•   Updating Fields before Printing EX 1-17	Move worksheets.
MS Excel 2019	9204	Insert a new worksheet to the right of the Sample Budget worksheet.	Incorrect	•   Working in Outline View EX 1-17	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	•   Checking Compatibility EX 1-17	Copy a worksheet.
MS Excel 2019	9000	Change the value of 13 to 33 in cell D9.	Correct	•   Making a Document Read-Only EX 1-18	Edit cell contents.
MS Excel 2019	9203	Delete the Sample Budget worksheet.	Correct	•   Working in Outline View EX 1-18	Delete a worksheet.
MS Excel 2019	9004	Change the font color of cell E12 to Orange, Accent 6, then undo that action.	Correct	•   Entering Text, Dates, and Numbers EX 1-20	Undo an action.
MS Excel 2019	9237	In cell F3, enter the value 2024 as text using the keyboard or keypad.	Incorrect	•   Entering Text, Dates, and Numbers EX 1-22	Enter a number as text.
MS Excel 2019	9240	Enter the number 55000 in cell C7.	Correct	•   Entering Text, Dates, and Numbers EX 1-26	Enter a number into a cell.
MS Excel 2019	8861	Change the width of column D to exactly 25 characters.	Correct	•   Resizing Columns and Rows EX 1-30-EX 1-31	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	•   Resizing Columns and Rows EX 1-30	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	•   Resizing Columns and Rows EX 1-30	Wrap text in a cell.
MS Excel 2019	8994	Change the height of row 3 to approximately 30 points (40 pixels).	Correct	•   SAM 2019 Custom Projects [PageNo:] n/a   •   Resizing Columns and Rows EX 1-31	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	•   Calculating with Formulas EX 1-35	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	•   Calculating with Formulas EX 1-35	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	•   Calculating with Formulas EX 1-35	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	•   Calculating with Formulas EX 1-36	Enter a formula by selecting cells.
MS Excel 2019	9199	Move the contents of cell G9 to cell A11.	Correct	•   Modifying a Worksheet EX 1-41	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	•   Using the COUNT Function EX 1-43	Create a formula using the COUNT function.
MS Excel 2019	10132	Cut and paste the contents of cell A18 into cell A15.	Correct	•   Modifying a Worksheet EX 1-43	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	•   Using the COUNT Function EX 1-39-EX 1-40	Create a formula using the SUM function.
MS Excel 2019	9217	Insert a new column to the left of column D.	Correct	•   Modifying Rows and Columns EX 1-45	Insert a column.
MS Excel 2019	10129	Insert a new row above row 9.	Correct	•   Modifying Rows and Columns EX 1-45	Insert a row.
MS Excel 2019	10130	Delete row 8 in the worksheet.	Correct	•   Modifying Rows and Columns EX 1-45-EX 1-46	Delete a row.
MS Excel 2019	8997	Clear the contents of cell B8.	Correct	•   Modifying Rows and Columns EX 1-46	Clear cell contents.
MS Excel 2019	10947	Clear the formatting from cell C6.	Correct	•   The New Perspectives Collection 2019 EX 1-46	Clear cell formatting.
MS Excel 2019	9201	Hide column C.	Correct	•   Modifying Rows and Columns EX 1-49	Hide a column.
MS Excel 2019	9202	Hide the Sample Budget worksheet, and then unhide the Sample Budget worksheet.	Correct	•   Modifying Rows and Columns EX 1-49	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	•   Using Flash Fill EX 1-50	Use Flash Fill.
MS Excel 2019	8990	Apply a Top and Double Bottom Border to range A12:D12.	Correct	•   Formatting a Worksheet EX 1-51	Add a border to cells.
MS Excel 2019	10941	Change the view of the Workshop Participants worksheet to Page Layout view.	Correct	•   The New Perspectives Collection 2019 EX 1-53	Change worksheet views.
MS Excel 2019	8867	Change the page orientation of the current worksheet to Portrait.	Correct	•   Printing a Workbook EX 1-55	Change the page orientation.
MS Excel 2019	10110	Change the scale of the worksheet to 85%.	Correct	•   Printing a Workbook EX 1-55	Scale a worksheet for printing.
MS Excel 2019	9016	Print range B3:D11.	Incorrect	•   Printing a Workbook EX 1-56	Print a section of a worksheet.
MS Excel 2019	10108	Print the Attendance worksheet.	Correct	•   Printing a Workbook EX 1-57	Print a worksheet.
MS Excel 2019	9006	In cell E4, enter a formula using relative cell references that multiplies cell C4 by cell D4.