ch 11 + 17 + 19

What is a foreign key used for?

Linking tables together by referencing the primary key in another table.

What does a primary key do?

Uniquely identifies each record in a database table.

Explain the difference between a primary key and a foreign key.

Primary key: Unique identifier for each record. Foreign key: Links to a primary key in another table.

What image format is identified as PNG?

Portable Network Graphic.

What does PNG stand for?

Portable Network Graphic.

What is the color depth of PNG files?

24 bits per pixel, Truecolor.

What is the advantage of using PNG format?

Supports lossless compression and transparency.

What is a function in Excel?

A special type of formula with a pre-defined name to simplify calculations.

What is a formula in Excel?

A calculation or operation typed directly into the formula bar, which can contain functions.

Why is a named range used in a spreadsheet?

Allows referring to a group of adjoining cells, making formulas shorter.

How can hyperlinks be used in spreadsheets?

To navigate from one page/place to another.

What's the difference between relative and absolute file paths?

Relative points to the current folder, absolute points to a specific location on a storage device.

What is an Excel worksheet?

An individual electronic paper within an Excel workbook.

Describe the structure of an Excel worksheet.

Divided into columns and rows, with the intersection called a cell.

What is a cell in Excel?

An intersection of a column and a row, uniquely identified by its address.

What are the three types of entries in an Excel cell?

Numbers/values, labels, and formulas.

Why is it important to enter accurate data in spreadsheets?

Incorrect data can lead to wrong results or non-functioning formulas.

Describe the content, presentation, and behavior layers in web development.

Content: Webpage structure. Presentation: Formatting. Behavior: Scripting language.

Why should you enter accurate data in spreadsheets?

To ensure data is identical to the original document and avoid formula errors.

What is a corporate house style?

A consistent format used across all documents belonging to the same organization.

Why do we need corporate house styles?

Ensure consistency, reduce setup time, reduce errors, and save cost.

What is the difference between PDF and RTF?

PDF: Portable, full formatting, allows comments. RTF: Basic formatting, fully editable.

How can a chart be created in Excel?

Select data range, choose chart type, customize chart elements.

How can the size of a document be reduced without reducing the number of images?

Compress images, reduce image resolution, remove unused elements.

Why do we need corporate house styles?

Ensures consistency across documents, reduces errors, saves time and cost.

What is the difference between PDF and RTF?

PDF: Portable, allows comments, digital signatures, compressed. RTF: Fully editable, basic formatting.

How do you create a chart in Excel?

Select data, choose chart type, customize chart elements.

How can you reduce document size without reducing the number of images?

Compress images, lower image resolution, remove unused data.

What are the web development layers?

Content layer, presentation layer, behavior layer.

Explain what is meant by house style.

A consistent format used across documents belonging to the same organization.

Name three types of objects that could be inserted into a web page.

Images, videos, hyperlinks.

What is an anchor in a web page?

Bookmark within the page for navigation purposes.

How do you resize an image?

Select image, adjust size using