Deck 8: Operating Systems

Question 1

Productivity applications include all of the following EXCEPT _____ software.

A) antivirus
B) spreadsheet
C) word processing
D) database

Answer 1

A

Question 2

A placeholder is displayed on presentation slides where data and graphics can be inserted.

Answer 2

True

Question 3

A chart is a visual aid to show trends or relationships in data.

Answer 3

True

Question 4

In PowerPoint, a _____ provides a coordinated set of colors, fonts, backgrounds, and effects to apply to your presentation.

A) layout
B) theme
C) frame
D) cell

Question 5

Productivity software includes the Windows 8 operating system.

Question 6

A workbook is the first file you create in Excel.

Question 7

Microsoft Publisher is an example of presentation software.

Question 8

The word wrap feature in Word keeps text within the document's margins.

Question 9

A Trojan is a type of malware that hides inside another program. ____________________

Question 10

Excel is a utility program designed to improve the processing power of your computer.

Question 11

Three types of graphics software are paint, photo-editing, and gaming software. ____________________

Question 12

_____ is a helpful tool when reviewing a document for incomplete sentences.

A) Spell checker
B) Grammar checker
C) Search or Find
D) Replace

Question 13

If you want to request specific data stored in a database table that meets set criteria, use a form.

Question 14

The defragmenter tool allows you to enter formulas in a spreadsheet.

Question 15

You can share information with users on the Web using a _____.

A) frame
B) blog
C) cell
D) function

Question 16

A desktop publishing software program displays a placeholder where you can enter text or graphics.____________________

Question 17

When creating a newsletter, which of the following application software is the best choice to use?

A) spreadsheet
B) word processing
C) database
D) desktop publishing

Question 18

Microsoft Excel is frequently used to create a database. ____________________

Question 19

File utility software helps you convert a file from one format to another.

Question 20

A spreadsheet software program is a good tool to use when creating a budget. ____________________

Question 21

The _____ uniquely identifies each record in a database's table.

A) query
B) field
C) file
D) primary key

Question 22

A database uses _____ to organize its data.

A) tables
B) placeholders
C) frames
D) functions

Question 23

Lossless file compression can reduce the size of a text file by _____ or more.

A) 25%
B) 35%
C) 50%
D) 75%

Question 24

Marni is trying to select antivirus software for her desktop computer.  Marni learns that some antivirus software also includes the capability to _____.

A) scan for spyware
B) run repetitive tasks
C) rename files
D) replicate itself

Question 25

With ___________________ word-processing software, users share a document and insert changes that can be reviewed by the author.

Question 26

Software bundled and sold together as one unit is sometimes called a software ____________________.

Question 27

The surface of your hard disk is made up of concentric circles called _____.

A) sectors
B) clusters
C) tracks
D) grooves

Question 28

Utility program tools include all of the following EXCEPT: _____.

A) file management
B) storage maintenance
C) software updating
D) video editing

Question 29

In PowerPoint, you can view thumbnails of your presentation by clicking on the _____ tab.

A) Design
B) Outline
C) Home
D) Slides

Question 30

One advantage of using a database rather than a spreadsheet for data manipulation is _____.

A) tables can be related to each other
B) a formula can be used to extract data
C) what-if analysis can be used
D) a workbook can be shared with other programs

Question 31

PowerPoint software is categorized as ___________________ software.

Question 32

__________ is the default name for the first worksheet found in an Excel workbook.

Question 33

A disk management software utility named ____________________ searches your hard drive for unnecessary files to delete.

Question 34

One advantage of using a formula to total a column of numbers in Excel is _____.

A) the formula cannot be changed
B) a formula is interchangeable with a primary key
C) if one number changes, the total is automatically recalculated
D) the cells referenced are locked and cannot be changed

Question 35

In Excel, the combination of a column letter and a row number is a _____.

A) cell address
B) frame
C) function
D) formula

Question 36

In video-editing software, you can rearrange _____ to change the sequence of video segments.

A) frames
B) clips
C) squares
D) crops

Question 37

Derek is asked to organize, manage, and track data for his company. He knows that the data must be stored for a long time and accessed often.  Derek knows he can create a _____ to request specific data from the database.

A) trigger
B) query
C) field
D) function

Question 38

Marni is trying to select antivirus software for her desktop computer.  Marni learns that malware includes all of the following EXCEPT: _____.

A) viruses
B) worms
C) Trojans
D) defragmenters

Question 39

Derek is asked to organize, manage, and track data for his company. He knows that the data must be stored for a long time and accessed often.  Derek decides to create a _____ database so data will need to be entered only once.

A) worksheet
B) tracking
C) relational
D) functional

Question 40

_____ is a basic photo editing program from Microsoft.

A) Photoshop
B) Photo Gallery
C) CorelDRAW
D) iPhoto

Question 42

What is the definition of disk management software? Explain how the error-checking and disk defragmenter utilities can improve a disk's performance.