BCA: Midterm
The default spacing before and after a paragraph for a new Word document is __.
0 point of blank space before a paragraph and 8 points of blank space after a paragraph
What are the default cell margins of a table?
0" for top and bottom; 0.08" for left and right
When you create a table, all of the cells have black, solid line borders of which point size?
1/2 point
All formulas begin with a(n) __
= sign
Which of the following is false about a workbook? A) It can contain only one worksheet. B) It contains one or ore worksheets. C) It contains one or more worksheets with a series of cells. D) It contains pages called worksheets.
A
Which of the following is least likely to be included on letterhead of a company? A) company officers B) contact information C) company name D) address
A
Which of the following is less common and included in only some business letters, not necessarily all? A) subject line B) salutation C) inside address D) writer's signature block
A
To display measurements on the ruler while changing column widths, hold down the __ key while dragging the marker.
Alt
Which of the following is FALSE about tables in Word? A) The intersection of a row and column is called a cell. B) Wordwrap does not work in a table. C) Tables present information in an orderly format. D) Information is organized into rows and columns.
B
Which of the following is false about Word templates? A) All documents are based on a template. B) The starting point for a blank Word document is called the standard template. C) A template has a predefined document structure. D) A template has a set of defined settings.
B
Which of the following is referred to as the closing line of a business letter? A) the writer's signature block B) the complimentary closing C) the writers identification D) the salutation
B
Which of the following is the standard business envelope? A) 12 B) 10 C) 6 D) 8
B
Which of the following is not a way to create a formula? A) by using a Function button on the status bar B) by typing C) by using a Function button located on the ribbon D) by using the point-and-click technique
C
The default folder where custom template files are stored is named __.
Custom Office Templates
Which of the following includes the name and/or job title of a writer of a business letter? A) the inside address B) the complimentary closing C) the salutation D) the writer's signature block
D
Which of the following is always included in a business letter? A) subject line B) enclosure notation C) initials of the preparer of the letter D) inside address
D
When a table is active in a Word document, the two additional tabs that display on the ribbon are __.
Design and Layout
How do you select an individual word?
Double-click the word
T/F: A subject line in a business letter is a required element of all letters.
F
T/F: AutoFill works only with alphabetic values.
F
T/F: Automatic spell checking in Word is not set by default; it must be turned on to be active.
F
T/F: By default, Word stores template files that you create on your Desktop.
F
T/F: F7 opens the Thesaurus pane.
F
T/F: From the File tab, you can insert a file into an existing document.
F
T/F: Table borders do not, by default, print.
F
T/F: The default envelope size is a standard envelops referred to as a Size 6.
F
T/F: The default font for Excel 2016 is Times New Roman 11 pt.
F
T/F: The status bar displays the ribbon as well as the Quick Access Toolbar directly above it.
F
T/F: When you create a table, the first column is approximately twice the width of the other columns.
F
T/F: When you open the Thesaurus pane in Word, it displays on the left side of the screen with a list of synonyms.
F
T/F: When you press Enter within a table cell, the insertion point moves to the next cell.
F
T/F: Words' AutoCorrect library of incorrect/correct words is so extensive that additional incorrect/correct words cannot be added to it.
F
T/F: You can double-click in a paragraph to select it.
F
T/F: You can select everything in an entire document two ways: by triple-clicking within the document or with Ctrl + S.
F
T/F: You cannot save Word template files that you create to any folder other than the Word default folder, Custom Office Templates.
F
On a desktop computer, which keyboard shortcut displays the Save As dialog box?
F12
Which keyboard shortcut key opens the Spelling & Grammar feature?
F7
Settings related to fonts are found on the __ tab.
Home
How can you identify the One-Click Row/Column Insertion button?
It is a circle with a plus sign within it
What enables you to select everything in an entire document?
Move the pointer to the left of any line and when the arrow pointer displays, triple-click
When you select a word in a document and you want to select a synonym, what do you do?
Right-click, point to synonyms
__ is a procedure that determines which digit to the right of a number will be the last to be displayed.
Rounding
Tine charts embedded in a cell that display a visual trend summary alongside your data are called __.
Sparklines
T/F: A delimiter character can be a tab or a paragraph mark.
T
T/F: A synonym is a word that has the same or similar meaning to a word that you have selected.
T
T/F: After column Z in an Excel worksheet, the next column is AA.
T
T/F: All documents in Word are based on a template.
T
T/F: An enclosure notification on a business letter alerts a reader to the fact that a document is included with the letter.
T
T/F: An outlined cell in a worksheet is the active cell.
T
T/F: AutoFill generates and extends a series of value into adjacent cells in a worksheet.
T
T/F: Block style is one of several accepted letter formats available.
T
T/F: Business letters should always have one blank line above and one blank line below the salutation.
T
T/F: By default, when you create a table, borders imply around each cell.
T
T/F: F7 starts the Spelling and Grammar common in Word.
T
T/F: IF you send a resume to a company, it is good practice to include a cover letter.
T
T/F: Normal view maximizes the number of cells visible on your screen.
T
T/F: On a desktop computer, F12 is the shortcut key to open the Save As dialog box.
T
T/F: The Formula Bar in Excel 2016 displays the value or formula in the active cell.
T
T/F: The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.
T
T/F: The Sum button resides on both the Home Tab and the Formulas Tab.
T
T/F: The default table border is a singe, solid, black line.
T
T/F: The most common date format for a letter is, as an example, July 4, 2018.
T
T/F: There is an Office dictionary included with Word.
T
T/F: Two options on the AutoFit button on the Table Tools Layout tab are AutoFit to Contents and AutoFit to Window.
T
T/F: When you create a table in a document, the font and font size in the table remain the same as for the document.
T
T/F: Word includes predesigned templates for a cover letter.
T
T/F: Words that are not in the Office dictionary are marked with a wavy underline.
T
T/F: You can sort information in a Word table in either ascending or descending order.
T
If gridlines do not show on a table without borders, click the Borders button arrow, and then click View Gridlines on the __ tab.
Table Tools Design
When a cell is part of an active formula, it is surrounded with __.
a colored border with small boxes on each side
What does pressing Tab in the last cell of a table do?
adds a new row
How do potential spelling and grammar errors display in Word 2016?
as red and blue wavy undelrines
When you create a table in Word 2016 from the Table button on the Insert tab, as you select the number of rows and columns you want, the cells are __.
bordered in orange
intersection of a row and a column
cell
group of vertical cells on a worksheet
column
When converting text to a table, you signal Word to create columns by separating the text with __.
commas or tabs
moves to the last cell in the last column of the active area of the worksheet
ctrl + end
an equation that performs mathematical calculation
formula
What is the default number format in Excel 2016?
general format, Calibri, 11 pt
How do you quickly select a sentence?
hold down Ctrl and click in the sentence
Where is the fill handle located?
in the lower right corner of a selected cell
The __ is the name and address of the person receiving a business letter.
inside address
A text value in Excel is also referred to as a __.
label
a text value
label
When you type text in a cel it is __.
left-aligned
In Excel 2016, row headings are identified by __.
numbers
In Business Communication texts, what is the recommendation of experts regarding the number of blank lines between the dateline of a business letter and its inside address?
one to six blank lines
moves down one full screen
page down
group of horizontal cells on a worksheet
row
moves one cell up
shift + enter
moves left one cell
shift + tab
also known as a worksheet
spreadsheet
The __ displays the current cell mode, the page number, and the zoom buttons.
status bar
moves right one cell
tab
When you type data in a cell and press Enter, what cell becomes the active cell?
the cell below
A formatting mark in each cell of a table indicates __.
the end of the contents in each cell
Most business communication gets recommended that the dateline of business letter be positioned at least __ below the letterhead of the page.
three blank lines
a number, date, or time of day
value
displays upon startup of Excel
workbook
also known as a spreadsheet
worksheet
