INTRO TO FAK ET

Question 1

• Allows user to organize data in rows and columns and perform calculations on the data.
• These rows and columns collectively are called
  Worksheet.

Answer 1

Spreadsheet Software

Question 2

Examples of Spreadsheet Software

Answer 2

Examples of Spreadsheet Software
• LibreOffice Calc
• OpenOffice.org Calc
• Google sheets
• Apple iWork Numbers
• Kingsoft Office Spreadsheets
• StarOffice Calc
• Microsoft Excel

Question 3

horizontal line of entries in a table

Answer 3

Row

Question 4

vertical line of entries in a table

Answer 4

Columns

Question 5

the place where information is held in a spreadsheet

Answer 5

Cell

Question 6

the selected cell

Answer 6

active cell

Question 7

the box at the top of each column containing a letter

Answer 7

column heading

Question 8

the bow at the left side that contains numbers

Answer 8

row heading

Question 9

• the cell address of the cell usually combines with letters and numbers

Answer 9

Cell reference

Question 10

combining or joining two or more cells

Answer 10

Merge

Question 11

an expression which calculates the value of a cell

Answer 11

Formula

Question 12

• are predefined formulas and are already available in excel

Answer 12

Functions

Question 13

• the bar that contains the contents of a cell

Answer 13

Formula bar

Question 14

• Allows you to create documents and combine or merge them with another document or cata file.
• Commonly used when sending out advertising materials to various recipient.

Answer 14

Mail Merge and Label Generation

Question 15

• Create a document and just copy and paste it several times then just replace the details sepending on whom you send it to.
But what if you have hundreds or thousands of recipients? Would not that take too many hours?
What if you have a small database of information where you can automatically generate those letters?’

Answer 15

Manual Method

Question 16

• Basically requires two components: the document that contains the message and the document or file that generally containe the list of names and addresses, as in our scenario.
• When these two documents are
combined(merged) during mail merging, feed your printer with enough paper until all mailers are printed out.

Answer 16

Mail Merging

Question 17

how many rows are there?

Answer 17

1,048,576

Question 18

how many columns are there?

Answer 18

16,384

Question 19

spreadsheet software has how many sheets?

Answer 19

255

Question 20

the right to keep personal matters privately

Answer 20

privacy

Question 21

-Government surveillance
-Security encryption

Answer 21

Constitutional

Question 22

transactional data collection and processing

Answer 22

Privacy in e commerce

Question 23

involves cookies and RFID

Answer 23

Specific technologies

Question 24

being construed by another

Answer 24

Profiling and data mining

Question 25

being limited by another

Answer 25

control over information received

Question 26

what values are served by preventing or limiting the flow of true info?

Answer 26

-sphere of freedom from law -sphere of freedom from norms -sphere of freedom from markets -power of self definition

Question 27

Formula of sumif?

Answer 27

=SUMIF (range, criteria, [sum_range])

Question 28

Formula of countif?

Answer 28

=COUNTIF (range, criteria)

Question 29

Formula of If?

Answer 29

=IF(logical test, [value_if_true], [value_if_false]

Question 30

Formula of averageif?

Answer 30

= AVERAGEIF(range, criteria, [average_range])