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 |