SC_EX_7_MISalesAnalysis_RileyKneisl_Report_1

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 0/3 The Meyor Insurance worksheet should be zoomed to 120 percent. To Enter Column Titles in the Template 3/3 To Enter Formulas and Functions in the Template 0/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 0/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 0/4 In the Screenshot worksheet, the image's upper-left corner should be located in cell D3. To Add a Picture Border 0/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 #1 | SCORE IS: 70 OUT OF 100 Creating Templates In the Meyor Insurance worksheet, cell I4 should contain the function IF(COUNTIF($B$4:B4,B4)=1,B4,"). Importing Data In the Meyor Insurance worksheet, cell I4 should contain the function IF(COUNTIF($B$4:B4,B4)=1,B4,"). Using the Quick Analysis Gallery In the Meyor Insurance worksheet, the range C24:F24 should be formatted using the Comma cell style. Using the Find and Replace Commands Inserting a Bar Chart Working with SmartArt Graphics Text Boxes Using Screenshots on a Worksheet In the Screenshot worksheet, the picture should have a border formatted using the Black Text 1 border color. Shapes In the Screenshot worksheet, the range A22:B23 should contain the upper-left end of a right arrow shape. Textbook

Err:501 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

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

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

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

SC_EX_7_MISalesAnalysis_RileyKneisl_Report_1

Related Documents