Spreadsheet
Database
Computer Threats
Fundamentals
Word Processing
100

What feature in spreadsheet extracts data from a table based on some criteria.

Advanced Filtering

100

What feature in Database maintains data accuracy between data in the tables.

Relationships

100

Pretending to be someone else to steal information is called

Identity theft

100

Which input device is used to read data off cheques.

MICR

100

Name the tab used to create fillable forms

Developer tab

200

What formula checks the number of book categories in a table.

=COUNTA

200

Explain how to form a relationship between two tables.

Close all open tables, select database tools, match the primary key and foreign key of the tables and enforce referential integrity.

200

Getting sensitive information by deceiving the user through an email

Phishing

200

Name three output device

printer, speaker, plotter

200

List three content controls used in a fillable form

rich text, date picker, combo box, drop down list, check box

300

What feature in spreadsheet allows us to summarise and manipulate data without changing the data in the table.

Pivot table

300

Name three objects that be used to analyse and manipulate data.

queries, reports, forms

300

Breaking into someone account

Hacking

300
Which input device marks multiple choice scripts

OMR

300

What content control can be used for date of birth, date registered

date picker


400

Briefly explain how to create a pie chart to show total number of various fruits sold.

Select Quantity and then hold down ctrl select the fruits column and then click insert, select pie chart. Place title above chart.

400

List any three data types used in access(database)

currency, short text, Long text, number, date and time

400

Listening to personal calls to get information

Electronic Eavesdropping

400

Name THREE input devices

keyboard, mouse, joystick, scanner, microphone

400

when doing mail merge state the first step

create recipient list ( contact information)

500

If a table has item cost and No. Sold. State the formula used to show Total Cost

=product(item cost*No.SOld)

500

Explain why we should maintain integrity of data in a database

maintains consistency of data, prevents data loss and corruption, accuracy in decision making

500

Using the internet to embarrass or hurt someone

Cyber bullying

500

Which input device converts handwritten text into digital form

OCR

500

Why do we create fillable forms

more organized data, ease of use, faster, more efficient, accuracy of data

M
e
n
u