Microcomputer Applications 1 Final

¡Supera tus tareas y exámenes ahora con Quizwiz!

`To indent the first of every paragraph in a document, do which of the following? A. Creat a right tab stop B. Create a first line indent C. Create a hanging indent D. Create a left tab stop

B. Create a first line indent

When you double-click a cell's right column border, which of the following occurs?

AutoFit resizes the column to the widest cell entry.

WHat feature inserts a function that totals the cells above or to the left of the selected cell?

AutoSum button

Cameron needs to insert a citation, but he does not have the source information. Which of the following should he do? A. Insert an endnote B. Add a new citation placeholder C. Insert a footnote D. Add an existing citation

B. Add new citation placeholder

You cannot change a shape to a different shape.

False

To change the color of cell content, you use the _____ color list arrow.

Font

To copy a cell's formatting to another cell, which of the following can you use?

Former Painter

To format the cell value 44.5, you can use the Increase Decimal button.

True

To have a picture appear behind text, change the text wrapping of the picture. Treu or False

True

You can change a slide's layout after the slide is created.

True

You can change the theme after you create a presentation.

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

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.

True

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

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.

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 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. True or False

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. True or False

False

To insert a picture from your desktop, click the Online Pictures button. True or 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

To move the text, press and hold the right mouse button over selected test, then drag the text to the desired location. True or False

False

To quickly change the colors, fonts, and effects in a document, change the document style. True or False

False

To remove the spelling change indicator under a word, you must accept the suggested change. True or False

False

To rotate a picture 90 degrees, flip the picture horizontally. True or False

False

To view a worksheet without headers, marigins, 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. True or False

False

Underscore text to have a line appear beneath the text. True or False

False

Use ALT to select multiple nonadjacent headings in a document. True or 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.

False

When you close a document, your work is automatically saved. True or False

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

When you recolor a picture, you use the Paintbrush tool to add color to parts of the picture. True or False

False

Widows and orphans refer to hyphenated words in a document. True and False

False

You can format an object even when it is not selected.

False

You can hide a portion of a picture by cutting it.

False

You cannot change the levels of items in a list in a content placeholder.

False

You cannot print more than one slide on a piece of paper.

False

A slide in Casey's presentation contains three shapes that should be treated as one shape. Which one of the following commands should Casey use to combine the three shapes so they can be resized or moved together?

Group

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

Ignore All

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.

If you want to change the color of the border around a shape, which of the following do you change?

Outline

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Page Break Preview

To print your worksheet on a piece of paper larger than 8-1/2 x11", which Excel tab would you use?

Page Layout

Which type of chart shows values as a percentage of the whole?

Pie

To which of the following chart types can you not add axis titles?

Pie chart

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 combine two or more shapes to create an entirely new shape, which of the following commands would you use to do this?

Merge

To combine multiple cells into one combined cell, which of the following do you use?

Merge and Center button

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

How would you proportionally resize a text box that contains WordArt?

Press and hold SHIFT as you drag a corner sizing handle.

Id 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

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?

Style

SmartArt consists of the graphic and which of the following?

Text pane

Which of the following statements is true about COUNT functions?

The COUNT function returns the number of cells in a range numeric data

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

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)

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 or 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 or False

True

To specify how a shape interacts with the text around it, modify the text wrapping of the shape. True or False

True

Use Print Layout view to adjust the document margins. True or False

True

When the ruler is displayed, the location of the pointer is shown on the ruler by a dotted red line.

True

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

True

When you use the Redo command, you red the action that was just completed. True or False

True

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

True

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

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

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

hidden

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

hide

You should carefully edit notes you add to a slide because your audience will be able to see them.

False

when you run the spell checker in a workbook, excel automatically checks the spelling in all worksheets at once

False

Which of the following tabs lets you set worksheet print options?

File

On which tab and button are document properties located for editing?

File tab, Info Button

If you want a specific date to appear everytime 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

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

Flash fill

If you want to create a mirror image of a shape to the left or right of the shape, you duplicate or copy and paste the shape, and then use which of the following commands?

Flip Horizontal

To format a picture with preset formatting options, which of the following should you change?

The picture style

Which slide usually does not require the slide number, date, and footer text on it?

Title slide

You must select the text or the text box before you change the font.

True

If you want to change the thickness of a shape outline, which of the following do you need to change?

Weight

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

two

To help you easily identify sheets in a workbook, you can add______ to the sheet tab.

Color

It's impossible to resize a shape to exact dimensions.

False

Which key or keys do you press to indent a first-level item in a list so it becomes a second-level item?

TAB

Click Save As in the File tab to save a document with a new name. True or False

True

To change the background color of a cell, you use the Background color button.

False

To change the name of a worksheet, you rename the____________.

sheet tab

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

=COUNT(B1:B20)

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

=COUNTA(B1:B20)

Which of the following is true about adding cell boarders?

A cell border extends the width of the cellq

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

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 has the Two Content layout applied.

What should you add to describe the data in a chart?

A title

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? A. Add appropriate alt text to each of the pictures B. Add an artistic effect to each of the pictures C. Reset the pictures D. Set the text wrapping to In Front of Text

A. Add appropriate alt text to each of the pictures

To quickly change the shading, borders, and font colors of a table, which of the following should be done? A. Apply a Table Style B. Apply Theme Effects C. Insert a Watermark D. Apply Text Effects

A. Apply a Table Style

Sarah wants to quickly apply a Picture Border and Picture Effect to a picture. Which of the following can she use to do this? A. Apply the Picture Style B. Apply an Artistic Effects C. Apply a Correction D. Change the Theme Effects

A. Apply the Picture Style

To clear all formatting from a picture, which of the following should be done? A. Click Reset Picture B. Select the picture and press ESC C. Select the picture and press DELETE D. Click Corrections and select the desired option

A. Click Reset Picture

To create a horizontal mirror reflection of a picture, which of the following should be done? A. Click Rotate and select Flip Horizontal B. Click Align and select Distribute Horizontally C. Click Rotate and select Flip Horizontal

A. Click Rotate and select Flip Horizontal

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? A. Click the Insert Citation button and select the desired source B. Click the Insert Citation button and select ADD New Placeholder C. Click the Insert Citation button and select ADD New Source

A. Click the Insert Citation button and select the desired source

To create a hierarchy diagram, which of the following should be done? A. Click the SmartArt button and select the desired option B. Click the Shapes button and select the desired option C. Click the Chart button and select the desired option D. Click the Table button and select desired option

A. 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? A. Click the Themes button and select the desired option B. Click the Watermark button and select the desired option C. Click the Page Borders button and select the desired option D. Select a Style from the Styles group

A. Click the Themes button and select the desired option

To have text appear at the bottom of each page in a document, do which of the following? A. Double-click the footer region of the page and enter the desired text B. Insert an endnote with the desired text C. Double-click the header region of the page and enter the desired text D. Manually enter the desired text at the bottom of each page

A. Double-click the footer region of the page and enter the desired text

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance. He should use which of the following paste options? A. Keep Source Formatting B. Use Destination Theme C. Keep Text Only

A. Keep Source Formatting

To set an item in a bulleted list at a higher level, which of the following should you do? A. Press the Increase Indent button on the Paragraph group of the Home tab B. Add seven spaces to the beginning of the list item C. Drag the appropriate Left Indent tab to the desired position D. Press the Decrease Indent button on the Paragraph group of the Home tab

A. Press the Increase Indent button on the Paragraph group of the Home tab

To remove space after a paragraph, do which of the following? A. Press the Line and Paragraph Spacing button and then select Remove Space After Paragraph B. Delete the last line of text in the paragraph C. Press the Decrease Indent button D. Press the Justify button

A. Press the Line and Paragraph Spacing button and then select Remove Space After Paragraph

Rihanna needs to read through a document without distractions. Which view should she use? A. Read Mode B. Web Layout C. Print Layout D. Outline View

A. Read Mode

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? A. Select the text, press the Change Case button in the Font group of the home tab, and then select UPPERCASE B. Select the text, then press the Bold button in the Font group of the Home tab. Select the text, then press the Bold button in the Font group of the Home tab C. Delete the text and retype it using all uppercase letters D. Change the font to a font that only has uppercase letters

A. Select the text, press the Change Case button in the Font group of the home tab, and then select UPPERCASE

To select a paragraph, do which of the following? A. Triple click the desired paragraph B. Place the insertion point within the paragraph and press CTRL+A C. Place the insertion point within the paragraph and press ALT+A D. Double click the desired paragraph

A. Triple click the desired paragraph

Which of the following do you use to change the document margins? A. Use the Margins button in the Page Setup group of the Layout tab to select the desired option B. Use the Columns button in the Page Setup group of the Layout tab to select the desired option C. Use the Orientation button in the Page Setup group of the Layout tab to select the desired option D. Use the Size button in the Page Setup group of the Layout tab to select the desired option

A. Use the Margins button in the Page Setup group of the Layout tab to select the desired option

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? A. changing the theme colors B. using the Page Color button C. pressing the Theme Effects button D. selecting the style from the Styles group

A. changing the theme colors

What are user-defined details about a file that describe its content and origin called? A. document properties B. formatting marks C. comments D. references

A. document properties

To change the size of a picture without distorting it, which of the following should you do? A. drag a corner sizing handle B. drag the bottom sizing handle C. drag the top sizing handle D. drag the side sizing handle

A. drag a corner sizing handle

To align currency symbols and decimal points in a column of numbers, you can apply the ______ number format.

Accounting

To add a Glow effect to a picture, which of the following do you do? A. Apply a Picture Border B. Apply a Picture Effect C. Change the Picture Layout D. Apply an Artistic Effect

B. Apply a Picture Effect

Kayla needs a paragraph border to have a shadow appearance. She should do which of the following? A. Click the Theme Effects button and select the desired option B. Change the type of paragraph border in the Borders and Shading dialogue box C. Insert a 3D Model D. Click the Text Effects and Typography button and select the desired option

B. 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? A. Check the document for accessibility by clicking the Check Accessibility button B. Check the document for spelling and grammar errors by clicking the Spelling & Grammar button C. Use smart Lookup by clicking the Smart Lookup button D. Check the document for compatibility by clicking the Check Compatibility button

B. 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? A. Use the Source Manager to edit the sources as needed B. Check to ensure the bibliography style in MLA in the Citations & Bibliography group of the Reference tab C. Ensure the document meets the style requirements by Inspecting the document

B. Check to ensure the bibliography style in MLA in the Citations & Bibliography group of the Reference tab

Tiana needs each line after the first line in a paragraph to be indented. She should do which of the following? A. Create a left tab stop B. Create a hanging indent C. Create a first line indent D. Create a Right tab stop

B. Create a hanging indent

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? A. Enable the don't hyphenate option B. Enable the widow and orphan control option C. Enable the keep with next option D. Enable the page break before option

B. Enable the widow and orphan option

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? A. Enter the desired message in the header of the document B. Enter the desired message in a comment attached to the paragraph C. Enter the desired message as a document property D. Enter the desired message in a text box placed next to the paragraph

B. Enter the desired message in a comment attached to the paragraph

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? A. Enter the parenthetical reference manually B. Insert a citation C. Insert a footnote with the source information D. Insert an endnote with the source information

B. Insert a citation

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? A. Multilevel bulleted list B. Numbered list C. Billeted list

B. Numbered list

Which of the following methods is the best way to find a word in a document? A. Enter the word in the Go To box, then press Enter B. Press CTRL+F and enter the word in the search box of the Navigation pane C. Scroll through the document manually looking for the word

B. Press CTRL+F and enter the word in the search box of the Navigation pane

Brian needs to view the paragraph marks in a document. Which of the following should he do? A. Enter Read Mode B. Select the Show/Hide (paragraph symbol) button C. Enter Web Layout view D. Click the checkbox to show the gridlines

B. Select the Show/Hide (paragraph symbol) button

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first? A. Select a column in the table B. Select the Table C. Select the row in the table

B. Select the Table

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? A. Select the first sentence, then press and hold ALT while selecting the second sentence B. Select the first sentence, then press and hold CTRL while selecting the second sentence C. Select the first sentence, then press and hold SHIFT+ALT while selecting the second sentence D. Select the first sentence, then press and hold SHIFT while selecting the second sentence

B. 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? A. Search for text with the Heading 1 style based on formatting, and then change the font color of each instance to green B. Select the green Heading 1 header, the update the Heading 1 style to match the selection C. Manually locate all headers with the Heading 1 style in the document and change the font color to green

B. Select the green Heading 1 header, the update the Heading 1 style to match the selection

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? A. Square B. Top and Bottom C. Through D. Tight

B. Top and Bottom

Austin needs to emphasize text by having color appear behind it. Which of the following tools should he use? A. the Theme Effects button B. the Text Highlight Color button C. the Colors button D. the Font Color button

B. the Text Highlight Color Button

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

A picture on the title in Jacob's presentation is too large for the space. To change the 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.

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 ensure that a document can be read by people with visual impairment, which of the following should be done? A. Inspect the document B. Check the document for compatibility C. Check the document for accessibility D. Check the document for spelling and grammar errors

C. Check the document for accessibility

Cameron needs to brighten and increase the contrast of a picture. He should do which of the following? A. Click the Color button and select the desired option B. Click the Change Picture button and select the desired option C. Click the Corrections button and select the desired option D. Click the Artistic Effects button and select the desired option

C. Click the Corrections button and select the desired option

Which of the following do you do to better view smaill, difficult-to-read text in a document? A. Select One Page in the window group of the View tab to enlarge the document B. Use the navigation pane to enlarge the document C. Drag the Zoom slider to enlarge the document D. Hold SHIFT and use the scroll wheel to enlarge the document

C. Drag the Zoom slider to enlarge the document

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? A. Click the Align button and select the desired option B. Click the Position button and select the desired option C. Enter the height in the Shape Height text box and enter the width in the Shape Width text box D. Drag one of the sizing handles

C. Enter the height in the Shape Height text box and enter the width in the Shape Width text box

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?

C. Handouts

Jada needs to create a not at the bottom of a page with a reference to the note in the text. She should do which of the following? A. Insert an endnote B. Insert a comment C. Insert a footnote D. Insert a header

C. Insert a footnote

To start entering text on a new page, do which of the following? A. Insert a column break B. Insert a continuous section break C. Insert a page break D. Insert a line break

C. Insert a page break

Which of the following options allows you to align text so that it is fully flush with both margins? A. Align Left B. Align Right C. Justify D. Center

C. Justify

Joshua needs stylized text in his document to be normal, unformatted text. He should do which of the following? A. Apply the Strong style B. Press the Format Painter button C. Press the Clear All Formatting button D. Apply the Heading 1 style`

C. Press the Clear All Formatting button

Steve wants a paragraph of text to be surrounded with a line and filled with a color. Which of the following should be used to achieve this? A. Shapes and Color commands B. Box and Fill commands C. Shading and Borders commands D. Highlighting and Line commands

C. Shading and Borders commands

Kennedy needs to rotate a picture by 45 degrees. She should do which of the following? A. Flip the picture horizontally B. Flip the picture vertically C. Specify the amount of rotation in the Layout dialogue box

C. Specify the amount of rotation in the Layout dialogue box

Which of the following layouts is best for the slide that contains the title of the presentation? A. Text and Content B. Blank C. Title Slide D. Title and Content

C. Title Slide

To ensure your bibliography accurately reflects the sources in your source list, do which of the following? A. Inspect the document B. Check the document for accessibility C. Update the bibliography D. Protect the document

C. Update the bibliography

Joanne needs each page in her document to be numbered. She should do which of the following? A. Use the Insert Footnote button B. Manually enter the page number at the bottom of each page C. Use the Page Number button D. Use the Cross-reference button

C. Use the Page Number button

In APA format, a works cited list is called which of the following? A. works cited B. references list C. bibliography

C. bibliography

Which of the following do you do to select text? A. press CTRL+T B. press CTRL+S C. click and drag across the desired text D. right-click and drag across the desired text

C. click and drag across the desired text

To select non adjacent cells or ranges on a worksheet, you can press and hold________ while selecting each one.

CTRL

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

Calculate Now

To accept a suggested spelling for that instance only, which of the following would you click?

Change

To return cell contents to its default font and style, you can use the ________ command.

Clear Formats

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

Click Margins in the Page Setup group on the Page Layout tab and then click on Normal

How do you change the layout slide?

Click the Layout button on the Home tab, and then click the layout you want to use.

Which of the following is the temporary Windows storage area that holds selections you copy and cut?

Clipboard

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.

To ensure a document with a table can be interpreted by people with vision impairment, make sure to do which of the following? A. Convert the table to text B. Sort the data in the table C. Apply a table style to the table D. Add alt text to the table

D. Add alt text to the table

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? A. Manually enter ">" character at the beginning of each item on the list B. Apply multilevel numbering to the list C. Apply numbering to the list D. Apply bullets to the list

D. Apply bullets to the list

Aniyah needs to insert the date and time in her document. She should do which of the following? A. Click the Table button and select the desired option B. Click the Link button and select the desired option C. Click the Cross-reference button D. Click the Insert Date and Time button and select the desired option

D. Click the Insert Date and Time button and select the desired option

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? A. Click Align and select Align Middle B. Click the Wrap Text button and select Top and Bottom C. Click Align and select Align Center D. Click the Position button and select Position in Middle Center with Square Text Wrapping

D. 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? A. Click the Wrap Text button and select Square B. Click the Align button and select Distribute Vertically C.Click the Align button and select Top D. Click the Position button and select Position in Top and Center with Square Text Wrapping

D. Click the Position button and select Position in Top and Center with Square Text Wrapping

Jared needs more space between lines of text in a paragraph. Which of the following is the best method to use for this action? A. Enter the Indents and Spacing tab of the Paragraph dialogue box and increase the value of the text box labeled "After". B. Press ENTER at the end of each line to create a space between lines C. Drag the zoom slider to increase the line spacing D. Press the Line and Paragraph Spacing button in the Paragraph group on the Home tab, the select the desired amount of spacing.

D. Press the Line and Paragraph Spacing button in the Paragraph group on the Home tab, the select the desired amount of spacing.

Joe accidentally deleted a paragraph. To restore the paragraph, he needs to do which of the following? A. Redo the action B. Repeat the action C. Reenter the text manually D. Undo the action

D. Undo the action

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? A. Use the Clipboard B. Use the Tell Me box C. Use Smart Lookup D. Use the Formatting Printer

D. Use the Formatting Printer

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

Which of the following lets you edit the contents of a cell?

Double-click the cell or click in the formula bar.

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

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

Edit the conditional formatting rule

The view that displays slides as thumbnails arranged in a grid and in which you can rearrange slides is called Reading view.

False

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

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

A negative indent causes lines of text to be indented more than the first line in a paragraph. True or False

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.

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

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

If you add a picture to the slide background, you cannot change its transparency.

False

If you don't like the speed of a transition that you applied, you cannot change it.

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

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.

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.

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 moniter.

False

In formulas, calculations in square brackets are calculated first.

False

It 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

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 or False

False

John needs to start a page in a document. The best way for him to achieve this is by pressing ENTER until new page is created. True of False

False

Karen wants a reference to appear at the bottom of a page. To do so, she should insert an endnote. True of False

False

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.

False

One way you can rotate a shape is to drag its adjustment handle.

False

Text that you delete by pressing DELETE or BACKSPACE is placed on the Clipboard.

False

The Comma Style format adds a comma and a dollar sign to a cell value.

False

To have Excel enter the lowest price from a range of prices, which of the following would you use?

MIN function

Where can you see a brief description of a selected function?

Insert Function dialog box

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 type of chart shows trends over a continuous period of time?

Line

In the formula =A8*A$1, which of the following describes A8?

Relative cell reference

To select more than one object at a time on a slide, which key do you press while you click the objects?

SHIFT

Which key or keys do you press to change a second-level item in a list to a first-level item?

SHIFT+TAB

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

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

When you drag a photo on a slide, what appears to help you position it?

Smart Guides

Which of the following can you apply to change the way a SmartArt graphic looks

SmartArt Style

Currency is an example of a number format.

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 or False

True

Every slide in a PowerPoint presentation has a background, the area behind the text and graphics.

True

If you apply formatting to a text box, you can set that formatting to be the default for new boxes that you create in the presentation.

True

If you don't change the default transition, each slide disappears and the next slide immediately appears.

True

In order to format all the text in a text box at the same time, you must select the text box first.

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. True or False

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.

True

One way to insert a picture on a slide is to click the Pictures button in a content placeholder. True of False

True

One way to make a list on a slide more interesting is to convert the list to a SmartArt graphic.

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 and 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. True or False

True

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

True

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

True

To change several format attributes of a shape at the same time, you can apply a shape style.

True

To copy formatting from on section of text to another, use the format painter. True or False

True

To display another slide in Normal view, you can click its thumbnail in the pane on the left.

True

To ensure that the edges of several pictures line up, align the pictures. True or False

True

To print a worksheet, you begin by going to backstage view.

True

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.

True

To right-justify text at a tab stop, change the tab stop alignment options. True or False

True

When you underline cell content, you are using _____.

a font style

In the formula=SUM(A6:A9), which of the following best describes A6?

argument

To format a range so that all values greater than $500 appear red, which of the following can you use?

conditional formatting


Conjuntos de estudio relacionados

Ch 15 Assembly Language and Related Topics

View Set

Executive Branch Structure: President, cabinet, executive departments, the three agencies

View Set