How would you decide whether to use a formula or a function in a Word table?
What will be an ideal response?
Often, a function provides a shorter and simpler version of a formula. For example, to sum or average a lengthy range of numbers, the SUM or AVERAGE function would be shorter and simpler than an equivalent formula. However, a function is not always available as a substitute for a formula; in that case, it would be necessary to use a formula.
You might also like to view...
A filter is a set of ________ applied to fields to display specific records, for example, a specific city
A) data B) rules C) criteria D) records
Identify the correct formula to calculate the cumulative interest paid on a mortgage loan for the second year of the loan (periods 13-24, where rate is 9%, nper is 5, and present value is $250,000
A) =CUMIPMT(.09/12, 30/12,-250000,24,13,0 ) B) =CUMIPMT(.09*12, 30/12,-250000,13,24,0 ) C) =-CUMIPMT(.09/12, 5*12, 250000,13,24,0 ) D) =CUMIPMT(.09/12, 5*12, 250000,24,13,0 )