spread sheets Flashcards

1
Q

define an electronic spreadsheet

A

an application software used to organise and analyze numerical data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

name the examples of spreadsheets

A

Microsoft Excel, Open Office,i work number, lotus 1-2-5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

name the components of a spreadsheet

A

workSHEET, graphs, database functionality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

DEFINE A WORKSHEET

A

A COMPONENT OF A SPREADSHEET THAT HAS ROWS, COLUMNS AND CELLS WHERE DATA IS ENTERED

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DEFINE DATABASE

A

A COLLECTION OF RELATED DATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DEFINE GRAPHS

A

A COMPONENT OF A SPREADSHEET THAT ENABLES THE USER TO REPRESENT DATA IN A GRAPHICAL FORM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

NAME THE APPLICATION AREAS FOR SPREADSHEET PROGRAMS

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

NAME OTHER APPLICATIONS OF SPREADSHEETS PROGRAMS

A

1 USED IN FORECASTING ECONOMIC TRENDS [2]MATHEMATICAL AND SCIENTIFIC ANALYSIS [3]ACCOUNTING

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

STATE THE PROCEDURE OF STARTING MICROSOFT EXCEL

A

CLICK ON THE START BUTTON ON THE TASK BAR [2 ] CLICK THE MICROSOFT OFFICE 2013 [3] CLICK MICROSOFT EXCEL 2013

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

NAME THE CATEGORIES OF DATA IN A CELL

A

LABELS;[2]VALUES [3]FORMULAE [4]FUNTION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

DEFINE A LABEL

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

DEFINE VALUES

A

THEY ARE TEXTS THAT CAN BE MANIPULATED MATHEMATICALLY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly