Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Press ALT+P to print a document.

Accepted Answer

A) True 
 B)False

Question 3

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?

Accepted Answer

A)  Shading and Borders commands 
B)  Shapes and Color commands 
C)  Highlighting and Line commands 
D)  Box and Fill commands 
A)  Shading and Borders commands 
B)  Shapes and Color commands 
C)  Highlighting and Line commands 
D)  Box and Fill commands

Question 4

Resize a picture proportionally by dragging a top sizing handle.

Accepted Answer

False - co

Question 5

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 6

To change the font, which of the following can you do? Select all that apply.

Accepted Answer

A)  Press CTRL+F. 
B)  Press the Font list box and select the desired text. 
C)  Press the Text Effects and Typography button and select the desired option. 
D)  Open the Font tab of the Font dialogue box, then select the desired font from the Font list box. 
A)  Press CTRL+F. 
B)  Press the Font list box and select the desired text. 
C)  Press the Text Effects and Typography button and select the desired option. 
D)  Open the Font tab of the Font dialogue box, then select the desired font from the Font list box.

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

Press CTRL+N to create a new blank document.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Which of the following methods do you use to accept a spelling change?

Accepted Answer

A)  Right-click the misspelled word, then select the desired suggested spelling. 
B)  Right-click the misspelled word, then press ENTER. 
C)  Right-click the misspelled word, then select Ignore All. 
D)  Right-click the misspelled word, then select Add to Dictionary. 
A)  Right-click the misspelled word, then select the desired suggested spelling. 
B)  Right-click the misspelled word, then press ENTER. 
C)  Right-click the misspelled word, then select Ignore All. 
D)  Right-click the misspelled word, then select Add to Dictionary.

Question 11

Underscore text to have a line appear beneath the text.

Accepted Answer

False - Underline
Fa

Question 12

Which preset text effect do you apply when you want the text to have a border color?

Accepted Answer

A)  Outline 
B)  Shadow 
C)  Reflection 
D)  Glow 
A)  Outline 
B)  Shadow 
C)  Reflection 
D)  Glow

Question 13

Austin needs to emphasize text by having color appear behind it. Which of the following tools should he use?

Accepted Answer

A)  the Text Highlight Color button 
B)  the Theme Effects button 
C)  the Font Color button 
D)  the Colors button 
A)  the Text Highlight Color button 
B)  the Theme Effects button 
C)  the Font Color button 
D)  the Colors button

Question 14

To create a numbered list that uses Roman numerals, change the list numbering style.

Accepted Answer

A) True 
 B)False

Question 15

To change the size of a picture without distorting it, which of the following should you do?

Accepted Answer

A)  drag a corner sizing handle 
B)  drag the top sizing handle 
C)  drag the bottom sizing handle 
D)  drag a side sizing handle 
A)  drag a corner sizing handle 
B)  drag the top sizing handle 
C)  drag the bottom sizing handle 
D)  drag a side sizing handle

Question 16

If Word suggests a grammar change that you do not want, you can ignore the change.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

To provide emphasis to text, you can apply bold.

Accepted Answer

A) True 
 B)False

Question 19

The Wingdings font includes a variety of symbols that can be used for a bulleted list.

Accepted Answer

A) True 
 B)False

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

Press ALT+P to print a document.

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?

Resize a picture proportionally by dragging a top sizing handle.

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?

To change the font, which of the following can you do? Select all that apply.

To italicize text, use which of the following keystrokes?

Press CTRL+N to create a new blank document.

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.

Which of the following methods do you use to accept a spelling change?

Underscore text to have a line appear beneath the text.

Which preset text effect do you apply when you want the text to have a border color?

Austin needs to emphasize text by having color appear behind it. Which of the following tools should he use?

To create a numbered list that uses Roman numerals, change the list numbering style.

To change the size of a picture without distorting it, which of the following should you do?

If Word suggests a grammar change that you do not want, you can ignore the change.

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

To provide emphasis to text, you can apply bold.

The Wingdings font includes a variety of symbols that can be used for a bulleted list.

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

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

Press ALT+P to print a document.

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?

Resize a picture proportionally by dragging a top sizing handle.

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?

To change the font, which of the following can you do? Select all that apply.

To italicize text, use which of the following keystrokes?

Press CTRL+N to create a new blank document.

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.

Which of the following methods do you use to accept a spelling change?

Underscore text to have a line appear beneath the text.

Which preset text effect do you apply when you want the text to have a border color?

Austin needs to emphasize text by having color appear behind it. Which of the following tools should he use?

To create a numbered list that uses Roman numerals, change the list numbering style.

To change the size of a picture without distorting it, which of the following should you do?

If Word suggests a grammar change that you do not want, you can ignore the change.

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

To provide emphasis to text, you can apply bold.

The Wingdings font includes a variety of symbols that can be used for a bulleted list.

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