question archive Open the workbook PB Financials

Open the workbook PB Financials

Subject:MS ExcelPrice: Bought3

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.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE