Question 1

Which of the following performs calculations on the data in a worksheet like the one in the accompanying figure and displays the resulting value in a cell?
A) index
B) formula
C) function
D) ratio

Accepted Answer

A formula performs calculations on the data in a worksheet and displays the resulting value in a cell. An index is a reference tool that shows where specific information can be found in a larger document or data set. A function is a pre-built formula that performs specific calculations or operations on data. A ratio is a comparison of two or more values or quantities.

Question 2

Which of the following kinds of software enables users to enter typed text, handwritten comments, drawings, or sketches anywhere on a page and then save the page as part of a notebook?
A) sketching
B) notebook
C) note taking
D) PDA

Accepted Answer

Note-taking software allows users to enter various types of content, including typed text, handwritten comments, drawings, or sketches, on a virtual page. This content can then be saved as part of a digital notebook, making it a versatile tool for capturing and organizing information in different formats.

Question 3

What kind of software assists in the preparation of a will, for example?
A) legal
B) tax
C) document management
D) financial

Accepted Answer

Legal software, specifically estate planning software, assists in the preparation of wills by providing tools and templates for creating and customizing legal documents. This software helps individuals ensure their wills meet legal requirements and are properly executed.

Question 4

What kind of software consists of programs designed to make users more productive and/or assist them with personal tasks?
A) application
B) utility
C) operating
D) system

Accepted Answer

Applications are software programs designed to make users more productive and/or assist them with personal tasks, such as word processors, spreadsheets, and email clients. Utility software, on the other hand, is designed to maintain and optimize the performance of the computer system, such as antivirus software and disk cleanup tools. Operating systems are the core software that manages the hardware and software resources of the computer, while system software refers to all software programs that coordinate the activities and functions of the hardware and other software components of a computer system.

Question 5

Which of the following kinds of software allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group?
A) desktop publishing
B) image editing
C) presentation
D) communications

Accepted Answer

Presentation software, such as Microsoft PowerPoint or Google Slides, specifically allows users to create and share visual aids for presentations to communicate ideas and messages to a group. Desktop publishing software is used for creating documents with complex layouts, while image editing software is used for manipulating images. Communications software generally refers to tools used for messaging and video conferencing.

Question 6

Which of the following kinds of software allows users to create and manipulate documents containing mostly text and sometimes graphics?
A) desktop publishing
B) contextual
C) image processing
D) word processing

Accepted Answer

Word processing software allows users to create and manipulate documents containing mainly text and sometimes graphics. Desktop publishing software is more focused on layout and design, contextual software is a type of software that provides context-sensitive information based on user input, and image processing software primarily deals with editing and manipulating images.

Question 7

Which kind of software can be distributed by anyone to others at no cost?
A) freeware
B) public-domain
C) shareware
D) open source software

Accepted Answer

The answer of Which kind of software can be distributed...

Question 8

A single point as shown in the accompanying figure is about what fraction of an inch in height?
A) 1/9
B) 1/18
C) 1/36
D) 1/72

Accepted Answer

The answer of  A single point as shown in...

Question 9

In the accompanying figure, 12 point and 28 point are measurements of which of the following?
A) graph scope
B) data valence
C) font size
D) textual ratio

Accepted Answer

12 point and 28 point refer to font sizes, as they are measurements of the size of the text.

Question 10

What is the term for a square-shaped coded graphic that corresponds to a web address or other information?
A) ISBN code
B) bar code
C) USPS code
D) QR code

Accepted Answer

QR code is a square-shaped coded graphic that corresponds to a web address or other information. ISBN code is used for identifying books, bar code is used for identifying products, and USPS code is used for identifying mail.

Question 11

Which of the following (with examples such as Cambria and Calibri shown in the accompanying figure) is a name assigned to a specific design of characters?
A) point
B) font
C) text set
D) iconography

Accepted Answer

A font is a name assigned to a specific design of characters, such as Cambria and Calibri shown in the accompanying figure. Points refer to the size of the characters, text set refers to the arrangement of text, and iconography refers to the use of icons or symbols.

Question 12

Which of the following is a request for specific data from a database?
A) query
B) formula
C) resample
D) function

Accepted Answer

A query is a request for specific data from a database. A formula is a calculation performed in a spreadsheet, a resample refers to the process of obtaining a new sample from an existing sample, and a function is a built-in operation in a programming language. Therefore, the best choice is A.

Question 13

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
A) spreadsheet
B) formula
C) database
D) functional set

Accepted Answer

A database is specifically designed to store and manage data in a way that allows for easy access and retrieval. Spreadsheets can be used to store data as well, but they do not have the same level of functionality and organization as a database. Formulas and functional sets are not collections of data, but rather mathematical operations or programming concepts.

Question 14

Which of the following programs allow designers to rotate designs of 3-D objects to view them from any angle?
A) CAD
B) DTP
C) CAM
D) DTM

Accepted Answer

CAD (Computer-Aided Design) programs allow designers to create and manipulate 3-D objects, including the ability to rotate the designs and view them from any angle. DTP (Desktop Publishing) programs are used for page layout and design, CAM (Computer-Aided Manufacturing) programs are used for designing and controlling production machinery, and DTM (Digital Terrain Modeling) programs are used for creating and analyzing maps and terrain data.

Question 15

Many worksheet cells like those in the accompanying figure contain a number that can be used in a calculation. What is the name for this?
A) function
B) index
C) formula
D) value

Accepted Answer

The name for a cell that contains a number that can be used in a calculation is simply a "value." A function is a predefined formula that performs a specific calculation, an index is a reference point, and a formula is an equation that uses values, functions, and/or operators to perform a calculation.

Question 16

Which of the following is a collection of individual programs sold as a unit?
A) software cluster
B) software suite
C) software aggregate
D) software archive

Accepted Answer

A software suite is a collection of individual programs sold as a unit, typically including programs for word processing, spreadsheet creation, presentation design, and more. A software cluster, software aggregate, and software archive are not commonly used terms in the software industry.

Question 17

Which of the following is a collection of electronic drawings, photos, and other images that can be inserted into documents?
A) clip art
B) graphics checkers
C) glossaries
D) image repositories

Accepted Answer

Clip art refers to a collection of electronic drawings, photos, and other images that can be inserted into documents. Graphics checkers refer to software tools used to check the quality of computer graphics. Glossaries are collections of terms and their definitions. Image repositories can refer to any collection of images stored in a database or other storage system.

Question 18

When using spreadsheet software like the kind in the accompanying figure, what are the rows and columns collectively called?
A) workbook
B) workspace
C) workload
D) worksheet

Accepted Answer

Rows and columns together form a grid-like structure that is known as a worksheet in spreadsheet software. A workbook is a file containing multiple worksheets, a workspace is a digital area where work is performed, and workload is a measure of the amount of work to be done.

Question 19

Which of the following kinds of software provides a means for sharing, distributing, and searching through documents by converting them into a format that can be viewed by any user?
A) tax preparation
B) business
C) document management
D) accounting

Accepted Answer

Document management software provides a means for sharing and distributing documents and converting them into a format that can be viewed by any user. Tax preparation, business, and accounting software do not necessarily have this capability.

Question 20

Which of the following (with examples such as the bold, italic, and underline shown in the accompanying figure) adds emphasis to a font?
A) font style
B) font point
C) font face
D) font weight

Accepted Answer

Font style is what adds emphasis to a font, such as bold, italic, and underline shown in the accompanying figure. Font point determines the size of the font, font face refers to the specific design of the characters, and font weight determines the thickness of the strokes in the characters.

Quiz 4: Programs and Apps

Which of the following performs calculations on the data in a worksheet like the one in the accompanying figure and displays the resulting value in a cell?

Which of the following kinds of software enables users to enter typed text, handwritten comments, drawings, or sketches anywhere on a page and then save the page as part of a notebook?

What kind of software assists in the preparation of a will, for example?

What kind of software consists of programs designed to make users more productive and/or assist them with personal tasks?

Which of the following kinds of software allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group?

Which of the following kinds of software allows users to create and manipulate documents containing mostly text and sometimes graphics?

Which kind of software can be distributed by anyone to others at no cost?

$A single point as shown in the accompanying figure is about what fraction of an inch in height? A) 1/9 B) 1/18 C) 1/36 D) 1/72$ A single point as shown in the accompanying figure is about what fraction of an inch in height?

In the accompanying figure, 12 point and 28 point are measurements of which of the following?

What is the term for a square-shaped coded graphic that corresponds to a web address or other information?

Which of the following (with examples such as Cambria and Calibri shown in the accompanying figure) is a name assigned to a specific design of characters?

Which of the following is a request for specific data from a database?

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Which of the following programs allow designers to rotate designs of 3-D objects to view them from any angle?

Many worksheet cells like those in the accompanying figure contain a number that can be used in a calculation. What is the name for this?

Which of the following is a collection of individual programs sold as a unit?

Which of the following is a collection of electronic drawings, photos, and other images that can be inserted into documents?

When using spreadsheet software like the kind in the accompanying figure, what are the rows and columns collectively called?

Which of the following kinds of software provides a means for sharing, distributing, and searching through documents by converting them into a format that can be viewed by any user?

Which of the following (with examples such as the bold, italic, and underline shown in the accompanying figure) adds emphasis to a font?