CIS 20400: Ch. 3, 8, & 2 (Concept Exam 2)

Window

A rectangular area containing a document or message.

Buttons

A special area you can click to make links that "navigate" through a presentation.

Contextual Tabs

A type of tab found in Microsoft Word that appears only when needed and anticipates the next operations to be performed by the user.

A database designed for microcomputers is Microsoft ______.

Access

The most widely used DBMS designed for microcomputers is Microsoft ______.

Access

Mobile Apps (applications)

Add-on features for a variety of mobile devices, including smartphones, netbooks, and tablets.

Application Software

Also referred to as apps. Software that can perform useful work, such as word processing, cost estimating, or accounting tasks. The user primarily interacts with application software.

Ribbon GUI

An interface that uses a system of ribbons, tabs, and galleries to make it easier to find and use all the features of an application.

General-Purpose Applications

Application used for doing common tasks, such as browsers and word processors, spreadsheets, databases, management systems, and presentation software. Also known as productivity applications.

Toolbar

Bar located typically below the menu bar containing icons or graphical representations for commonly used commands.

An image that consists of pixels.

Bitmap

A ______ is a shortcut on a toolbar that provides quick access to commonly used commands.

Button

Toolbars include small graphic elements called ______ that provide shortcuts for quick access to commonly used commands.

Buttons

A ______ address is identified by the row and column label.

Cell

In a spreadsheet, the intersection of a row and a column is called a ______.

Cell

A ______ is a collection of related data.

Database

A ______ is a structured set of data and provides the ability to sort, link, and search records for specific data.

Database

This is a collection of related data like an electronic file cabinet.

Database

A ______ is a program that sets up a database and provides tools to enter, edit, and retrieve data from a database.

Database Management System

A ______ is a program that structures a database and provides tools to enter, edit, and retrieve data from the database.

Database Manager

A newspaper editor would use a(n) ______ program to create articles and layout pages.

Desktop Publishing

Professional graphic artists would use ______ programs, also called page layout programs to create documents such as brochures, newsletters, newspapers, and textbooks.

Desktop Publishing

______ programs allow you to mix text and graphics and provide flexibility on page design and layout to create publications of professional quality.

Desktop Publishing

______ focus on page design and layout and provide great flexibility.

Desktop publishers

A(n) ______ will display if there is an option for additional user input.

Dialog Box

______ provide additional information and request user input.

Dialog Boxes

True or false: A specialized application is one that is used in many different professions.

False

Ribbons

Feature of Microsoft Office that replaces menus and toolbars by organizing commonly used commands into a set of tabs.

Galleries

Feature of Microsoft Office that simplifies the process of making selections from a list of alternatives by replacing dialog boxes with visual presentations of results.

Pointer

For a monitor, a pointer is typically displayed as an arrow and controlled by a mouse. For a database, a pointer is a connection between a parent node and a child node in a hierarchical database.

An expression instructing Excel to add two cells is called a ______.

Formula

An expression instructing Excel to multiply two cells is called a ______.

Formula

=SUM(C14:C19) is an example of a ______.

Function

A prewritten formula provided for you is called a ______.

Function

Icons

Graphic objects on the desktop used to represent programs and other files.

______ programs are used widely by professionals in the graphic arts profession.

Graphics

Most general-purpose applications use a mouse and a graphical user interface that displays graphical elements called ______ to represent familiar objects.

Icons

______ programs allow you to create and edit vector images.

Illustration

______ programs, also known as drawing programs, use a combination of vector objects instead of bitmaps to create an image.

Illustration

______ programs allow you to edit and modify digital photographs.

Image editing

Groups

In Microsoft Word, each tab is organized into groups that contain related items. In social media, communities of individuals who share a common interest.

Menus

List of commands.

User Interface

Means by which users interact with application programs and hardware. A window is displayed with information for the user to enter or choose, and that is how users communicate with the program.

In a software program, a ______ is specifically designed to provide a list of options or commands.

Menu

Menu Bar

Menus are displayed in a menu bar at the top of the screen.

This is an example of a file created in ______.

Microsoft PowerPoint

A specialized application used in business to help coordinate and plan complicated projects

Microsoft Project

Some of the most widely used ______ applications are for listening to music, viewing video, social networking, shopping, and game playing.

Mobile

______ are add-on programs for mobile devices including cell phones and tablets.

Mobile Apps

______ suites are stored on a server on the Internet and are available anywhere you can access the Internet.

Online office

A bitmap image is made up of tiny dots called _______. These form bitmap images.

Pixels

This image consists of thousands of dots, or ______.

Pixels

______ combine a variety of objects to allow users to create appealing, visually interesting presentations.

Presentation Software

______ suites commonly include a word processor, spreadsheet, database manager, and a presentation application.

Productivity

Specialized Applications

Programs that are narrowly focused on specific disciplines and occupations. Some of the best known are multimedia, web authoring, graphics, virtual reality, and artificial intelligence.

Dialog Box

Provides additional information and requests user input.

A specialized application used by individuals to track their personal finances and investments

Quicken Starter Edition

A bitmap image, such as a photograph, is also known as a ______ image.

Raster

In a database table, each row, or ______, contains multiple fields of data about some specific person, place, or thing.

Record

The ______ GUI in this image uses a system of ribbons, tabs, and galleries.

Ribbon

This interface, which uses ribbons, tabs, and galleries, is an example of a ______.

Ribbon GUI

A worksheet is a rectangular grid of ______.

Rows and Columns

Graphical User Interface (GUI)

Special screen that allows software commands to be issued through the use of graphic symbols (icons) or pull-down menus.

A department manager should use a ______ to analyze sales and create departmental budgets.

Spreadsheet

______ are used to analyze sales, graph trends, and calculate averages.

Spreadsheets

______ organize, analyze, and graph numeric data.

Spreadsheets

______ software works with computer hardware to handle the majority of the technical details.

System

A ______ includes buttons that provide quick access to commonly used commands.

Toolbar

A ______ typically appears below the menu bar and includes buttons that provide shortcuts for quick access to commonly used commands.

Toolbar

This is an example of a ______.

Traditional GUI

True or false: Desktop publishing programs are used to create publications that have unique page design and layout.

True

True or false: The features in the following document can all be included using a word processor.

True

Tabs

Used to divide the ribbon into major activity areas, with each tab being organized into groups that contain related items.

The ______ interface enables the user and the computer to interact.

User

This ______ image was created by connecting lines.

Vector

When this ______ image is stretched it does not become pixelated or jagged on the edges.

Vector

______ images use geometric shapes or objects to create an image.

Vector

Anyone can take a video on a cell phone and then enhance the quality, appearance, and effects using a(n) ______.

Video Editor

______ software is available for anyone to design a game, develop characters and an environment.

Video game design

______ is described as designing a web site and creating its content.

Web authoring

______ are used to create memos, letters and faxes.

Word Processors

______ create text-based documents.

Word Processors

A ______ in an Excel workbook is a collection of cells organized in rows and columns where you create and analyze data.

Worksheet

An app store is typically a(n) ______ for providing applications for mobile devices.

commercial website

Mobile applications, also called ______, are add-on programs for mobile devices.

mobile apps

A ______ would be used to create a budget.

spreadsheet

A software ______ is a collection of separate application programs bundled together and made available as a group.

suite

In a ______, each record contains fields of data about some specific person, place, or thing.

table

Microsoft Photos is an example of a(n) _____.

video editor

The ______ in this image can be used to add special effects, music tracks, titles and on-screen graphics to a recording.

video editor

The ______ software in this image allows users to create their own characters as shown.

video game design

The process of creating a web site would be referred to as ______.

web authoring

System Software

works with end users, application software, and computer hardware to handle the majority of technical details.

Select all the examples of video editors.

• Apple Final Cut Pro • Adobe Premier • Microsoft's Photos

Select all the examples that would be a good use of a DBMS.

• Storing employee data • Recording student grades • Looking up criminal records

Select all the examples of general-purpose application software.

• browsers • word processors • spreadsheets • databases • management systems • presentation software

Select all the types of graphics programs.

• illustration programs • image editing programs • video editors • desktop publishing/ page layout programs

Select all of the common features of application software.

• spell checker • alignment • edit options • character options • fonts and font sizes • find and replace

Common features of application software that make entering/presenting, editing, and formatting documents easy:

• spell checker - looks for misspelled words • alignment - centers, right-aligns, or left-aligns numbers and characters • fonts and font sizes - specify the size and style of entered numbers and text • character effects - provide a variety of different typefaces, such as bold or italics • edit options - provide easy ways to edit text, such as cut, copy, and paste • find and replace - searches a document for a specific word or phrase, with the option to replace the word or phrase with something else

Select all the types of specialized applications.

• web authoring • graphics