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
Posted By
Questions:
17075
Tutorials:
17013
Feedback Score:

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:
prof.Charlie
Questions:
17075
Tutorials:
17013
Feedback Score:
Tutorial Preview ……
Attachments
soln.zip (652.26 KB)
Preview not available.
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable