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