Computer Applications (Module 1)

docx

School

Sheridan College *

*We aren’t endorsed by this school

Course

COMPUTER S

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by ChefPantherMaster56

Computer Applications: Module 1 Case1: Cross State Problem 1. Open the NP_EX_1-2 Workbook 2. Change the name of the Sheet 1 worksheet using Travel Log as the name, and then move it to the end of the workbook.  Rename this sheet as “Travel Log” and moved to the end of workbook.  Rename the Sheet 1 as “Documentation” in the TAB below. 3. In the documentation sheet, enter your name in Cell B4 and the current date in Cell B4, Move the Documentation sheet to the front of the workbook. o To enter the current date in cell B4  Type the formula =Today() 4. Go to the Travel log Worksheet. Resize the columns to that all the data is visible in the cells. o Make a new column between columns H and J to that the column “I” is made. o Name the column as “Miles” in I4. 5. Between the Odometer Ending column and the Hours column and the hours column, insert a new column. Enter MILES as the column label in cell I4 6. In the Miles column, in the range I5:I25, enter formulas to calculate the number of miles driven each day by subtracting the odometer beginning value from the odometer ending value. o For the first day, we get the value as 476 o To get this number the formula to enter In the formula bar would be  =H5-G5 7. Between the price per gallon column and the Seller column, insert a new column. Enter Total Fuel Purchase as the label in cell N4.  Insert a new column between (M) and (O) which will be (N) and name it total fuel purchase.  To insert a new column

o Right click the column (M) and a new column appears between. o Name the column (N) as Total Fuel Purchase. 8. In the Total Fuel Purchase column, in the range N5:N25, enter the formulas to calculate the total amount spent on fuel each day by multiplying the gallons value by the price per gallon value.  For the first day in cell N5, total amount is calculates as 227.6703 o To calculate this number add the following formula in the formula tab bar o =L5*M5 9. In Cell B5, use the COUNT function to calculate the total number of driving days using the values in the Date column in the range D5:D25.  Total days of driving is calculated in cell B5 using the COUNT function in the range D5:D25. The total days would be 21 o To get the total days 21 enter the following formula in the formula tab. o =Count (D5:D25) 10. In cell B6, use the SUM function to calculate the total number of driving hours using the values in the hours column in the range J5:J25.  Total hours of driving is calculated in cell B6 using SUM function. The total hours is 156.75 o To get this number enter the formula in the formula tab bar.  =SUM(J5:J25) 11. In cell B7, enter a formula that divides the hours of driving value (cell B6) by the days of driving value (cell B5) to calculate the average hours of driving per day.  Average hours of driving per day is calculated in cell B7, the amount is 7.46 o To get this number enter the following formula  =B6/B5 12. In cell B9, using the SUM function to calculate the driver’s Total expenses for the month for fuel, tolls and miscellaneous expenditures using the nonadjacent range N5:N25, P5:Q25.  Total Expenses for the month is calculated in cell B9 using the SUM function o Enter the formula =SUM(N5:N25:, P5:Q25) the expenses come out to be $5,347.72 o This function essentially adds values 13. In cell B10, use the SUM function to calculate the total amount the driver spent on fuel using the range N5:N25. In cell B11, use the SUM function to calculate the total amount spent on tolls and miscellaneous expenses using the range P5:Q25.  Total fuel expenses for the month is calculated using the SUM function o Total expenses is found as $4,021.73 o To get this number enter the formula  =SUM(N5:N25)

14. In Cell B13, use the SUM to function to calculate the total gallons of gas the driver used during the month using the range L5:L25. In cell B14, use the SUM function to calculate the total number of miles driven that month using the range I5:I25 15. In Cell B15, Enter a formula that divides the total miles (cell B14) by the total gallons (Cell B13) to calculate the miles per gallon. In the cell B16, enter a formula that divides the total expenses (cell B9) by the total miles driven (cell B14) to calculate the cost per mile. 16. Cross State Trucking wants to keep the cost of driving and delivering goods to less than 65 cents per mile. If the cost per mile is greater than 65 cents, enter over budget in cell B4, other wise enter on budget in cell B4. 17. In cell A1, increase the font size of the text to 28 points. In cell D3 and cell L3, Increase the font size of the Mileage Table and Expense Tables to 18 points 18. Change the worksheet to landscape orientation. Scale the printout so that the worksheet is scaled to 1 page wide by 1 page tall. If you are instructed to print, print the entire workbook.

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

Related Documents

CS 171 lab 5.pdf

CS 171 Lab 1.pdf

prove.py

ECOR1041_Midterm_F23_B_SOLUTION.pdf

CPSC assigment #1.pdf

Module 3 (Computer Applications.docx

Lab-3 WORKSHEET Answer.docx

World project for one controller to another.docx

Th64-CSE360-Phase-3.docx.pdf

data-8hw4.pdf

hw04.pdf

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

Microsoft Visual C#

Computer Science

ISBN:9781337102100

Author:Joyce, Farrell.

Publisher:Cengage Learning,

CMPTR

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage