VOIM 220 assignment
Question # 00527969
Posted By:
Updated on: 05/15/2017 07:30 AM Due on: 05/15/2017
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
-
Rating:
5/
Solution: VOIM 220 assignment