7. Information Technology Applications

What feature in word processing software is typically used to create a consistent design across a document?

• Styles

• Headers

• Tabs

• Margins

Which of the following can you use to create a bar chart from data in a spreadsheet?

• Formulas

• Data Visualization Tools

• Macros

• Cell Formatting

In database software, what is the purpose of a primary key?

• To organize data alphabetically

• To uniquely identify each record in a table

• To link tables together

• To summarize data

What is the function of a slide master in presentation software?

• To format individual slides

• To set consistent formatting for all slides

• To animate slide transitions

• To manage slide notes

Which feature allows spreadsheet software to automatically recalculate totals when values are updated?

• Macros

• Filters

• Formulas

• Templates

In presentation software, what is the purpose of the “Rehearse Timings” tool?

• To record audio for slides

• To practice and record slide durations

• To set slide layouts

• To adjust animations

Which database object is best used to retrieve specific information from a table?

• Query
• Form

• Report

• Macro

Which spreadsheet function is used to calculate the average of a range of numbers?

• =SUM()

• =IF()

• =COUNT()

• =AVERAGE()

What is the primary purpose of mail merge in word processing software?

• To create a template document

• To combine data from a database into a document

• To format a letter with specific styles

• To track document versions

Which spreadsheet tool can display trends over time?

• Pivot Table

• Line Chart

• Conditional Formatting

• Solver