Question 1

When typing text in a word processing program, you should only press ____ after a short line (like a title), at the end of a paragraph, and to leave a blank line between paragraphs.

Accepted Answer

When typing text in a word processing program, you should only press Enter after a short line (like a title), at the end of a paragraph, and to leave a blank line between paragraphs.

Question 2

Businesses and many individuals often use office suites, sometimes called ____, to produce written documents.

Accepted Answer

"Productivity software suites" is the most accurate term used to describe Office suites as they typically include programs such as word processors, spreadsheets, and presentation software that are commonly used in business and personal settings to increase productivity. The other options listed are not commonly used terms to describe office suites.

Question 3

The keyboard shortcut [Ctrl]+[Z] is used to ____ the last change to the document.

Accepted Answer

The keyboard shortcut [Ctrl]+[Z] is used to "Undo" the last change to the document. This means it allows you to reverse or delete the most recent action or typing.

Question 4

The ____ is a tool in versions of Microsoft Office starting with Office 2007 that consists of tabs, which contain groups of related command buttons for the program being used.

Accepted Answer

The Ribbon is a tool in versions of Microsoft Office starting with Office 2007 that consists of tabs, which contain groups of related command buttons for the program being used. It is not the shortcut menu, menu bar, or wizard.

Question 5

A(n) ____ is a named, preprogrammed formula, such as to compute the average of a group of cells or to calculate a mortgage payment amount.

Accepted Answer

A function is a preprogrammed formula that performs a specific calculation, such as finding the average of a group of cells or calculating a mortgage payment amount. Arguments are the values or references that a function uses to perform its calculation. Labels are used to identify data and do not perform calculations. Cells are the individual boxes within a spreadsheet where data is entered and stored.

Question 6

A single spreadsheet document is often called a ____.

Accepted Answer

A single spreadsheet document is often referred to as a worksheet, which is a single page or tab within a workbook.

Question 7

In spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas when they are copied depends on whether they use relative cell referencing or ____.

Accepted Answer

Absolute cell referencing uses a fixed cell reference in a formula, regardless of where it is copied, ensuring that the formula will always refer to the intended cells. This is useful when creating formulas that need to be applied to multiple cells but always refer to specific cells, such as a tax rate or commission percentage.

Question 8

In a worksheet, the intersection of a row and a column is called a ____.

Accepted Answer

The intersection of a row and a column in a worksheet is called a cell.

Question 9

When selecting font size in a document, ____ points equals one-inch-tall text.

Accepted Answer

The standard measurement for font size is points, and there are 72 points in one inch. Therefore, font size 72 would be one-inch-tall text.

Question 10

____ can be used, copied, modified, and distributed to others without restrictions.

Accepted Answer

Public domain software is software that can be freely used, modified, copied, and distributed without any restrictions. This is because the software's original copyright holder has relinquished their rights to the software, or because the software's copyright has expired. Shareware often comes with restrictions or limitations, and commercial software is typically protected by copyright laws. Freeware is similar to public domain software, but may still have some restrictions on its use or distribution.

Question 11

Most ____ programs are available to try free of charge, but typically require a small fee if you choose to use the program regularly.

Accepted Answer

Shareware programs are typically available to try for free, but require payment if you use them regularly. Freeware programs are always free to use, while commercial programs are usually not available for free at all. Public domain programs are not protected by copyright and can be used freely by anyone.

Question 12

The most common type of database used with personal computers today is a ____.

Accepted Answer

Relational databases are the most commonly used database type with personal computers today. They organize data into tables with columns and rows, and allow for easy querying and manipulation of data. Two-way databases and concurrent databases are not common database types, and a one-dimensional database does not exist.

Question 13

Many business software services are offered as ____, including applications geared for collaboration, scheduling, customer service, accounting, project management, and more.

Accepted Answer

Software as a Service (SaaS) is a delivery model where the software is hosted on the cloud and accessed via the internet. It is a popular model for business software services as it allows for easy scalability, flexible pricing options, and automatic updates. Download services, ISPs, and running services are not appropriate choices as they do not accurately describe the delivery model of business software services.

Question 14

Some mobile apps are designed to be compatible with popular ____ such as Microsoft Office.

Accepted Answer

Mobile apps designed to be compatible with popular desktop software such as Microsoft Office are typically designed to work with traditional desktop operating systems, not web-based or internet utilities.

Question 15

Word processing programs use a feature called ____, which means the insertion point automatically moves to the beginning of the next line when the end of the screen line is reached.

Accepted Answer

Word wrap is the feature that automatically moves the insertion point to the beginning of the next line when the end of the screen line is reached. Character wrap and letter wrap are not commonly used terms in modern word processing programs. Character overflow is not a feature, but rather an issue that occurs when a line of text is too long to fit within the margins of a document.

Question 16

____ programs are software programs that are distributed on the honor system.

Accepted Answer

Shareware programs are distributed on the honor system, allowing users to try the software for a limited trial period before either purchasing the program or uninstalling it. Freeware programs are free to use, but do not necessarily rely on honor system distribution. Commercial programs are typically sold for a set price and require a license. Public domain programs are free and open for anyone to use or modify without restriction.

Question 17

A ____ is a group of values and other data organized into rows and columns, similar to the ruled paper worksheets traditionally used by bookkeepers and accountants.

Accepted Answer

A spreadsheet is a software application designed to organize, analyze and manipulate data in a tabular format. It consists of cells organized into rows and columns, which can contain various types of data such as text, numbers, and formulas. Spreadsheets are commonly used in business, accounting, finance and other fields to perform calculations, track expenses and revenues, manage inventory, and more.

Question 18

Related software programs (such as a group of graphics programs, utility programs, or office-related software) are sometimes sold bundled together as a ____.

Accepted Answer

A group of related software programs sold bundled together is called a software suite. Choice B, C, and D are not applicable in this context.

Question 19

Charts are inserted into an Excel spreadsheet using the commands in the Charts group on the ____ tab on the Ribbon.

Accepted Answer

The Charts group, which contains commands for inserting charts, is located on the Insert tab on the Ribbon in Excel.

Question 20

Most application programs have a built-in help feature, typically available through a(n) ____ button.

Accepted Answer

Most application programs have a built-in help feature, typically available through a Help button. This button is usually located in the menu bar or toolbar of the program's interface. Choosing the Help option will usually open a new window or dialog box that contains information about the program's various features and functions, as well as troubleshooting tips and other helpful information.

Quiz 6: Application Software: Desktop and Mobile Apps

When typing text in a word processing program, you should only press ____ after a short line (like a title) , at the end of a paragraph, and to leave a blank line between paragraphs.

Businesses and many individuals often use office suites, sometimes called ____, to produce written documents.

The keyboard shortcut [Ctrl]+[Z] is used to ____ the last change to the document.

The ____ is a tool in versions of Microsoft Office starting with Office 2007 that consists of tabs, which contain groups of related command buttons for the program being used.

A(n) ____ is a named, preprogrammed formula, such as to compute the average of a group of cells or to calculate a mortgage payment amount.

A single spreadsheet document is often called a ____.

In spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas when they are copied depends on whether they use relative cell referencing or ____.

In a worksheet, the intersection of a row and a column is called a ____.

When selecting font size in a document, ____ points equals one-inch-tall text.

____ can be used, copied, modified, and distributed to others without restrictions.

Most ____ programs are available to try free of charge, but typically require a small fee if you choose to use the program regularly.

The most common type of database used with personal computers today is a ____.

Many business software services are offered as ____, including applications geared for collaboration, scheduling, customer service, accounting, project management, and more.

Some mobile apps are designed to be compatible with popular ____ such as Microsoft Office.

Word processing programs use a feature called ____, which means the insertion point automatically moves to the beginning of the next line when the end of the screen line is reached.

____ programs are software programs that are distributed on the honor system.

A ____ is a group of values and other data organized into rows and columns, similar to the ruled paper worksheets traditionally used by bookkeepers and accountants.

Related software programs (such as a group of graphics programs, utility programs, or office-related software) are sometimes sold bundled together as a ____.

Charts are inserted into an Excel spreadsheet using the commands in the Charts group on the ____ tab on the Ribbon.

Most application programs have a built-in help feature, typically available through a(n) ____ button.