spread sheets Flashcards
(13 cards)
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