Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Help me, Instruction for Formatting a Worksheet 1. Open the attached excel le: Assignment ZS Highlight the range AI : F1 Merge and center

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Please Help me,

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Instruction for Formatting a Worksheet 1. Open the attached excel le: Assignment ZS Highlight the range AI : F1 Merge and center the cells in the highlighted range using Merge & Center icon in the Ribbon Highlight the range A1 : Fl Use Home/Format/Format Cells/ to open a dialogue Box Select Border tab, Select Bold line style, and Select outline area Click ok to add border to Title Highlight the range A3 : F12 Use Home/Format/Format Cells/ to open a dialogue Box 10. Select Border tab, Select double-line line style, and Select outline and inside areas 1 1. Click ok to add border to detailed area 12. Save the le with the name: Lastname_Firstname_Assignment_SZ 13. The result should look like the image below: 9"!" EDWT-'P'P'F' mmm 5 6 m-_mn 7 MUM" 8 "m 9 m 10 mm 11 M 12 5-9- 13 14 University Bookstore Sales Report Season Item Description Item Number Unit Sales Average Price Sales Dollars Fall Sweatshirt 70500 5000 49.99 249950 Fall Sweaters 70505 3200 69.99 223968 Fall Footballs 70508 500 59.99 29995 Fall Blankets 70507 900 32.99 29691 Fall Scarves 70503 2200 9.99 21978 Spring T-Shirts 70501 8500 18.99 161415 Spring Sandals 70506 2200 29.99 65978 Spring Sunglasses 70504 1800 22.99 41382 Spring Baseballs 70502 1200 12.99 15588 Spring Sunscreen 70509 1800 5.99 10782University Bookstore Sales Report Season Item Description Item Number Unit Sales Average Pr Sales Dolla Spring T-Shirts 70501 8500 18.99 161415 Fall Sweatshirt 70500 5000 49.99 249950 Fall Sweaters 70505 3200 69.99 223968 Spring Sandals 70506 2200 29.99 65978 Fall Scarves 70503 2200 9.99 21978 Spring Sunglasses 70504 1800 22.99 41382 Spring Sunscreen 70509 1800 5.99 10782 Spring Baseballs 70502 1200 12.99 15588 Fall Blankets 70507 900 32.99 29691 Fall Footballs 70508 500 59.99 29995University Bookstore Sales Report - Season Item Description Item Number Unit Sales Average Pr Sales Doll 1078 2197 12.9 1558 18.9 16141 tam-mm .mm mm mm

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes, Arshad Ahmad, Jordan Fortino

6th Canadian edition

1259453146, 978-1259453144

More Books

Students also viewed these Finance questions