BUS 180:301 

Project Description:

In the following project, you will prepare materials that will provide information on the health risks posed by smoking cigarettes. You will modify fonts, insert a picture,  change page layout, use find and replace, cut and paste, insert a text box, and check spelling.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open the downloaded Excel file named exploring_f01_grader_a1.xlsx.

0

2

On the Cigarette Cost worksheet, add the name Kelly Crume to cell A10.

6

3

Change the font colors of cells G3 through I4 to Red.

8

4

Italicize the Annual Cost cells (F3 and F4).

8

5

Click cell G7, and then insert an online picture by searching for cigarette Insert the picture of the broken cigarette with tobacco. For your reference, the file, exploring_f01_grader_cigarette.jpg, has been included with your data files.

12

6

Resize the picture proportionately so that its height is 2.45. Reposition it so that the upper left corner aligns with the upper left corner of cell B7. Click outside the picture to deselect it.

12

7

Change the page orientation to Landscape. Change the margins to Narrow.

12

8

On the Smoking Quiz worksheet, replace all occurrences of CDC with Centers for Disease Control and Prevention.

8

9

Insert a text box beginning at the upper left corner of cell I5 and ending at the lower right corner of cell K12.

8

10

Select and cut the contents of cell A2, the Mark Twain quote (just the text, not the cell). Paste the cut text into the text box.

10

11

Change the font size of the content of the text box to 18.

8

12

Check spelling and fix any found errors. The word hairlike is not misspelled so do not correct it.

8

13

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Cigarette Cost, Smoking Quiz. Save the workbook, close the workbook window, and then submit the workbook as directed.

0

 

Total Points

100

 

                                                                                                                        

  • 8 years ago
BUS 180:301 - 94% score
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    answers_exploring_f01_grader_a1.xlsx