Work in groups of ten on the following simple Excel projects. Join one of the groups on TIES. Make sure you complete and submit (upload) your assignment as a group on TIES using the “Groups” facility. Project 1: Editing and Formatting a Worksheet Attains Mamba is a weather reporter for a local television station. As part of his daily report, he uses the Air Quality Index (IQ) to provide information about the air quality in the surrounding area.
He is reading an Excel worksheet for tracking this information. 1. Create a new blank workbook and save it as Assignments XX. XSL (replace XX with your group number). Egg Assignments Groups. XSL 2. Enter the data shown in the figure below. 3. Use the keyboard to select cell 83, and then enter Numerical Value. 4. Use the mouse to select cell AY, and then enter Green. 5. Use the keyboard to select cell 84, and then enter O to 50. 6. Use the keyboard to select cell CA, and then enter Good. 7.
Don’t waste your time!
Order your assignment!
Use the keyboard to move to the last cell in the worksheet containing data or aromatizing (cell CA) and replace Unsafe with Hazardous. 8. Use the mouse to select cell AY, and then apply bold to the text, change the font to Cambric, and change the font size to 18. 9. Use the keyboard to select cells AY:CA, and then apply bold to the text in this range, change the font to Cambric, and apply a Thick Bottom Border to the cells in this range. 10. Use the mouse to select cells AY:CA, and then center the data in the cells. 11.
Rename your worksheet to “Air Quality Index” (Hint: right click on top of Sheets and choose the rename option) PROJECT 2: Creating and Formatting a Schedule Miranda owns a small business that recycles glass bottles into useful products. She uses a kiln to melt the bottles into cheese trays, serving dishes, and decorative artwork to sell in local specialty stores. She is creating a firing schedule to post as a reminder of how many minutes the kiln should remain at each rate and temperature through the stages of the melting process. 1 .
Complete this project in a new worksheet named “Firing Schedule” 2. Enter the data shown in the figure below. . Adjust the width of columns A through C to 12. 00 (89 pixels). 4. Adjust the height of rows 4 through 8 to 24. 00 (32 pixels). 5. Center the data in cells AY:CA. 6. Merge and center the text in cell AY across the range of AY :CHI, then change the font size to 20 and the text color to Red. 7. Bold and underline the text in cell AY, and change the font size to 12. 8. Use the Format Painter to copy the formatting in cell AY to cells BE:CA.
PROJECT 3: Formatting a Worksheet Tracking As a regional sales manager, Taboo recently takes short commuter flights to meet with his sales teams. To help neutralize the climate-changing emissions produced by these tilling, Taboo keeps track of his total kilometers flown each month so that he can calculate the carbon dioxide emissions and then purchase emissions credit to offset his personal carbon footprint. 1 . Complete this project in a new worksheet named “Carbon Footprint” 2. Enter the data shown in the figure below 3. Apply the Median theme to the workbook. . Apply the Heading 1 cell style to cells AY . 5. Center the data and wrap the text in row 3. 6. Apply the Heading 3 cell style to cells AY:DO. 7. Change the number format to Short Date in cells AY:AI. 8. Center the data in cells BE:BIO. 9. Change the number format to Number with zero decimals cells CA:DID. PROJECT 4: Creating a Worksheet for Calculating Recipe Amounts Mary has a successful catering business that specializes in small company dinner parties. The most popular dessert item on her menu is old-fashioned custard.
Because the number of people at each catered event varies, Mary needs to be able to scale the swipe accordingly, so she uses a worksheet to calculate the amounts for each ingredient. 1. Create a new worksheet and rename it as “Custard Recipe” 2. Enter the data shown in the figure below.