Question 1

A computer file's location is defined by a file ______, such as C:\Documents\To-Do-List.docx.

Accepted Answer

The answer of A computer file's location is defined by...

Question 2

When saving a file, you must provide a valid file name that adheres to specific rules, referred to as _______________.
A) disk partition
B) file path
C) file-naming conventions
D) root directory

Accepted Answer

File-naming conventions are the set of rules and guidelines for creating a valid file name that can be recognized by the operating system. It includes limitations on the number of characters, special characters, and spaces that can be used in a file name. Failure to adhere to these conventions can lead to file saving errors or issues with accessing the file.

Question 3

Macs do not use drive letters, and the main hard disk is called Macintosh HD.

Accepted Answer

This statement is true. Macs use a different file system than Windows called HFS+ or APFS, which does not use drive letters. The main hard disk on a Mac is typically called Macintosh HD.

Question 4

Which of the following is not a file-naming convention?
A) Avoid using symbols.
B) Maximum length is 256 characters.
C) Do not use reserved words.
D) Spaces are not allowed.

Accepted Answer

Spaces are allowed in file names for many operating systems, including Windows and macOS, making option D incorrect as a file-naming convention that should be avoided. The other options (A, B, C) are common guidelines or restrictions in file-naming practices.

Question 5

Partitions are created, modified, and deleted using Filezilla on Macs and Disk Partitioner on PCs.

Accepted Answer

Partitions can be created, modified, and deleted on both Mac and PC using their respective built-in disk utility tools. On Macs, this tool is called Disk Utility, while on PCs, it is called Disk Management or Disk Partitioner. Filezilla is a file transfer client and not a disk utility tool, so it is not used for partition management.

Question 6

When working with Windows, storage devices can also be identified by a device __________.

Accepted Answer

The answer of When working with Windows, storage devices can...

Question 7

Microsoft Access, FileMaker Pro, and LibreOffice Base are three examples of popular ___________ software.

Accepted Answer

The answer of Microsoft Access, FileMaker Pro, and LibreOffice Base...

Question 8

In spreadsheet software, the________________ feature ensures that the results in every cell are accurate for the information currently entered in the worksheet.
A) what-if analysis
B) automatic recalculation
C) relative reference
D) absolute reference

Accepted Answer

Automatic recalculation ensures that formulas and functions in a spreadsheet software are updated and accurate when there is a change in the information entered in the worksheet. The other choices (A, C, and D) are not directly related to ensuring accuracy in every cell.

Question 9

In spreadsheet software, a(n) ___________ is a built-in preset formula.

Accepted Answer

The answer of In spreadsheet software, a(n) ___________ is a...

Question 10

In a database, a(n) _________ holds data for a single entity.

Accepted Answer

The answer of In a database, a(n) _________ holds data...

Question 11

Some database software provides tools to work with more than one collection of records, as long as the records are somehow related to each other.

Accepted Answer

This is true. Many database software allow users to work with multiple collections of records as long as there is some level of relationship or connection between the records. This is commonly done through the use of database tables and relational database management systems.

Question 12

Database software stores data as a series of ____________, which are composed of fields that hold data.

Accepted Answer

The answer of Database software stores data as a series...

Question 13

Popular ___________ software products include Microsoft PowerPoint, iWork Keynote, LibreOffice Impress, and Google Docs Slides.

Accepted Answer

The answer of Popular ___________ software products include Microsoft PowerPoint,...

Question 14

_________ software supplies the tools for combining text, photos, clip art, graphs, animations, and sound into a series of electronic slides that can be shown on a screen or projector.

Accepted Answer

The answer of _________ software supplies the tools for combining...

Question 15

Database software stores data as a series of records, which are composed of _________ that hold data.

Accepted Answer

The answer of Database software stores data as a series...

Question 16

Every storage device has a directory containing a list of its files.

Accepted Answer

Every storage device like hard disk, USB drive or memory card has a directory or file system containing a list of its files and folders which makes it easy for users to navigate and access the stored data.

Question 17

In a spreadsheet worksheet, a(n) ___________ works behind the scenes to tell the microprocessor how to use the contents of cells in calculations.
A) record
B) label
C) value
D) formula

Accepted Answer

A formula is a sequence of values (numbers or cell references), arithmetic operators, and/or functions used to perform a calculation in a spreadsheet. The formula is what determines how the contents of cells are used in calculations, and is processed by the microprocessor to produce the result.

Question 18

The main directory on a storage device is referred to as the ________ directory.
A) root
B) boot
C) partition
D) DOS

Accepted Answer

The main directory on a storage device is commonly referred to as the root directory. This is because it is the directory that contains all other directories and files on the storage device. The other options listed are not necessarily incorrect, but they do not accurately describe the main directory on a storage device.

Question 19

A disk __________ is a section of a hard disk drive that is treated as a separate storage unit.

Accepted Answer

The answer of A disk __________ is a section of...

Question 20

A formula, such as =B6+(C6*.1), does not contain cell references.

Accepted Answer

The formula contains cell references B6 and C6 which are used to calculate the result.

Quiz 6: Software