MCIS Final Exam- Word, Excel, Access
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
