CSC - Final Exam Guide
Workbook
An Excel file with one or more worksheets.
Table
An arrangement of information organized into rows and columns.
Formula
An equation that performs mathematical calculations on values in a worksheet.
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.
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
AutoFit
File Tab
Backstage view in Word is accessed by clicking the
The area long the bottom of a chart that identifies the categories of data is the:
Category Axis
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 is referred to as:
Number Values
Constant values consisting of only numbers.
Learning Tools
Features in Word that add visual changes to assist with reading fluency and comprehension are referred to as
A(n)___ is prewritten in Excel to look at one or more values, perform an operation, and then return a value
Function
The default format that Excel applies to numbers is the:
General format
View
If the rulers do not display on your screen, click the ___ tab, and select the Ruler check box in the Show group.
Which of the following is TRUE about footnotes?
If you delete a footnote, the remaining footnotes are automatically renumbered.
List formulas
-=$B$1+A3 -=1*2+3 -=B3+A4 -=2*(X*Y/2)
In MLA style, the font size for footnote text is ___ pt font
10
All Excel formulas begin with a(n) ____.
=sign
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
Crop
A command that removes unwanted or unnecessary areas of a picture.
Text from File
A command to insert text from another file into your document
Date & Time
A command with which you can automatically insert the current date and time into a document is
Editor
A digital writing assistant in Word that flags misspellings, grammatical errors, and writing style issues.
Cover Letter
A document that you send with your resume to provide additional information about your skills and experience.
Resume Assistant
A feature in Word with which you can see suggestions from LinkedIn to help you update your resume.
Complementary Closing
A parting farewell in a letter.
Section
A portion of a document that can be formatted differently from the rest of the document is a:
SUM Function
A predefined formula that adds all the numbers in a selected range of cells.
Function
A predefined formula that performs a specific calculation using the inputs you specify.
Template
A preformatted document that you can use as a starting point and then change to suit your needs.
LinkdIn
A professional networking website that focuses on business and employment-oriented services-a good place to build your professional identity.
Thesaurus
A proofing tool that provides a list of words with similar meanings is the
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:
How can you distinguish the footnotes in a document from the body of the report?
A short black line displays just above the footnote area.
Rotation Handle
A symbol with which you can rotate a graphic to any angle and that 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.
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 where totals from other worksheets are displayed and summarized.
The type of cell reference that refers to cells by their fixed position in a worksheet is:
Absolute
Enclosures
Additional documents included with a business letter.
Which of the following titles is used for the list of sources in an MLA-style research paper?
Works Cited
Row
a horizontal group of cells in a worksheet
Statistical Functions
excel functions, such as AVERAGE, that are useful to analyze a group of measurements
When you type text in a cell it is ________.
left-aligned
Chart
The graphic representation of data in a worksheet.
Salutation
The greeting line of a letter.
Cell
The intersection of a column and a row
Sheet Tabs
The labels along the lower border of the Excel window that identify each worksheet
Sheet Tabs
The labels along the lower border of the Excel window that identify each worksheet.
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.
Writer's Identification
The name and title of the author of a letter, placed near the bottom of the letter under the complimentary closing—also referred to as the writer's signature block.
What should be on the first line of the first page of an MLA-style research paper?
The name of the report author
Subject Line
The optional line following the inside address in a business letter that states the purpose of the letter.
Letterhead
The personal or company information that displays at the top of a letter.
Alignment
The placement of paragraph text relative to the left and right margins is referred to
Sorting
The process of arranging data in a specific order based on the value in a 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.
Which of the following are included in the first four lines of a research paper?
The report author
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.
Cell Margin
The space inside a table cell between the text and the cell borders-top, bottom, left, and right--is the
Which of the following would NOT be included in the citation for a book?
The street address of the publisher
Anchor
The symbol that indicates to which paragraph an image is attached.
Normal Template
The template that serves as a basis for all Word documents.
Body
The text of a letter is the
Detail Sheets
The worksheets that contain the details of the information summarized on a summary sheet.
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
Office Presentation Service
To present your Word document to others who can watch it in a web browser, use:
The data that displays in the Formula Bar is referred to as the:
Underlying value
Screen
Using drag-and-drop to move text is most useful when both the text and the destination are on the same
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
Default spacing after paragraphs of 12 points
Which of the following is NOT a default setting of Word?
Word's default style for footnote text is ________.
Single-spaced paragraph with 10-point Calibri font and no paragraph indents.
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
Sparklines
Data
Text or numbers in a cell
Flash Fill
The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output
Cell
The box at the intersection of a row and column in a table.
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.
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.
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.
What is a style guide?
A manual of standards for the design and writing of documents
Text Box
A movable resizable container for text or graphics.
Word Processing
Microsoft Word is an example of what type of computer application?
Which of the following is one of the MLA standards for formatting text?
No extra space above or below paragraphs
Placeholder Text
Non-printing text that holds a place in a document where you can type.
In Excel, row headings are identified by ________.
Numbers
Constant Value
Numbers, text, dates, or times of day that you type into a cell.
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
Operators
Layout Options
Picture formatting options that control the manner in which text wraps around a picture or other object.
The purpose of an explanatory footnote is to ________.
Provide additional information that may not fit well in the context of the document.
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 is called:
Quick Analysis Tool