Deck 7: Software Fundamentals

Question 1

Presentation software is a computer program you use to organize and present information, normally in the form of a slide show.

Answer 1

True

Question 2

A(n) utility program helps you perform computer housekeeping chores.

Answer 2

True

Question 3

Software is divided into two classes: utility and application software.

Answer 3

False

Question 4

You use paint programs to create moving images and 3D graphics.

Question 5

WYSIWYG programs work with the document on the screen as it will look when printed.

Question 6

____ software sits on top of system software because it cannot run without the operating system.

A) Application
B) Utility
C) Primary
D) Service

Question 7

When you start Excel, you open a file called a(n) ____.

A) spreadsheet
B) worksheet
C) workbook
D) document

Question 8

MP3 and QUICKTIME are types of audio files.

Question 9

PDF documents are used for presentation broadcasting.

Question 10

Which of the following is NOT true about software suites?

A) Suites are a group of related programs that interact with each other.
B) All suites include a database program.
C) Google Docs is an example of a suite.
D) Some suites contain add-ons such as instant messaging and calendars.

Question 11

In Microsoft Word, the word wrap feature automatically moves the insertion point to the next line when one line is filled with text.

Question 12

If you want to ask a question about the information stored in a database table, use a form.

Question 13

If you are going to be a presentation manager, it is important to get a certification or degree in presentation management.

Question 14

A report is a database object that allows you to organize, summarize, and print all or a portion of the data in a database.

Question 15

You can save word-processing files in all of the following formats, EXCEPT: ____.

A) Rich Text Format
B) templates
C) files compatible with earlier versions of the program
D) vector

Question 16

Linking is useful when information is maintained independently.

Question 17

In the figure above, which of the following is NOT true?

A) Columns are indicated by letters.
B) The first cell in a worksheet is cell 1A.
C) The point at which a column and row intersect is a cell.
D) The cell address is also called the cell reference.

Question 18

The images created using a matrix of picture elements are called bitmapped graphics.

Question 19

The primary key uniquely identifies each record in a table.

Question 20

In Datasheet view, you can create a table and assign a primary key.

Question 21

A(n) ____ is a collection of related information organized in a manner that allows for rapid search and retrieval.

A) database
B) spreadsheet
C) presentation
D) table

Question 22

CBT stands for Computer-Based ____.

A) Technology
B) Training
C) Tasks
D) Text

Question 23

In a database, a row of data is called a(n) ____.

Question 24

Miguel is creating a presentation to give to clients about a new product. Miguel knows that all of the following are true about effective presentations, EXCEPT: ____.

A) Use short comments and fill in the details orally.
B) Do not try to dazzle your audience with an overabundance of graphics, sound, and transitions.
C) Use simple tables to present numbers.
D) You can use bullets or numbers interchangeably in a list.

Question 25

In Microsoft Access, a(n) ____ is used to enter data in a table.

A) object
B) form
C) query
D) key

Question 26

Which of the following is NOT true about delivering effective presentations?

A) Cover one topic per slide.
B) Use no more than 10 words per slide.
C) Use photos, clip art, and graphics instead of words for a more powerful presentation.
D) All of the above are true.

Question 27

Rebecca and Lucy are learning about Microsoft Word and the Word window. Lucy tells Rebecca that the ____ displays the name of the program and the name of the current document.

A) Ribbon
B) Title bar
C) File tab
D) Document window

Question 28

Miguel is creating a presentation to give to clients about a new product. Miguel uses Microsoft ____ to create the presentation.

A) Excel
B) Word
C) PowerPoint
D) Access

Question 29

In Microsoft Word, the ____________________ contains panels that include command buttons and icons.

Question 30

Which of the following is NOT true about OLE?

A) It stands for Object Linking and Exchanging.
B) It was developed by Microsoft.
C) It lets you create a document or object in one program and connect it to another program.
D) Any changes made to the source file are reflected in the linked object.

Question 31

A(n) ____________________ is a row-and-column arrangement of data that is used to evaluate, calculate, manipulate and analyze data.

Question 32

A(n) ____ image consists of many individual objects, each with properties.

A) raster
B) bitmap
C) vector
D) multimedia

Question 33

All of the following are types of graphic files, EXCEPT: ____.

A) GIF
B) JPEG
C) FLV
D) TIF

Question 34

Which of the following is NOT true about database structure?

A) A database can consist of one table or a collection of tables.
B) A table is composed of columns and rows.
C) Columns are referred to as records.
D) All of the above are true.

Question 35

____________________ is defined as the use of text, graphics, audio, and video in some combination to create an effective means of communication and interaction.

Question 36

Rebecca and Lucy are learning about Microsoft Word and the Word window. Lucy tells Rebecca that the ____ contains the most-used functions and is customizable.

A) Quick Access Toolbar
B) Ribbon
C) desktop
D) Document window

Question 37

The ____ utility organizes the contents of the disk.

A) antivirus
B) file compression
C) backup
D) defragmentation

Question 38

A(n) ____________________ graphic is created using a drawing program.

Question 39

In the figure above, each file has a default of ____ worksheets?

A) zero
B) one
C) three
D) 1,000

Question 40

You can set up many online databases by uploading a CSV file from Microsoft Excel or Access.

A) CSV
B) PDF
C) PC
D) XLS

Question 43

What are the three methods Microsoft Office provides for inserting objects form one Office document into another Office document? What does OLE stand for? What does OLE do? Describe what happens to a linked object when the source document is updated.