Spreadsheets
Hi, i have attached two word file the first one is the SP assignment (PLEASE DO WHAT EXACTLY REQUIRED) and the second one is the policies of the assignment…
please DO YOUR BEST..
……………………..Answer preview………………………..
Spreadsheets Have plenty of formulas that can be used. Some of the functions and formulas are commonly used. They include:
Conditional formulas for instance used to; hide or display zero values, hide error indicator and error values in a cell, etc.
Lookup and reference functions- They are used to efficiently and quickly get a specific data in a list and to verify that the correct data is being used. Some of the ways to look u date and display include;
VLOOKUP function which is used to look up values that are vertically organized in a list using an exact match or an approximate match
HLOOKUP function will look up value horizontally on a list using an exact match or an approximate match…………………………..
APA
734 words
