Intro: Business Productivity Software

Which software is best for writing a formal business letter?

• Word processing software

• Spreadsheet software

• Presentation software

• Database software

Answer explanation

Word processing software is designed for text-based documents like formal letters. Spreadsheet software handles numerical data, not written correspondence.

Tags

Blooms Level: Remember

Which tool most efficiently calculates monthly sales totals across regions?

• Spreadsheet with built-in formulas

• Presentation slide deck

• Word processing document

• Database query report

Answer explanation

Spreadsheets use formulas to calculate and compare numerical totals quickly. A database query organizes records but requires more setup for quick numerical summaries.

Tags

Blooms Level: Apply

What spreadsheet feature summarizes large data sets by category?

• Mail merge

• Slide transition

• Text template

• Pivot table

Answer explanation

A pivot table reorganizes and summarizes data by category without changing the original data set. Mail merge combines data with documents, not summaries.

Tags

Blooms Level: Remember

How does a database differ from a spreadsheet for storing records?

• Database links tables; spreadsheet uses flat rows

• Database displays charts; spreadsheet stores text

• Database formats pages; spreadsheet manages email

• Database runs slideshows; spreadsheet tracks contacts

Answer explanation

Databases link related tables and handle large structured records efficiently. Spreadsheets store data in flat rows and are better suited for calculations than relational records.

Tags

Blooms Level: Understand

Which feature sends personalized letters to recipients automatically?

• Slide animation effect

• Pivot table summary

• Mail merge tool

• Macro recording script

Answer explanation

Mail merge combines a document template with a data source to produce personalized copies for each recipient. A macro automates repeated tasks but does not merge contact data into letters.

Tags

Blooms Level: Remember

Which tool saves a report's margins and fonts for future use?

• Saved formula set

• Database filter

• Document template

• Presentation theme

Answer explanation

A document template stores pre-set formatting so every new report starts with the same layout. A presentation theme applies to slide decks, not word processing documents.

Tags

Blooms Level: Apply

Which software is the best choice for building a sales meeting slide deck?

• Presentation software

• Word processing software

• Spreadsheet software

• Database software

Answer explanation

Presentation software is designed to create and display slide decks with visuals and speaker notes. Word processing software produces text documents, not slideshows.

Tags

Blooms Level: Remember

In a spreadsheet, how does a formula differ from a function?

• Formula uses operators and references; function is pre-built

• Formula is a built-in shortcut; function is custom-written

• Formula displays charts; function formats cell borders

• Formula sorts records; function filters table data

Answer explanation

A formula is any expression built with operators and cell references, while a function is a named pre-built operation like SUM or AVERAGE used inside formulas.

Tags

Blooms Level: Understand