Deck 4: Application Software

Question 1

When you enter data using spreadsheet software, your workspace is called a template or sheet.

Answer 1

False

Question 2

When you change a cell value or formula, spreadsheet software recalculates the workbook automatically.

Answer 2

True

Question 3

An application software program is usually represented on the desktop by an icon.

Answer 3

True

Question 4

Application software programs are sometimes called just apps.

Question 5

Web development software has many features of word processing software, but you enter text by talking into a microphone rather than typing.

Question 6

Color blindness affects a portion of our population, so do not use blue and green to distinguish content.

Question 7

While not as detail-rich as vector images, bitmap graphic files are smaller and can be enlarged without losing image quality.

Question 8

You can use photo editing tools to remove red eye, an effect that can happen when the flash from a camera is used on light-eyed people.

Question 9

If you are opening a document on your smartphone that has content that is not supported in Word Mobile, a warning message will tell you the file can only be opened using Word on a PC.

Question 10

Macros are visual representation of data that visually illustrate relationships and patterns.

Question 11

In a database, you input data and navigate records by using queries.

Question 12

Local applications are installed on your computer's hard drive.

Question 13

Each piece of data in a database is entered and stored in an area called a field.

Question 14

To create a chart, select a data range and choose a chart type, layout, and location.

Question 15

When working collaboratively on documents, multiple users can read and edit a document simultaneously.

Question 16

You can choose your own formatting options with slide masters.

Question 17

A common feature of application software programs is that they are identified by a taskbar at the top of the program.

Question 18

You can forgo all formatting decisions by creating documents from pre-formatted queries.

Question 19

To enter data in a worksheet, you click a cell to make it active and type the desired characters.

Question 20

In a word processing document, when the text fills a page, new text automatically flows onto the next page

Question 21

____ applications work on your smartphone or tablet.

A) Portable
B) Mobile
C) Local
D) Vector

Question 22

When formatting documents, ____ settings determine where text begins on a line in relation to the left margin.

A) Indent
B) Alignment
C) Line spacing
D) Paragraph spacing

Question 23

____ means that the distinction between "categories" of application software is becoming more blurred.

A) Alignment
B) Macro
C) Convergence
D) Transition

Question 24

In word processing software, ____ are documents that contain document formatting such as margins, fonts, and page layouts that you use to create new documents.

A) breaks
B) worksheets
C) macros
D) templates

Question 25

____ software is used to create, edit, format, view, print, and publish documents.

A) Word processing
B)   Spreadsheet
C) Presentation
D) Database

Question 26

Google Drive provides ____ GB of free online storage for the files that you create.

A) 5
B) 15
C) 25
D) 50

Question 27

____ software is used to perform numerical analysis and enhance the appearance of data.

A) Word processing
B) Spreadsheet
C) Presentation
D) Database

Question 28

You can use Microsoft Office programs to save your files in the ____ format so you can share your files with others who might not have the Office programs.

A) .pptx
B) .xlsx
C) .pdf
D) .docx

Question 29

____ applications are stored on and run from portable removable storage devices such as flash drives.

A) Portable
B) Local
C) Web-based
D) Mobile

Question 30

A formula contains a calculation, which specifies the operation to be performed, and ____, which are the values involved in the calculation.

A) addresses
B) filters
C) vectors
D) arguments

Question 31

In word processing software, the screen displays a(n) ____ to mark your place.

A) insertion point
B) address
C) thumbnail
D) absolute reference

Question 32

A cell ____ is a group of cells.

A) field
B) form
C) filter
D) range

Question 33

In spreadsheet software, a(n) ____ performs a calculation that generates a value.

A) argument
B) filter
C) formula
D) reference

Question 34

In spreadsheet software, each cell has a unique cell ____.

A) form
B) address
C) macro
D) vector

Question 35

____ software combines word processing with advanced graphics capabilities.

A) Speech recognition
B) Web development
C) Desktop publishing
D) Presentation

Question 36

In word processing software, page ____ can be portrait or landscape.

A) breaking
B) margins
C) orientation
D) spacing

Question 37

____ are small graphic image files available on the web that can be used in documents, presentations, or worksheets.

A) Clip art images
B) Thumbnail images
C) Icon graphics
D) Vector graphics

Question 38

The files you create using word processing software are called ____.

A) applications
B) pages
C) records
D) documents

Question 39

In word processing software, ____ tools help you find just the right word, search online to check facts, and provide topic-related information.

A) research
B) language
C) reference
D) hyperlink

Question 40

A font ____ adds visual effects to text.

A) type
B) size
C) style
D) color

Question 41

In spreadsheet software, use ____ to test multiple scenarios by temporarily changing one or more variables to see the effect on related calculations.

A) filters
B) macros
C) pivot tables
D) what-if analysis

Question 42

In spreadsheet software, use ____ to create meaningful data summaries to analyze worksheets containing large volumes of data.

A) tables
B) macros
C) what-if analysis
D) pivot tables

Question 43

A ____ extracts data from a database based on criteria its creator specifies.

A) form
B) report
C) table
D) query

Question 44

A ____ chart compares categories of data to one another.

A) line
B) column
C) pie
D) scatter

Question 45

A(n) ____ reference identifies a cell by its location in relation to other cells and changes when a formula is moved or copied.

A) absolute
B) relative
C) template
D) vector

Question 46

In presentation software, ____ are small versions of each slide.

A) bitmaps
B) macros
C) v ectors
D) t humbnails

Question 47

____ lets you remove parts of an image, deleting unwanted objects or people from your photo.

A) Splicing
B) Aligning
C) Cropping
D) Filtering

Question 48

In graphics software, you can use ____ to add visual interest to graphics.

A) shape tools
B) filters
C) macros
D) vectors

Question 49

In database software, fields have ____, which are characteristics that define the field.

A) properties
B) references
C) ranges
D) operators

Question 50

A ____ chart compares parts to the whole.

A) line
B) column
C) pie
D) scatter

Question 51

In presentation software, a ____ automatically applies any new formatting to all slides in your presentation that use it.

A) slide master
B) slide pane
C) report
D) filter

Question 52

A ____ is a user-designed layout of database content.

A) report
B) form
C) table
D) query

Question 53

Bitmap images are based on ____.

A) macros
B) pixels
C) vectors
D) cropping

Question 54

Spreadsheet software allows you to ____ worksheet data to display only the values you want to see.

A) tab
B) query
C) filter
D) pivot

Question 55

In presentation software, ____ are actions that occur as you move from slide to slide in a presentation.

A) page breaks
B) animations
C) transitions
D) convergences

Question 56

Most database programs create ____ databases.

A) macro
B) relational
C) transitional
D) marginal

Question 57

A(n) ____ reference refers to a fixed cell location that never changes.

A) absolute
B) relative
C) template
D) vector

Question 58

A ____ is a database screen primarily used for data entry.

A) pivot table
B) query
C) form
D) report

Question 59

In presentation software, you can use a(n) ____ to add movement to an object or text.

A) transition
B) animation
C) operator
D) vector

Question 60

In database software, data is organized into ____ stored in tables.

A) cells
B) tabs
C) vectors
D) records

Question 61

____ lets you create electronic slides for slide shows that can be viewed on a single computer, on a projection device, or over the Internet.

A) Presentation software
B) Word processing software
C) Spreadsheet software
D) Database software

Question 62

When measuring font size, each point is ____ of an inch.

A) 1/8
B) 1/ 16
C) 1/36
D) 1/72

Question 63

____ apps share your whereabouts with friends and family.
Web browsing

A) Location-sharing
B) Contact management
C) Web browsing
D) News

Question 65

____ apps allow you to collaborate with co-workers, organize your documents, and share photos and other files online.

A) File sharing and storage
B) Organizational
C) Travel
D) Language and translation

Question 66

A ____ app is a program that has been designed to run on a specific operating system.

A) platform
B) portable
C) w eb
D) native

Question 67

Common image formats are j P G , GIF, and ____.

A) PNG
B) EXE
C) TXT
D) HTML

Question 68

____ tools protect and organize files and let you collaborate with others.

A) Document formatting
B) Document management
C) Document processing
D) Contact management

Question 69

A ____ is not installed on a user's device; instead, it resides on a server on the Internet, and it is run by a user through a web browser.

A) web application (web app)
B) native app
C) mobile app
D) portable app

Question 70

____ display document information such as title, page number, date, and author on every page.

A) Hyperlinks
B) Language tools
C) Reference features
D) Headers

Question 71

____ software helps people be more productive by automating common or repetitive tasks.

A) Productivity
B) Graphics
C) Communications
D) Scheduling