Business Data Applications

What is a database?

• is used to find duplicates

• copied across multiple cells, they change based on the relative position of rows and columns

• an organized collection of related data stored accessed electronically from a computer system

• used mainly to find specific data effectively

What is a spreadsheet?

• a document that is arranged in rows and columns that can be manipulated and used in calculations

• is designated for a formula

• is an organized collection of related data stored accessed electronically from a computer system

• a section at the top that holds the query wizard, data sheet view, design view, etc.

What symbol is used to do a Wildcard?

• !

• ^

• :)

• *

How do you use the symbol for the Wildcard in a database?

• You put the symbol in the middle of the word

• You put two symbols, one in front of the word, and one behind the word

• You don't use Wildcards in a Database

• It is used to delete things

C5*$C$4

• Absolute cell reference

• Relative cell reference

C5*F7

• Absolute cell reference

• Relative cell reference

A row is vertical

• True

• False

A column is horizontal

• True

• False

What is a cell?

• Something in a human body

• designed to hold specific information within a record

• used to find duplicates in a database

• used to search up information

What is conditional formatting?

• changes the appearance of the database based on color to highlight a certain part

• use to find duplicates

• changes the font of the information listed on the database

• conditional formatting is never used for a database