Office 2010 - Excel Intermediate - Using Functions
Interactive

Office 2010 - Excel Intermediate - Using Functions

Jenison
Updated Nov 07, 2018

Learning Objectives

  • Identify function components
  • Use the now function
  • Use the average function
  • Use the maxand min function
  • Use the count function
  • Apply the if function
  • Work with the pmt function
  • Edit functions

Course Overview

  • Functions perform various calculations by using specific values, known as arguments.
  • To quickly display a list of functions, and their respective descriptions, use the Insert Function button.
  • To be able to use the current date and time in calculations, use the NOW function.
  • The IF function, which enables you to evaluate if a condition in a worksheet is true or false, produces different results depending upon the true/false value of the condition.
  • The PMT function enables you to work out any periodic payments, such as a loan or mortgage repayment.
;