CSCI

A _______ file is a type of vector graphics file created specifically for Windows.

.wmf

One of the graphics Emily wants to include in her mailings is an illustration, a line drawing whose size she can increase as much as she wants without affecting its overall quality. Which of the following is the most likely format for this illustration?

.wmf

To cut selected text, you can use the keyboard command ____.

CTRL X

Case 2-1Thomas is writing a report for his advertising class in which he analyzes corporate campaigns and ad slogans. To compile his report, he needs to copy several quotes and portions of articles from other documents, and needs to pay special attention to formatting. Thomas has just applied Header 1 to some selected text in his report. He needs to do the same thing again now. To save time, you suggest that he press the ____ key to repeat his most recent action

F4

A ____ is a coordinated collection of fonts, colors, and other visual effects designed to give a document a cohesive, polished look.

Theme

To sort by a second column, click the ____ arrow and click a column header.

Then by

Case 2-1Thomas is writing a report for his advertising class in which he analyzes corporate campaigns and ad slogans. To compile his report, he needs to copy several quotes and portions of articles from other documents, and needs to pay special attention to formatting. Thomas is reviewing all his documents and decides that using boldface and italics is too heavy. To change the formatting, he should use ____.

Find and replace

To copy formatting from the selected text to other text in the document, use the _______ button

Format Painter

mm/dd/yyyy is known as ____.

a date format

Case 4-1Santo is creating a company newsletter for his architectural firm. He has solicited contributions from his colleagues on their current projects, and several people have provided photos of homes and businesses they are currently remodeling. Santo is about to begin compiling all the information using desktop publishing in Microsoft Word. Santo would like to position his WordArt object across the width of the newsletter. So that he can wrap text below the graphic and give himself more flexibility in positioning the graphic later, he should _______.

wrap the graphic around the text

The _______ file format is similar to GIF files, but suitable for art containing a wider array of colors

png

To move the insertion point to the next cell to the right in a table, you can ____.

press the Tab key

A wavy _______ line appears if you type a word that is not in the dictionary at all.

red

Which of the following errors will AutoCorrect catch?

teh for the

Preformatted files in Word (e.g., fax cover sheets, memos) are known as _______.

templates

To delete the structure of a row, column, or table, select the row, column, or table, and then use ____.

the Delete button in the Rows & Columns group

By default Word documents include _______ margins on all sides of the document.

1-inch

An Excel worksheet can have a maximum of ____ columns in a worksheet

16384

To move or copy a range of cells, select the correct order:1. Move the pointer over the border of the selection until the pointer changes shape.2. Select the cell or range you want to move or copy.3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

2,1,3

Case 3-2Monica is working on a report for her art history class. She is using Microsoft Word for her report so that she can incorporate tables, text, and graphics into one document, but needs suggestions on fine-tuning her report. Monica is editing her report and notices that she has forgotten to insert a footnote on page 4. When Monica inserts the footnote, ____.

:Word will automatically renumber all footnotes

Case 3-2Monica is working on a report for her art history class. She is using Microsoft Word for her report so that she can incorporate tables, text, and graphics into one document, but needs suggestions on fine-tuning her report. Monica wants to start a new section at the location of the insertion point without changing the page flow. To do this, she should ____.

:insert a Continuous section break

Case 4-1Santo is creating a company newsletter for his architectural firm. He has solicited contributions from his colleagues on their current projects, and several people have provided photos of homes and businesses they are currently remodeling. Santo is about to begin compiling all the information using desktop publishing in Microsoft Word. Santo wants to use most of the graphics his colleagues asked to display with their articles, but his file size has become unmanageable with so many sketches and photos. Santo might be able to reduce his document file size without leaving out content by _______.

:saving all graphics as JPEG files

The formula used to multiply cell A1 by cell C1 is ____

=A1*C1

What is the syntax for a SUM formula adding the values of cell F6 to F9?

=SUM(F6:F9

Case 3-2Monica is working on a report for her art history class. She is using Microsoft Word for her report so that she can incorporate tables, text, and graphics into one document, but needs suggestions on fine-tuning her report. Monica has included a table in her report to give information on 20 key events. Since the table is text-heavy, Monica wants to make it easier to distinguish between the rows. Monica should use the ____ formatting to make her table easier to read.

A:Banded Rows

____ makes it easier to enter repetitive text in cells.

AutoComplete

Case 1-1Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. Anxious to apply, Gabrielle downloads the form and opens it on her computer. In the space allocated for today's date, Andrea types Janu and then is prompted by _______.

AutoComplete to insert the name of the month, January

Case 1-1Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. Gabrielle is very excited and rushing. She continually types "teh" instead of "the." Fortunately, the _______.

AutoCorrect feature corrects it automatically

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column

AutoFit

Emily has a very large digital picture file and a colleague of hers has recommended that she save it in a different format before using it in her Word document. Which of the following is most likely to be the file format in question?

BMP

To cut off part of the graphic in an illustration, you would _______ the illustration.

CROP

To copy selected text, you can use the keyboard command ____.

CTRL + C

Case 3-1Josephine has just been hired as the assistant for a ten-person production team. She wants to organize her team's information, but she is only familiar with Microsoft Word. Josephine wants to include each team member's name, title, e-mail address, and work extension. Josephine's boss likes her table, but has asked that she also include each team member's home office number. What's the best way for Josephine to go about adding this information?

Click the Add Column button at the top of the column border.

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

Colon

Although a citation looks like ordinary text, it is actually contained inside a ____, a special feature used to display information that is inserted automatically, and that may need to be updated later. (

Content Control

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

Ctrl + S

To select the entire document, press

Ctrl+A

All of the following are options in the Delete menu EXCEPT ____.

Delete All

Case 1-2Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. The next day Kade opens the letter in order to proofread it. He realizes that there is some formatting in part of the letter that he would like to use elsewhere in the letter. After using the Format Painter, he wants to turn it off. What key should he press?

ESC

To switch to ____ mode, you double-click the cell.

Edit

____ enters text based on patterns it finds in the data

Flash Fill

Ctrl + G is used to access the ____

Go to a location in the worksheet command

Case 3-2Monica is working on a report for her art history class. She is using Microsoft Word for her report so that she can incorporate tables, text, and graphics into one document, but needs suggestions on fine-tuning her report. Monica wants insert a cover page for her report. She needs to be sure her insertion point is at the beginning of the report. Then she would click the Cover Page button from the ____.

INSERT tab

Emily has used this file format many times, as it is suitable for photographs, and highly compressed, which makes it a good idea when file storage is at a premium. What is this format?

JPEG

For another self-mailer she is producing, Emily needs a photograph. Which of the following is the most likely format for the file she will use?

JPEG

Case 2-2Charlotte has just taken a job at a local publishing house. She has a lot of tasks to accomplish today, but her first task is to write letters to several of the authors and send out contracts. Charlotte wants to make a good impression on her boss, so she wants to make sure all her correspondence with the authors is professional and looks formal. Charlotte has added a citation to the documents on which she is working. In the process of her doing so, Word has added the source that she introduced to a ____ of sources, which is now available to any document created using the same user account on that computer.

Master List

In the Find and Replace dialog box, click ____ on the Replace tab to display the Search Options section.

More

You can insert pictures via either the Pictures button or the _______ button.

Online Pictures

Case 3-1Josephine has just been hired as the assistant for a ten-person production team. She wants to organize her team's information, but she is only familiar with Microsoft Word. Josephine wants to include each team member's name, title, e-mail address, and work extension. After using the table for a few weeks, Josephine has gotten tired of having to look through every row for the name she wants to find. What would be the easiest way for Josephine to organize her data?

Open the table and do a Find each time she wants to locate information.-wrong

Now Emily is looking for a compressed file format that is suitable for most types of simple line art, but that has the capacity for some complicated colors. What is the most likely format for the file she will use?

PNG

Line spacing is the amount of space that appears between lines of text within a _______.

Paragraph

To change the order of operations, enclose part of the formula in ____

Parenthesis

Case 1-2Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. Kade thinks that a photo may help to illustrate a point he is making in the letter about a project on which he has worked. What is the term for the photo he wants to insert into this document?

Picture

In ____ orientation, a page is taller than it is wide

Portrait

Case 3-2Monica is working on a report for her art history class. She is using Microsoft Word for her report so that she can incorporate tables, text, and graphics into one document, but needs suggestions on fine-tuning her report. Monica used the Cover Page gallery to insert a cover page in her report but now she wants to delete it. To do so, she should click the Cover Page button in the Pages group, and then click ____. (478370)

Remove Current Cover Page

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

Scale

Case 3-1Josephine has just been hired as the assistant for a ten-person production team. She wants to organize her team's information, but she is only familiar with Microsoft Word. Josephine wants to include each team member's name, title, e-mail address, and work extension. After a few months, one of Josephine's colleagues moves to another team within the company. Josephine no longer needs his information in her table. What would you recommend that she do?

Select the table, and click the Delete button in the Rows & Columns group.

To move the active cell up one row, press ____.

Shift + Enter

You can use the _______ button in the Text group to rotate text within a text box.

Text Direction

Case 2-2Charlotte has just taken a job at a local publishing house. She has a lot of tasks to accomplish today, but her first task is to write letters to several of the authors and send out contracts. Charlotte wants to make a good impression on her boss, so she wants to make sure all her correspondence with the authors is professional and looks formal. Charlotte knows that she will be drafting several contracts in the coming weeks, and each letter will need to be printed with specific headings and body text formatting. To save time, Charlotte should apply ____.

Styles

Case 4-1Santo is creating a company newsletter for his architectural firm. He has solicited contributions from his colleagues on their current projects, and several people have provided photos of homes and businesses they are currently remodeling. Santo is about to begin compiling all the information using desktop publishing in Microsoft Word. When Santo is formatting the text in his WordArt text box, he discovers that by default the text box is formatted with _______ text wrapping.

Tight

Case 1-1Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. The first part of the form asks applicants to write one paragraph about why they would like to at work Channel 30. Right away, Gabrielle knows what she wants to write; she's grown up with Channel 30 and has always been impressed by the quality of the news anchors, especially Katie Couric. Each time she types Couric in her response, a red

Word considers "Couric" to be a misspelled word

To change the text wrap setting for clip art, click the _______ button.

Wrap Text

Case 3-1Josephine has just been hired as the assistant for a ten-person production team. She wants to organize her team's information, but she is only familiar with Microsoft Word. Josephine wants to include each team member's name, title, e-mail address, and work extension. The best way for Josephine to organize her data in Microsoft Word would be to use ____.

a table

Case 1-2Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. Kade's dad suggests that Kade also check the cover letter for grammatical errors. Kade notices that he typed "you're" instead of "your," so the word is underlined with _______.

a wavy blue line

When you copy a selection of cells using drag and drop, which appears before you release the mouse button

an outline of the new location of the selected range

The characters +, -, *, and / are examples of ____.

arithmetic operators

Case 2-2Charlotte has just taken a job at a local publishing house. She has a lot of tasks to accomplish today, but her first task is to write letters to several of the authors and send out contracts. Charlotte wants to make a good impression on her boss, so she wants to make sure all her correspondence with the authors is professional and looks formal. In her letter, Charlotte asks each author to return a copy of their signed agreement. She needs to emphasize parts of her letter, but she wants to make sure everyone reads this particular sentence. She should apply ____.

character-level formatting

Case 1-2Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. In his work on the letter, Kade inserts a sentence, then changes his mind and deletes the sentence using the Cut command. He then changes his mind again and _______.

clicks the Undo button to undo the delete

To update a bibliography field that is not contained in a ____, right-click the bibliography, and then click Update Field on the Shortcut menu.

content control

A(n) _______ tab appears on the ribbon only when an object is selected.

contextual

You typed a paragraph on page 2 that should appear on page 27. To move that paragraph to the correct place in your document, you should use ____.

cut and paste

To hide the shaded space between pages, ____.

double-click the shaded space

To clear a tab stop, ____.

drag it off the ruler

To accept an AutoComplete suggestion, press the _______ key.

enter

An Excel formula always begins with a(n) ____

equals sign

A _______ is a set of characters that uses the same typeface

font

A(n) ____ should not be included on a cover page.

footer

Cover Page styles in the Cover Page gallery match the preformatted ____ styles in Word, making it easier to create a coherent style by choosing matching names

header

To add a blank table to a page, use the Table button on the ____ tab.

insert

When you position the pointer over the selected text, it changes to a ____.

left-facing arrow

Aligning a graphic relative to the _______ is usually the best choice because it ensures that you don't accidentally position a graphic outside the page margins.

margin

To delete a drop cap, click the paragraph that contains it, open the Drop cap dialog box, and then click _______.

none

Case 3-2Monica is working on a report for her art history class. She is using Microsoft Word for her report so that she can incorporate tables, text, and graphics into one document, but needs suggestions on fine-tuning her report. Monica needs to add a header to her report. She wants to have a different heading for the first page. Monica needs to select Different First Page check box in the Options group ____

on the HEADER & FOOTER TOOLS DESIGN tab

Case 2-1Thomas is writing a report for his advertising class in which he analyzes corporate campaigns and ad slogans. To compile his report, he needs to copy several quotes and portions of articles from other documents, and needs to pay special attention to formatting. Thomas needs to copy quotes from several of his research documents. To keep track of what text he has copied, Thomas should ____.

open the Clipboard task pane

To create a numbered list, you use the Numbering button in the ____ group.

paragraph

Case 1-1Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. The last part of the form asks applicants to create a bulleted list of their accomplishments. Gabrielle does not like the amount of space the program inserts between the bulleted items each time she presses Enter, so she adjusts the _______.

paragraph spacing

Case 4-1Santo is creating a company newsletter for his architectural firm. He has solicited contributions from his colleagues on their current projects, and several people have provided photos of homes and businesses they are currently remodeling. Santo is about to begin compiling all the information using desktop publishing in Microsoft Word. Santo wants to create a WordArt object to include the company's logo, "Creative Interior Design" To do this, Santo's first step is to _______.

select the text to be transformed into a WordArt object

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

shortcuts

If you type :), then the symbol or character inserted will be _______.

smiley

A(n) ____ is a location on the horizontal ruler where the insertion point moves when you press the Tab key

tab stop

Word's AutoCorrect feature automatically converts some standard characters into more polished-looking characters, such as the em dash or copyright symbol, known as _______.

typographic characters

Case 2-1Thomas is writing a report for his advertising class in which he analyzes corporate campaigns and ad slogans. To compile his report, he needs to copy several quotes and portions of articles from other documents, and needs to pay special attention to formatting. Thomas has typed 20 pages of his report and realizes that he typed Niko and should have typed Nike. The most efficient way for him to fix this error is to

use Find and Replace

Case 4-1Santo is creating a company newsletter for his architectural firm. He has solicited contributions from his colleagues on their current projects, and several people have provided photos of homes and businesses they are currently remodeling. Santo is about to begin compiling all the information using desktop publishing in Microsoft Word. Santo has named the newsletter "Skyline" but wants to make sure the newsletter's name stands out. Santo should _______.

use WordArt to create a graphic effect

When you press the Tab key in the last cell in the table, ____.

you add a new row to the bottom of the table