question

The main elements of the ___ include the Ribbon, Mini toolbar, and Office button.

answer

Word Window

question

The __ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted.

answer

Insertion point

question

The ___ is the control center in Word.

answer

Ribbon

question

The ___ tab contains the more frequently used commands.

answer

Home

question

As shown in Figure 1-1, a ___ is a set of choices , often graphical, arranged in a grid or in a list.

answer

Gallery

question

The ___, or typeface, defines the appearance and shape of letters, numbers, and special characters.

answer

Font

question

The small squares and circles around a selected graphic, as shown in Figure 1-5, are called ___ handles.

answer

Sizing

question

To move left one word with the keyboard, press ___.

answer

Ctrl+Left Arrow

question

To move to the beginning of a line with the keyboard, press ___.

answer

Home

question

To delete a character in a document, click next to the character and then press the ___ key to erase to the left of the insertion point.

answer

Backspace

question

The ___ on the right side of the menu bar lets users type free-form questions, such as how do I save, or terms, such as copy, and Word responds by displaying a list of topics related to the word or phrase entered.

answer

Type words to search for text box

question

When using MLA style, position explanatory notes either at the ___, as shown in Figure 2-1.

answer

Bottom of the page as footnotes or at the end of the paper as endnotes

question

On the works cited page, list works by each author's last name and ___ the title of the work, as shown in Figure 2-1.

answer

Italicize or underline

question

Headers (as shown in Figure 2-2) and footer can include text and graphics, as well as the ___.

answer

Current date, Page number, Current time

question

A ___ is a book of synonyms.

answer

Thesaurus

question

If you want to remove the AutoCorrect Options button from the screen, you can press the ___ key.

answer

Escape

question

The rule is to press the spacebar ___ times after periods, colons, and other punctuation marks.

answer

One

question

Automatic page breaks like the one in Figure 2-4 are determined by ___.

answer

Paper size, Line spacing, Margin settings

question

All of the following are guidlines about the appearance of letterhead elements except ___.

answer

Make the font size of your name the same size as the rest of the text in the letterhead

question

When you move the mouse pointer into the transparent ___, it changes to a bright toolbar.

answer

Mini toolbar

question

A ___ is a seperate window that enables you to carry out some Word tasks more effeciently.

answer

Task pane

question

As an alternative to using the Recolor button on the Format tab to display the Recolor gallery shown in the accompanying figure, you can right-click the graphic, click ___ on the shortcut menu, click Picture in the left pane and then click the Recolor button.

answer

Format picture

question

Word, by default, places a tab stop at every ___ mark on the ruler.

answer

.5"

question

Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to an ___.

answer

Em dash

question

Essential business letter elements include the ___.

answer

Date line, Inside address, Message, Signature block

question

To advance rightward from one cell to the next in a table, press the ___ key.

answer

Tab

question

A ___ contains instructions for filling areas of a template.

answer

Content control

question

A ___ is a formatting mark at the end of a line that moves the insertion point to the beginning of the next physical line.

answer

Line break character

question

Items like the phone number in the accompanying figure are copied from a ___ document.

answer

Source

question

If the e-mail address shown in the accompanying figure had just been pasted into the cover letter shown, that would make this letter the ___ document.

answer

Destination

question

What is the title of the blank workbook that opens when you first start Excel form the Windows Start menu?

answer

Book1

question

The number of worksheets that a workbook can contain is ___.

answer

Limited by computer memory

question

How many file formats does Excel offer for saving a workbook?

answer

More than 30

question

While Excel is saving your file, it briefly displays a message on the status bar indicating ___.

answer

The amount of the file saved

question

Combining two or more cells together is called ___ cells.

answer

Merging

question

What effect does the Comma Style format have on the selected cells?

answer

Causes the cells to display with two decimal places and commas as thousand seperators

question

___ properties are associated with all MIcrosoft Office documents and include author, title, and subject.

answer

Standard

question

Which key on the keyboard toggles between Insert mode and Overtype mode?

answer

Insert

question

In the accompanying figure, the ___ tab is called the primary tab of the Ribbon.

answer

Home

question

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ___.

answer

1932

question

When Excel follows the order of operations, the formula, 8*3+2, equals ___.

answer

26

question

Every time you enter a value into a cell into a cell in the worksheet, Excel automatically ___ formulas.

answer

Recalculates all

question

When an error occurs in a formula in a cell, Excel displays the ___ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.

answer

Trace error

question

The ___ button lists formatting options following an insertion of cells, rows, or columns.

answer

Insert Options

question

As with column widths, when you decrease the row height to 0, the row is ___.

answer

Hidden

question

If a single cell is selected so that the formulat bar is not active and then the spell checker is started, Excel checks ___.

answer

The remainder of the worksheet, including notes and embedded charts

question

In the Print dialog shown in the acccompanying figure, the ___ instructs Excel to print the worksheet currently on the screen or the selected worksheets.

answer

Active sheets option button

question

To toggle between the values version and the formulas and the formulas version of a worksheet, hold down the ___ key.

answer

Ctrl key while pressing the Accent mark

question

The formulas version verifies that you entered formulas, rather than ___, in formula-based cells.

answer

Number

question

To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ___.

answer

Press the enter key

question

In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.

answer

Copy

question

If you drag the fill handle to the left or up, Excel will ___ the series rather than ___ the series.

answer

Decrement, Increment

question

The increase Indent button indents the contents of a cell to the right by ___ spaces each time you click it.

answer

3

question

Unless you first select a range of cells or an object before starting the spell checker, Excel checks the selected ___.

answer

Worksheet

question

The ___ if ideal for returning the worksheet to its original state after you have changed the values in a worksheet to answer a what-if question.

answer

Undo button

question

What is your recommendation for her in terms of where she should store the files for this project, given that she will be working on the files frequently, saving and resaving them all the time?

answer

USB flash drive

question

Every time Sara tries to save one of the file associated with her project, it is rejected as an invalid file name.Which of the following could be the name of the fiel that is giving her trouble?

answer

Finances:2007

question

Which of the following changes you make to your text is an example of paragraph formatting?

answer

Centering all of the paragraphs on the title page

question

Which of the following is not a character the formatting of which you can change?

answer

Paragraph mark

question

Riley brings to you the research paper on which she is currently working. Which of the following is a correct and complete citation for a book?

answer

Santos, Matthew and Joshua Lyman. _How to Run (and Win) a Presidential Campaign._ Houston: GOP Publishing, 2008.

question

Her most recent paper is the first example of a paper on which Riley has worked that will use Web sites as sources. Can you help her to indicate which of the following is a correct and complete citation for a Web site?

answer

Cashman, Thomas J. How a USB Flash Drive Works. Course Technology. 14 April 2008.

question

Which of the following allows you to select a paragraph?

answer

Triple-click the paragraph

question

Which of the following keys do you recommend to your collegue as a key to hold down while you select nonadjacent items?

answer

Ctrl

question

Julian has designed a person letterhead with his name at the very top. What is the first thing he should put immediately below the letterhead, and how far below the letterhead should it appear.

answer

Date line, two to six lines below

question

Julian is concerned that he is forgetting something in the inside address. He has the following information: courtesy title, full name, business affiliation, and full geographical address.

answer

Yes, he is forgetting the job title.

question

Which of the following allows you to select the entire table?

answer

Click teh table move handle.

question

If you click at the left edge of a cell, what are you selecting?

answer

The cell

question

Which of the following storage media is the best choice for Perry and his team if they decide that they will not need to share their workbooks across the team and they will not need to transport their projects to other locations?

answer

Hard drive

question

Perry decides that he will need to have access to particular workbooks on a variety of computers in the office. As a result, which of the following storage media is a good choice for him?

answer

USB flash drive

question

Which of the following features would be helpful to Anita if she wants to see the impact of a particular gallery choice of her worksheet, but she is nervous about actually applying the feature from the outset?

answer

Live preview

question

Anita has decided that she would like to make better use of the keyboard. Which of the following features would alert her to any available keyboard shortcuts associated with commands on the Ribbon?

answer

Enhanced ScreenTip

question

To format the location of the dollar sign, which category on the Number tab in the Format Cells dialog box would he select?

answer

Currency

question

How would Leo rename the worksheets to Rye Bread, Onion Rolls, and Bagels?

answer

Double-click the worksheet tab, type the new name, and press the Enter key.

question

Why did Anna prefer to use the MAX function?

answer

The MAX function recalculates the highes value each time a new value is entered into the worksheet.

question

What would she do in cell E4 to determine the average distance?

answer

Enter the text =av and then select the AVERAGE function from the AutoComplete list; then enter the cell range.

question

Which statement is true about the number of people who voted on each type of pie?

answer

The number of people determines the sizes of the slices.

question

From a design perspective, what should she do to emphasize the apple pie?

answer

Rotate the apple pie slice toward the front and explode it.

question

If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the Receptionist. Otherwise, George will just purchase the desk and chair. How should George determine this in the worksheet?

answer

Use the IF function

question

In George's worksheet, the result for the calculation in cell H4 is ######. What should George do?

answer

Increase the width of column H

CBA Semester Test – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards