IBA Final Practice I-A, I-B, I-C
The Footnote and Endnote dialog box contains an option to change the page number format to:
Uppercase Roman numerals
Monitor dimensions and resolution affect how ____ display on the ribbon.
buttons
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
A table of contents is located at the ______ of the document.
Beginning
Which of the following inserts an empty page at the insertion point?
Blank Page & Page Break
How do you display only one reviewer's comments in a Word document containing multiple reviewers' comments?
Deselect the All Reviewers check box and place a check mark beside only that one reviewer's name.
When you create a table in Word, two new Ribbon tabs appear. Which of the following is in the Table Tools tab?
Design
To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu
Design View
Endnotes can be converted to which of the following?
Footnotes
The ________ lets you copy the format of text and apply those attributes to different text.
Format Painter
____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.
Graphics
Where do you go to personalize your copy of Microsoft Office options?
Located in the Word Options dialog box from Backstage view
The ____ function displays the highest value in a range.
MAX
The ____ function determines the lowest number in a range.
MIN
When mail merge fields have been inserted into a document, Word will automatically replace them with information from a data source when the
Mail merge is performed
Which tab contains the commands used to perform mail merges?
Mailings
Unsaved documents can be recovered using:
Manage Versions
A line inserted around the document page is called a __________.
Page border
If you accidentally replace the wrong text, just click the Undo button on the ____.
Quick Access Toolbar
The Undo button is located on the ____.
Quick Access Toolbar
Recovering unsaved documents is located under which command?
Recent
If you make any changes to the colors, fonts, or effects of the current theme, you can save it as a custom theme and apply it to future documents.
True
You can sort single-level lists, such as bulleted or numbered lists in a table.
True
The accompanying figure illustrates the screen you use to choose a ____.
document theme
A ____ is a prewritten formula that is built into Excel.
function
The Notes pane is ____ until you tap or click the Notes button on the status bar to open the pane.
hidden
A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
presentation
Access is a ____.
database management system
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
demoting
Which of the following is the path to the Comma Style button?
(HOME tab | Number group)
The Picture Effects button is located on the ____, as shown in the accompanying figure.
(PICTURE TOOLS FORMAT tab | Picture Styles group)
The Picture Styles gallery, shown in the accompanying figure, is displayed by clicking the More button located on the ____.
(PICTURE TOOLS FORMAT tab | Picture Styles group)
A point is ____ of an inch in height.
1/72
When measuring point size, one point is equal to a character height of:
1/72 of an inch
How many chart types does Excel offer?
10
Excel remembers the last ____ actions you have completed.
100
To exit Access, tap or click the ____ button on the right side of the title bar.
Close
You can place an insertion point by tapping or clicking in the field or by pressing ____.
F2
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 is the path to the Sum arrow?
(HOME tab | Editing group)
What is the correct path to the Bold button?
(HOME tab | Font group)
In Access, table and field names can be up to ____ characters in length.
64
Which of the following calculations multiplies 23 by 0.01?
=23%
Pressing Ctrl+Enter produces what?
A manual page break.
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
When previewing the mail merge document, Word replaces the merge fields with
Actual data
Which menu will allow you to add content to the table of contents?
Add Text
Which property of borders can be changed in the Borders tab of the Borders and Shading dialog box?
All choices offered
The Go To command allows you to navigate by page, text, graphics, equations, or tables by doing which of the following:
All of the answer choices
Changing the font and font size of selected text can be completed using:
All of the offered choices
Exceptions can be added to AutoCorrect by:
All of the offered choices
Opening the Modify Style dialog box allows you to________________.
All of the offered choices
Sorted data can consist of:
All of the offered choices
The Replace command can be opened using:
All of the offered choices
Using the Sort feature in a table sorts selected content in what order?
All of the offered choices
Which one of these keyboard shortcuts are not assigned.
Alt+Q
The shortcut key, Ctrl+C is:
Assigned
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
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
__________ can be found within the Quick Parts menu.
AutoText
In the _____________dialog box, you can specify to insert a page border on only the first page of a document.
Borders and Shading
____ determines the overall lightness or darkness of an entire image.
Brightness
The ____________ provides a way to manage building blocks by editing, deleting, and/or inserting them.
Building Blocks Organizer
What element can you use to provide a short descriptive label for an image in a newsletter or magazine?
Caption
Mail merge fields are enclosed by
Chevrons (<< >>)
The ________________feature removes all formatting from the selected text.
Clear Formatting
What does dragging a tab off the ruler do?
Clears it
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
Compact & Repair
Which command enables you to remove unwanted parts from a picture?
Crop
The keyboard shortcut for finding text is:
Ctrl+F
To merge information into your main document, you must first connect the document to a(n)
Data source
Which line spacing command sets the spacing at a fixed amount that Word does not adjust?
Exactly
____ text has a slanted appearance.
Italicized
Which of the following displays the Columns dialog box?
More Columns command
Which Word feature enables you to select multiple pieces of text that are not next to each other?
Multi-selection feature
To add a record to a table, tap or click the ____ record button.
New (blank)
As shown in the accompanying figure, the ____ arrow displays the Facet layout gallery.
New Slide
By default, how many levels does the Outline View contain?
Nine
You can type comments to yourself in the ____ for a specific slide while working in Normal view.
Notes pane
Clip Art can be accessed by clicking on which button?
Online Pictures
Which of the following is NOT a type of indent?
Positive
You must register a Blog space before:
Publishing
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
Macros are used for:
Repetitive Work.
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
Reserved
Draft versions of documents can be deleted by:
Right-clicking then selecting Delete & Using Manage Versions
The ____________ will capture a picture of the whole application window.
Screenshot button
Which of the following is used to create layout or formatting changes in a portion of a document?
Section break.
Tiny lines at the ends of characters are known as:
Serifs
A field whose data type is ____ can contain any characters.
Short Text
Clicking the Expand subdocuments button will?
Show all of the text in the subdocument
An arrangement of data made up of horizontal rows and vertical columns is called a:
Table
____________ are reduced-size versions of images.
Thumbnails
When you open a new presentation, a slide with the default ____ layout appears.
Title Slide
The Vertical Reviewing Pane displays where?
To the left of the document
You can change the transparency of a picture used as a slide's background with the ____.
Transparency slider
A bookmark is a reference point in a document.
True
The formatting marks can be turned off in the Display screen of the Word Options dialog box.
True
The shortcut to double space a paragraph is Ctrl+2.
True
To apply a Style to selected text, click the style from the Styles group.
True
When customizing the Ribbon, you have the option to group commands within a tab.
True
Which word(s) refers to how text is positioned between the top and bottom margins of the page?
Vertical alignment
What is the term for the last line of a paragraph when it is left alone at the top of a page?
Widow
____ allows you to type new text or convert existing text to WordArt.
WordArt styles
In Excel, a number can contain the characters ____.
all of the above
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
The rectangles that are formed when rows and columns intersect are known as:
cells
The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
equal sign (=)
Solid ____ is one color used throughout the entire slide.
fill
The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.
fill handle
Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.
font
Combining two or more selected cells into one cell is called ____ cells.
merging
PowerPoint increased the weight of a line in ____ increments.
one-fourth
Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.
one-third
PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.
predefined
A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
range
The adjusted cell references in a copied and pasted formula are called ____ cell references.
relative
In the accompanying figure, the small box or bar to the left of each field is called the ____.
row selector
PowerPoint displays many ____ that are varied and appealing and give you an excellent start at designing a presentation.
themes
An Excel ____ allows data to be summarized and charted easily.
worksheet