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