SC_EX_7_MISalesAnalysis_RileyKneisl_Report_2

.xlsx

School

Minnesota State Community and Technical College *

*We aren’t endorsed by this school

Course

1124

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

Uploaded by SuperHawk2942

Shelly Cashman Excel 2019 | Module 7: Textbook Project Riley Kneisl GE ver. 17.1.0-rc0000 1. Non-graded - Project: Meyor Insurance 2. To Open a Blank Workbook and Format the Rows and Columns 3/3 To Enter Titles in the Template 3/3 To Enter Column Titles in the Template 3/3 To Enter Formulas and Functions in the Template 3/3 3. To Import Data from a Text File 4/4 To Import Data from an Access Table 4/4 To Import Data from a Webpage 4/4 To Copy from Word and Paste to Excel 4/4 To Replicate Formulas 0/4 4. To Format Using the Quick Analysis Gallery 4/4 To Total Data 4/4 5. To Find and Replace Text 4/4 To Format Styles and Borders 4/4 6. To Insert a Chart Using the Quick Analysis Gallery 4/4 To Format the Chart 4/4 To Format the Chart Title 4/4 7. To Create a New Worksheet 4/4 To Color and Resize the SmartArt Graphic 4/4 To Apply Picture Effects 4/4 8. Non-graded - Pictures and Icons 9. To Draw a Text Box 4/4 10. Non-graded - Alternative Text 11. Non-graded - Objective Linking and Embedding 12. To Create Another New Sheet 4/4 To Move an Object 4/4 To Add a Picture Border 4/4 13. To Create a Shape and Copy It 4/4 To Add a Shape Style and Shape Effect 0/4 Using the Format Painter with Objects 0/4 Cell range A8:B9 should contain a left-top end of a right arrow shape. SUBMISSION #2 | SCORE IS: 88 OUT OF 100 Creating Templates Importing Data In the Meyor Insurance worksheet, one or more cells in the range I5:I8 contains an incorrect formula. Using the Quick Analysis Gallery Using the Find and Replace Commands Inserting a Bar Chart Working with SmartArt Graphics Text Boxes Using Screenshots on a Worksheet Shapes In the Screenshot worksheet, the range A22:B23 should contain the upper-left end of a right arrow shape. Textbook

Auto Err:501 Err:501 Err:501 Err:501 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2,000,000 Meyor Insurance 2021 Premiums in $

Our New Graphic

Meyor Insurance Sales Analysis

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help