Question 1

Which of the following do you use to change the document margins?

Accepted Answer

A)  Use the Orientation button in the Page Setup group of the Layout tab to select the desired option. 
B)  Use the Margins button in the Page Setup group of the Layout tab to select the desired option. 
C)  Use the Size button in the Page Setup group of the Layout tab to select the desired option. 
D)  Use the Columns button in the Page Setup group of the Layout tab to select the desired option. 
A)  Use the Orientation button in the Page Setup group of the Layout tab to select the desired option. 
B)  Use the Margins button in the Page Setup group of the Layout tab to select the desired option. 
C)  Use the Size button in the Page Setup group of the Layout tab to select the desired option. 
D)  Use the Columns button in the Page Setup group of the Layout tab to select the desired option. B

Question 2

Kennedy needs to start a new section on a new page. She should do which of the following?

Accepted Answer

A)  Insert a Next Page section break. 
B)  Insert a Continuous section break. 
C)  Insert a Page break. 
D)  Insert a Column break. 
A)  Insert a Next Page section break. 
B)  Insert a Continuous section break. 
C)  Insert a Page break. 
D)  Insert a Column break. A

Question 3

Which of the following options allows you to align text so that it is fully flush with both margins?

Accepted Answer

A)  Align Left 
B)  Center 
C)  Align Right 
D)  Justify 
A)  Align Left 
B)  Center 
C)  Align Right 
D)  Justify D

Question 4

Jeremy is reading a document about geology when he encounters the word Paleolithic. To conduct research about the Paleolithic era, he should do which of the following?

Accepted Answer

A)  Click the Online Pictures button. 
B)  Enter the word Paleolithic in the Tell Me box. 
C)  Right-click the word and select translate. 
D)  Click the Researcher button. 
A)  Click the Online Pictures button. 
B)  Enter the word Paleolithic in the Tell Me box. 
C)  Right-click the word and select translate. 
D)  Click the Researcher button.

Question 5

Which view is best for laying out shapes on a page?

Accepted Answer

A)  Web Layout 
B)  Read Mode 
C)  Print Layout 
D)  Outline 
A)  Web Layout 
B)  Read Mode 
C)  Print Layout 
D)  Outline

Question 6

Samantha needs to create a numbered series of paragraphs. Which of the following should she do? Select all that apply.

Accepted Answer

A)  Type "1." and then press SPACEBAR to begin numbering. 
B)  Select the desired paragraphs and then press the Numbering button in the Paragraph group of the Home tab. 
C)  Enter ">" and then press SPACEBAR to begin numbering. 
D)  Select the desired paragraphs and then press CTRL+N. 
A)  Type "1." and then press SPACEBAR to begin numbering. 
B)  Select the desired paragraphs and then press the Numbering button in the Paragraph group of the Home tab. 
C)  Enter ">" and then press SPACEBAR to begin numbering. 
D)  Select the desired paragraphs and then press CTRL+N.

Question 7

Jared needs to create dozens of envelopes for a mailing. He plans to create a mail merge document to do so. He should select which of the following options in the Mail Merge Wizard?

Accepted Answer

A)  Letters 
B)  E-mail messages 
C)  Envelopes 
D)  Labels 
A)  Letters 
B)  E-mail messages 
C)  Envelopes 
D)  Labels

Question 8

Andrew accidentally misspelled a word. To correct the error, he can do which of the following?

Accepted Answer

A)  Right-click the word and select the desired suggested spelling. 
B)  Right-click the word and select Smart Lookup. 
C)  Right-click the word and select Link. 
D)  Right-click the word and select Translate. 
A)  Right-click the word and select the desired suggested spelling. 
B)  Right-click the word and select Smart Lookup. 
C)  Right-click the word and select Link. 
D)  Right-click the word and select Translate.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Caleb has a hierarchical list that he needs to create in a document. He should do which of the following?

Accepted Answer

A)  Create a multilevel list. 
B)  Create a single-level bulleted list. 
C)  Create a single-level numbered list. 
A)  Create a multilevel list. 
B)  Create a single-level bulleted list. 
C)  Create a single-level numbered list.

Question 11

Use Print Layout view to adjust the document margins.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following do you do to select text?

Accepted Answer

A)  press CTRL+T 
B)  click and drag across the desired text 
C)  right-click and drag across the desired text 
D)  press CTRL+S 
A)  press CTRL+T 
B)  click and drag across the desired text 
C)  right-click and drag across the desired text 
D)  press CTRL+S

Question 13

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?

Accepted Answer

A)  Bulleted list 
B)  Numbered list 
C)  Multilevel bulleted list 
A)  Bulleted list 
B)  Numbered list 
C)  Multilevel bulleted list

Question 14

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?

Accepted Answer

A)  Use the Clipboard. 
B)  Use Smart Lookup. 
C)  Use the Tell Me box. 
D)  Use the Formatting Painter. 
A)  Use the Clipboard. 
B)  Use Smart Lookup. 
C)  Use the Tell Me box. 
D)  Use the Formatting Painter.

Question 15

Showing the rulers will help you do which of the following?

Accepted Answer

A)  change the size of the page 
B)  make straight lines 
C)  change the zoom level 
D)  modify tabs 
A)  change the size of the page 
B)  make straight lines 
C)  change the zoom level 
D)  modify tabs

Question 16

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

Accepted Answer

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

Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?

Accepted Answer

A)  Right-click the text box border and select Repeat nine times. 
B)  Press the Redo button nine times. 
C)  Cut the text box and then paste it. 
D)  Press CTRL+R nine times. 
A)  Right-click the text box border and select Repeat nine times. 
B)  Press the Redo button nine times. 
C)  Cut the text box and then paste it. 
D)  Press CTRL+R nine times.

Question 18

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

Accepted Answer

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

Question 19

Chloe needs a bulleted list to have exclamation marks as bullets. She should do which of the following?

Accepted Answer

A)  Enter "!" at the beginning of each item in the list. 
B)  Change the bulleted list to a numbered list. 
C)  Change the bulleted list to a multilevel list. 
D)  Change the bullet to a symbol. 
A)  Enter "!" at the beginning of each item in the list. 
B)  Change the bulleted list to a numbered list. 
C)  Change the bulleted list to a multilevel list. 
D)  Change the bullet to a symbol.

Question 20

Aaron needs to create a document that is 17" wide and 11" tall. He should change the paper size.

Accepted Answer

A) True 
 B)False

Which of the following do you use to change the document margins?

Kennedy needs to start a new section on a new page. She should do which of the following?

Which of the following options allows you to align text so that it is fully flush with both margins?

Jeremy is reading a document about geology when he encounters the word Paleolithic. To conduct research about the Paleolithic era, he should do which of the following?

Which view is best for laying out shapes on a page?

Samantha needs to create a numbered series of paragraphs. Which of the following should she do? Select all that apply.

Jared needs to create dozens of envelopes for a mailing. He plans to create a mail merge document to do so. He should select which of the following options in the Mail Merge Wizard?

Andrew accidentally misspelled a word. To correct the error, he can do which of the following?

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

Caleb has a hierarchical list that he needs to create in a document. He should do which of the following?

Use Print Layout view to adjust the document margins.

Which of the following do you do to select text?

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?

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?

Showing the rulers will help you do which of the following?

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

Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?

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

Chloe needs a bulleted list to have exclamation marks as bullets. She should do which of the following?

Aaron needs to create a document that is 17" wide and 11" tall. He should change the paper size.

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters

Exam 1: Getting Started With Excel

Which of the following do you use to change the document margins?

Kennedy needs to start a new section on a new page. She should do which of the following?

Which of the following options allows you to align text so that it is fully flush with both margins?

Jeremy is reading a document about geology when he encounters the word Paleolithic. To conduct research about the Paleolithic era, he should do which of the following?

Which view is best for laying out shapes on a page?

Samantha needs to create a numbered series of paragraphs. Which of the following should she do? Select all that apply.

Jared needs to create dozens of envelopes for a mailing. He plans to create a mail merge document to do so. He should select which of the following options in the Mail Merge Wizard?

Andrew accidentally misspelled a word. To correct the error, he can do which of the following?

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

Caleb has a hierarchical list that he needs to create in a document. He should do which of the following?

Use Print Layout view to adjust the document margins.

Which of the following do you do to select text?

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?

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?

Showing the rulers will help you do which of the following?

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

Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?

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

Chloe needs a bulleted list to have exclamation marks as bullets. She should do which of the following?

Aaron needs to create a document that is 17" wide and 11" tall. He should change the paper size.

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters