VOIM 220 assignment

Question # 00527969 Posted By: Prof.Longines Updated on: 05/15/2017 07:30 AM Due on: 05/15/2017
Subject Computer Science Topic Algorithms Tutorials:
Question
Dot Image

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
Dot Image
Tutorials for this Question
  1. Tutorial # 00525001 Posted By: Prof.Longines Posted on: 05/15/2017 07:31 AM
    Puchased By: 2
    Tutorial Preview
    The solution of VOIM 220 assignment...
    Attachments
    soln.zip (652.26 KB)

Great! We have found the solution of this question!

Whatsapp Lisa