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

Change selected cell to 20pt in excel

15/10/2021 Client: muhammad11 Deadline: 2 Day

How To Work On A Spreed Sheet Document Using The Information Given

Eller Software Services has received contract revenue information in a text file. You import, sort, and filter the data. You also create a PivotTable, prepare a worksheet with subtotals, and format related data as an Excel table.

[Student Learning Outcomes 4.1, 4.3, 4.4, 4.5, 4.6, 4.8]

Files Needed: EllerSoftware-04.xlsx (Available from the Start File link.) and EllerSoftwareText-04.txt (Available from the Resources link.)

Completed Project File Name: [your name]-EllerSoftware-04.xlsx

Skills Covered in This Project
Import a text file.
Use AutoFilters.
Sort data by multiple columns.
Create a PivotTable.
Format fields in a PivotTable.
Use the Subtotal command.
Format data in an Excel table.
Sort data in an Excel table.
Alternate Instruction for Microsoft 365 Apps icon This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

Open the EllerSoftware-04.xlsx start file. Click the Enable Editing button. 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.
Import the EllerSoftwareText-04.txt file downloaded from the Resources link and load it to begin in cell A4. The text file is tab-delimited.
Format the values in column H as Currency with zero decimal places.
Click cell G4 and use the AutoFilter arrow to sort by date oldest to newest.
Click cell F4 and use the AutoFilter arrow to sort by product/service name in ascending order.
Filter the Date column to show only contracts for September using the All Dates in the Period option.
Edit the label in cell A2 to display Contract Amounts for September.
Select cells A1:H2 and press Ctrl+1 to open the Format Cells dialog box. On the Alignment tab, choose Center Across Selection.
Change the font size for cells A1:H2 to 20 pt (Figure 4-102) and close the Queries & Connections pane.Date header displays filter icon.Figure 4-102 Imported data sorted and filtered
Copy the Contracts sheet to the end and name the copy Data.
Clear the date filter.
Select cell A5 and click the PivotTable button [Insert tab, Tables group]. The range is identified as the EllerSoftwareText file.
Verify that New Worksheet is selected, deselect the Add this data to the Data Model button, and click OK.
Name the sheet PivotTable. Close the Queries & Connections pane.
Show the Product/Service and Contract fields in the PivotTable.
Drag the Contract field from the Choose fields to add to report area below the Sum of Contract field in the Values area so that it appears twice in the report layout and the pane (Figure 4-103).Values are identical.Figure 4-103 “Contract” field appears twice in the report
Select cell C4 and click the Field Settings button [PivotTable Analyze tab, Active Field group]. Type Average Contract as the Custom Name, choose Average as the calculation, and set the Number Format to Currency with zero decimal places.
Alternate Instruction for Microsoft 365 Apps icon Select cell C4 and click the Field Settings button [PivotTable Tools Analyze tab, Active Field group]. Type Average Contract as the Custom Name, choose Average as the calculation, and set the Number Format to Currency with zero decimal places.
Select cell B4 and set its Custom Name to Total Contracts and the number format to Currency with zero decimal places.
Apply Brown, Pivot Style Dark 3.
Select the Data sheet tab and copy cells A1:A2. Paste them in cell A1 on the PivotTable sheet.
Select Align Left for cells A1:A2 and 16 pt. as the font size. Edit the label in cell A2 to display Contract Amounts, September through December (Figure 4-104).Completed PivotTableFigure 4-104 Completed PivotTable
Copy the Data sheet to the end and name the copy Subtotals.
Select cell D5 and sort by City in A to Z order.
Select cell A5 and convert the table to a range. Select cells A5:H31 and apply No Fill [Home tab, Font group].
Use the Subtotal command to show a SUM for the contract amounts for each city.
Edit the label in cell A2 to display Contract Amounts by City.
Format the sheet to Landscape orientation, center the page vertically, and scale it to fit one page.
Click the Billable Hours sheet tab and select cell A4.
Click the Format as Table button [Home tab, Styles group], use Orange, Table Style Medium 10, and remove the data connections.
Type 5% Add On in cell E4 and press Enter.
Build a formula in cell E5 to multiply cell D5 by 105% and press Enter to copy the formula.
Select cells A1:A2 and left align them. Then select cells A1:E2, click the Launcher for the Alignment group [Home tab], and select Center Across Selection from the Horizontal list.
Use the AutoFilter arrows to sort by date in oldest to newest order.
Save and close the workbook (Figure 4-105).Excel 4-4 completedFigure 4-105 Excel 4-4 completed
Upload and save your project file.
Submit project for grading.

Contracts
Eller Software Services
Contract Amounts, September through December
Billable Hours
Eller Software Services
Billable Hours
Client Name Product/Service Date Billable
Heather Guyan Training 10/7/19 3.25
Karen Talon Accounting Software 10/1/19 5.50
Mike Gunderson Technical Support 12/18/19 4.50
Thomas Larson Training 12/5/19 5.00
Wade Whitworth Accounting Software 11/14/19 5.00
Paula Valentine Training 11/15/19 4.00
Richard Malinowski Technical Support 1/5/20 3.00
Robert Gneiss ERP: Enterprise Resource Planning 9/1/19 6.00
Susan Charlotte ERP: Enterprise Resource Planning 3/5/20 8.00
Martin Green Accounting Software 3/7/20 4.00
Heather Guyan Training 2/3/20 4.50
Craig Brand Technical Support 10/1/19 8.00
Glenn Ladewig Accounting Software 9/1/19 5.00
Terri Olander POS: Point of Sale Software 10/15/19 6.50
Karen Talon Accounting Software 9/1/19 3.50
Hilary Marschke Training 3/8/20 5.00
Shelly Vlcko Accounting Software 9/15/19 5.00
Wade Whitworth Accounting Software 2/2/20 6.00
Michelle Cronin POS: Point of Sale Software 12/15/19 4.00
Paula Valentine Training 4/5/20 4.00
Paula Valentine Training 10/15/19 4.00
Hilary Marschke Training 11/15/19 5.00
Arthur Weston Technical Support 5/5/20 6.00
Christine Barton POS: Point of Sale Software 11/15/19 4.00
Charlie Lindberg ERP: Enterprise Resource Planning 4/5/20 6.00
Hilary Marschke Training 11/15/19 5.00
Shelly Vlcko Accounting Software 11/16/19 5.00
Mike Gunderson Technical Support 10/28/19 4.75
Jeremie Midboe POS: Point of Sale Software 11/1/19 3.50
Arthur Weston Technical Support 10/1/19 3.00
Susan Charlotte ERP: Enterprise Resource Planning 11/1/19 6.00
Thomas Larson Training 3/18/20 4.00
Arnold Robert Accounting Software 9/15/19 5.00
Wade Whitworth Accounting Software 5/17/20 5.00
Paula Valentine Training 10/15/19 4.00
Michelle Cronin POS: Point of Sale Software 12/15/19 4.00
Amir Atef Training 12/15/19 4.00
Richard Malinowski Technical Support 10/1/19 4.50
Charlie Lindberg ERP: Enterprise Resource Planning 9/1/19 4.00
Christine Barton POS: Point of Sale Software 11/15/19 2.00
Robert Gneiss ERP: Enterprise Resource Planning 2/5/20 7.00
Martin Green Accounting Software 12/15/19 5.00
Jerri Salzman POS: Point of Sale Software 3/9/20 4.50
Juan Garcia Training 11/15/19 4.00
Elizabeth Jones Technical Support 10/1/19 3.50
Robert Lawlor Technical Support 1/8/20 2.75
Patricia Glunz POS: Point of Sale Software 12/15/19 3.25
1

2

3

4

5

6

7

8

9

A

B

C

D

E

Eller Software Services

Contract Amounts, September through December

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:

Fatimah Syeda
Instant Assignment Writer
Essay & Assignment Help
Engineering Guru
Professional Accountant
Top Quality Assignments
Writer Writer Name Offer Chat
Fatimah Syeda

ONLINE

Fatimah Syeda

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$37 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$42 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$27 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$23 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$44 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$19 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

Combat oil cabinet heaters - 8 tyee street box hill - Shakespeare sonnet 14 analysis - Java GUI Assignment - On monsters by stephen t asma - Applicant day leeds beckett - Woolworths third party insurance - 1 glucose solution is a positive control for - What prize does macbeth's killer bring back to the castle - Codes and conventions in film - Peace arch vet hospital - Nucor corporation case study answers - Week 4 Assignment - Infectious diseases advanced training - 1 prop z test - How are photosynthesis and cellular respiration alike - Strain hardening exponent from stress strain curve - Fireball technology company excel - Roller bending machine project report - Bubaran kembang pacar - Week4 project - Elders cattle sale boyanup - Www outofservice com bigfive big five - Gcu christian identity and heritage - Week 2 Case Studies - Mpa to kn m 2 - Azure site recovery domain controller - L2 Environmental Health and Health Effects of Environmental Change - AMH - Z wave screw in lamp socket - Birds and the bees talk for 8 year olds - Zanna don t script - Chemical reaction between khp and naoh - Paparazzi compliance phone number - Alaska fly fishing expedition risk assessment - Coleg y cymoedd moodle - Using sources effectively 5th edition pdf - Operations management functions at nissan - Clearpass palo alto integration - Cases in healthcare finance 5th edition - Question to be answered - Art - Who destroyed the hanging gardens of babylon - Art appreciation and criticism - 13 strategic staffing decisions more important than others - How many segment registers are there in 8086 - According to many developmentalists the key to successful aging is - Pharmacy Question - Content writing - Discussion - Cloud Computing - West oaks school meanwood - Data science life cycle pdf - Article Analysis - Burrowa pine mountain national park - The wright group sunshine books guided reading level - Ready player one theme essay - Trapezoidal pattern am modulation - Diagram of a prokaryotic cell - Ingrid jonker poem by sally bryer - Evolutionary Ecology Question - Give me liberty ap 5th edition - MANAGING THE FAMILY BUSINESS 4 - Http www purplemath com modules logs htm - Black card revoked petty edition amazon - Odyssey Plan - How to use a focimeter - Jia ning international caboolture - Glencoe virtual light lab - Research Paper in Arab Uprisings - Wiring diagram circuit breaker symbol - Matlab state space simulation - Assignment01 - How to write service level agreement - The blind side football game scene - Sparklebox chinese new year - 1 what features of contemporary e commerce does groupon utilize - Integral of tan x - Self awareness ppt template - 16 university avenue macquarie university - Carry on olivia holt sheet music - Calculating tidal volume by weight - 275 lion street sawyers valley - Bible - Fazil say summertime variations pdf - In the post office example suppose that each - Apollo shoes audit case - As1100 drawing standards free download - Synthesis paper psyc 255 - Kenyon medical centre coventry - Athlean x workout free download - What is directly proportional - Two tier email architecture - Feedback form format for seminar - 36/38 as a percentage - Axe target market demographics - 2 - Executive Summary of a Key Trend in HIT - Clark creative education answer key - PoliticalScience week 5 Assignment - Ampac technologies pty ltd - Practice of clinical psychology worksheet