Deck 3: Working With Large Worksheets, Charting, and What-If Analysis

Question 1

To decrease the font size by two points,press CTRL+SHIFT+<.

Answer 1

True

Question 2

To copy formatting from one selection of text to another,use the Format Painter.

Answer 2

True

Question 3

Press CTRL+SHIFT+> to increase the font size by two points.

Answer 3

True

Question 4

Jeremiah needs to organize information in his document using rows and columns.He should insert a table.

Question 5

To resize the width of a picture without changing the height,resize the picture nonproportionally.

Question 6

To rotate a picture 90 degrees,flip the picture horizontally.

Question 7

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

Question 8

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

Question 9

To specify the location the cursor stops after the tab key is pressed,create a hanging indent.

Question 10

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

Question 11

To add a shadow to a picture,click the Picture Border button.

Question 12

Jasmine needs a double underline to appear beneath a word.She should change the underline style.

Question 13

To insert a text box,click the SmartArt button.

Question 14

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

Question 15

To add a line around a shape,add a shape outline.

Question 16

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

Question 17

To insert a picture from your desktop,click the Online Pictures button.

Question 18

Nathan needs more room to add another entry in a table.To do so,he should insert a row.

Question 19

To create a new page in a document,click the Multiple Pages button.

Question 20

Makayla needs to select the entire line of cells in a table going from left to right.She needs to select a column.

Question 21

Isaiah needs to insert a copyright symbol (©).He should do which of the following?

A) Insert a citation.
B) Insert a symbol from the Symbol gallery.
C) Insert a cross-reference.
D) Insert a footnote.

Question 22

Joshua needs stylized text in his document to be normal,unformatted text.He should do which of the following?

A) Press the Format Painter button.
B) Apply the Heading 1 style.
C) Press the Clear All Formatting button.
D) Apply the Strong style.

Question 23

Alexis needs the text after a tab character to be moved further to the right.She should do which of the following?

A) Move the appropriate tab stop to the right.
B) Remove the tab stop.
C) Insert space characters to move the text to the right.
D) Insert tab characters to move the text to the right.

Question 24

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

Question 25

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.

Question 26

Jeremiah has inserted a table and needs to fill it with data.After entering a value,he should do which of the following to advance the curser to the next cell in the table?

A) Press TAB.
B) Press ENTER.
C) Press ESC.
D) Press INSERT.

Question 27

Gabrielle opened a document that has a large number of tab stops in undesired locations.She wants the tab stops removed.She should do which of the following?

A) Remove all tab characters from the document.
B) Remove all paragraph characters from the document.
C) Insert new tab stops in the document.
D) Clear all tab stops from the document.

Question 28

Laila needs the pictures in her document to be distributed vertically.She should do which of the following?

A) Press the Position button and select the desired option.
B) Press the Align button and select the desired option.
C) Press the Wrap Text button and select the desired option.
D) Press the Corrections button and select the desired option.

Question 29

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) Insert a 3D Model.
C) Click the Text Effects and Typography button and select the desired option.
D) Change the type of paragraph border in the Borders and Shading dialogue box.

Question 30

Aniyah needs to insert the date and time in her document.She should do which of the following?

A) Click the Insert Date and Time button and select the desired option.
B) Click the Cross-reference button.
C) Click the Table button and select the desired option.
D) Click the Link button and select the desired option.

Question 31

Nevaeh needs a paragraph border to be very thick.He should do which of the following?

A) Change the width of the border in the Borders and Shading dialogue box.
B) Click the Theme Effects button and select the desired option.
C) Click the Text Effects and Typography button and select the desired option.
D) Click the Shapes button and insert a line.

Question 32

Alyssa needs a paragraph to have a dotted border.She should do which of the following?

A) Insert appropriate SmartArt.
B) Insert a table.
C) Apply a paragraph border and change the line style of the border.
D) Insert appropriate WordArt.

Question 33

Tiana wants a line to appear around a paragraph.She should do which of the following?

A) Add a paragraph border.
B) Add paragraph shading.
C) Apply a text effect.
D) Apply a character style.

Question 34

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.

Question 35

One of the pictures in Destiny's document is covered up by another picture.To make the obscured picture visible,she should do which of the following?

A) Set the text wrapping of the obscured picture to In Front of Text.
B) Set the text wrapping of the obscured picture to Behind Text.
C) Send the obscured picture to the back.
D) Bring the obscured picture to the front.

Question 36

Imani needs to duplicate a picture in her document.She should do which of the following?

A) Copy and paste the picture.
B) Rotate the picture.
C) Change the picture.
D) Reset the picture.

Question 37

Chloe notices that when she inserts a tab character,her insertion point moves to the right side of the page and the text she enters is right-justified.She does not want tab characters to behave this way.She should do which of the following?

A) Change the paragraph justification.
B) Remove the tab stop.
C) Remove the paragraph.
D) Change the paragraph spacing.

Question 38

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 Smart Lookup.
C) Use the Tell Me box.
D) Use the Formatting Painter.

Question 39

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 row in the table.
B) Select the table.
C) Select a column in the table.

Question 40

Sydney has created a table with two columns to store the name and address of clients.She needs to add additional information about phone numbers.She should do which of the following?

A) Add a column.
B) Add a row.
C) Create a new table.
D) Add comments to the table.

Question 41

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 Chart button and select the desired option.
C) Click the Shapes button and select the desired option.
D) Click the Table button and select the desired option.

Question 42

To have a shape appear at the top and center of a page,which of the following should be done?

A) Click the Position button and select Position in Top and Center with Square Text Wrapping.
B) Click the Wrap Text button and select Square.
C) Click the Align button and select Top.
D) Click the Align button and select Distribute Vertically.

Question 43

Imani needs to rearrange a picture in her document.The picture has Square text wrapping.She should do which of the following?

A) Click and drag the picture to the desired location.
B) CTRL+Click and drag the picture to the desired location.
C) CTRL+SHIFT+Click and drag the picture to the desired location.
D) CTRL+ALT+Click and drag the picture to the desired location.

Question 44

Alexandra wants text to appear within a circle shape in her document.She should do which of the following?

A) Select the shape and change the Text Wrapping to In Front of Text.
B) Hover the cursor over the shape and enter the desired text.
C) Select the shape and start typing the desired text.

Question 45

Jordan wants a warm color palette for his SmartArt.He should do which of the following?

A) Click the Change Colors button and select the desired option.
B) Click the Text Effects button and select the desired option.
C) Click the Shape Effects button and select the desired option.
D) Click the Change Shape button and select the desired option.

Question 46

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) Tight
C) Top and Bottom
D) Through

Question 47

Alexis needs to remove an entry going from left to right in a table.She first needs to do which of the following?

A) Select a row.
B) Select a column.
C) Select the table.
D) Select a cell.

Question 48

David needs an oval to appear in his document.He should do which of the following?

A) Click the Chart button and select the desired option.
B) Click the Shapes button and select the desired option.
C) Click the Table button and select the desired option.
D) Click the WordArt button and select the desired option.

Question 49

To quickly change the fill,outline,and effect of a shape,which of the following should be done?

A) Apply a Character Style.
B) Apply a Paragraph Style.
C) Apply a Theme Effect.
D) Apply a Shape Style.

Question 50

To quickly change the colors,fonts,and effects in a document,which of the following should be done?

A) Click the Watermark button and select the desired option.
B) Select a Style from the Styles group.
C) Click the Themes button and select the desired option.
D) Click the Page Borders button and select the desired option.

Question 51

To clear all formatting from a picture,which of the following should be done?

A) Click Reset Picture.
B) Select the picture and press DELETE.
C) Select the picture and press ESC.
D) Click Corrections and select the desired option.

Question 52

To resize a shape nonproportionally,which of the following should be done?

A) Click and drag the corner sizing handle.
B) Select the Lock aspect ratio check box and then enter values.
C) Click and drag a middle sizing handle.
D) ALT+SHIFT-Click and drag the corner sizing handle.

Question 53

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) Drag one of the sizing handles.
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) Click the Align button and select the desired option.

Question 54

To specify the exact dimensions of a shape,which of the following should be done?

A) Enter the height in the Shape Height text box and enter the width in the Shape Width text box.
B) Drag one of the sizing handles.
C) Click the Position button and select the desired option.
D) Click the Align button and select the desired option.

Question 55

To move an inline picture,which of the following should be done?

A) Click and drag the picture to the desired location.
B) CTRL+Click and drag the picture to the desired location.
C) ALT+Click and drag the picture to the desired location.
D) CTRL+SHIFT+Click and drag the picture to the desired location.

Question 56

Hailey wants to resize a picture using percentages of its original size.She should do which of the following?

A) Select the Lock aspect ratio check box before entering the percentages.
B) Select the Absolute option and then enter the percentages.
C) Clear the Lock aspect ratio check box and then use the Scale option.
D) Select the Relative option and then enter the percentages.

Question 57

To change the shading of a cell in a table,which of the following should be done first?

A) Select the table.
B) Select the desired column.
C) Select the desired row.
D) Select the desired cell.

Question 58

Tom clicked and dragged the rotation handle above a picture.This resulted in which of the following?

A) Flipped the shape vertically.
B) Flipped the shape horizontally.
C) Rotated the shape to an exact value.
D) Rotated the shape to an approximate value.

Question 59

Cameron needs to brighten and increase the contrast of a picture.He should do which of the following?

A) Click the Corrections button and select the desired option.
B) Click the Color button and select the desired option.
C) Click the Artistic Effects button and select the desired option.
D) Click the Change Picture button and select the desired option.

Question 60

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) Apply Text Effects.
D) Insert a Watermark.

Question 61

To create a cycle diagram in a document,which of the following should be done?

A) Click SmartArt and select the desired option.
B) Click Chart and select the desired option.
C) Click Shapes and select the desired option.
D) Click Table and select the desired option.

Question 62

To ensure a document with tables can be interpreted by people with vision impairment,make sure to add appropriate alt text to the tables in the document.

Question 63

Brianna needs the rows in a table to alternate colors.She should do which of the following?

A) Manually apply alternating fill colors to each row.
B) Select the table and apply a table style with banded rows.
C) Modify the table border style.
D) Click Distribute Rows.

Question 64

To recolor a picture with a green tint,which of the following should be done?

A) Click the Corrections button and select the desired option.
B) Click the Color button and select the desired option.
C) Click the Artistic Effects button and select the desired option.
D) Click the Change Picture button and select the desired option.

Question 65

To create a duplicate copy of a picture in a document,which of the following should be done? Select all that apply.

A) Select the picture,click Copy,then click Paste.
B) Select the picture,then click and drag the picture to the desired location.
C) Select the picture,click Cut,then click Paste.
D) Select the picture,then CTRL+click and drag the picture to the desired location.

Question 66

To enable a table to be interpreted by a screen reader,which of the following should be done?

A) Apply a table style to the table.
B) Sort the data in the table.
C) Convert the table to text.
D) Add alt text to the tables.

Question 67

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 Rotate and select Rotate Left 90°.
C) Click Align and select Distribute Horizontally.

Question 68

To right-align text using a tab character,which of the following should be done?

A) Click the Orientation button and select the desired option.
B) Create a tab stop and set the alignment option to Right.
C) Click the Align Right button in the Paragraph group.
D) Click the Align button and select Align Right.

Question 69

To view the document at 100%,which of the following should be done? Select all that apply.

A) Click the 100% button.
B) Click the One Page button.
C) Click the Zoom button and select 100%.
D) Click the Page Width button.

Question 70

Joseph needs to remove the formatting from a selection of text.He should do which of the following?

A) Select the text and press DEL.
B) Select the text and press ESC.
C) Select the text and click Cut.
D) Select the text and click Clear All Formatting.

Question 71

To ensure a document with a table can be interpreted by people with vision impairment,make sure to do which of the following?

A) Add alt text to the table.
B) Apply a table style to the table.
C) Sort the data in the table.
D) Convert the table to text.

Question 72

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) Use Destination Theme
B) Keep Source Formatting
C) Keep Text Only

Question 73

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.

Question 74

To ensure that a document can be read by people with visual impairment,which of the following should be done?

A) Check the document for accessibility.
B) Check the document for spelling and grammar errors.
C) Inspect the document.
D) Check the document for compatibility.

Question 75

To quickly change the outline,fill,and font color of a SmartArt shape,which of the following should be done?

A) Select the SmartArt shape and click Change Shape.
B) Select the SmartArt shape and click Shape Effects.
C) Select the SmartArt shape and select the desired WordArt Style.
D) Select the SmartArt shape and select the desired Shape Style.