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:
17190
Tutorials:
17132
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

Tags aignment voim select daily range apply format create names calculate change month march style column list functions display type accent weekly accountingstyle text sumproduct formula income rentals merge doubleclick symbol formulas a1and

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:
17190
Tutorials:
17132
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview ……
Attachments
soln.zip (652.26 KB)
Preview not available.
Purchase this Tutorial @ $18.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
Loading...