Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Critical Thinking Questions Case 1-1 Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering 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 textE) B) and C)
F) C) and D)

Question 3

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Accepted Answer

A)   AutoFormat
B)   AutoComplete
C)   AutoFunction
D)   AutoCalculateE) A) and B)
F) None of the above

Question 4

Critical Thinking Questions Case 1-2 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 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) A) and B)
F) C) and D)

Question 5

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 6

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Highlights one or more adjacent characters to the right.

Accepted Answer

The Answer of ARROW and SHIFT+RIGHT ARROW and HOME and is...

Question 8

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Accepted Answer

A)   revised
B)   relative
C)   recycled
D)   retainedE) B) and C)
F) C) and D)

Question 9

Match between columns
                        Premises: Selects the cell one worksheet window to the right.

Accepted Answer

The Answer of END and SHIFT+RIGHT ARROW and BACKSPACE and is...

Question 10

Match between columns
                        Premises: Selects the cell at the beginning of the row that contains the active cell.

Accepted Answer

The Answer of END and INSERT and CTRL+F and SPACEBAR is...

Question 11

Match between columns
                        Premises: Selects cell A1.

Accepted Answer

The Answer of ARROW and SHIFT+RIGHT ARROW and END and is...

Question 12

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

Accepted Answer

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

Question 13

The range of cells receiving copied content is called the ____ area.

Accepted Answer

A)   fill
B)   range
C)   location
D)   pasteE) A) and C)
F) C) and D)

Question 14

Combining two or more selected cells into one cell is called ____ cells.

Accepted Answer

A)   merging
B)   mixing
C)   combining
D)   spanningE) A) and C)
F) All of the above

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Should not be used to clear a cell.

Accepted Answer

The Answer of ARROW and ALT+PAGE DOWN and HOME and is...

Question 17

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range .

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

Which of the following keys toggles between Insert mode and Overtype mode?

Accepted Answer

A)   INSERT
B)   ENTER
C)   TAB
D)   ALTE) None of the above
F) B) and D)

Question 20

Match between columns
                        Premises: Selects the adjacent cell in the direction of the arrow on the key.

Accepted Answer

The Answer of END and CTRL+F and HOME and BACKSPACE is...

Exam 9: Excel: Creating a Worksheet and a Chart

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Combining two or more selected cells into one cell is called ____ cells.

Correct Answer
verified

Correct Answer
verified

Which of the following keys toggles between Insert mode and Overtype mode?

Correct Answer
verified

The range of cells receiving copied content is called the ____ area.

Correct Answer
verified

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Correct Answer
verified

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

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

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

Correct Answer
verified

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range .

Correct Answer
verified

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

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

Correct Answer
verified

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

Correct Answer
verified

Exam 9: Excel: Creating a Worksheet and a Chart

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Combining two or more selected cells into one cell is called ____ cells.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Which of the following keys toggles between Insert mode and Overtype mode?

Correct AnswerverifiedShow Answer

The range of cells receiving copied content is called the ____ area.

Correct AnswerverifiedShow Answer

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

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

Correct AnswerverifiedShow Answer

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range .

Correct AnswerverifiedShow Answer

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

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

Correct AnswerverifiedShow Answer

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

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