Question 1

Juana needs to open a document.To access the Open dialogue box,which tab should she use?

Accepted Answer

A)  Home tab 
B)  View tab 
C)  File tab 
D)  Review tab 
A)  Home tab 
B)  View tab 
C)  File tab 
D)  Review tab

Question 2

To modify the color palette of a document,you can change the theme colors.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

What are user-defined details about a file that describe its content and origin called?

Accepted Answer

A)  document properties 
B)  comments 
C)  formatting marks 
D)  references 
A)  document properties 
B)  comments 
C)  formatting marks 
D)  references

Question 6

Karen needs to add a shadow to a picture.She can do this by compressing the picture.

Accepted Answer

A) True 
 B)False

Question 7

To italicize text,use which of the following keystrokes?

Accepted Answer

A)  CTRL+I 
B)  CTRL+SHIFT+I 
C)  CTRL+Z 
D)  CTRL+SHIFT+Z 
A)  CTRL+I 
B)  CTRL+SHIFT+I 
C)  CTRL+Z 
D)  CTRL+SHIFT+Z

Question 8

Joe accidentally deleted a paragraph.To restore the paragraph,he needs to do which of the following?

Accepted Answer

A)  Undo the action. 
B)  Redo the action. 
C)  Repeat the action. 
D)  Reenter the text manually. 
A)  Undo the action. 
B)  Redo the action. 
C)  Repeat the action. 
D)  Reenter the text manually.

Question 9

Brian needs to view the paragraph marks in a document.Which of the following should he do?

Accepted Answer

A)  Enter Web Layout view 
B)  Enter Read Mode 
C)  Click the checkbox to show Gridlines 
D)  Select the Show/Hide ¶ button. 
A)  Enter Web Layout view 
B)  Enter Read Mode 
C)  Click the checkbox to show Gridlines 
D)  Select the Show/Hide ¶ button.

Question 10

Press CTRL+N to create a new blank document.

Accepted Answer

A) True 
 B)False

Question 11

To paste text,which of the following can you do? Select all that apply.

Accepted Answer

A)  Press CTRL+T. 
B)  Press CTRL+V. 
C)  Press the Replace button in the Editing group of the Home tab. 
D)  Press the Paste button in the Clipboard group of the Home tab. 
A)  Press CTRL+T. 
B)  Press CTRL+V. 
C)  Press the Replace button in the Editing group of the Home tab. 
D)  Press the Paste button in the Clipboard group of the Home tab.

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Terri needs each word in a paragraph to be capitalized.Which of the following is the simplest method to achieve this?

Accepted Answer

A)  Delete the first character of each word and retype it as a capital letter. 
B)  Write a Macro to replace the first character in each word with a capital letter. 
C)  Press the Text Effects and Typography button and select the desired option. 
D)  Press the Change Case button in the Font group of the Home tab and select Capitalize Each Word. 
A)  Delete the first character of each word and retype it as a capital letter. 
B)  Write a Macro to replace the first character in each word with a capital letter. 
C)  Press the Text Effects and Typography button and select the desired option. 
D)  Press the Change Case button in the Font group of the Home tab and select Capitalize Each Word.

Question 14

Tom needs to change the font size.He should do which of the following?

Accepted Answer

A) Select the desired text and press CTRL+SHIFT+> to increase the font size or CTRL+SHIFT+< to decrease the font size. B) Select the desired text and press CTRL+SHIFT+I to increase the font size or CTRL+SHIFT+D to decrease the font size. C) Press the Increase Font Size button or the Decrease Font Size button in the Mini toolbar. D) Press the Increase Font Size button or the Decrease Font Size button in the Font group of the Home tab. A) Select the desired text and press CTRL+SHIFT+> to increase the font size or CTRL+SHIFT+< to decrease the font size. B) Select the desired text and press CTRL+SHIFT+I to increase the font size or CTRL+SHIFT+D to decrease the font size. C) Press the Increase Font Size button or the Decrease Font Size button in the Mini toolbar. D) Press the Increase Font Size button or the Decrease Font Size button in the Font group of the Home tab.

Question 15

Press CTRL+W to save the document.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Dan needs to view his document as it will appear after being printed.Which view should he use?

Accepted Answer

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

Question 18

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?

Accepted Answer

A)  Apply numbering to the list. 
B)  Apply bullets to the list. 
C)  Apply multilevel numbering to the list. 
D)  Manually enter a ">" character at the beginning of each item in the list. 
A)  Apply numbering to the list. 
B)  Apply bullets to the list. 
C)  Apply multilevel numbering to the list. 
D)  Manually enter a ">" character at the beginning of each item in the list.

Question 19

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.

Accepted Answer

A) True 
 B)False

Question 20

Alejandro needs text to appear as if it were written in cursive.He can change the font of the desired text to achieve this.

Accepted Answer

A) True 
 B)False

Juana needs to open a document.To access the Open dialogue box,which tab should she use?

To modify the color palette of a document,you can change the theme colors.

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

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

What are user-defined details about a file that describe its content and origin called?

Karen needs to add a shadow to a picture.She can do this by compressing the picture.

To italicize text,use which of the following keystrokes?

Joe accidentally deleted a paragraph.To restore the paragraph,he needs to do which of the following?

Brian needs to view the paragraph marks in a document.Which of the following should he do?

Press CTRL+N to create a new blank document.

To paste text,which of the following can you do? Select all that apply.

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

Terri needs each word in a paragraph to be capitalized.Which of the following is the simplest method to achieve this?

Tom needs to change the font size.He should do which of the following?

Press CTRL+W to save the document.

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?

Dan needs to view his document as it will appear after being printed.Which view should he use?

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?

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.

Alejandro needs text to appear as if it were written in cursive.He can change the font of the desired text to achieve this.

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 1: Creating a Worksheet and a Chart

Juana needs to open a document.To access the Open dialogue box,which tab should she use?

To modify the color palette of a document,you can change the theme colors.

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

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

What are user-defined details about a file that describe its content and origin called?

Karen needs to add a shadow to a picture.She can do this by compressing the picture.

To italicize text,use which of the following keystrokes?

Joe accidentally deleted a paragraph.To restore the paragraph,he needs to do which of the following?

Brian needs to view the paragraph marks in a document.Which of the following should he do?

Press CTRL+N to create a new blank document.

To paste text,which of the following can you do? Select all that apply.

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

Terri needs each word in a paragraph to be capitalized.Which of the following is the simplest method to achieve this?

Tom needs to change the font size.He should do which of the following?

Press CTRL+W to save the document.

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?

Dan needs to view his document as it will appear after being printed.Which view should he use?

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?

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.

Alejandro needs text to appear as if it were written in cursive.He can change the font of the desired text to achieve this.

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters