App Logo

No.1 PSC Learning App

1M+ Downloads
Function to create a shortcut to open a stored document in hard disk or network server is:

AHyper link

BHypr link

CHyper link()

DHypr link()

Answer:

A. Hyper link

Read Explanation:

Functions in Excel

  • Function in Excel includes Mathematical functions, Statistical functions , Text functions, Logical functions
  • Statistical function in Excel

             Average() , Count() , Max() , Min(), Stdev() , Var().

  • Mathematical functions

              Abs() , Int() , Mod() , Rand() , Sqrt() , Sum()

Examples of functions

Functions              Example                              Description

Sum                      =SUM(A1:A10)                     Finds sum of cells A1 through A10

Average                =AVERAGE(A1:A10)              Finds average of the cells A1 through A10

Max                       =MAX(C1:C50)                     Finds the highest of the values from C1 to C50

Min                        =MIN(C1:C50)                     Finds the lowest number from the cells C1 to C50

  • Text functions

               Char() , Concatenate() , Len()

  • Logical functions

               And() , Or() , IF() , NOT()

  • Financial functions

              Rate() , FV() , PV() , NPV() , PMT() , IRR()

  • Function to add all the numbers in a range of Cells

               SUM()

  • Function which calculates the average of its numbers

              AVERAGE()

  • Function to check whether a condition is met IF( it returns a value if TRUE and another  value if FALSE)
  • Function to create a shortcut to open a stored document in hard disk or network server

                 Hyper link

  •  Function to count the number of cells that  contain numbers and numbers within the list of arguments : count
  • Function which returns the largest value in a set of values : MAX()
  • Function which calculates the payment for a loan based on constant payments and a constant   interest rate : PMT()
  • Function which returns the interest paid during a specific period of an investment : ISPMT()
  • Function to calculate the periodic rate of interest for an investment over a specific period

                Rate()

  • Function to calculate the future value for a series of equal investments, earning a fixed periodic rate of interest :  FV ()
  • Function to calculate the net present value of a series of future cash flows discounted a fixed interest rate : NPV()

 


Related Questions:

which is the Intersection of a column and a row on a worksheet?
The shortcut key used to select the current row in an excel
Which is the wrong command in Insert tab of MS Excel 2007?
Function which returns the interest paid during a specific period of an investment is:
____ is a feature used to join the selected cell to larger cell and centers the content in the new cell