Microcomputer Applications Final Review

Which of these cell references is an absolute reference? none of these C9 C$9 $C$9

$C$9

Identify the Pv argument in this formula: =PMT(B1/12,B2,-B3)

-B3

The Clipboard can store up to _______ items for use in the current document or any other Office application.

24

Which of the following graphic objects can be rotated along three different axes?

3D models

What would you type in the Pages box on the Print page to print only the fourth and seventh page in a document?

4,7

Which of these tasks can you perform in Backstage view?

All of these

When retrieving a file and you don't see the folder containing the file, click the _________ button.

Browse

Which command would you use to change the text from uppercase to having each word capitalized?

Change Case

You can remove conditional formatting using the ________.

Clear Rules from Selected Cells command

What is the keyboard shortcut for reversing the last action you performed?

Ctrl + Z

The keyboard shortcut for applying double spacing is _______.

Ctrl+2

The keyboard shortcut to close a file is:

Ctrl+W

Tables open in _______ where you can enter, sort, and filter data.

Datasheet view

The _______ property allows you to add a preset value to a field.

Default Value

The keyboard shortcut to begin the spelling checker is _______.

F7

To rename a database object, double-click the name in the Navigation Pane and type the new name. T/F

False

Users can enter and edit data in an AutoNumber field. T/F

False

You can adjust the amount of space that appears before and after paragraphs from the Design tab on the Ribbon. T/F

False

You can undo a record deletion. T/F

False

The _______ tab opens Backstage view.

File

Which command would you use to locate specific instances of text in your presentation?

Find

______ allow users to input data through a friendly interface.

Forms

The _______ is the data entry area directly below the Ribbon and above the worksheet grid.

Formula bar

Which paste option pastes formulas and number formatting but none of the cell formatting?

Formulas & Number Formatting

To look up more information about a command, you can look it up using the ______________.

Help task pane

Each application includes a _______ tab that contains the most commonly used commands for that application.

Home

Use the _______ tab when you add WordArt to a slide.

Insert

_______ is a spreadsheet program.

Microsoft Excel

If you want to insert a picture from a file into PowerPoint, use the _______ button on the Insert tab.

Pictures

One method to open the Insert Picture dialog is for you to click the _______ icon in the content placeholder.

Pictures

Which view would you use to view the presentation as your audience will see it?

Slide Show view

The _______ allows you to quickly search the Internet about any word or phrase in a document, spreadsheet, or presentation.

Smart Lookup tool

You can control the order in which records appear in a table, query, or form by using the _______ feature.

Sort

________ are the basic building blocks of a database.

Tables

Splitting a cell back into the original cells uses a method called _______.

Unmerge Cells

Which of these methods can you use to enter a formula using the AVERAGE function? AutoSum all of these Function Arguments dialog Formula AutoComplete

all of these

The zoom slider is located ________.

at the lower right corner of the status bar

Using the Fill Color button changes the _______ color in cells.

background

A piece of content that is reusable in any document, such as a cover page or a watermark, is known as a ____________.

building block

Which kind of list would you use for instructions that do not need to be performed in a certain order?

bulleted list

What is the intersection of a row and column in a table called?

cell

Selecting a cell and pressing Delete clears ________.

cell content only

A _______ is a contiguous group of cells.

cell range

A cell's address, its position in the workbook, is referred to as a _______ when it is used in a formula.

cell reference

The _______ placeholder is a special type of placeholder that gives you a quick way to add a variety of material to your presentations.

content

Which of the following is a special type of placeholder that gives you a quick way to add a variety of material to your presentations?

content

What term is used for the blinking vertical line that indicates the place on the page where text will appear when you begin typing?

cursor

When you cut and paste a cell containing a formula with relative references, Excel ________.

does not update the cell references to the new location

If you want to change all the text in a placeholder, click the _______ of the placeholder and then select a new font or font size.

edge

Each column in a table represents a specific data value called a ________.

field

Each column in a table represents a specific data value called a(n) _______.

field

A _______, or typeface, refers to a set of characters of a certain design.

font

An input mask _______________.

forces users to input data in a consistent format

Displaying the _______ allows you to easily see if there are extra line breaks.

formatting marks

Formula AutoComplete is a shortcut for entering _______.

functions

From the View tab you can display _______ in the Slide pane, giving you visual markers for aligning placeholders and images.

gridlines

A _______ is text or a graphic that, when clicked, opens another page or file.

hyperlink

Which of the following will add text that when clicked will take you to another place in the document?

hyperlink

Which of the following are added to a document as an SVG image?

icons

To apply the Double Accounting underline format ________.

in the Font dialog, on the Font tab, expand the Underline list and select Double Accounting

A ScreenTip displays the _______ of the command when you rest your mouse over a button on the Ribbon.

name

AutoSum is located ________.

on the Home tab, in the Editing group

When you enter a formula with more than one mathematical operation, the formula is not necessarily calculated left to right because Excel calculations follow the mathematical rules called the _______.

order of operations

What is the final step in creating a presentation?

practice your presentation

Text placeholders are _______ in slide layouts where you enter text.

predefined areas

Microsoft Office PowerPoint enables you to create robust multimedia _______.

presentations

The _______ is the field that contains data unique to that record.

primary key

Each row in a table contains all the data for a single _______.

record

Each row in a table contains all the data for a single ________.

record

Using the same font style on the title for each slide is an example of which design principle?

recurrence

A(n) _______ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied.

relative

Normally in Access, _______ are the only database objects that are printed.

reports

Which type of font has an embellishment at the end of each stroke to lead the eye from one character to the next?

serif

A(n) _______ is a drawing object that you can quickly add to your presentation.

shape

When you close a file, the application _______.

stays open

A well-designed database ___________. repeats important data in multiple tables uses the AutoNumber data type for primary key fields stores each unique piece of data in only one table both b and c

stores each unique piece of data in only one table

A(n) ____________ changes the font and paragraph formatting for an entire document based on styles.

style set

To clear a(n) _______, drag the tab marker down from the horizontal ruler to remove it.

tab stop

All data entered into a form are stored in the underlying ________.

table

Access _______ are the essential building blocks of the database.

tables

The database ________ store all the data.

tables

A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.

template

The cell C4 refers to the cell at ________.

the intersection of column C and row 4

Clicking the Borders button on the Ribbon applies which border style?

the most recently used border style

In addition to the number of words in a document, the Word Count dialog also displays

the number of pages

In a PMT function, what is the Pv argument?

the present value of the loan

A group of formatting options that you apply to an entire document is called a(n) _______.

theme

A ____________ is a graphic or text that appears as part of the page background and is usually faded in appearance.

watermark

Microsoft Office Word is a _______ program that enables you to create many types of documents.

word processing

Which feature in Word automatically places text on the next line when the right margin of the document has been reached?

word wrap

A _______ is an electronic ledger in which you enter data.

worksheet

To split a cell into two cells _________.

you cannot split a cell into two cells; you can only unmerge merged cells

Formulas begin with which character?

=

In the Editor pane, which command will prevent the word from being marked as a misspelling in all the Office applications, not just Word?

Add to Dictionary

To align objects on a slide, select more than one object and then click the _______ button in the Arrange group on the Picture Tools Format tab.

Align

When you cut or copy items, they are placed on the ________.

Clipboard

The _______ displays the text from your slides in an outline.

Outline view

Which command aligns text along the upper edge of a text placeholder?

Top

The text that appears at the top of every page, just below the top margin is known as what?

header

Identify the Value_if_true argument in this formula: =IF(A2>100,"high","low")

high

A PowerPoint presentation is made up of a series of _______.

slides

When you are entering data in a new record in a form, the Undo command will ________.

undo the entire record at once

An example of the AVERAGE function is _______.

=AVERAGE(B3:D3)

A formula to display the value of cell A5 on the Inventory worksheet looks like this:

=Inventory!A5

A formula using the TODAY function looks like _______.

=TODAY()

Which data type should be used to include an image file with each record in a table? Memo Photo Hyperlink Attachment

Attachment

Which of the following removes text to the left of the cursor?

Backspace

The number of words and the number of pages in the document are displayed as part of the document properties available from the Info tab in the _______ view.

Backstage

Access opens to _______ where you can select an existing database to open or begin a new one.

Backstage view

To change the Office theme you make the selection from the Account page of the _______.

Backstage view

To count the number of cells that contain text or numerical values, but not blanks, use which function?

COUNTA

Which of the following functions counts the number of cells that are not blank within a specified range of cells.

COUNTA

The keyboard shortcut to open the Quick Analysis tool is ________.

CTRL+ Q

If a list includes more items than will easily fit vertically on a slide, you should use the command to display the items side by side.

Columns

_______ formatting applies formatting to cells based on their values.

Conditional

_______ contain commands specific to the type of object selected and are only visible when the commands might be useful.

Contextual tabs

The _______ command is used to duplicate content in a document.

Copy

Which command would you use to copy text to the Clipboard and not remove it from the presentation?

Copy

Which key combination is used to select an entire document?

Ctrl+A

Press _______ to bypass the Backstage view and create a new blank file.

Ctrl+N

Which of these is not an acceptable name for a named range?

Current Inventory

Which command would you use to copy text to the Clipboard and remove it from the document?

Cut

Which tab can you use to apply a theme to a document?

Design

The AutoSum button is found on the Home tab, in the _______ group and enters the SUM function arguments using the most likely range of cells based on the structure of the worksheet.

Editing

When you open a database for the first time, Access may display a security warning in the Message Bar. If you trust the source of the database, click the _______ button in the Message Bar.

Enable Content

Pressing _______ on the keyboard after entering text will move the cursor down one cell.

Enter

Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database. T/F

False

The Currency field format is the same as the Currency data type. T/F

False

You must manually save the record each time you enter data in a table or form. T/F

False

The easiest way to use AutoFill is to use the _______ tool.

Fill Handle

To perform a complex search in your document, such as finding an exact match, searching for whole words only, or finding formatting in your document, use the _____ command.

Find and Replace

Forms open in _______ view, which provides a user-friendly interface for entering data.

Form

After adding a sound to a slide, the Audio Tools _______ tab will allow you to apply artistic effects and Quick Styles to your sound icon.

Format

The _______ tool allows you to copy formatting styles that have been applied to text.

Format Painter

Which command is used to copy the styles from one word to another?

Format Painter

Which command would you use to copy and paste formatting from one object to another?

Format Painter command

_______ are preprogrammed shortcuts for calculating complex equations, such as the monthly payment amount for a loan.

Functions

When creating slides from a Word outline, text with which style applied to it will become the title text for each slide?

Heading 1

The Slide Layout button is located in the _______ tab of the Ribbon.

Home

To add a bulleted or numbered list to a slide, go to the _______ tab on the Ribbon.

Home

To add a slide to a presentation, click the New Slide button arrow in the _______ tab of the Ribbon.

Home

You can delete a table or other database object by selecting it in the Navigation Pane, and then on the _______ tab, in the Records group, click the Delete button.

Home

The _______ logical function returns one value if a condition is true and another value if the condition is false.

IF

To move a point down a level in a list, click the _______ button.

Increase Indent

Properties are listed at the far right of the _______ page in Backstage view.

Info

To add a header or footer to a document, start by clicking the _______ tab.

Insert

_______ alignment evenly spaces the words, aligning the text on the right and left sides of the printed page.

Justified

To evenly space words, aligning the text on the right and left sides of the printed page, use the ________ command.

Justify

Which paste option pastes the text with the original formatting of the copied text?

Keep Source Formatting

Files that are opened in Protected View display a warning in the _______ at the top of the window, below the Ribbon.

Message Bar

Which of these functions returns the current date and time? DATE NOW TIME TODAY

NOW

The _______ displays the address of the selected cell and can be used to navigate to a specific cell in the worksheet by typing the cell address.

Name box

All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.

Navigation

The primary method for finding text in a document is to use the .

Navigation pane

To insert slides from a Word outline, click the arrow below the _______ button and select the Slides from Outline option.

New Slide

The _______ allows you to create new files without exiting and reopening the program.

New command

_______ can be printed along with your slides to hand out to your audience. They do not appear when you are playing your presentation.

Notes

_______ is Microsoft's free cloud storage where you can save documents, workbooks, presentations, videos, pictures, and other files and be able to access the files from any computer or share the files with others.

OneDrive

_______ converts the text string so that the first letter in each word is capitalized.

PROPER

You can create a slide show of photographs, including captions, using PowerPoint's _______ feature.

Photo Album

Which commands hides the sound icon and play an audio file across the entire presentation? Play in Background button Volume button Hide During Show check box No Style

Play in Background button No Style

What does a red, wavy line under text represent?

Possible misspelled word

_______ key fields are identified with a key icon next to the field name.

Primary

Reports include _______, which shows how the report will look when printed.

Print Preview

_______ extract data from a table or related tables and can include actions such as updating data values or deleting data.

Queries

The _______ is located at the top of the application window, above the File tab, providing one-click access to common commands.

Quick Access Toolbar

Use this view when you want to review a document in an easy-to-read format.

Read Mode

The _______ command allows you to reverse the Undo command and restore the file to its previous state.

Redo

_______ databases allow you to relate tables and databases to one another.

Relational

The _______ command in Word allows you to locate specific instances of text in your document and replace them with different text.

Replace

Which command would you use to replace all instances of a word with another word?

Replace All

The _______ is located across the top of the application window and organizes common features and commands into tabs.

Ribbon

Which tab stop displays the text to the left of the tab stop?

Right Tab

_______ fonts, such as Calibri and Arial, do not have an embellishment at the end of each stroke.

Sans serif

Which of these dates uses the Long Date format? 01/01/2020 1/1/2020 Saturday, January 1, 2020 January 1, 2020

Saturday, January 1, 2020

_______ are menus of commands that display when you right-click an area of the application window.

Shortcut menus

Which command displays hidden formatting marks in a document, including paragraph and spacing marks?

Show/Hide

You can collapse or expand the Navigation Pane by clicking the _______ button.

Shutter Bar Open/Close

Which of the following are visual diagrams containing graphic elements with text boxes in which you enter information?

SmartArt

When you launch Office applications you are first taken to the ________ page which gives you quick access to recently opened files and templates.

Start

The _______ appears at the bottom of the worksheet grid and displays information about the selected data, including the number of cells selected that contain data and the average and sum of the selected values.

Status bar

When you have entered all the data for a new record, press _______ or _______ to start another new record.

Tab; Enter

The __________ feature offers a quick way to access commands.

Tell Me

Which command would you use to call attention to text by coloring the background behind the text?

Text Highlight Color

To highlight cells with values in the top 10% of the select range, use ________ conditional formatting.

Top/Bottom Rules

Data markers are graphic representations of the values of data points in a chart. T/F

True

Moving a field in Design view also changes the field order in Datasheet view. T/F

True

Styles ensure parts of your document, such as headings, all use the same formatting. T/F

True

To open one of the Office applications using Windows 10, click the _________ Start button, All Apps, and then find the application in the list and click on the one you want to open.

Windows

Text that includes predefined graphic styles, such as shadows, reflections, and glows, is known as ________.

WordArt

Which would you use to magnify the text on-screen, making the text appear larger?

Zoom In button

A(n) _______ reference is a cell reference whose location remains constant when the formula is copied.

absolute

There are several different design principles to consider when creating a presentation, and they include:

balance, flow, distinction, and recurrence

A table's primary key must _________.

be unique for every record in the table.

Grammatical errors in a document are represented by a

blue double underline

To pick up where you left off in a document or presentation, open the document or presentation and click the _______ to navigate to the location.

bookmark tag

If two tables have referential integrity enforced, ___________. both a and b you cannot add a record to the secondary table without an associated record in the primary table you cannot make changes to the primary table that would cause records in the secondary table to become unmat none of these

both a and b

To rename a field, ________. both b and c click the column header, and type the new field name double-click the column header, and type the new field name right-click the column header, select Rename Field, and type the new field name

both b and c

A _______ is a group of predefined colors that work well together in a document.

color theme

Adding _______ to placeholders allows for more flexibility of displaying lists across a slide.

columns

Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.

database

A(n) ________ is the cell containing a formula that references the value or formula in the selected cell.

dependent

When sorting a datasheet on more than one field, apply the _________ first.

innermost sort

The MAX (maximum) statistical function will give you the _______ value in a range of values.

largest

Click the tab selector at the _______ of the horizontal ruler to change the type of tab stop.

left

What are the blank spaces at the top, bottom, left, and right of a page known as?

margins

Which would you use to display items in a list in a particular order?

numbered list

Although you create and work with a single Access database file, inside the file, there are multiple _______.

objects

Where is the Set Print Area command located?

on the Page Layout tab, in the Page Setup group

How many worksheets does a new Excel workbook have?

one

After clicking the Format Painter button, your cursor transforms into a _______.

paint brush

Which of the following would you use to add your company's name over and over again in a document without typing it every time?

property control

A(n) _______ database is a group of tables related to one another by common fields.

relational

Which type of font does not have an embellishment at the end of each stroke?

sans serif

What would you use to force text on to a new page that will have its own settings separate from the rest of the document?

section break

After clicking the New Slide button arrow, you will be asked to select a _______ from the New Slide gallery.

slide layout

The _______ bar appears at the bottom of the Excel window and displays information about the current worksheet.

status

Styles and Themes Table Formatting include:

table styles and shading

A _____ is a file with predefined settings that you can use as a pattern to create a new presentation of your own.

template

Which are predefined areas in slide layouts where you enter text?

text placeholders

To control the number of characters a user can enter into a table field, use __________.

the Field Size property

Which of the following is a group of formatting elements you apply to a document?

theme

What is the definition of concatenate?

to link items together

Which of the following actions is used to select a paragraph of text?

triple-click the paragraph

The NOW and TODAY functions are termed volatile, in that they _______ the current date or date and time each time the workbook is opened.

update