Databases And SpreadSheets

A friend asks if you want to go see the new Avengers movie but you say it's too expensive. What formula would provide the percentage increase?

= (10 - 8) / 8 * 100

In the financial world, which color represents credits or profits?

Black

Select two common uses of spreadsheets.

Budgeting and finance

The role of a DBA is to ________Blank and maintain tables in a relational database.

Build

The Foreign Key is a ________Blank field between tables that is not the primary key.

Common

In Google Sheets, what are two methods that allow a user to move data from one cell to another cell?

Drag the data to the desired cell when the cursor changes to a drag hand. Double-click the cell and then drag the data to the desired cell.

f you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ________ options.

Freeze

The total amount of money (principal + interest) that lender receives from a borrower at the end of the loan is referred to as the loan's

Future Value

Select the two spreadsheet programs.

Google Slides and Apple Numbers

The steps in the data project life cycle, according to Harvard University's Data Science Ready Project include which three of the following?

Sensing, collection, wrangling

Which of the following are standard SQL commands?

Update, create, drop

Data redundancy can lead to which three of the following?

increased storage fees, inefficient access times, inconsistent data

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called

spreadsheets.

An ERD requires the use of various ________Blank and ________Blank that help visualize two types of information: the entities within the system and the interrelationship among the entities.

symbols and oppositions