MBAI-106 IT Applications – Unit 8
Questions: understand the basic features of Excel such as creation of worksheets and computation of data; understand how to construct and insert formulas; and learn about various kinds of functions available in MS-Excel and their uses.
Materials:
The relevant material is available here.
Questions:
- What is the key combination used to find the result for an Array Formula? Why is it used?
- Define Functions is MS Excel.
- Name the formula categories shown under the Formulas Tab in MS Excel.
- Why does the “#VALUE!” error come up when adding or subtracting the cells in MS Excel?
- What is the difference between PV and NPV formulae in MS Excel?