Final Exam Computer Application

Date & Time

A command with which you can automatically insert the current date and time into a document in a variety of formats ______

A Cover Letter

A document that you send with your resume to provide additional information about your skills and experience.

chart

A graphical representation of data in a worksheet

Bulleted List

A list of items with each item introduced by a symbol such as a small circle or check mark, and which is useful when the items in the list can be displayed in any order

Text Box

A moveable, resizable container for text or graphics

Complementary closing

A parting farewell in a business letter.

template

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

Thesaurus

A proofing tool that provides a list of words with similar meaning is the:

Rotation Handle

A symbol with which you can rotate a graphic to any angle; displays above the top center sizing handle

Drag-and-drop

A technique by which you can move, by dragging, selected text from one location in a document to another.

Enclosures

Additional documents included with a business letter.

= sign

All Excel formulas begin with a(n) ______________

table

An arrangement of information organized into rows and columns.

Formula

An equation that performs mathematical calculations on values in a worksheet.

File Tab

Backstage view in word is accessed by clicking the ____________

Criteria

Conditions that you specify in a logical function

Number values

Constant values consisting of only numbers.

Statistic Functions

Excel functions, such as, AVERAGE, that are useful to analyze a group of measurements

A short black line displays just above the footnote area

How can you distinguish the footnotes in a document from the body of the report?

View

If the rulers do not display on the screen, click the _________ tab, and select the Ruler check box in the Show group

10

In MLA style, the font size for footnote text is ________ pt font

Numbers

In excel, row headings are identified by_____________

Word Processing

Microsoft Word is an example of which type of computer applications?

Placeholder Text

Non-printing text that holds a place in a document where you can type

No paragraph space

The built-in paragraph style—available from the Paragraph Spacing command—that inserts no extra space before or after a paragraph and uses line spacing of 1.

General Format

The default format that Excel applies to numbers

cell

The intersection of a row and a column

Live Layout

The manner in which text reflows around an object when it is moved or resized is called __________ ___________.

inside address

The name and address of the person receiving the letter and positioned below the date line.

Subject line

The optional line following the inside address in a business letter that states the purpose of the letter.

Alignment

The placement of paragraph text relative to the left and right margins

provide additional information that may not fit well in the context of the document

The purpose of an explanatory footnote is to ___________

Fill handle

The small black square in the lower right corner of a selected cell

Margins

The space between the text and the top, bottom, left, and right edges of the paper

Normal Template

The template that serves as a basis for all Word documents.

Double blue underlines

To indicate possible grammar errors, Word flags text with _______

Red squiggles

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

if you delete a footnote, the remaining footnotes are automatically renumbered

True

Screen

Using drag-and-drop to move text is most useful when both the text and destination are on the same ________

A manual of standards for the design and writing of documents

What is a style guide?

The name of the report author

What should be on the first line of the first page of an MLA-style research paper?

Dimmed

When the body of a document is active, the footer or header text is ____________.

equal

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

left aligned

When you type text in a cell it is _________

the report author

Which of the following are included in the first four lines of a research paper?

Default spacing after paragraphs of 12 points

Which of the following is NOT a default setting of word?

Citation

Which of the following is found within the body of a report and refers to a source in the bibliography at the end of the paper?

No extra space above or below paragraphs

Which of the following is one of the MLA standards for formatting text?

works cited

Which of the following titles is used for the list of sources in an MLA- style research paper?

The street address of the publisher

Which of the following would NOT be included in the citation for a book?

single-spaced paragraph with 10-point Calibri font and no paragraph indents

Word's default style for footnote text is

crop

a command that removes unwanted or unnecessary areas of a picture

Editor

a digital writing assistant in word that flags misspellings, grammatical errors, and writing style issues

resume assistant

a feature in word with which you can see suggestions from Linkedln to help you update your resume

Quick Analysis tool

a feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas

Logical Functions

a group of functions that test the specific conditions, and which typically use conditional test to determine whether specified conditions are true or false

Row

a horizontal group of cells in a worksheet

Section

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

Function

a predefined formula that performs calculations by using specific values in a particular order or structure

Linkedln

a professional networking website that focuses on business and employment- oriented services- a good place to build your professional identity

Data bar

a shaded bar that provides a visual cue above the value of a cell relative to other cells

Column

a vertical group of cells in a worksheet

Synonym

a word with the same or similar meaning as another word

Summary Sheet

a worksheet totals from other worksheets are displayed and summarized

Autofit

an excel feature that adjusts the width of a column to fit the cell context of the widest cell in the column

Workbook

an excel file that contains one or more worksheets

cell address

another name for a cell reference

value

another name for a constant value

Spreadsheet

another name for a worksheet

Cell content

anything typed into a cell

nonprinting characters

characters that display on the screen to show the location of paragraphs, tabs, and spaces, but that do not print

Justified

column text that is aligned to both the left and right margins

learning tools

features in word that add visual changes to assist with reading fluency and comprehension are referred to as:

Constant Value

numbers, text, dates or times of day that you type into a cell

Layout Options

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

Data

text or numbers in a cell

Flash Fill

the Excel command that recognizes a pattern in your data and then automatically fills the values when you enter examples of the desired output

Category axis

the area along the bottom of a chart that identifies the categories of data

cell

the box at the intersection of a row and column in a table

Underlying Value

the data that displays in the Formula Bar

Dateline

the first line in a business letter that contains the current date and that is positioned just below the letterhead if a letterhead is used

Salutation

the greeting line of a letter

Sheet tabs

the labels along the lower border of the excel window that identify each worksheet

Writers Identification

the name and title of the author of the letter, placed near the bottom of the letter under the complementary closing

letter head

the personal or company information that displays at the top of a letter

sorting

the process of arranging data in a specific order based on the value in each field

Filtering

the process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify

Cell Margin

the space inside a table cell between the text and the cell boarders- top, bottom, left, and right- is the:

Anchor

the symbol that indicates to which paragraph an image is attached

Operators

the symbols with which you can specify the type of calculation you want to perform in an Excel formula

Body

the text of a letter is the:

Absolute

the type of cell reference that refers to cells by their fixed position in a worksheet

Detail Sheets

the worksheets that contain the details of the information summarized on a summary sheet

Sparklines

tiny charts embedded in a cell that give a visual trend summary alongside your data

office Presentation Service

to present your word document to others who can watch in a web browser

Function

A _________________ is prewritten in Excel to look at one or more values, perform an operation, and then return a value

Toggle

A button that can be turned on by clicking it once, and then turned off by clicking it again

Style Set

A collection of character and paragraph formatting that is stored and named

Freeze Panes

A command that enables you to select one or more rows or columns and freeze (lock) them into place

Text from file

A command to insert text from another file into your document