Question

1. Excel worksheets can accommodate two basic types of information, namely Formulae and constants.   

1. Explain the terms Formulae and Constant.
2. List three characteristics of formulae and constant respectively.

Answer 1

1) Formulae and constant = it is a simple calculation to define one constant CELL in excel

Constant formula= Sheet1!$D$1

$ will lock the cell number and use i as formulas

A	B	C	D
1	Year	Revenue per year	Growth rate 50 percent
2	2015	$100000	(constant formula of selecting the cell with $ sign before cell C) 10000
3	2016	$150000	(150000+50 percent ) $225000
4	2017	$200000	($200000+50 percent constant) $250000
5	2018	$250000	($250000+ 50 percent constant) $ 337500

2) charactorisitcs of formulae and constant

-Finding the growth rate of an organization keeping the cell constant

- Adding the same value for the next cells consecutively

- any big firms will use the formulae and constant to add thousands of sales sold and growth percentage to calculate future value