Excel 2

Bold cell content.

Answer explanation

1. Select cell A2. 2. In the Font group on the Home tab, click the Bold button. 3. Excel applies bold formatting to the text in the cell.

Change the font of cell content.

Answer explanation

1. Select cell A2. 2. In the Font group, click the Font arrow. 3. The Font gallery displays a list of available fonts. 4. In the Font gallery, click Cambria. 5. Excel changes the font of the cell to Cambria.

Italicize cell content.

Answer explanation

1. Click cell F6. 2. You want to make the text in this cell stand out from other text. 3. In the Font group on the Home tab, click the Italic button. 4. Excel italicizes the text in the cell.

Change the font color of cell content.

Answer explanation

1. Select cell D9. 2. In the Font group on the Home tab, click the Font Color arrow. 3. The Font Color gallery displays a palette of Theme Colors and Standard Colors. 4.In the Standard Colors section of the Font Color gallery, click Blue (column 8). 5. Excel changes the font color in the cell to blue.

Change the fill color of a cell.

Answer explanation

1. Select cell D9. 2. In the Font group on the Home tab, click the Fill Color arrow. 3. The Fill Color gallery displays a palette of Theme Colors and Standard Colors. 4. In the Theme Colors section of the Fill Color gallery, click Blue, Accent 1, Lighter 60% (column 5, row 3). 5. Excel changes the cell color to light blue.

Insert a picture as a worksheet background

Answer explanation

1. Click the Page Layout tab on the Ribbon. 2. In the Page Setup group, click the Background button. 3. The Insert Pictures dialog box opens. You can choose pictures from a folder on your computer or search online for an image. 4. Click From a file. 5. The Sheet Background dialog box opens and displays the contents of the Pictures Library. 6. Click the Ice Cream Cone.png picture icon to select it. 7. Click the Insert button. 8. Excel inserts the picture into the worksheet as the worksheet background, repeating the image as needed to fil

Create a formula using arithmetic operators.

Answer explanation

1. Select cell G4..You will create a formula to calculate the projected 2021 Salary, less Healthcare, for each employee.Type = (equal sign) in cell G4 to start the formulaYour formula will use a variety of arithmetic operations to complete the calculation. As with all formulas, you will begin by typing = (equal sign) in the cell. 2. Click cell C4.The value in cell C4 represents the employee's current salary.Type + (plus) in cell G4.To this, you want to add the amount of the employee's raise, in dollars...Click cell C4....which you will calculate by multiplying the employee's current salary in cell C4...Type * in cell G4.... by the raise percentage in cell E4.Click cell E4.Type - (minus) in cell G4.Next, you will subtract the annual healthcare deduction shown in cell F4 from the projected new salary result.Click cell F4.On the formula bar, click the Enter button.Excel performs the calculations as specified and returns the result in cell G4.

Select non-adjacent cells.

Answer explanation

1. Click cell C4. 2. Press and hold the CTRL key and click cell C6. 3. Cell C4 remains selected, and cell C6 is added to the selection. 4. With the CTRL key pressed, click cell C11. 5. Cell C11 is now selected as well. Excel applies a double border to the cell last selected, and highlights previously selected cells in grey. All corresponding column and row headings are highlighted in grey as well.

Apply the Currency number format

Answer explanation

1. Click and drag to select range C4:C15. 2. In the Number group on the Home tab, click the Number Format arrow. 3. The Number Format menu opens. 4. On the menu, click Currency. 5. Excel applies the Currency format to the cells in the range. The numbers in each cell are preceded by a $ (dollar sign) and display two decimal places.

Apply the Accounting number format.

Answer explanation

1. Position the mouse pointer over cell C4. Press and hold the left mouse button as you drag the mouse pointer down until it is over cell C15, then release the mouse button. 2. In the Number group, click the $ (dollar sign) button. 3. Excel applies the Accounting number format to the selected cells.