Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel document edit

13/10/2020 Client: bingyanj Deadline: 10 Days

Open and save a workbook.


Change zoom size and remove a split.


Freeze panes.


Format labels and values.


Use the Fill Handle to copy a formula and fill a series.


Check spelling.


Apply a workbook theme, cell styles, and font attributes.


Merge and center labels.


Insert a column and adjust column widths and row heights.


Adjust alignment, indents, and borders.


Rename the sheet tab.


Use Page Layout view to insert a footer.


 Open the WearEverShoes-01.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.


Remove a split and freeze panes.


 Click the Split button [View tab, Window group]. The split is removed.


 Click cell A4 to freeze the column titles at this position.


 Click the Freeze Panes button [View tab, Window group].


 Choose Freeze Panes. A solid border appears between rows 3 and 4 to mark the pane.


 Scroll to row 31 and click cell E31. The column titles are frozen.


 Type 3 and press Enter (Figure 1-91).There is a thin border below the cells in row 3


Figure 1-91 Panes frozen at cell A4


 Press Ctrl+Home. The insertion point returns to cell A4.


Change zoom size and unfreeze the pane.


 Click the 100% button [View tab, Zoom group].


 Click the Freeze Panes button [View tab, Window group].


 Choose Unfreeze Panes.


 Click cell A1.


Check spelling in the worksheet.


 Click the Spelling button [Review tab, Proofing group]. The first occurrence of “Hikin” is found as misspelled.


 Select Hiking in the Suggestions list.


 Click Change All to correct all occurrences of the misspelled word (Figure 1-92).


The correct spelling is H I K I N G in Suggestions list


Figure 1-92 Change all occurrences of a misspelled word


 Click OK.


Use the Fill Handle to copy a formula.


 Click H4. The formula displays in the Formula bar. The formula multiples the quantity by the cost to calculate the value of the current stock (Figure 1-93).The formula is E4 times G4


Figure 1-93 Formula to be copied


 Point to the Fill Handle for cell H4.


 Double-click the Fill pointer. The formula is copied down the entire column.


 Press Ctrl+Home.


 Click the Themes button [Page Layout tab, Themes group] and choose Ion from the gallery.


Merge and center the titles.


 Select cells A1:J1 and click the Merge & Center button [Home tab, Alignment group].


 Merge and center cells A2:J2.


Apply cell styles and adjust row height.


 Select cell A1, click the Cell Styles button or the More button [Home tab, Styles group], and select Title in the Titles and Headings category.


 Select cell A2 and apply the Heading 4 style.


 Click the Font Size arrow [Home tab, Font group] and select 14 pt. The font size change overwrites the font size of the cell style.


 Point to the row 1 heading and drag to select row headings 1:2.


 Click the Format button [Home tab, Cells group] and choose Row Height.


 Type 22 as the new row height and press Enter.


 Select cells A3:J3.


 From the Cell Styles gallery [Home tab], select Light Yellow, 40% - Accent3.


 Apply bold to the selected cells.


 Click the row 3 heading.


 Point to the bottom border of the row heading to display the resize arrow.


 Drag the resize arrow to 21.00 (28 pixels) as the new row height and release the pointer (Figure 1-94).


The resize pointer is between the row headings for rows 3 and 4


Figure 1-94 Adjust row height from the row heading


 Click the Zoom Out button in the Status bar if necessary so that you can see all rows (1:39).


Change alignment, format values, apply borders, and increase the indent.


 Select cells D4:F39.


 Click the Center button [Home tab, Alignment group].


 Select cells G4:H39.


 Click the Accounting Number Format button [Home tab, Number group].


 Select cells A3:J39.


 Click the Borders drop-down arrow [Home tab, Font group] and select All Borders.


 Click the Font size drop-down arrow [Home tab, Font group] and choose 12 while the cells are selected.


 Select cells B4:C39 and click the Increase Indent button [Home tab, Alignment group] one time. This moves the label away from the border for easier reading.


 Click and drag to select columns A:J.


 Double-click the border between columns J and K to AutoFit the selected columns (Figure 1-95).


Columns A:J are selected and shaded gray


Figure 1-95 Select column headings to AutoFit


 Select and center align the labels in row 3.


Insert a column and create a pattern to fill data.


 Right-click column heading B.


 Choose Insert from the context menu.


 In cell B3, type Disc? and press Enter.


 In cell B4, type No and press Enter.


 In cell B5, type No and press Enter.


 In cell B6, type Yes and press Enter. The pattern is two occurrences of No and one occurrence of Yes.


 Select cells B4:B6 and increase the indent twice.


 Select cells B4:B6 and double-click the Fill pointer (Figure 1-96).The Fill pointer displays at cell B6


Figure 1-96 Double-click the Fill pointer to complete a series


 Select cells A4:A39 and increase the indent one time.


 Press Ctrl+Home.


Rename the sheet tab.


 Double-click the Sheet1 tab.


 Type Inventory and press Enter.


Use Page Layout view to insert a footer.


 Click the Page Layout button in the Status bar.


 Click the center header section. The Header & Footer Tools tab is active.


 If necessary, click the Header & Footer Tools Design tab to display it.


 Click the Go to Footer button [Header & Footer Tools Design tab, Navigation group].


 Click the middle section if necessary.


 Click the File Name button in the Header & Footer Elements group. The code is &[File].


 Click a worksheet cell to see the file name.


 Switch to Normal view and press Ctrl+Home.


Change page setup options.


 Click the Page Layout tab and click the Page Setup launcher.


 Display the Page tab and select the Landscape radio button under Orientation.


 Select the Fit to radio button and enter 1 page wide by 1 tall.


 Click OK.


 Switch to Normal view and press Ctrl+Home.


Set a print area.


 Select cells A1:K11.


 Click the Page Layout tab.


 Click the Print Area button [Page Setup group] and select Set Print Area.


 Press Ctrl+Home.


 Click the File tab and select Print to preview the worksheet print area.


 Return to the worksheet.


 Click the Save button in the Quick Access toolbar to save the workbook changes. The print area is saved.


 Close the workbook (Figure 1-97).



Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Peter O.
Pro Writer
Financial Hub
Assignments Hut
Solution Provider
Instant Assignments
Writer Writer Name Offer Chat
Peter O.

ONLINE

Peter O.

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

$70 Chat With Writer
Pro Writer

ONLINE

Pro Writer

Hello, I can assist you in every kind of writing. I am a professional academic/research writer and an MBA in business and finance. Please connect in chat session to further discuss the details.

$70 Chat With Writer
Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$70 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I am 100% sure that I will meet your expectations in writing the essay . I have written over 4000 high quality plagiarism free papers and deliver within stipulated deadlines. I am familiar with a number of citation styles among them MLA, APA, APSA, Oxford, Chicago, OSCOLA, Harvard and Turabian. I believe that I am the right candidate for this project, and I guarantee quality work. I have a wide knowledge in this subject and I believe this will come a long way in giving you quality work. Thank you in advance

$70 Chat With Writer
Solution Provider

ONLINE

Solution Provider

Hi.I have read your descriptions and i will provide you quality work.I am a Ph.D. writer with 5-6 years of experience. I have worked on several similar projects and can deliver quality works in a tight deadline. I am interested to hear more about the project and about the subject. If you award me the project I would be very glad to discuss this further and get started for you as soon as possible. Thanks You!

$70 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

Good day dear client, I am a full-time freelance writer with years of experience. My strongest strengths are strong dedication to duty, reliability, quality and excellence. I am going to do an outstanding job for you, kindly PM me and let us commence. Thank you so much in anticipation of your positive response. Thank you very much.

$70 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Cnn the eighties netflix - Ryan clark sickle cell trait - Knauf 76 x 3000mm steel wall track - Competency Paper # 1: Agency & Community Analysis - Petrarchan sonnet elizabeth barrett browning - Lean Six Sigma - Assignment 3 - Shanahan construction company has entered - Case study of southwest airlines with solution - Rhs level 2 past papers 2015 - Dan murphys phillip island - Get skilled get active - Eso flipping the coin - Approaches to connecting public health and the healthcare system - NURSING: EVIDENCED-BASED PRACTICE PROJECT - Abdominal inflammation crossword clue - Death of the iceman documentary - Netgear jfs516 manual pdf - The story of an hourpdf - Preparing for future of work - Forum 3 - 5aa sports text line - 50.2 kg in stone - DQ - Humn 8660 - Final business plan - Review Paper - Love's executioner the wrong one died summary - Ovidentia file manager upload shell - 2.5 3 test ts teacher scored unit test answers - University of iowa human resources - The crucible and the dressmaker themes - Fenner dunlop engineered conveyor solutions - Richmond regent twin cinema - Daniel gilbert reporting live from tomorrow - Balance Sheet and Income Statement - Uc davis nutrition faculty - Week 5 assignment essay ideal citizen in a totalitarian government - Forecasting interview questions - Characteristics of the genre of fahrenheit 451 - Goring & woodcote medical practice - The perils and pitfalls of leading change - Gomalco - Blow a kiss into the sun volvo commercial song - Minnesota micromotors simulation excel - To kill a mockingbird chapter 5 - Module 04 Written Assignment - Case Mix Crisis - Best christian publishers for new authors - Romeo and juliet powerpoint notes - How to record stock dividend in journal entry - Cognos impromptu end of life - Chemical equation for iron - Team contract template in project management - Nick donato 9 11 - Rotary club of strathfield - What is historical balancing account in myob - SOCW 6361 - Homework: The Truth® Campaign/Initiative - Tuggerah station to gosford station - Short case study on organizational behavior ppt - Forced choice reinforcement survey - What does cate often call her twin sister answer key - Lorna jane westfield garden city - Nicholas kristof and jaweed kaleem on the value of the humanities - Anatomy of a microscope quiz - Shadow health focused assessment cough - Research paper - I need help with a Managerial writing assignment. - How to use wes - A plastic ocean worksheet pdf - Pearl seas cruises employment - The Nurse Leader as Knowledge Worker - Most abundant cation in extracellular fluid - Zara clothing annual report 2017 - Undulate in a sentence - Crossword clue connective tissue - Consider the following time series data - Q is greater than k - Offset method to determine yield strength - What is the significance of daniel felsenfeld literacy narrative - Alternative Analysis Case study - Iprofile - Et solar panel datasheet - The minister's black veil symbolism - What is the slowest type of mass wasting process - 4 band resistor chart - Assign 6 inter - Bus 499 business administration capstone exam - Fundamentals of financial management chapter 5 solutions - Sven hedin my life as an explorer - Example of a personification - Html5 vs silverlight comparison - Plastic waste recycling project proposal - Marketing assignment new product launch - Remind 101 parent letter - How to find tax and tip - Duncan guthrie institute of medical genetics - Three pillars of the colangelo college of business - Elimination complexities - Ferocity in a simple sentence