Software and Apps Flashcards

1
Q

programs that help you perform specific tasks when using your computer or smartphone

A

Application software (or software applications, or apps)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Allow you to create documents for business and personal use

A

Productivity apps (word, PowerPoint, etc.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Allow you to interact with digital media

A

Graphics and media apps (photo, video, audio edit apps)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Give you tools to pursue your interests

A

Personal interest apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Provide tools for sharing or receiving information

A

Communications apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Provide tools for maintaining your computer or mobile device

A

Device management apps (screen saver, cloud, etc)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Apps that you install on your computer’s hard drive

A

Local applications

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Run from a removable storage device such as an external hard drive or flash drive, or from the cloud.

A

Portable apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You can access portable apps from

A

folder in your cloud storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

useful when you have limited storage space on your computer.

A

Portable apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A portable open source productivity suite like those found in Microsoft Office

A

OpenOffice.org

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Apps that you access on a smartphone or tablet are called

A

mobile applications, or mobile apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You can…..data and activity between the web app and the mobile app, so your actions and information will be consistent across all your devices.

A

synchronize

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Optimize storage, delete unused or duplicate files, optimize device performance

A

Device maintenance apps (CCleaner, PhoneClean)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Organize your address book

A

Contact management apps (Contacts)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Search the Internet, set timers, add appointments to your calendar, make hands-free calls by speaking commands

A

Personal assistant apps (Siri, Cortana, Google Home, Amazon Alexa)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

An app written for a specific operating system and installed on a computer or mobile device

A

Native apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Can take advantage of specific features of the devices on which they are installed, such as a smartphone’s camera, microphone, or contacts list

A

Native apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Require an Internet connection to provide full functionality. Some apps can run offline and will store information on your device until they can synchronize with the cloud.

A

Native apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A web app that runs on a mobile device

A

A mobile app

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Optimized for display in a browser on a mobile device, regardless of screen size or orientation.

A

Responsive design (mobile web apps)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Developers prefer it because it runs on all devices

A

Web apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Rely on HTML5 to display information, JavaScript to manage the app’s performance, and CSS (Cascading Style Sheets) to format information.

A

Web apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Pros of Mobile Apps

A

Quickly create, and access information on the go, and simplified interactions with voice input and on-screen keyboard.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Cons of Mobile Apps

A

Fewer features and not fast, can be poorly designed, and using a small on-screen keyboard can be cumbersome (or slow).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Mobile apps have an Android phone, you need to install the Android version of your app; if you have an iPhone, you need to download the iPhone version of your app which is called

A

platform-specific

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Designers and developers start building apps to work on mobile devices first because these typically have more restrictions, such as smaller screens.

A

Mobile first design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Development tools, developers can build apps that work on multiple platforms, rather than writing different code for Android or iOS devices.

A

cross-platform

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Writes apps in Swift or Objective-C

A

iOS developers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Writes apps in Java

A

Android developers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Rely on HTML5, JavaScript, and CSS

A

Cross-platform developers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Let you use your mobile device to make online purchases of goods and services

A

Mobile commerce, or m-commerce apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Productivity suits are:

A

Windows 360 Office, Apple iWork, G suit, and Apache OpenOffice

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Protect and organize files, and let you share your document with others.

A

Document management tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

Who and what to use to create agendas, memos, contracts, proposals, reports, letters, email, newsletters, personalized bulk mailings and labels?

A

Word - Business executives, office workers, medical professionals, politicians

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Who and what to use to create letters, greeting cards, notes, event flyers, check lists?

A

Word - Personal users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Who and what to use to create essays, reports, stories, resumes, notes?

A

Word - Students

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Who and what to use to create business cards, postcards, invitations, conference tent cards, name tags, gift tags, stickers?

A

Word - Conference promoters and event planners

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Who and what to use to create documents for publishing to the web after converting them to HTML?

A

Word - Web designers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

To format a text you

A

change its font type, size, style, color, and special effects such as reflection, shadows, and outlining.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

The direction in which content is printed on the page, portrait or landscape

A

page orientation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

You can change font and font sizes, change the color of text and backgrounds, add photos and shapes, and use provided templates to give a professional appearance to your documents.

A

Word

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

You can restrict access to a document by providing

A

A view-only link, or read-only access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

You can share documents with several people who can read, edit, and comment on the same document at the same time if you store the document on the

A

cloud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Apps let you interact with numbers, charts, graphics, text, and data

A

Spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

To calculate taxes or payroll businesses often use

A

spreadsheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

Keeping to-do lists, creating a budget, tracking your personal finances, following the performance of your favorite sports teams, and calculating payments on a loan are all tasks you can accomplish using a

A

spreadsheet (manipulate numbers or display numerical data)

48
Q

Allow you to organize data stored in rows and columns and perform simple or complex calculations on that data

A

spreadsheet

49
Q

You use spreadsheet software to create, edit, and format

A

Worksheets

50
Q

laid out in a grid of rows and columns; they use letters or pairs of letters, such as A or AB, to identify each column, and consecutive numbers to identify each row.

A

worksheets

51
Q

in a worksheet is the location formed by the intersection of a column and a row

A

a cell

52
Q

a collection of related worksheets contained in a single file

A

workbook

53
Q

“+”, “-”, “*”, and “/”

A

arithmetic operators

54
Q

Spreadsheet formulas always begin with an

A

equal sign (“=“)

55
Q

a predefined computation or calculation, such as calculating the sum or average of values or finding the largest or smallest value in a range of cells.

A

A function

56
Q

is a cell reference that does not change when the formula containing that reference is moved to a new location

A

An absolute reference

57
Q

is a cell reference that changes when the formula containing that reference is moved to a new location.

A

A relative reference

58
Q

What spreadsheet function to use to calculate the sum, average, or count of cells in a range

A

SUM, AVERAGE, COUNT

59
Q

What spreadsheet function to use to calculate interest rates and loan payments

A

RATE, PMT

60
Q

What spreadsheet function to use to obtain the current date, time, or date and time

A

DATE, TIME, NOW

61
Q

What spreadsheet function to use to perform calculations based on logical conditions

A

IF, AND, OR, NOT

62
Q

What spreadsheet function to use to calculate the largest and smallest values in a group of cells

A

MAX, MIN

63
Q

What spreadsheet function to use to look up values in a table

A

VLOOKUP

64
Q

What to use to highlight cells that meet specified criteria

A

conditional formatting

65
Q

to arrange them in increasing or decreasing order

A

Sort data by values in a column

66
Q

to display only the values you want to see

A

Filter worksheet data

67
Q

to test multiple scenarios by temporarily changing one or more variables, to see the effect on related calculations

A

What-if analysis

68
Q

to visually summarize changes in values over time with small graphs that appear in cells of the worksheet next to the values they represent

A

trendlines, or sparklines

69
Q

to create meaningful data summaries to analyze worksheets containing large amounts of data

A

pivot tables

70
Q

to perform steps you repeat frequently in a spreadsheet software you use

A

macros

71
Q

represent data using bars, columns, pie wedges, lines, or other symbols.

A

Charts (sometimes called graphs)

72
Q

Present data visually and make it easier to see relationships among the data on a spreadsheet software

A

charts

73
Q

In a database software, it compares categories of data to one another, and a pie chart compares parts (or slices) to the whole.

A

column chart

74
Q

shows how several values change over time in the same graphic

A

A stacked area chart

75
Q

an overall template for a presentation formatted with a theme, customized title and text fonts, backgrounds, and other objects that appear on slides in the presentation.

A

slide master

76
Q

What app should you use to keep track of contacts, addresses, and collections. Large enterprises use it to store vast quantities of data that enable us to shop online, execute web searches, or find friends on social media.

A

database software

77
Q

a collection of data organized in a manner that allows access, retrieval, and reporting of that data

A

database

78
Q

to track contacts, schedules, possessions, or collections.

A

database software for individuals

79
Q

to process orders, track inventory, maintain customer lists, or manage employee records

A

database software for small business

80
Q

to store customer relationship management data, such as interactions with customers and their purchases

A

database software for companies

81
Q

a language that provides a standardized way to request information from a relational database system

A

SQL (Structured Query Language),

82
Q

allow you to organize large amounts of data, and have many users update it simultaneously.

A

Oracle, Microsoft SQL Server, and MySQL

83
Q

Data can be exported from a database into other programs, such as

A

a spreadsheet program

84
Q

is a database that consists of a collection of tables where items are organized in columns and rows.

A

A relational database management system (RDBMS), or relational database,

85
Q

provide advanced database solutions for enterprise use

A

SQL Server and Oracle

86
Q

In a relational database, such as Microsoft Access, data is organized into tables of

A

records (rows of data)

87
Q

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

A

field

88
Q

a column containing a specific property for each record, such as a person, place, object, event, or idea.

A

field

89
Q

are a collection of records for a single subject, such as all the customer records, organized in grids of rows and columns, much like worksheets in spreadsheet applications.

A

tables

90
Q

extracts data from a database based on specified criteria, or conditions, for one or more fields.

A

A query

91
Q

You might ……… a sales database to find all the customers in Connecticut who made purchases of more than $1000 in January and sort the results in decreasing order by the purchase amount.

A

query

92
Q

converts your query specifications to SQL

A

visual query builder tool

93
Q

provides a series of keywords and commands that advanced users might type directly to create and run queries.

A

SQL

94
Q

a user-designed layout of database content

A

report

95
Q

You might prepare a monthly sales………. listing top deals and agents, or an inventory report to identify low-stock items.

A

report

96
Q

a screen used to enter data into a database

A

A form

97
Q

provides an easy-to-use data entry screen that generally shows only one record at a time.

A

A form

98
Q

A form is made up of

A

controls

99
Q

elements such as labels, text boxes, list boxes, buttons, and graphics, that specify where content is placed and how it is labeled.

A

controls

100
Q

What should you use to reduce data entry errors?

A

controls

101
Q

a form might contain a text box in which a database user can type an email address, would it accept any other type of data?

A

No

102
Q

help users navigate records and find specific information

A

form

103
Q

refers to data collections so large and complex that it is difficult to process using relational database applications.

A

Big Data

104
Q

What should companies do to easily increase storage or processing capabilities to store, access, or query the data?

A

storing large databases in the cloud

105
Q

Digital images are stored either in

A

bitmap (raster), or vector format

106
Q

Bitmap images are based on a grid of colored dots called

A

pixels

107
Q

tend to be simple images composed of shapes, lines, and diagrams.

A

Vector graphics (does not lose quality)

108
Q

use mathematical formulas instead of pixels to define their appearance.

A

Vector graphics

109
Q

useful for images that can be shrunk or enlarged (e.q logos) and still maintain their crisp outlines and clarity.

A

Vector graphics (does not lose quality)

110
Q

Most clip art images are stored as

A

Vector graphics

111
Q

refers to premade pictures and symbols available on the web or included with your application’s image gallery.

A

Clip art

112
Q

supports images with animation and transparent backgrounds

A

.gif

113
Q

codes a value for each pixel. Files can be large (uncompressed)

A

.bmp

114
Q

unprocessed data from a digital camera, usually used by professional photographers (uncompressed)

A

.raw

115
Q

commonly used for print publishing because it maintains quality.

A

.tiff

116
Q

let you create simple, two-dimensional images.

A

Drawing apps