Microapplications final
Maria wants to change a shape with text so that it faces left instead of right, so she rotated the shape so that the text stays right-side up. True False
false
One way you can rotate a shape is to drag its adjustment handle. True False
false
Text that you delete by pressing DELETE or BACKSPACE is placed on the False True
false
The Comma Style format adds a comma and a dollar sign to a cell value.
false
The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.
false
The view that displays slides as thumbnails arranged in a grid and in which you can rearrange slides is called Reading view. False True
false
To combine multiple cells into one and center its content, you change the cells' style.
false
To find a word in a document, use the Smart Lookup feature. False True
false
To find the largest value in a cell range, use the MIN function.
false
To find the number of words in a document, press the Language button. False True
false
To insert a picture from your desktop, click the Online Pictures button. True False
false
To insert slides from another presentation into a presentation, click the New Slide list arrow in the Slides group, then click Insert Slides. False True
false
To move text, press and hold the right mouse button over selected text, then drag the text to the desired location. True False
false
To quickly change the colors, fonts, and effects in a document, change the document style. True False
false
To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.
false
To remove the spelling change indicator under a word, you must accept the suggested change. True False
false
To rotate a picture 90 degrees, flip the picture horizontally. True False
false
To view a worksheet without headers, margins, and rulers, use Page Layout view.
false
Tom took a photo using his webcam and saved it to his desktop. To insert the file in a word document, he can use the Online Pictures button. t or f
false
Underscore text to have a line appear beneath the text. True False
false
Use ALT to select multiple nonadjacent headings in a document. True False
false
When the insertion point is at the beginning of a new line in a content placeholder, you can press SHIFT+TAB to indent the item. True False
false
When you close a document, your work is automatically saved. False True
false
When you copy and paste a formula to a new location, the formula's relative references do not change.
false
When you enter a value in a worksheet cell, it is automatically left-aligned.
false
When you insert TextArt, you can change its fill, outline, and shape, and you can apply special effects to it. False True
false
When you recolor a picture, you use the Paintbrush tool to add color to parts of the picture. True False
false
Widows and orphans refer to hyphenated words in a document. True False
false
You can hide a portion of a picture you don't want to be seen by cutting it. True False
false
You cannot change a shape to a different shape. True False
false
You cannot change the levels of items in a list in a content placeholder. True False
false
You cannot print more than one slide on a piece of paper. True False
false
You should carefully edit notes you add to a slide because your audience will be able to see them. False True
false
t is not necessary to look over a presentation for contextual errors if you use the Spelling command to check the spelling in a presentation. False True
false
Which of the following tabs lets you set worksheet print options?
file
If you want to change text in a text box by changing the text fill and outline and the shape of the text, which of the following should you change it to?
wordart
On which tab and button are document properties located for editing?
File tab, Info Button
Which key or keys do you press to indent a first-level item in a list so it becomes a second-level item?
TAB
If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?
The Undo button on the Quick Access toolbar
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
The formula =SUM(B6:B10)
If you want a specific date to appear every time you open a presentation rather than updating to the current date, which of the following options do you need to select when you add the date to the slides?
fixed
If you want to create a mirror image of a shape to the left or right of the shape, you should duplicate or copy and paste the shape, and then use which of the following commands?
flip horizontal
A _______ refers to a collection of characters with a similar, specific design.
font
Which of the following is a built-in formula that helps you perform complex calculations?
function
When you drag a photo on a slide, what appears to help you position it?
gridlines
A slide in Casey's presentation contains three shapes that should be treated as one shape. Which of the following commands should Casey use to combine the three shapes so they can be resized or moved together?
group
How would you proportionally resize a text box that contains WordArt?
Type a new value in the Shape Height box on the Drawing Tools Format tab.
Which of the following do you use to change the document margins?
Use the Margins button in the Page Setup group of the Layout tab to select the desired option.
Which type of chart shows trends over a continuous period of time?
XY (scatter)
When you underline cell content, you are using _____.
a font style
If the cell in the last row and the last column in a table on a slide is selected, what happens if you press TAB?
a new row is created below the last row in the table
What should you add to describe the data in a chart?
a title
To format a picture with preset formatting options, which of the following should you change?
the picture style
To specify how a shape interacts with the text around it, modify the text wrapping of the shape. True False
true
Use Print Layout view to adjust the document margins. False True
true
When the ruler is displayed, the location of the pointer is shown on the ruler by a dotted red line. True False
true
When you use the Redo command, you redo the action that was just completed. True False
true
You can change a slide's layout after the slide is created. True False
true
You can change the theme after you create a presentation. True False
true
You can edit cell contents in the Formula bar or in the cell itself.
true
You can insert columns and rows into an existing table. True False
true
You can move a chart to a new position on a slide in the same manner that you move any other object on a slide. False True
true
You must select the text or the text box before you change the font. False True
true
Joe accidentally deleted a paragraph. To restore the paragraph, he needs to do which of the following?
undo the action
To ensure your bibliography accurately reflects the sources in your source list, do which of the following?
update the bibliography
Jaylen needs a shape in her document to have the same formatting as another shape in her document. She should do which of the following?
use the formatting painter
Joanne needs each page in her document to be numbered. She should do which of the following?
use the page number button
If you want to change the thickness of a shape outline, which of the following do you need to change?
weight
If the current slide has the Two Content layout applied, what happens when you click the New Slide button on the Home tab?
A new slide is created with the Two Content layout applied.
Brian needs to view the paragraph marks in a document. Which of the following should he do?
Select the Show/Hide ¶ button.
Jasmine needs to select the first sentence of a paragraph and the last sentence of a paragraph simultaneously. The text is nonadjacent. Which of the following should she do?
Select the first sentence, then press and hold CTRL while selecting the second sentence.
Jenna changed the font color of a header with the Heading 1 style to green. She wants all headers with the Heading 1 style in the document to be green. Which of the following is the best way to achieve this?
Select the green Heading 1 header, then update the Heading 1 style to match the selection.
Susan needs all the text in a title to be upper case. Which of the following is the best way to capitalize all the text in the title?
Select the text, press the Change Case button in the Font group of the Home tab, and then select UPPERCASE.
Kennedy needs to rotate a picture by 45 degrees. She should do which of the following?
Specify the amount of rotation in the Layout dialogue box.
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
Change the page orientation to landscape.
Kayla needs a paragraph border to have a shadow appearance. She should do which of the following?
Change the type of paragraph border in the Borders and Shading dialogue box.
To ensure a document is free of typos, always do which of the following before publishing the document.
Check the document for spelling and grammar errors by clicking the Spelling & Grammar button.
Jasmine is working on a research paper that needs to be in MLA format. To ensure her bibliography is formatted properly, she should do which of the following?
Check to ensure the bibliography style is MLA in the Citations & Bibliography group of the References tab.
To clear all formatting from a picture, which of the following should be done?
Click Reset Picture.
To create a horizontal mirror reflection of a picture, which of the following should be done?
Click Rotate and select Flip Horizontal.
Cameron needs to brighten and increase the contrast of a picture. He should do which of the following?
Click the Corrections button and select the desired option.
Ben has created a source for a quotation in the citation manager. To insert a citation using this source, he should do which of the following?
Click the Insert Citation button and select the desired source
Aniyah needs to insert the date and time in her document. She should do which of the following?
Click the Insert Date and Time button and select the desired option.
How do you change the layout of a slide?
Click the Layout button on the Home tab, and then click the layout you want to use.
Hannah needs a picture to be positioned in the middle and center of a page. After applying Square text wrapping to the picture, she should do which of the following?
Click the Position button and select Position in Middle Center with Square Text Wrapping.
To have a shape appear at the top and center of a page, which of the following should be done?
Click the Position button and select Position in Top and Center with Square Text Wrapping.
To create a hierarchy diagram, which of the following should be done?
Click the SmartArt button and select the desired option.
To quickly change the colors, fonts, and effects in a document, which of the following should be done?
Click the Themes button and select the desired option.
Karen wants a reference to appear at the bottom of a page. To do so, she should insert an endnote. True False
false
Which of the following lets you edit the contents of a cell?
Double-click the cell or click in the formula bar.
To have text appear at the bottom of each page in a document, do which of the following?
Double-click the footer region of the page and enter the desired text.
Which of the following do you do to better view small, difficult-to-read text in a document?
Drag the Zoom slider to enlarge the document.
To prevent the last line of a paragraph from being separated from the rest of the paragraph as a result of flowing onto another page, which of the following should be done?
Enable the don't hyphenate option.
Sydney needs to resize a picture so that it is exactly 2 inches tall and 3 inches wide. She should do which of the following?
Enter the height in the Shape Height text box and enter the width in the Shape Width text box.
In APA format, a works cited list is called which of the following?
bibliography
In the formula =SUM(A6:A9), which of the following best describes A6?
argument
Nathan is creating a document that needs to be accessible to people with visual impairment. He should do what to the pictures in the document?
Add appropriate alt text to each of the pictures.
A document contains a list of items that appear in no particular order. Which of the following is the best way to format the list?
Apply bullets to the list.
When you double-click a cell's right column border, which of the following occurs?
AutoFit resizes the column to the widest cell entry.
A picture on the title slide in Jacob's presentation is too large for the space. To change its size, he dragged the sizing handle on the right side of the picture. Now the picture looks distorted. What went wrong?
Because he dragged a side sizing handle instead of a corner sizing handle, the image changed in one direction but not the other.
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MIN function
To combine multiple cells into one combined cell, which of the following do you use?
Merge and Center button
A slide in Olivia's presentation has the Title and Content layout applied. The bulleted list on the slide contains 14 items and each item is only one or two words, so Olivia thinks the Two Content layout would work better than the Title and Content layout. How does she change the slide's layout?
On the Home tab, click the Layout button, and then click Two Content.
How do you select everything on a slide except objects on the slide background?
On the Home tab, click the Select button, and then click Select All.
Which of the following methods is the best way to find a word in a document?
Press CTRL+F and enter the word in the search box of the Navigation pane.
Joshua needs stylized text in his document to be normal, unformatted text. He should do which of the following?
Press the Clear All Formatting button.
To set an item in a bulleted list at a higher level, which of the following should you do?
Press the Increase Indent button on the Paragraph group of the Home tab.
To remove space after a paragraph, do which of the following?
Press the Line and Paragraph Spacing button and then select Remove Space After Paragraph.
Jared needs more space between lines of text in a paragraph. Which of the following is the best method to use for this action?
Press the Line and Paragraph Spacing button in the Paragraph group on the Home tab, then select the desired amount of spacing.
Which key or keys do you press to change a second-level item in a list to a first-level item?
SHIFT+TAB
To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.
accounting
Cameron needs to insert a citation, but he does not have the source information. Which of the following should he do?
add a new citation placeholder
To ensure a document with a table can be interpreted by people with vision impairment, make sure to do which of the following?
add alt text to the table
To add a Glow effect to a picture, which of the following do you do?
apply a picture effect
Sarah wants to quickly apply a Picture Border and Picture Effect to a picture. Which of the following can she use to do this?
apply a picture style
To quickly change the shading, borders, and font colors of a table, which of the following should be done?
apply theme effects
If you want to shade every other row in a PowerPoint table, which of the following options do you select on the Table Tools Design tab?
banded rows
During a slide show, all of the items in a bulleted list appear on the slide at the same time with the entrance animation effect Fly In applied. If you want each item in the list to appear one at a time, which effect option should you choose?
by paragraph
To change the color of cell content, you use the ________ color list arrow.
cell
Ravi wants the title of the last slide in her presentation to stand out. Which of the following will help her do this?
change the color of the title text
Joanne wants a warmer color palette for the text in her document. Which of the following can she use to obtain a warmer color palette?
changing the theme colors
If you need to present numerical data on a slide, which of the following can you insert to show the data as a graphic?
chart
To ensure that a document can be read by people with visual impairment, which of the following should be done?
check the document for accessibility
To return cell contents to its default font and style, you can use the _____ command.
clear formats
Which of the following do you do to select text?
click and drag across the desired text
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
clipboard
Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?
color
Tiana needs each line after the first line in a paragraph to be indented. She should do which of the following?
create a first line indent
To indent the first line of every paragraph in a document, do which of the following?
create first line indent
Kyle inserted a photo of a dog on a slide. In the photo, the dog is on the right, and an empty street is on the left. What can Kyle do to remove the part of the photo that contains the empty street?
crop the photo
Which of the following commands found on the Align menu evenly space objects horizontally or vertically relative to each other or the slide?
distribute
Suppose a slide contains three ovals and you want to evenly space the ovals horizontally across the slide. After you select the three ovals, which command would you use to accomplish this?
distribute horizontally
What are user-defined details about a file that describe its content and origin called?
document properties
To change the size of a picture without distorting it, which of the following should you do?
drag a corner sizing handle
Raul needs to create a slide that will contain similar information and have the same format as Slide 3 in his presentation. Which of the following should he do?
duplicate slide 3
David ran his presentation in Slide Show view, and he thought the transition between each slide was too slow. Which of the following can he change to make the transitions faster?
duration
If you want to change the direction of an animation, which of the following buttons on the Animations tab do you click?
effect options
Animations in which one of the following categories cause objects to change while they are on a slide?
emphasis
Anna needs to leave a message for a collaborator about a specific paragraph in a document. Which of the following methods is the best way for her to communicate with her collaborator?
enter the desired message in a comment attached to the paragraph
During a slide show, Luis wants a picture to appear on one of his slides after the slide appears on the screen. Which type of animation should he use?
entrance
A layout is the effect that occurs when one slide leaves the screen and the next slide appears on the screen during a slide show. False True
false
A negative indent causes lines of text to be indented more than the first line in the paragraph. False True
false
A predesigned combination of formats, such as font size and color, is called a cell default.
false
An object containing text on a slide is called a text placeholder. True False
false
If a data label, title, or legend in a chart is difficult to read, you can format them as bold, but you cannot change the font size. False True
false
If the volume of a video on a slide is too loud, you cannot change it, so you need to make sure you adjust the volume on you speakers. False True
false
If you add a picture to the slide background, you cannot change its transparency. True False
false
If you don't like the speed of a transition that you applied, you cannot change it. False True
false
If you need to change the order in which animations on a slide occur, you must remove the animations, and then reapply them in the correct order. False True
false
If you want to change the manner in which a slide appears on the screen in place of the previous slide, you change the animation. True False
false
In Slide Show view, you can see the next slide, speaker notes, and a timer, while your audience sees the current slide fill the screen on another monitor. false True
false
It's impossible to resize a shape to exact dimensions. True False
false
Jasmine needs an indent at the beginning of each paragraph in her document. The best way for her to achieve this is by entering eight spaces at the beginning of each paragraph. True False
false
John needs to start a new page in a document. The best way for him to achieve this is by pressing ENTER until a new page is created. False True
false
Kiaan wants to give people who attend his presentation a printed copy of the slides. Instead of printing one slide on each piece of paper, he wants to print six slides on each piece of paper. Which setting should he select on the Print tab in Backstage view to do this?
handouts
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.
hide
To accept a suggested spelling for that instance only, which of the following would you click?
ignore once
Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source of a quotation. What is the best way for him to achieve this?
insert a citation
Jada needs to create a note at the bottom of a page with a reference to the note in the text. She should do which of the following?
insert a footnote
To start entering text on a new page, do which of the following?
insert a page break
Which of the following lets you search for a function or select one from a category?
insert function dialog box
Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?
insert pie or doughnut chart
In a complex formula, how does Excel determine which calculation to perform first?
it follows the order of operations
Which of the following options allows you to align text so that it is fully flush with both margins?
justify
If you want to combine two or more shapes to create an entirely new shape, which of the following commands would you use to do this?
merge
To print your worksheet at its actual size, which of the following would you select?
no scaling
If you want to add a note to a slide to remind you to mention a fact that is related to the slide, where do you place the note?
notes pane
Karen has a document with a list of five priorities on separate lines. The priorities are listed in order from most important to least important. Which of the following formatting options is best for this situation?
numbered list
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
one
If you want to change the color of the border around a shape, which of the following do you change?
outline
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
page layout
Which type of chart shows values as a percentage of the whole?
pie
When you have a second monitor attached to your computer, which view provides you with additional tools, such as a timer, to help you as you give your presentation?
presenter view
If you want to move a selected object on a slide a very small amount, which of the following will accomplish this?
press one of the arrow keys
To enter a range of text based on examples that are already in your worksheet, which of the following can you use?
quick analysis tools
Rihanna needs to read through a document without distractions. Which view should she use?
read mode
Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?
select the table
Steve wants a paragraph of text to be surrounded with a line and filled with a color. Which of the following should he use to achieve this?
shading and borders commands
If you want to apply a special effect to a shape, such as a beveled edge, a shadow, or a glow, which of the following buttons would you click on the Drawing Tools Format tab?
shape effects
Which button on the Drawing Tools Format tab would you click to change the color, weight, or style of the border of a shape?
shape outline
If a photo on a slide looks somewhat blurry and out of focus, what action can you take to fix this?
sharpen the photo
To select more than one object at a time on a slide, which key do you press while you click the objects?
shift
What are the small squares that appear in the corners and in the middle of the sides of a selected object's border called?
sizing handles
If you want to see many slide thumbnails on the screen at the same time, which view should you use?
slide sorter
Raj needs to rearrange the slides in his presentation. Which of the following views would be the best one to use?
slide sorter
Which view do you choose if you want to see a thumbnail of each slide in a presentation arranged in a grid?
slide sorter
Which of the following can you apply to change the way a SmartArt graphic looks?
smart art style
SmartArt consists of the graphic and which of the following?
text pane
Maura created a new, blank presentation and added a title to the title slide. She wants to save it before she continues working on it. What happens when she clicks the Save button?
the save as screen in backstage view appears
Austin needs to emphasize text by having color appear behind it. Which of the following tools should he use?
the text highlight color button
Which of the following layouts is best for the slide that contains the title of the presentation?
title slide
Which slide usually does not require the slide number, date, and footer text on it?
title slide
Makayla needs text to appear above and below a shape on the page. She should set the text wrapping of the shape to which of the following?
top and bottom
To select a paragraph, do which of the following?
triple click the desired paragraph
A citation is a parenthetical reference in the document text that gives credit to the source for a quotation or other information used in a document. True False
true
Alan is working on a draft document. He wants the document to have more white space. He can do this by changing the line spacing. True False
true
Click Save As in the File tab to save a document with a new name. True False
true
Dan is writing a novel that contains the nonsense word "Zerphron", which Word identifies as a spelling error. To prevent Word from identifying "Zerphron" as a misspelled word, he can select the Ignore All option. True False
true
Every slide in a PowerPoint presentation has a background, which is the area behind the text and graphic. True False
true
If you apply formatting to a text box, you can set that formatting to be the default for new text boxes that you create in the presentation. False True
true
If you don't change the default transition, each slide disappears and the next slide immediately appears. True False
true
If you want WordArt or other text in a text box to look like it has rotated on an axis, you should apply a Bevel effect. True False
true
In order to format all the text in a text box at the same time, you must select the text box first. True False
true
Jasmine needs a floating picture to be exactly 2" from the left side of the page and 4" from the top side of the page. She should specify an absolute position for the picture. False True
true
One reason to apply one transition to one slide and a different transition to all of the other slides in the presentation is to draw attention to the slide that has a different transition applied to it. False True
true
One way to insert a picture on a slide is to click the Pictures button in a content placeholder. True False
true
One way to make a list on a slide more interesting is to convert the list to a SmartArt graphic. False True
true
Shauna is preparing a newsletter that will be widely distributed. While checking the document for spelling and grammar errors, she notices that she consistently misspelled the word "disappear". She can correct all instances of the misspelled word by selecting Change All in the Spelling pane. True False
true
Sherri is trying to remember the word "tremendous". She knows "excellent" is similar to the word she's trying to remember. To help her remember, she can enter the word "excellent" in the document and then search for synonyms using the Thesaurus button in the Proofing group of the Review tab. False True
true
To change several format attributes of a shape at the same time, you can apply a shape style. False True
true
To copy formatting from one selection of text to another, use the Format Painter. True False
true
To display another slide in Normal view, you can click its thumbnail in the pane on the left. True False
true
To ensure that the edges of several pictures line up, align the pictures. False True
true
To have a picture appear behind text, change the text wrapping of the picture. True False
true
To print a worksheet, you begin by going to Backstage view.
true
To right-justify text at a tab stop, change the tab stop alignment options. False True
true