Module 4-6 review questions and vocab

cross-platform

Tools that developers can use to build apps that work on multiple platforms, rather than writing different code for Android or iPhone devices.

presentation

A PowerPoint document that lets you create and deliver a dynamic, professional-looking message to an audience in the form of a slide show.

clip art

Premade pictures and symbols you can use in electronic documents.

When giving a presentation, pushing one slide off the right edge of the screen as another one appears is an example of a(n) ______. a. exit b. animation c. entrance d. transition

d. transition

form

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

app

Short for "application," a computer program that performs specific tasks; also called a program.

conditional formatting

Special formatting that is applied if values meet specified criteria.

cell

The box formed by the intersection of a column and a row.

document management tools

Tools that protect and organize files and let you share documents with others.

When you work on a file using a web app, changes are saved as you make them.( T or F)

Ture

CAPS LOCK is a sticky key.( T or F)

False

field name

In Access, Excel, Publisher, or in a Word table, a column label that describes a data field.

query

In Power BI or similar programs, a request for information from a data source.

animations

In PowerPoint, an effect applied to an object that makes the object appear, disappear, change, or move.

Big Data

Large and complex data sources that defy easy handling with traditional data processing methods.

platform-specific

Mobile apps designed for a specific operating system like Android or iPhone.

pixels

Short for picture element, an individual point of color on a display screen or printout.

The kernel is the core of an operating system.(T or F)

Ture

The operating system manages interactions between hardware and software.(T or F)

Ture

relative reference

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

absolute reference

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

cell address

A cell's location, expressed by its column letter and row number, such as A1.

database

A collection of data organized in a manner that allows access, retrieval, and use of that data.

productivity suite

A collection of productivity apps such as Microsoft Office 365, Apple iWork, G Suite, or Apache OpenOffice.

workbook

A collection of related worksheets contained within a single file.

relational database

A database that consists of a collection of tables that can be joined through a common field; each table contains information on a specific subject, stored in the same file.

mobile first design

A design principle centered on building apps to work on mobile devices first because these typically have more restrictions, such as smaller screens.

relational database management system (RDBMS)

A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.

presentation software

A software program used to organize and present information in the form of an electronic slide show.

slide show

A term used to describe a PowerPoint presentation.

what-if analysis

A way to explore the impact that changing input values has on calculated values and output values

responsive design

A way to provide content so that it adapts appropriately to the size of the display on any device.

A data file contains the instructions your computer or device needs to run programs and apps.(T or F)

False

A shortcut icon puts the actual file, folder, or app on the desktop, removing it from the location where it is saved on your computer or device.( T or F)

False

File properties are the same no matter what type of file.(T or F)

False

When you move a file to the Recycle Bin or Trash, it is permanently deleted.(T or F)

False

built-in functions

Features in spreadsheet apps that perform financial, mathematical, logical, date and time, and other calculations.

G suite

Google's web-based productivity applications for creating documents, spreadsheets, presentations, email, and calendars.

records

In Access and Excel, a row of data in a table, representing a complete set of field values for a specific person, place, object, event, or idea; also called a tuple.

tables

In Access, a collection of records for a single subject, such as all of the customer records; the fundamental building block of a relational database because it stores all of the data.

controls

In Access, any form or report element such as a label, text box, or combo box. In Windows, an object used to manipulate a window or to use a program.

template

In Computer Concepts, a document that has been preformatted for specific purpose (such as an invitation, a brochure, a flyer, a cover letter, or a resume).

web-based applications

In Computer Concepts, a program that you access over the Internet, in a browser on your computer or on your mobile device, also known as a web app.

argument

In Excel and Access, and in Word tables, information necessary for a formula or function to calculate an answer.

documents

In Excel, to make notes about basic worksheet assumptions, complex formulas, or questionable data.

field

In an Access or in an Excel table or PivotTable, a column containing a specific property for each record, such as a person, place, object, event, or idea.

application software

Programs that help you perform specific tasks when using your computer or smartphone. They are also called software applications or apps.

An operating system is a program that manages the complete operation of your computer or mobile device and lets you interact with it.(T or F)

Ture

Moving or copying a folder affects all of the contents of the folder. (T or F)

Ture

When you open the file manager you have access to frequently or recently opened files and folders, favorite files and folders, and the main folders on your computer or device. (T or F)

Ture

When you take a photo with a digital camera, most likely it is saved in ______ format. a. GIF b. TIFF c. PNG d. JPG

d. JPG

Which of these is not an option for formatting text? a. changing the text's size b. changing the text's color c. making text bold d. copying a region of text

d. copying a region of text

You want to share information about an upcoming event at your school by creating a short promotional video. Which type of app might you use to create the video? a. communications b. device management c. personal interest d. graphics and media

d. graphics and media

To run a productivity app with most complete and advanced capabilities, you would most likely ______. a. run a web app in a web browser b. update the app online to make sure you have the most recent version c. download it from an app store to your smartphone d. install and run the software on your desktop or laptop computer

d. install and run the software on your desktop or laptop

m-commerce

Also known as mobile commerce. These apps let you use your mobile device to make online purchases of goods and services.

raster

Another name for bitmap images.

app store

An online store to help you locate and download apps for your mobile device.

Apache OpenOffice

An open source suite of productivity apps.

vector

A format for storing digital images that tend to be simple images composed of shapes, lines, and diagrams.

charts

A graphic that represents data using bars, columns, dots, lines, or other symbols to make the data easier to understand and to make it easier to see the relationships among the data.

spreadsheet

A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a worksheet.

bitmap

A grid of square colored dots, called pixels, that form a picture; also, a file containing a graphic that consists of a bitmap.

SQL (Structured Query Language)

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

trendlines

A line that represents the general direction in a series of data.

view-only link

A link to a workbook on a OneDrive that can be viewed by users.

function

A named operation that replaces the action of an arithmetic expression.

server

A powerful, high-capacity computer you access using the Internet or other network; it stores files and "serves" them, that is, makes the files available to, users; usually grouped at a location called a data center.

Apple iWork

A productivity suite for computers running macOS and iPhones and iPads running the iOS operating system.

sparklines

A quick, simple chart located within a cell that serves as a visual indicator of data trends.

worksheets

A single sheet in a workbook file that is laid out in in a grid of rows and columns

report

An Access object that creates a professional printout of data that may contain enhancements such as headers, footers, and calculations on groups of records.

paint apps

An app designed for drawing pictures, shapes, and other graphics with various onscreen tools, such as a text, pen, brush, eyedropper, and paint bucket.

web app

An app stored on an Internet server that can be run entirely in a web browser.

presentation apps

An app that lets you create visual aids for presentations to communicate ideas, messages, and other information to a group.

native app

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

local applications

An application that runs from the hard drive of a local computer.

productivity apps

Apps for personal use that you may use to create documents, develop presentations, track appointments, or to stay organized.

graphics and media apps

Apps that allow you to interact with and edit digital media.

video editing apps

Apps that allow you to modify a segment of a video, called a clip.

Drawing apps

Apps that let you create simple, two-dimensional images, which are often vector graphics.

photo and image editing apps

Apps that provide the capabilities of paint apps and let you enhance and modify existing photos and images.

device management apps

Apps that provide tools for maintaining your computer or mobile device.

communications apps

Apps that provide tools for sharing or receiving information.

portable apps

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

mobile apps

Apps that you access on a smartphone or tablet.

GUI stands for ______ user interface. A. Google B. Government C. graphical D. general

C. graphical

word processing software

Commonly used software to create documents and reports, mailing labels, flyers, brochures, newsletters, resumes, letters, and more.

Which of the following is NOT true about RAM? a. RAM stores open apps and document data while a computer or device is on. b. Every program and app requires RAM. c. RAM is nonvolatile memory. d. The system can assign virtual memory to function as RAM.

c. Ram is nonvolatile memory

slide master

The template for the slides in a presentation that contains theme elements and styles, text formatting, the slide background, and other objects that appear on all the slides in the presentation.

filter

To specify a set of restrictions to only display specific database records, online images, or files.

Mobile-first design is important because ______. a. developers can only write apps for one platform b. sales of personal computers have surpassed sales of smartphones c. developers must provide simplified user experiences for apps that run on small screens d. smartphones generally have more processing power than laptops

c. developers must provide simplified user experiences for apps that run on small screens

Which of the following units measure millions of bytes of data? a. megabytes b. kilobytes c. terabytes d. gigabytes

a. megabytes

When a value in a worksheet changes, the spreadsheet program will ______. a. recalculate any cells whose formulas depend on the value that changed b. delete the value c. reformat any cells whose values changed d. launch a calculator for you to check the calculations

a. recalculate any cells whose formulas depend on the value that changed

In a relational database, data is organized into rows of data called ______. a. records b. views c. tables d. fields

a. records

What is the temporary Windows storage area that holds items you copy or cut called? a. the buffer b. the Clipboard c. the cloud d. the Library

b. Clipboard

The ______ window is the window you are currently using, which appears in front of any other open windows. a. default b. active c. native d. forward

b. active

Which type of app would most likely NOT be found included in a productivity suite? a. presentation b. web browser c. spreadsheet d. word processing

b. web browser

______ is any data and instructions entered into the memory. a. Information b. Output c. Input d. Objection

c. Imput