What is on the Exam October 9th for COMP1003.docx - What is...

This preview shows page 1 out of 1 page.

What is on the Exam October 9th?What is:AutocorrectAutocompleteAutofilland give an exampleWrite the formula for:SumMaximumMinimumAverageCountfor a set of cellsThese are what appear under autosumWhat is the difference between absolute value and relative value.Give an exampleIn Chapter 4 we covered:PMT formula =PMT(Rate,nper,PV,[FV],[type])Present value, Future valueThere were some of the pieces of the formula that we could have used or left out, what were they.Know what to do when the period is a year vs monthly to make the formula work.What do you do to make the payment value appear as a positive number vs a negative number and why?How to name a cell and / or range of cells.How to make a cell absolute. You can do it more than one way.
End of preview. Want to read the entire page?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
NoProfessor
Tags
Addition, Negative and non negative numbers

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture