Microsoft 365 Final exam
Press ____ to select the entire worksheet.
CTRL+A
The shortcut keys used to center a paragraph are ____.
CTRL+E
To move to the end of the document, press the ____ key(s)
CTRL+END
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
To move left one word with the keyboard, press the ____ key(s)
CTRL+LEFT ARROW
You can insert a new slide by pressing the ____ keyboard shortcut keys.
CTRL+M
To right-align a paragraph, use the ____ shortcut keys.
CTRL+R
To move to the right one word, press the ____ key(s).
CTRL+RIGHT ARROW
To move up one paragraph, press the ____ key(s).
CTRL+UP ARROW
The ____ function displays the highest value in a range.
MAX
To advance rightward from one cell to the next in a table, press the ____ key.
TAB
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
Attachment
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The date you change a file is an example of a(n) ____ property.
automatically updated
In the ____ letter style, all components of the letter begin flush with the left margin.
block
A cell reference with only one dollar sign before either the column or the row is called an absolute reference.
false
A photo's color intensity can be modified by changing the brightness and content.
false
A raised dot (·) shows where the ENTER key was pressed.
false
A single point is about 1/12 of an inch in height.
false
According to MLA style, on each page of the research paper, precede the page number by the title of the paper.
false
After you have created at least four slides, a scroll bar containing scroll arrows and scroll boxes will appear on the right edge of the window.
false
The MLA style uses the term bibliographical references for works cited.
false
To follow the MLA style, single-space text on all pages and apply one and a half-inch top and bottom margins, and one-inch left and right margins.
false
To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.
false
When at the rightmost cell in a row, press the ENTER key to move to the first cell in the next row; do not press the TAB key.
false
Business documents can include all of the following EXCEPT ____.
personal letters
A(n) ____ contains information about a given person, product, or event.
record
In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
relational
The adjusted cell references in a copied and pasted formula are called ____ cell references.
relative
In a business letter, type the ____ at least four blank lines below the complimentary close, allowing room for the author to sign his or her name.
signature block
Footnote text is _____.
single-spaced, left-aligned, and a smaller font size than the text in the research paper
The small squares and circles around a selected graphic are called ____ handles.
sizing
PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.
slides
To order the records in the answer to a query in a particular way, you ____ the records.
sort
A letterhead should contain all of the following EXCEPT ____.
the company's objective
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
PowerPoint displays many ____ that are varied and appealing and give you an excellent start at designing a presentation.
themes
Word includes a variety of document ____ to assist you with coordinating visual elements in a document.
themes
A(n) ____ is a book of synonyms.
thesaurus
You can use ____ options to repeat a background image many times vertically and horizontally on a slide.
tiling
The ____ introduces the presentation to the audience.
title slide
A slide ____ is a special effect used to progress from one slide to the next slide in a slide show.
transition
You can make one color in a graphic ____, that is, removing its color.
transparent
A background is considered fill.
true
A property sheet is a window containing the various properties of the object.
true
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
true
A slide show is another name for a PowerPoint presentation.
true
Color saturation changes the intensity of colors.
true
Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.
true
The Navigation Pane contains a list of all the objects in the database.
true
To place your name to the left of the page number as required by the MLA style, you must create a header that contains the page number.
true
You can remove selected text from a slide by pressing the CTRL+X keyboard shortcut keys.
true
To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
Open
To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the ____.
(DRAWING TOOLS FORMAT tab | Size group)
Which of the following formulas contains an absolute cell reference?
=$B$4
The Bullets button is available on the HOME tab of the Ribbon in the ____ group.
Paragraph
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
Pressing the ____ key instructs Word to replace a building block name with the stored building block entry.
F3
Which of the following keys can you press to run a slide show starting with slide 1?
F5
To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
Rename
To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.
Rename Field
To instruct PowerPoint to confirm each change, click the Find Next button in the ____ dialog box.
Replace
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
Reserved
____ is/are used to place worksheet, column, and row titles on a worksheet.
Text
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
____ is one color shade gradually progressing to another shade of the same color or to another color.
Gradient fill
____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.
Graphics
____ changes picture color into black, white, and shades of gray
Grayscale
To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.
Group By
Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
MAX
The ____ function determines the lowest number in a range.
MIN
You can type comments to yourself in the ____ for a specific slide while working in Normal view.
Notes pane
A ____ is text and graphics that print at the bottom of every page.
footer
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
A ____ is a prewritten formula that is built into Excel.
function
One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.
graphical elements
Which of the following colors suggests neutrality?
gray
Word shades fields ____ on the screen.
gray
Redundancy means storing the same fact in more than one place.
true
Researchers have known for decades that documents with visual elements are more effective than those that consist of only text.
true
Shapes in the Shapes gallery can be combined to show relationships among the elements.
true
Standard properties are associated with all Microsoft Office documents and include author, title, and subject.
true
The Sum button menu allows you to enter one of five often-used functions easily into a cell.
true
The field or fields on which records are sorted is called the sort key.
true
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
true
The mini toolbar contains the Italic button.
true
The path to the Logical button is (FORMULAS tab | Function Library group).
true
The shortcut keys, CTRL+ENTER, instruct Word to insert a manual page break.
true
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).
true
A tag name is an identifier that links a(n) ____ to a source.
citation
The question mark (?) wildcard represents any collection of characters.
false
You cannot format an entire column at once.
false
Files containing ____ are available from a variety of sources.
graphics
A ____ is text and graphics that print at the top of each page.
header
Formatting text in a shape follows the same techniques as formatting text in a ____.
placeholder
PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.
predefined
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.
true
The ____ feature automatically locates specific text and then replaces it with desired text.
Find and Replace
To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.
Format Painter
. ____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point.
Pasting
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.
Undo
When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a(n) ____
X
You use ____ to view an XPS file.
XPS Viewer
PowerPoint assumes every new slide, except for a blank slide, has ____.
a title
The path to the Format Painter button is ____.
(HOME tab | Clipboard group)
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
One way to add a correctly spelled word to the custom dictionary is to click the ____ button in the Spelling and Grammar dialog box.
Add to Dictionary `
____ are types of changes that occur when text has been omitted from a document and must be inserted later
Additions
____ includes special visual and sound effects applied to text or other content.
Animation
Word provides a(n) ____ button, which increases the font size of selected text each time you tap or click the button.
Increase Font Size
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
When you click the ____ button for a selected graphic, Word provides options for changing how a graphic is positioned with text in a document.
Layout Options
By default, slides in a new presentation are in ____ orientation.
landscape
High color saturation produces gray tones.
false
In Access, the columns in a table are called records.
false
In a business letter, within the message, paragraphs are double-spaced with single-spacing between paragraphs.
false
It is not possible to add a shadow to text.
false
____ effects modify text and objects displayed on the screen.
Emphasis
Clicking the ____ box completes an entry.
Enter
____ effects determine how slide elements disappear.
Exit
Combining two or more selected cells into one cell is called ____ cells.
merging
In the ____ letter style, the date, complimentary close, and signature block are positioned approximately one-half inch to the right of center or at the right margin.
modified block
A background feature called ____ allows you to move the background from the slide borders in varying distances by a percentage.
offsets
Headers print in the top margin ____ inch from the top of every page
one-half
Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.
one-third
The Trim Video feature allows you to trim your clip by time measurements that are accurate to ____ of a second.
one-thousandth
A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.
bulleted
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
two
There are ____ standard colors for text in a theme.
two
When working with a large worksheet, you can split the window into ____ panes.
two or four
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
According to the MLA style, the _____ is a list of sources that are referenced directly in a research paper.
works cited page
An Excel ____ allows data to be summarized and charted easily.
worksheet
A point is ____ of an inch in height.
1/72
Every theme has ____ standard colors.
10
Excel remembers the last ____ actions you have completed.
100
On most computers, the default font size in Word is ____.
11
How many chart types does Excel offer?
15
When you install PowerPoint, the default setting allows you to reverse up to the last ____ changes by tapping or clicking the Undo button on the Quick Access Toolbar.
20
With more than ____ predefined color schemes, Word provides a simple way to select colors that work well together.
20
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
____ determines the overall lightness or darkness of an entire image.
Brightness
Click ____ to move a stacked object toward the top of the stack.
Bring Forward
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
You should use a ____ chart to compare values side by side, broken down by category.
Clustered Column
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
Compact & Repair
Press the ____ key(s) to erase one character to the right of the insertion point.
DELETE
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
Which of the following keys moves the insertion point to the end of data in a cell?
END
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
ESC
To import data to a table, tap or click the ____ tab on the ribbon.
EXTERNAL DATA
To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.
EXTERNAL DATA
Which of the following Auto Fill Options menu options is the same as the Fill Series option?
Fill Months
A field whose data type is ____ can store text that can be used as a hyperlink address.
Hyperlink
Which of the following keys toggles between Insert mode and Overtype mode?
INSERT
To center a page's contents vertically between the top and bottom margins, click the Page Setup Dialog Box Launcher, click the ____ tab, click the vertical alignment box arrow, click Center in the list, and then click the OK button.
Layout
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
Long Text
To add a record to a table, tap or click the ____ record button.
New (blank)
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.
OLE object
The default color scheme is called ____.
Office
To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
Open
The default view in Word is ____
Print Layout view
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Qtr2
Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.
Shapes
A field whose data type is ____ can contain any characters.
Short Text
To open the Navigation Pane, tap or click the ____ Button.
Shutter Bar Open/Close
To show the Navigation Pane if it is hidden, click the ____ Button.
Shutter Bar Open/Close
To see the height and width of the currently selected graphic, look in the ____ group on the Picture Tools Format tab.
Size
____ view allows you to look at several slides at one time.
Slide Sorter
When you open a new presentation, a slide with the default ____ layout appears.
Title Slide
When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.
Title and Content
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
____ help one slide flow gracefully into the next during a slide show.
Transitions
____ allows you to see through the background, so that any text on the slide is visible.
Transparency
Using the____, you can choose the arrangement of placeholders on a new slide.
layout gallery
When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.
caption
Charts can either be embedded in a worksheet or placed in a separate ____.
chart sheet
A ____ may be composed of a few individual objects or several complex groups of objects.
clip
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
demoting
A ____ is a specific design with coordinating colors, fonts, and special effects.
document theme
Using the mouse to move or copy cells is called ____.
drag and drop
A(n) ____ is a placeholder for data whose contents can change.
field
The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
font
Word, by default, places a tab stop at every ____ mark on the ruler.
.5"
The file type ____ identifies a Word 2016 document.
.docx
In Access, table and field names can be up to ____ characters in length.
64
By default, the Normal style places ____ points of blank space after each paragraph.
8
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
AutoCalculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them.
AutoCorrect
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
AutoNumber
Click ____ to move a stacked object to the top of the stack.
Bring to Front
To print a mailing label, click the Labels button on the MAILINGS tab in the ____ group.
Create
One way to delete a note is to click immediately to the left of the note reference mark in the document text and then press the ____ key twice.
DELETE
To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
Delete
To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.
Delete Field
To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.
Property Sheet
To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query
Query Design
The Undo button is located on the ____.
Quick Access Toolbar
To save the changes to the layout of a table, tap or click the Save button on the ____.
Quick Access Toolbar
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
RANGEAVG
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
RIGHT ARROW
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu.
Remove Hyperlink
To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key
Sort
____ properties are associated with all Microsoft Office files and include author, title, and subject.
Standard
To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
Zoom
____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.
Zooming
Cell references in a formula are called ____.
assumptions
Which of the following is a standard document property?
author
Sepia changes picture colors into ____.
brown, gold, and yellow
A ____ symbol is another name for a dot symbol.
bullet
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.
false
Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to a(n) ____.
em dash
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
All slide layouts have a content placeholder.
false
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
The WordArt ____ is the exterior border surrounding each letter or symbol.
outline
You can include ____ in calculations to indicate which calculation should be done first.
parentheses ( )
A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
presentation
The person or persons requesting the worksheet should supply their requirements in a ____ document.
requirements
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
A ____ paragraph places the last character of text near the right border of a paragraph.
right-aligned
When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.
rotate
In a business letter, the ____, if present, begins two lines below the last line of the inside address.
salutation
Dragging or sizing affects only a ____.
selected object
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
semi-colon (;)
Which of the following is not a valid format symbol?
semi-colon (;)
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
sparkline
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
square brackets [ ]
A ____ is a named group of formatting characteristics.
style
A thesaurus can be used to look up a(n) _____, or a word similar in meaning to a given word.
synonym
According to the MLA style, the first line of each entry on the works cited page begins at the left margin.
true
By default, PowerPoint ends a slide show with a black slide.
true
Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.
true
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.
true
Form view displays a single record at a time.
true
Layout view shows a report on the screen and allows the user to make changes to the report.
true
To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
true
Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
true
When shading paragraphs, Word shades from the left margin to the right margin of the current paragraph.
true
You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.
true
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
true
