BCIS-1305 Final Exam
A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.
bulleted
Monitor dimensions and resolution affect how ____ display on the ribbon.
buttons
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
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
To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
Back Up Database
In the accompanying figure, the Book Rep table displays in ____
Design view
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
Format
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
Which mode hides all commands and just displays a document?
Full Screen mode
____ is one color shade gradually progressing to another shade of the same color or to another color.
Gradient fill
To move to the beginning of a line with the keyboard, press the ____ key(s).
HOME
Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
If you do not want to keep a change automatically made by Word and you immediately notice the automatic correction, you can undo the change by clicking the Undo button on the ____.
Quick Access Toolbar
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
A ____ is a specific design with coordinating colors, fonts, and special effects.
document theme
You should ____ a function name in the Formula AutoComplete list to select the function.
double-click or double-tap
A ____ is text and graphics that print at the bottom of every page.
footer
A ____ is a set of choices, often graphical, arranged in a grid or in a list
gallery
Sending electronic documents is a way to contribute to ____ computing.
green
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.
horizontal ruler
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
The buttons, arrows, and boxes on the mini toolbar vary, depending on whether you are using Touch mode versus ____ mode.
mouse
To increase the font size of selected text, chose the Increase Font Size button, located ____.
on the mini toolbar
In Word, you can create electronic image files through the ____ tab in the Backstage view.
Document ____ are the details about a file.
properties
To order the records in the answer to a query in a particular way, you ____ the records.
sort
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 [ ]
On the works cited page, list works by each author's last name, as shown in the accompanying figure, or, if the author's name is not available, by the _____.
title of the source
The ____ introduces the presentation to the audience.
title slide
In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.
design grid
The file type ____ identifies a Word 2013 document.
.docx
When you decrease the row height to ____, the row is hidden.
0
A point is ____ of an inch in height.
1/72
How many chart types does Excel offer?
10
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
You can place an insertion point by tapping or clicking in the field or by pressing ____.
F2
In the accompanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.
Join Properties
To create a crosstab, click the ____ button on the CREATE tab.
Query Wizard
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)
All of the following are valid Excel arithmetic operators EXCEPT ____
>
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
One way to add a correctly spelled word to the custom dictionary is to tap or click the ____ button in the Spelling and Grammar dialog box.
Add to Dictionary
The ____ includes a button that enables you to display all of your apps.
App bar
You can click the ____ button to undo an automatic correction
AutoCorrect Options
To define an additional field in Datasheet view, tap or click the ____ column heading.
Click to Add
To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
Build
To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.
CREATE
To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Report Wizard button
CREATE
To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items
CTRL
You can select a document by using the ____ key.
CTRL+A
You can select a paragraph by using the ____ key.
CTRL+SHIFT+DOWN ARROW
You can select a word by using the ____ key.
CTRL+SHIFT+LEFT ARROW
The ____ shortcut keys underline words, and not spaces.
CTRL+SHIFT+W
To move up one paragraph, press the ____ key(s).
CTRL+UP ARROW
To paste copied cell contents, you can press the ____ keys.
CTRL+V
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.
Caption
The Office ____ is a temporary storage area.
Clipboard
One way to delete a note is to tap or click immediately to the left of the note reference mark in the document text and then press the ____ key twice.
DELETE
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
ID
When you tap or click the ____ button for a selected graphic, Word provides options for changing how a graphic is positioned with text in a document.
Layout Options
The ____ Option button lists formatting options following an insertion of cells, rows, or columns
Insert
The ____ dialog box allows you to search for clip art by using descriptive keywords.
Insert Pictures
The default color scheme is called ____.
Office
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
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 find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.
S*
To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
Tables and Related Views
____ are the alternate designs that exist for each theme.
Variants
You use ____ to view an XPS file.
XPS Viewer
Automatic page breaks are determined by ____.
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
____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
character
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
comparison operators
A ____ is a collection of data organized in a manner that allows access, retrieval, and use of the data.
database
Access is a ____.
database management system
____ is the difference between the darkest and lightest areas of an image.
contrast
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
As shown in the accompanying figure, tap or click the ____ arrow to display the Font gallery.
font
The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
font
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
When you use the keyboard to scroll to a different position in the document, the ____ automatically moves when you press the desired keys.
insertion point
In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.
join
The Italic button is located on the ____.
mini toolbar
To search for formatting or a special character, click the _____ button to expand the Find dialog box.
more
A(n) ____ is a book of synonyms.
thesaurus
____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point.
pasting
A ____ consists of a drive letter (preceded by a drive name when necessary) and colon, to identify the storage device, and one or more folder names.
path
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
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
The ____ allows you to adjust the screen resolution.
resolution slider
When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.
rotate
Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.
shapes
The small squares and circles around a selected graphic are called ____ handles.
sizing
A ____ is a named group of formatting characteristics.
style
The shortcut keys for the _____ character formatting are CTRL+SHIFT+PLUS SIGN.
superscript
Tap or click the Texture button to display the ____ gallery, as shown in the accompanying figure.
texture
An Excel ____ allows data to be summarized and charted easily.
worksheet
____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.
zooming
