MCIS Final Exam- Word, Excel, Access

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

An excel file that contains one or more worksheets

Workbook

The typical file extension assigned to a Word document.

.docx

The number of inches from the top edge of the paper to the beginning of the bibliography.

2 in

How many columns are there in a 3x7 TABLE

3

Page headers and footers can be changed in this view

Page layout view

The vertical distance above and below each paragraph in a document

Paragraph spacing

This keyboard shortcut places the insertion point at the beginning of the document

ctrl+home

A wavy line indicating a possible spelling, grammar, or style error

Flagged error

The intersection of a row and a column in a table

Cell

A button used to turn a feature both on and off.

Toggle Button

The last line of a paragraph that displays as the first line of a page

Widow

The cell surrounded by a green border, ready to receive data or be affected by the next Excel command.

Active cell

A line that displays when an object is aligned with a document object such as a margin or heading

Alignment guide

The symbol that indicates which paragraph a picture is associated with.

Anchor

Symbols that specify mathematical operations such as addition or subtraction

Arithmetic operations

This command can be used to make a picture look more like a drawing or a painting`

Artistic effects

The citation type used for the Chicago style

Author-date

the command used to make the size of the table column reflect the data in the columns

AutoFit contents

A category of data- such as file name, the page number, or the current date- that can be inserted into a document.

Field

To change Proofing settings, first display the:

File tab

The small green square in the lowerright corner of the active cell

Fill handle

The position of the first line of a paragraph relative to the text in the rest of the paragraph

First line indent

The column letter and row number that identify a cell

Cell address

A list of sources displayed on a seperate page at the end of a report

Bibliography

Items that can be listed in any order are best presented using which of the following

Bulleted list

The identification of a specific cell by its intersecting column letter and row number

Cell reference

This is placed in the body paragraphs and points to an entry in the bibliography

Citation

An image, drawing, or photograph accessed from Microsoft Office Online and other online providers.

Clip art

This moves the text that follows it to the top of the next column

Column break

The type of sizing handle used to resize a picture proportionally.

Corner

A command that deletes the selected text or object and places a copy in the Office Clipboard

Cut

Used by a mail merge document, this file contains information such as names and addresses.

Data source

You can change the font set that a theme uses by clicking the Fonts button on this tab

Design

The data displayed in a cell

Displayed value

A series of evenly spaced dots that precede a tab

Dot leader

The default line spacing in a long report

Double

The equivalent of a blank line of text displayed between each line of text in a paragraph

Double - spacing

A comment or notation added to the end of a section or document

Endnote

The default width assigned to columns

Equal

To place a not on the same page as the comment or notation, use which of these?

Footnote

A character that indicates a paragraph, tab, or space on your screen, but that does not print when you print a Word document.

Formatting Mark

Ab equation that performs mathematical calculations on number values

Formula

An excel feature that suggests values as you type a function

Formula AutoComplete

A prewritten Excel formula

Function

In a Chicago style bibliography, this type of indent is used for each reference,

Hanging indent

A reserved area for text, graphics, and fields that displays at the top of each page in a document

Header

a paragraph alignment that aligns the text with both the left and right margins

Justified

When you select a picture, this button displays next to the image so that you can change text wrapping settings quickly.

Layout Option

A series of characters that form a solid, dashed, or dotted line that fills the space preceding a tab stop.

Leader

The vertical distance between lines in a paragraph

Line spacing

A feature that combines a main document and a data source to create customized letters or tables

Mail merge

Forces a page to end, and places subsequent text at the top of the next page

Manual page break

The space between the text and the top, bottom, left and right edges of the paper when you print the document

Margin

In the columns gallery the command that displays the columns dialog box

More columns

An image of a document that can be viewed using a reader such as Adobe Acrobat Reader instead of the application that created the original document.

PDF document

To view two pages at the same time, on the View tab, in the Zoom group, click this command.

Multiple pages

An excel window area that displays the value contained in the active cell.

Name box

The Excel window area that displays the address of a selected cell

Name box

The pane used to find document text

Navigation

The pre-built setting that places all four margins at 1.0 inches

Normal

A view that maximizes the number of cells visible on the screen

Normal view

To move a selected picture small distances using an arrow key,

Nudge

Data in a cell made up of numbers only

Number value

The type of list used for items that are in chronological or sequential order

Numbered

A pre-built set of formatting options that can be applied to a graphic with a single click.

Picture Style

A field that reserves space in a SmartArt shape but does not print until you insert your own text.

Placeholder

A unit of measurement for font sizes

Point

The Undo button is located here.

Quick Access Toolbar

Any style that displays in a ribbon gallery

Quick style

Two or more cells on a worksheet

Range

The Spelling and Grammar group is located on this Ribbon tab

Review

This type of alignment positions the text so that it is aligned with the right margin

Right

The number that displays at the left of a row

Row heading

When you open a mail merge document, a message displays informing that this will be run.

SQL SelectQuery

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

Section

A type of break that is used to create a new section that can be formatted differently from the rest of the document

Section

An extra detail or hook at the end of a character stroke

Serif

When you make a change to a tab stop in the Tabs dialog box, click this button to apply the changes

Set

To change the color of the background in a paragraph, add this to the text background

Shading

When you select a picture, you can use these to change the picture's size

Sizing handles

A font effect that displays all characters in uppercase while making any character originally typed as an uppercase letter taller than the ones typed as lowercase characters.

Small caps

A pre-built visual representation of information in which you can enter your own text

SmartArt

The reference used to find information or data when writing a report.

Source

A red wavy line indicates this type of error.

Spelling

A layout option that sets a picture to "float" so that it can be moved independently of the paragragh

Square

A pre-built collection of formatting settings that can be assigned to text

Style

In the Grammar Options dialog box which is a category that can be enabled or disabled.

Subject-Verb agreement

A specific location in the document, marked on the Word ruler, to which you can move using the tab key.

Tab stop

Information presented in rows and columns to summarize and present data effectively and efficiently

Table

A pre-build set of formatting options that can be applied to a table with a single click

Table style

A pre-built set of decorative formats that make text stand out in a document

Text effects

Data in a cell made up of text only

Text value

In mail merge, the command used to modify all labels based on changes made to the original label

Update labels

Data in a cell- text or numbers

Value

A reference that lists words that have the same meaning to the word you are looking up

Thesaurus

The primary document that you use in Excel to store and work with data

Worksheet

In a mail merge document, this document contains the text that remains constant

main document

Numbers in a table are typically aligned this way

right

A font where the letters do not have serifs

sans serif

Use this key to move from one part of a table to another

tab


Ensembles d'études connexes

EMS/Module 7; Trauma-Practice Quiz

View Set