Question
Offered Price $18.00

VOIM 220 assignment

Question # 00527969
Subject: Computer Science
Due on: 05/15/2017
Posted On: 05/15/2017 07:30 AM

Rating:
4.1/5
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
17159
Tutorials:
17122
Feedback Score:

Purchase it
Report this Question as Inappropriate
Question

Complete Project File Name : [your initials (SJ)]

  • SelectB20and use the SUMPRODUCT function to create a formula to calculate income from daily rentals.
  • UseC5:C12for thearray1 argument
  • UseD5:D12for thearray2argument
  • Create formulas forB21andB22using SUMPRODUCT.
  • SelectB23and useSUMto calculate total rental income for the month of March.
  • SelectC5:C12and name the range Daily.
  • SelectE5:E12and name the range Weekly.
  • SelectG5:G12and name the range Monthly.
  • SelectB6and use theSumfunction and the Daily range name to calculate the number of daily rentals.
  • Type =Su to display a list of functions beginning with "SU."
  • Double-clickSUM
  • Type da to display a list of functions and range names.
  • Double-clickDaily
  • PressEnter
  • Create formulas forB27andB28usingSumand range names
  • SelectB29and create a formula to add theDaily,Weekly, andMonthlyrange names together.
  • Change the theme toSlice
  • FormatA1andA2
  • Merge & Centerand text inA1overA1:H1, and merge and center the text inA2overA2:H2
  • EditA2to Month of March
  • ApplyAccent 1cell style toA1
  • Applyboldformatting toA1andA2
  • Change the font size ofA1to18pt
  • Format the column heading (A4:H4) with cell style20% Accent 1
  • Autofit column width and row height.
  • Format the numbers in columnsD,F, andHusingAccountingstyle with no symbol. Apply theAccountingstyle with no symbol format to cellsB20:B22
  • ApplyAll BorderstoA4:H12,A20:B23, andA26:B29
  • Change the orientation tolandscape
Tutorials for this Question
Available for
$18.00

VOIM 220 assignment

Tutorial # 00525001
Posted On: 05/15/2017 07:31 AM
Posted By:
Best Tutors for school students, college students Prof.Charlie
Expert tutors with experiences and qualities
Questions:
17159
Tutorials:
17122
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview ……
Attachments
soln.zip (652.26 KB)
Purchase this Tutorial @ $18.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
Loading...