The text provided appears to be instructions for using Excel. There are no spelling, typographical, grammatical, OCR, or mathematical errors in the text. However, the formatting of the text could be improved for clarity and coherence.
Added by Rachel C.
Close
Step 1
Step 1: Open Microsoft Excel on your computer. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 52 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Akash M.
Microsoft Excel - (65 points) 1. Create an Excel workbook and name the file using your last name_final project 2. Create a worksheet with a minimum of 5 columns and 7 rows 3. Create a minimum of 5 column titles, Times New Roman 12pt, Bold, use a font color other than black 4. Create a minimum of 7 row titles, Times New Roma 12pt, do not bold 5. Create formulas in no less than 4 cells, these are separate from the functions in #6 and must be 4 different formulas 6. Use the MIN, MAX, and AVERAGE functions 7. Create a title for the worksheet merging and centering the text using a minimum of 5 cells 8. Format title with font of your choice, 14 pt, bold, italics, using a font color other than black 9. Rename the Sheet Tab using your last name 10. Apply color to Sheet Tab 12. Create a chart on separate sheet using the data on the main sheet; name the sheet tab Chart 13. Add Sparklines to one or more pieces of data 14. Change the Number Formatting from General to a Number Format of your choosing to one or more rows/columns of data
Microsoft Excel - 65 points 1. Create an Excel workbook and name the file using your last name_final project 2. Create a worksheet with a minimum of 5 columns and 7 rows 3. Create a minimum of 5 column titles, Times New Roman 12pt, Bold, use a font color other than black 4. Create a minimum of 7 row titles, Times New Roma 12pt, do not bold 5. Create formulas in no less than 4 cells, these are separate from the functions in #6 and must be 4 different formulas 6. Use the MIN, MAX, and AVERAGE functions 7. Create a title for the worksheet merging and centering the text using a minimum of 5 cells 8. Format title with font of your choice, 14 pt, bold, italics, using a font color other than black 9. Rename the Sheet Tab using your last name 10. Apply color to Sheet Tab 12. Create a chart on separate sheet using the data on the main sheet; name the sheet tab Chart 13. Add Sparklines to one or more pieces of data 14. Change the Number Formatting from General to a Number Format of your choosing to one or more rows/columns of data
Supreeta N.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD