CSCI 2203 Final Exam

select all box

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

absolute

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:

active cell

A cell surrounded by a black border and ready to receive data is the:

Date & Time

A command with which you can automatically insert the current date and time into a document is

Animation Painter

A feature that copies animation settings from one object to another is:

Small Caps

A font effect, commonly used in titles, that changes lowercase text into uppercase letters using a reduced font size is.

an enterprise fund

A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:

section

A portion of a document that can be formatted differently from the rest of the document is a:

template

A preformatted document that you can use as a starting point and then change to suit your needs.

a thesaurus

A research tool that provides a list of words with similar meanings is

Excel table

A series of rows and columns that contains related data and that is managed independently from other data is an Excel:

data bar

A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

point

A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:

formula bar

An element in the Excel window that displays the value or formula contained in the active cell is the:

name box

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:

field properties

Characteristics of a field that control how the field displays and how data is entered are:

nonprinting characters

Characters that display on the screen to show the location of paragraphs, tabs, and spaces, but that do not print, are called:

justified

Column text that is aligned to both the left and right margins is referred to as:

Slide pane

In Normal view, the pane that displays a large image of the active slide is the:

Notes pane

In Normal view, the pane that displays below the Slide pane:

workbook

On startup, Excel displays a new blank:

Layout Options

Picture formatting options that control the manner in which text wraps around a picture or other object.

series

Related data points represented by data markers are referred to as the data:

Datasheet view

The Access view that displays data in columns and rows like an Excel worksheet is:

explode

The action of pulling out a pie slice from a pie chart is called:

Layout

The arrangement of elements, such as title and subtitle text, lists, pictures, tables, charts, shapes and movies on a PowerPoint slide is:

nameplate

The banner on the front page of a newsletter that identifies the publication is the:

record selector box

The box at the left of a record in Datasheet view that you click to select an entire record is the:

View buttons

The buttons in the lower right corner of the PowerPoint window that control the look of the presentation window are the:

data type

The characteristic that defines the kind of data you can store in a field is the:

freeze panes

The command that enables you to select one or more rows or columns and lock them into place is:

Hide background graphics.

The command that is used to prevent background graphics from displaying on a slide is:

Reset Background

The command that restores the original background theme formatting to a slide:

Smart guides

The dashed lines that display on your slide when you are moving an object are:

Presentation theme

The default color of the numbers or bullet symbols in a list is determined by the:

wordwrap

The feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins.

NOW function

The function that retrieves and then displays the date and time from your computer is the:

sorting

The process of arranging data in a specific order based on the value in each field is called:

Editing

The process of modifying a presentation by adding and deleting slides or by changing the contents of individual slides is referred to as:

Theme colors.

The set of coordinating colors applied to the backgrounds, objects, and text in a presentation is called:

Transparency.

The setting that lightens a picture is:

CTRL + D

The shortcut key used to duplicate objects is:

anchor

The symbol that indicates the paragraph to which an image is attached is a(n):

Eyedropper

The tool that captures the exact color from an object on your screen is the:

append

To add on to the end of an object, such as to add records to the end of an existing table, is to:

"Enter" key

To end a line before the normal end of the line, without creating a new paragraph, hold down the "Shift" key while pressing the:

Align tools

To horizontally or vertically position selected objects on a slide relative to each other, use the:

blue wavy underlines

To indicate possible grammar errors, Word flags text with

red wavy underlines

To indicate words that might be misspelled because they are not in Word's dictionary, Word flags text with

equal

When you create a table, the width of all of cells in the table is