exam #2 excel words (just in case)

Application software

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

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.

Personal interest apps

Apps that give you tools to pursue your interests.

Communications apps

Apps that provide tools for sharing or receiving information.

Device management apps

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

Local applications

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

Portable apps

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

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.

Web apps

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

Mobile apps

Apps that you access on a smartphone or tablet.

Synchronize

In Publisher, tear-offs and business information fields that are automatically updated across pages and publications.

On-screen keyboard

A keyboard displayed on-screen that includes keys for typing text, numbers, and symbols.

App store

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

Native app

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

Responsive design

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

Platform-specific

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

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.

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.

Mobile commerce

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

M-commerce

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

Productivity suite

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

Microsoft Office 365

Microsoft's productivity suite which includes word processing, spreadsheets, and presentation apps, as well as Microsoft Outlook for email, Microsoft OneNote for note taking, and Microsoft Access for databases.

Apple iWork

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

G Suite

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

Apache OpenOffice

An open source suite of productivity apps.

Word processing software

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

Documents

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

Page orientation

The direction in which content is printed on the page.

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).

View-only link

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

Read-only access

A way to share files so others may read the file, but cannot change it.

Spreadsheet

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

Cell

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

Cell address

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

Workbook

A collection of related worksheets contained within a single file.

Formulas

A mathematical statement in a spreadsheet or table cell that calculates a value using cell references, numbers, and arithmetic operators.

Operators

A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell.

Function

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

Argument

Information necessary for a formula or function to calculate an answer.

Absolute reference

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

Relative reference

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

Built-in functions

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

Conditional formatting

Special formatting that is applied if values meet specified criteria.

Sort

To organize data, such as table rows, items in a list, or records in a mail merge, in ascending or descending order, based on criteria such as date, alphabetical order, file size, or filename.

Filter

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

What-if analysis

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

Trendlines

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

Sparklines

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

Pivot tables

A spreadsheet table designed to create meaningful data summaries that analyze worksheets containing large amounts of data.

Macros

A named set of instructions written in the Visual Basic programming language that perform tasks automatically in a specified order.

Charts

Visual representations of data in a graphical format.

Presentation software

Software used to create visual aids for presentations.

Slide master

A template that defines the layout and design of slides in a presentation.

SQL (Structured Query Language)

A standard programming language used to manage and manipulate databases.

Graphic

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.

PowerPoint

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

Dynamic Message

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

Slide Transition

The manner in which a slide appears on the screen in place of the previous slide during a slide show.

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.

SQL

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

Database

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

RDBMS

Relational database management system.

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.

Record

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.

Field

In 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.

Field Name

In Access, a column label that describes a data field.

Table

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.

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.

Form

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

Control

In Access, any form or report element such as a label, text box, or combo box.

Big Data

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

Bitmap

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

Raster

Another name for bitmap images.

Vector

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

Pixels

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

Clip Art

Premade pictures and symbols you can use in electronic documents.

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.

Photo and Image Editing Apps

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

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.

System software

The software that runs a computer, including the operating system.

operating system (OS)

A program that manages the complete operation of your computer or mobile device and lets you interact with it.

platform

A collective term for all the ways you interact with the device; a GUI controls how you interact with menus, programs and apps, and visual images such as icons by touching, pointing, tapping, or clicking buttons and other objects to issue commands.

graphical user interface (GUI)

The software, or operating system, a device uses.

utilities

Apps or programs that enable you to perform maintenance-type tasks related to managing the computer or device.

Software as a Service (SaaS)

Software that is distributed online for a monthly subscription or an annual fee.

personal computer (PC) operating system

An operating system installed on a single computer.

desktop operating system

Computers designed for personal use, as opposed to commercial or industrial use.

Windows

The operating systems for Microsoft machines; supports the Cortana virtual assistant, touchscreen input, HoloLens headsets, and built-in apps such as the Microsoft Edge browser.

macOS

The operating system for Apple desktop and laptop computers; includes the Siri virtual assistant, coordination with Apple mobile devices, and cloud file storage.

UNIX

UNIX-based operating system for desktop computers, laptops, and some tablets; multitasking operating system with many versions, as the code is licensed to different developers.

Linux

Operating system based on Linux that uses the Google Chrome browser as its user interface, and primarily runs web apps.

Chrome OS

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

web apps

Programs and apps (including operating systems) that have no restrictions from the copyright holder regarding modification and redistribution; users can add functionality and sell or give away their versions to others.

Closed source

Programs that keep all or some of the code hidden, enabling them to control and profit from the program they create.

Open source

Programs that allow you to copy the OS for your own use, to give to others, or to sell.

server operating system

Multiuser operating system because it controls a single, centralized server computer that supports many users on networked computers.

Virtualization

The practice of sharing computing resources, such as servers or storage devices, among computers and devices on a network.

Windows Server

Microsoft server operating system that includes advanced security tools and a set of programs called Internet Information Services that manage web apps and services.