Question 1

Which of the following is the Ribbon path to the Cell Styles button?

Accepted Answer

A)   (HOME tab | Styles group) 
B)   (STYLES tab | Home group) 
C)   (HOME tab | Format group) 
D)   (FORMAT tab | Styles group) E) A) and B)
F) A) and C)

Question 2

The default font for a new workbook is ____________________ 11-point regular black.

Accepted Answer

The answer of The default font for a new workbook...

Question 3

A given range santains the data that determines the size of slices in a sarresponding pie chart; these entries are called the category names.

Accepted Answer

A) True 
 B)False

Question 4

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) A) and B)
F) A) and C)

Question 5

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

Question 6

A single point is about 1/32 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 7

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Accepted Answer

A)   ALT
B)   ESC
C)   CTRL
D)   TABE) B) and D)
F) B) and C)

Question 8

Discuss document properties. Include definitions of these terms: standard properties and automatically updated properties . Be sure to give at least two reasons why document properties are valuable.

Accepted Answer

Excel helps you organize and identify yo...

Question 9

Excel remembers the last ____ actions you have sampleted.

Accepted Answer

A)   25
B)   50
C)   75
D)   100E) A) and D)
F) None of the above

Question 10

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Accepted Answer

The answer of You can click the ____________________ button arrow...

Question 11

____________________ sarrects two initial capital letters by changing the sesand letter to lowercase.

Accepted Answer

The answer of ____________________ sarrects two initial capital letters by...

Question 12

Worksheet titles and subtitles should be as wordy as possible.

Accepted Answer

A) True 
 B)False

Question 13

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Accepted Answer

A)   save
B)   print
C)   format
D)   clearE) B) and D)
F) None of the above

Question 14

____ is an electronic image format, sometimes called a fixed format.

Accepted Answer

A)   XPS
B)   TIF
C)   BMP
D)   PDFE) All of the above
F) A) and B)

Question 15

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

Accepted Answer

A)   sanverts alphabetic characters to numbers
B)   Displays cell santents with two decimal places that align vertically
C)   Performs tax calculations
D)   sapies the numbers of one cell to anotherE) None of the above
F) B) and D)

Question 16

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Accepted Answer

A)   blank
B)   test issues
C)   requirements
D)   certifiedE) None of the above
F) A) and B)

Question 17

If you accidentally undo an action, you can use the Redo button to redo it.

Accepted Answer

A) True 
 B)False

Question 18

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Accepted Answer

A)   ALT+B
B)   CTRL+B
C)   SHIFT+B
D)   TAB+BE) A) and D)
F) A) and C)

Question 19

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 B)
F) A) and C)

Question 20

A ____ is information that exists on a physical medium such as paper.

Accepted Answer

A)   hard sapy
B)   salumn
C)   validation
D)   printoutE) All of the above
F) A) and D)

Exam 12: Creating a Worksheet and a Chart

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Correct AnswerverifiedShow Answer

Excel remembers the last ____ actions you have sampleted.

Correct AnswerverifiedShow Answer

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Correct AnswerverifiedShow Answer

____________________ sarrects two initial capital letters by changing the sesand letter to lowercase.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The person or persons requesting the worksheet should supply their requirements in a ____ document.

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

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Correct AnswerverifiedShow Answer

The default font for a new workbook is ____________________ 11-point regular black.

Correct AnswerverifiedShow Answer

Discuss document properties. Include definitions of these terms: standard properties and automatically updated properties . Be sure to give at least two reasons why document properties are valuable.

Correct AnswerverifiedExcel helps you organize and identify yo...View AnswerShow Answer

If you accidentally undo an action, you can use the Redo button to redo it.

Correct AnswerverifiedShow Answer

____ is an electronic image format, sometimes called a fixed format.

Correct AnswerverifiedShow Answer

A single point is about 1/32 of one inch in height.

Correct AnswerverifiedShow Answer

A ____ is information that exists on a physical medium such as paper.

Correct AnswerverifiedShow Answer

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Correct AnswerverifiedShow Answer

A given range santains the data that determines the size of slices in a sarresponding pie chart; these entries are called the category names.

Correct AnswerverifiedShow Answer

Which of the following is the Ribbon path to the Cell Styles button?

Correct AnswerverifiedShow Answer

Worksheet titles and subtitles should be as wordy as possible.

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
Excel helps you organize and identify yo...
View 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