Final computer class
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a: a. data bar b. filter c. detail bar
A
A worksheet where totals from other worksheets are displayed and summarized is a: a. summary sheet b. table c. detail sheet
A
All Excel formulas begin with a(n) ________. a. = sign b. + sign c. % sign d. # sign
A
Below you will see a list of formulas and functions mixed together. Go through the list and select ALL the ones that are Formulas ONLY -- do not select any functions. Make sure to select every formula. a. =max(n47:n77, x2) b. =sum(z2:z22) c. =Min(S23:S93) d. =1*2+3 e. =B3+A4 f. =2*(X*Y/2) g. =$B$1 + A3 h. =Average(M1:M42)
A
If the formula in cell C1 is copied to cell C2, what will be computed and displayed in cell C2? (Make the best choice from the answers below) a. =B2+A3 b. 15 c. 9 d. =B1+A2
A
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 is: a. flash fill b. find and replace c. split
A
The labels along the lower border of the workbook window that identify each worksheet are the: a. sheet tabs b. detail sheets c. data bars
A
The process of arranging data in a specific order based on the value in each field is called: a. sorting b. filtering c. scaling
A
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 is called: a. filtering b. sorting c. conditional formatting
A
The type of cell reference that refers to cells by their fixed position in a worksheet is: a. absolute b. relative c. exponentiation
A
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? a. Citation b. Footnote c. Endnote d. Reference
A
Which of the following is one of the MLA standards for formatting text? a. No extra space above or below paragraphs b. 2" margins c. 0.75" first line indent d. Line spacing of 1.15
A
Word default style for footnote text is ________. a. single-spaced paragraph with 10-point Calibri font and no paragraph indents b. single-spaced paragraph with 11-point Calibri font and no paragraph indents c. single-spaced paragraph with 10-point Times New Roman font and .5" paragraph indents d. double-spaced paragraph with 10-point Times New Roman font and .5" paragraph indents
A
toogle
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 is a
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 and time
A command with which you can automatically insert the current date and time into a document
cell
A digital writing assistant in Word that flags misspellings, grammatical errors, and writing style issues.
a cover letter
A document that you send with your resume to provide additional information about your skills and experience.
drag and drop
A feature in Word with which you can see suggestions from LinkedIn to help you update your resume.
value
A horizontal group of cells 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 movable, resizable container for text or graphics.
section
A portion of a document that can be formatted differently from the rest of the document is a:
IF function
A predefined formula that performs calculations by using specific values in a particular order or structure.a.
Template
A preformatted document that you can use as a starting point and then change to suit your needs.
Resume Assistant
A professional networking website that focuses on business and employment-oriented services—a good place to build your professional identity
rotation handle
A symbol with which you can rotate a graphic to any angle and that displays above the top center sizing handle.
writer's identification
A technique by which you can move, by dragging, selected text from one location in a document to another.
Spreadsheet
A vertical group of cells in a worksheet.
Linkedln
Additional documents included with a business letter.
file handle
An Excel file that contains one or more worksheets.
table
An arrangement of information organized into rows and columns.
Data
Another name for a worksheet.
How can you distinguish the footnotes in a document from the body of the report? a. The font is the same, but footnotes are italicized. b. A short black line displays just above the footnote area. c. Footnote text is bolded. d. Footnotes are centered; text in the body is left justified.
B
The data that displays in the Formula Bar is referred to as the: a. formula b. underlying value c. constant value
B
The worksheets that contain the details of the information summarized on a summary sheet are called: a. summary sheets b. detail sheets c. master worksheets
B
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: a. range finder b. AutoFit c. Quick Analysis tool
C
A series of rows and columns that contains related data and that is managed independently from other data is an Excel: a. detail sheet b. pane c. table
C
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is: a. range finder b. Quick Analysis tool c.Autofit
C
In Excel, row headings are identified by ________. a. lowercase letters b. Roman numerals c. numbers d. uppercase letters
C
In MLA style, the font size for footnote text is ________ pt font. a. 11 b. 8 c. 10 d. 12
C
The area along the bottom of a chart that identifies the categories of data is the: a. data point b. value axis c. category axis
C
The default format that Excel applies to numbers is the: a. accounting format b. comma format c. general format
C
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are: a. data points b. pixels c. operators
C
Tiny charts embedded in a cell that give a visual trend summary alongside your data are: a. chart styles b. embedded charts c. sparklines
C
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:
A(n) ________ is prewritten in Excel to look at one or more values, perform an operation, and then return a value. a. displayed value b. underlying value c. formula d. function
D
The purpose of an explanatory footnote is to ________. a. provide a page number to find additional information about the topic b. define technical terms in the text c. list all the sources on the page d. provide additional information that may not fit well in the context of the document
D
When you type text in a cell it is ________. a. right-aligned b. fully justified c. centered d. left-aligned
D
Which of the following are included in the first four lines of a research paper? a. The report title b. The page number c. The name of the Style Guide used for the paper d. The report author
D
Which of the following is TRUE about footnotes? a. Word inserts a line across the width of the page above the footnote area. b. All footnotes are placed at the end of the document. c. You must type the footnote number at the bottom of the page on which you insert a footnote. d. If you delete a footnote, the remaining footnotes are automatically renumbered.
D
Which of the following titles is used for the list of sources in an MLA-style research paper? a. Works Cited b. Sources c. References d. Bibliography
D
Which of the following would NOT be included in the citation for a book? a. The year of publication b. The author's name c. The title of the book d. The street address of the publisher
D
Which of the following is NOT a default setting of Word? a. Print Layout view b. Left, right, top, and bottom page margins of 1 inch c. Calibri, 11 point font, with 1.08 line spacing d. Default spacing after paragraphs of 12 points
D-Default spacing after paragraphs of 12 points
The intersection of a column and a row.
Data Chart
file tab
Default spacing after paragraphs of 12 points
learning tool
Features in Word that add visual changes to assist with reading fluency and comprehension are referred to as:
view
If the rulers do not display on your screen, click the ________ tab, and select the Ruler check box in the Show group.
word processing
Microsoft Word is an example of which type of computer application?
placeholder text
Non-printing text that holds a place in a document where you can type.
Layout Options
Picture formatting options that control the manner in which text wraps around a picture or other object.
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.
column
The labels along the lower border of the Excel window that identify each worksheet.
Letterhead
The optional line following the inside address in a business letter that states the purpose of the letter.
Complimentary Closing
The personal or company information that displays at the top of a letter.
Dateline
The personal or company information that displays at the top of a letter.
Allignment
The placement of paragraph text relative to the left and right margins is referred to as:
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:
anchor
The symbol that indicates to which paragraph an image is attached is a(n):
Normal template
The template that serves as a basis for all Word documents.
double blue undrlines
To indicate possible grammar errors, word flags text with:
Office Presentation Service
To present your Word document to others who can watch in a web browser, use
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
enclosures
a parting farewell in a letter
thesaurus
a proofing tool that provides a list with similar meaning is the
a synonym
a word with the same meaning as another word is
What is a style guide? a. A manual of standards for the design and writing of documents b. A list of business and personal template files in Word with associated guides c. A manual for how to maneuver and manipulate Word templates and default settings d. A list of style formats available in Word
a. A manual of standards for the design and writing of documents
cell
an equation that performs mathematical calculations on values in a worksheet.
sheet tabs
another name for a cell reference
formula
another name for a constant value
number values
anything into a cell
What should be on the first line of the first page of an MLA-style research paper? a. The name of the report author b. The report title c. The report date d. The name of the person for whom the report is prepared
b
workbook
constant values consisting of only numbers
row
numbers text dates,or times of day that you type into a cell
constant values
text or numbers into a cell
salutation
the box at the intersection of a row and column in a table.b.
Cell content
the graphic representation of data in worksheet
subject line
the greeting line of a letter.
live layout
the manner in which text reflows around an object when it moved or resized is called
editor
the name and address of the person receiving a letter and positioned below the line.
inside address
the name and title of the author of a letter, placed near the bottom of the letter under the complimentary closing.
cell address
the small black square in the lower right corner of a selected cell.
body
the text of letter is the
Red Squirrel
to indicate words that might be misspelled because they re not in word's dictionary, word flags text with.