NEW
Font size
WorksheetsBusiness Data Applications
Total questions: 20
Worksheet time: 10mins
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
What is design view?
helps you see the database
It is used to design and edit your database
used to delete some info
What is the correct order to run a query?
go to create in the ribbon--->click "simple query"---> delete info---> click "run"
go to create in the ribbon--->click "simple query"---> put down info
go to create in the ribbon--->click "simple query"---> put down info---> click "run"
go to create in the ribbon--->put down info---> click "run"
What is a legitimate example of a database?
Microsoft Access
Excel
Google Sheets
Google Docs
What is a function?
is a predefined formula already generated in a database
an expression that uses cell references or hard-coded numbers to calculate the value of a cell
What is a formula?
an expression that uses cell references or hard-coded numbers to calculate the value of a cell
is a predefined formula already available in Excel
used for an equation
the krabby patty formula
A fill handle pulls down the formula you have put down, and drag onto other cells
True
False
A pivot table allows you to extract the information from a large, detailed spreadsheet
True
False
Data accuracy is important because...
If you have faulty data, you will end up with faulty work and predictions regarding your database or spreadsheet
It is not really important
So you can maintain a good grade in your class
Having accurate data is almost impossible to have since research is not really reliable
What determines a database as an Excel file?
.com
@
.xlxs
.xlsx
To make a google sheet into a Microsoft Excel, you have to click "File" and then "Download" then you will choose Microsoft Excel (.xlsx) on google sheets
True
False
