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

3

Uploaded by ChefPantherMaster56

Report
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)
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