spread sheets Flashcards
define an electronic spreadsheet
an application software used to organise and analyze numerical data
name the examples of spreadsheets
Microsoft Excel, Open Office,i work number, lotus 1-2-5
name the components of a spreadsheet
workSHEET, graphs, database functionality
DEFINE A WORKSHEET
A COMPONENT OF A SPREADSHEET THAT HAS ROWS, COLUMNS AND CELLS WHERE DATA IS ENTERED
DEFINE DATABASE
A COLLECTION OF RELATED DATA
DEFINE GRAPHS
A COMPONENT OF A SPREADSHEET THAT ENABLES THE USER TO REPRESENT DATA IN A GRAPHICAL FORM
NAME THE APPLICATION AREAS FOR SPREADSHEET PROGRAMS
STATISTICAL ANALYSIS-SPREAD SHEETS APPLICATION PROVIDES A SET OF TOOLS THAT CAN BE USED TO PERFORM SIMPLER ANALYSES SUCH AS MEAN, MODE, MEDIAN AND STANDARD DEVIATION.
NAME OTHER APPLICATIONS OF SPREADSHEETS PROGRAMS
1 USED IN FORECASTING ECONOMIC TRENDS [2]MATHEMATICAL AND SCIENTIFIC ANALYSIS [3]ACCOUNTING
STATE THE PROCEDURE OF STARTING MICROSOFT EXCEL
CLICK ON THE START BUTTON ON THE TASK BAR [2 ] CLICK THE MICROSOFT OFFICE 2013 [3] CLICK MICROSOFT EXCEL 2013
NAME THE CATEGORIES OF DATA IN A CELL
LABELS;[2]VALUES [3]FORMULAE [4]FUNTION
DEFINE A LABEL
A TEXT ENTERED IN A SPREADSHEET PROGRAM THAT IS USED AS A COLUMN OR ROW HEADING TO DESCRIBE THE CONTENT OF THE ROW AND COLUMN
DEFINE VALUES
THEY ARE TEXTS THAT CAN BE MANIPULATED MATHEMATICALLY