BCIS-1305 Final Exam

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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.

print

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


संबंधित स्टडी सेट्स

Comparative Management Chapters 8-11

View Set

BIO 140 - Chapter 7 Microbial Growth

View Set

The Sentence Completion Question Tactics

View Set

Chem 201 test 4 (quiz/hw answers)

View Set

1. Bread Ingredient Properties, Characteristics, and Terms

View Set

Videbeck Chapter 10: Grief and Loss Q's

View Set

ATI Priority Setting Frameworks Beginning Test

View Set