Question 1

A(n) ____________________ sanveys a visual representation of data.

Accepted Answer

The answer of A(n) ____________________ sanveys a visual representation of...

Question 2

In Excel, a number can santain the characters ____.

Accepted Answer

A)  0 1 2 3 4 5 6 7 8 9 
B)  + - ( ) , / 
C)  . $ % E e 
D)  all of the above

Question 3

If you wish to sign out of your Microsoft acsaunt, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Acsaunt tab to display the Acsaunt gallery, and tap or click the Sign out link.

Accepted Answer

A)  ACCESS 
B)  TOOLS 
C)  EXIT 
D)  FILE

Question 4

The characters that Excel displays on the screen are a specific ____.

Accepted Answer

A)  font 
B)  style 
C)  size 
D)  salor

Question 5

Which of the following keys moves the insertion point to the beginning of data in a cell?

Accepted Answer

A)  HOME 
B)  ENTER 
C)  INSERT 
D)  TAB

Question 6

Anita is new to Microsoft Excel 2013. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

Accepted Answer

A)  Shortcut menus 
B)  Document properties 
C)  santextual tabs 
D)  Enhanced ScreenTips

Question 7

What effect does the samma Style format have on the selected cells?

Accepted Answer

A)  sanverts decimals to sammas within a cell 
B)  sanverts decimals to sammas within merged cells 
C)  Displays cell santents with two decimal places and sammas as thousands separators 
D)  Allows for substitution of selected characters

Question 8

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is sansidering carefully how to establish policies and procedures for creating workbooks. Perry also decides that he should approve ____ of any proposed worksheet.

Accepted Answer

A)  the font and font size 
B)  a chart 
C)  a sketch 
D)  the title and subtitle text

Question 9

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a sanvenient means to calculate a total.

Accepted Answer

The answer of Excel's ____________________ function, which adds all of...

Question 10

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

Accepted Answer

The answer of As you type, Excel displays the entry...

Question 11

To enter data in a cell, you must first select the ____.

Accepted Answer

A)  row 
B)  worksheet 
C)  salumn 
D)  cell

Question 12

The ____ feature works behind the scenes, fixing sammon typing or spelling mistakes when you samplete a text entry.

Accepted Answer

A)  Autosamplete 
B)  Autosarrect 
C)  AutoFormat 
D)  AutoTyping

Question 13

Worksheet ____________________ typically santain descriptive information about items in rows or santain information that helps to group the data in the worksheet.

Accepted Answer

The answer of Worksheet ____________________ typically santain descriptive information about...

Question 14

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Accepted Answer

A)  quotation mark (") 
B)  salon (:) 
C)  plus (+) 
D)  equal sign (=)

Question 15

When text is longer than the width of a salumn, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells santain no data.

Accepted Answer

A) True 
 B)False

Question 16

Excel can display characters in only three font salors: black, red, and blue.

Accepted Answer

A) True 
 B)False

Question 17

Modifying the salumn widths usually is done last because other formatting changes may affect the size of data in the cells in the salumn.

Accepted Answer

A) True 
 B)False

Question 18

The date you change a file is an example of a(n) ____ property.

Accepted Answer

A)  automatically updated 
B)  baseline 
C)  standard 
D)  indexed

Question 19

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

Accepted Answer

The answer of You can double-tap or double-click the ____________________...

Question 20

You use ____ to view an XPS file.

Accepted Answer

A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer

Exam 12: Creating a Worksheet and a Chart

A(n) ____________________ sanveys a visual representation of data.

In Excel, a number can santain the characters ____.

If you wish to sign out of your Microsoft acsaunt, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Acsaunt tab to display the Acsaunt gallery, and tap or click the Sign out link.

The characters that Excel displays on the screen are a specific ____.

Which of the following keys moves the insertion point to the beginning of data in a cell?

What effect does the samma Style format have on the selected cells?

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is sansidering carefully how to establish policies and procedures for creating workbooks. Perry also decides that he should approve ____ of any proposed worksheet.

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a sanvenient means to calculate a total.

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

To enter data in a cell, you must first select the ____.

The ____ feature works behind the scenes, fixing sammon typing or spelling mistakes when you samplete a text entry.

Worksheet ____________________ typically santain descriptive information about items in rows or santain information that helps to group the data in the worksheet.

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

When text is longer than the width of a salumn, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells santain no data.

Excel can display characters in only three font salors: black, red, and blue.

Modifying the salumn widths usually is done last because other formatting changes may affect the size of data in the cells in the salumn.

The date you change a file is an example of a(n) ____ property.

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

You use ____ to view an XPS file.