Learn Introduction To Spreadsheets

SPREADSHEETS Introduction, concepts and starting spreadsheet application Components of a spreadsheet Worksheet Data management Graphs Macros Page settings and printingIntroduction, concepts and starting spreadsheet application Electronic spreadsheet is an application software used to calculate, organize and analyze numerical dataAdvantages of spreadsheet Utilizes the powerful aspects of computer like speed, accuracy and efficiency to enable user quickly accomplish tasks Offer large space for data entry, manipulation and storage Can store data for future reference Enables user produce neat work Have powerful document formatting capabilities Have inbuilt formulae called functions that the user can quickly manipulate mathematical data Automatically adjust results of a formula if the values are changed. This is called automatic recalculation feature.Application areas of a spreadsheet Statistical analysis Spreadsheet provides a set of data analysis tools that can be used to perform simple analysis like mean, mode etc Accounting Accountants find electronic spreadsheet useful tool for analyzing financial transactions. Mathematical and scientific Spreadsheets are used to solve mathematical and scientific problems such as arithmetic and trigonometric Forecasting A feature known as What if analysis is used to make future predictions.Examples of electronic spreadsheets Microsoft excel OpenOffice calc Lotus 1-2-3 Corel Quattro Pro NB: We will base our study on