## East End Building Materials Assignment

### The purpose of this assignment is to:

1. Apply the AND formula

2. Apply the IF formula

3. Use argument boxes successfully

### Preparation: (Review these terms)

• Insert extra rows
• Change font and size

### New Terms: (Terms are bolded in the steps in the assignment below)

• Apply the AND function (Step 12, page 2)
• Apply the IF function (Step 13, page 2)

### Narrative:

It is one thing to understand a formula and quite another to apply that formula. This exercise allows you to practice the If and AND functions and to view the results. (THIS ASSIGNMENT IS WORTH 20 POINTS. THE RUBRIC IS ON PAGE 2.)

## East End Building Materials Assignment

1. Open the spreadsheet called East End Building Materials and save it as East End.

2. Center the title (East End Building Materials) over the entire table and change the font to 14 Aharoni,

3. Center the sub title (Bonus Pay Summary) over the entire table and change the font to 12 pt Aharoni.

4. Insert an extra row below the sub title but above the column headings. In that row, type your name and center it. Choose the font and size you would like

5. Select the Title, Sub Title, Your Name and the column headings (entire rows of each) and shade them in light gray.

6. With that section still highlighted, place a border underneath the column headings.

7. Select the column headings and bold them.

8. Adjust the columns as necessary

9. Adjust the Performance Rating column heading using the Wrap Text so the heading is on two lines.