Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A)  automatically updated
B)  baseline
C)  standard
D)  indexedE) A) and B)
F) B) and C)

Question 3

The first step in creating an effective worksheet is to make sure you ____.

Accepted Answer

A)  apply font formatting
B)  understand what is required
C)  insert a chart
D)  enter the dataE) A) and B)
F) A) and C)

Question 4

A character with a point size of 10 is about 10/72 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 5

Excel remembers the last ____ actions you have completed.

Accepted Answer

A)  25
B)  50
C)  75
D)  100E) B) and C)
F) A) and B)

Question 6

What effect does the Accounting Number Format have on the selected cells?

Accepted Answer

A)  Converts alphabetic characters to numbers
B)  Displays cell contents with two decimal places that align vertically
C)  Performs tax calculations
D)  Copies the numbers of one cell to anotherE) A) and C)
F) A) and B)

Question 7

Case 1-2
Anita is new to Microsoft Excel 2016. 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 features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

Accepted Answer

A)  AutoComplete
B)  AutoCalculate
C)  AutoCorrect
D)  Auto FillE) All of the above
F) C) and D)

Question 8

A pie chart with one or more slices offset is referred to as a(n)  ____ pie chart.

Accepted Answer

A)  exploded
B)  outer
C)  offset
D)  rasterizedE) B) and C)
F) A) and B)

Question 9

With Excel in Edit mode, you can edit cell contents directly in the cell.

Accepted Answer

A) True 
 B)False

Question 10

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

Accepted Answer

The answer of While typing in a cell, you can...

Question 11

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

Accepted Answer

A)  HOME
B)  DELETE
C)  END
D)  BACKSPACEE) A) and C)
F) A) and B)

Question 12

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

Accepted Answer

A)  Converts decimals to commas within a cell
B)  Converts decimals to commas within merged cells
C)  Displays cell contents with two decimal places and commas as thousands separators
D)  Allows for substitution of selected charactersE) A) and B)
F) A) and C)

Question 13

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Accepted Answer

A)  Automatic
B)  Hidden
C)  Replacement
D)  StandardE) A) and B)
F) None of the above

Question 14

Pressing the ____ keyboard shortcut key(s)  selects cell A1.

Accepted Answer

A)  CTRL+HOME
B)  CTRL+END
C)  HOME
D)  ENDE) A) and B)
F) All of the above

Question 15

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Accepted Answer

The answer of The easiest way to select a cell...

Exam 8: Excel_Module_1

Pressing the ____ keyboard shortcut key(s) selects cell A1.

Correct Answer
verified

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Correct Answer
verified

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Correct Answer
verified

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

Correct Answer
verified

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

Correct Answer
verified

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

Correct Answer
verified

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Correct Answer
verified

What effect does the Accounting Number Format have on the selected cells?

Correct Answer
verified

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

Correct Answer
verified

With Excel in Edit mode, you can edit cell contents directly in the cell.

Correct Answer
verified

A character with a point size of 10 is about 10/72 of one inch in height.

Correct Answer
verified

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

Correct Answer
verified

The first step in creating an effective worksheet is to make sure you ____.

Correct Answer
verified

Excel remembers the last ____ actions you have completed.

Correct Answer
verified

Correct Answer
verified

Exam 8: Excel_Module_1

Pressing the ____ keyboard shortcut key(s) selects cell A1.

Correct AnswerverifiedShow Answer

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Correct AnswerverifiedShow Answer

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Correct AnswerverifiedShow Answer

What effect does the Accounting Number Format have on the selected cells?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

With Excel in Edit mode, you can edit cell contents directly in the cell.

Correct AnswerverifiedShow Answer

A character with a point size of 10 is about 10/72 of one inch in height.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The first step in creating an effective worksheet is to make sure you ____.

Correct AnswerverifiedShow Answer

Excel remembers the last ____ actions you have completed.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified