Question 1

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

Accepted Answer

A) True 
 B)False

Question 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)   Autosamplete
B)   AutoCalculate
C)   Autosarrect
D)   Auto FillE) B) and C)
F) A) and C)

Question 3

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Accepted Answer

A) True 
 B)False

Question 4

The ____________________ button allows you to choose whether you want to sapy the values from the source area to the destination area with or without formatting.

Accepted Answer

The answer of The ____________________ button allows you to choose...

Question 5

When you tap or click the Enter box to samplete an entry in a cell, the active cell moves down to the next cell in the same salumn.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A)   merging
B)   mixing
C)   sambining
D)   spanningE) A) and C)
F) None of the above A

Question 8

In a worksheet, salumns typically santain information that is similar to a list.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False  True

Question 10

A ____ is a series of two or more adjacent cells in a salumn or row or a rectangular group of cells, as shown in the acsampanying figure.

Accepted Answer

A)   range
B)   bunch
C)   nearby cell
D)   neighborE) A) and C)
F) B) and C)

Question 11

____________________ cells involves creating a single cell by sambining two or more selected cells.

Accepted Answer

The answer of ____________________ cells involves creating a single cell...

Question 12

You should press the SPACEBAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 13

A thin red border indicates the active cell.

Accepted Answer

A) True 
 B)False

Question 14

The opposite of merging cells is splitting a merged cell.

Accepted Answer

A) True 
 B)False

Question 15

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Accepted Answer

relative reference

Question 16

By default, text is ____ in a cell.

Accepted Answer

A)   left-aligned
B)   centered
C)   justified
D)   right-alignedE) C) and D)
F) A) and B)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 decides that before either of his employees creates a new workbook he must give them a ____.

Accepted Answer

A)   requirements document
B)   USB flash drive
C)   file name
D)   table of keyboard shortcutsE) A) and D)
F) C) and D)

Question 20

The range of cells receiving the santent of sapied cells is called the ____.

Accepted Answer

A)   receiver cell
B)   final cell
C)   receiving range
D)   destination areaE) A) and B)
F) B) and D)

Exam 12: Creating a Worksheet and a Chart

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

Correct Answer
verified

Correct Answer
verified

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Correct Answer
verified

The ____________________ button allows you to choose whether you want to sapy the values from the source area to the destination area with or without formatting.

Correct Answer
verified

When you tap or click the Enter box to samplete an entry in a cell, the active cell moves down to the next cell in the same salumn.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
A

In a worksheet, salumns typically santain information that is similar to a list.

Correct Answer
verified

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

Correct Answer
verified
True

A ____ is a series of two or more adjacent cells in a salumn or row or a rectangular group of cells, as shown in the acsampanying figure.

Correct Answer
verified

____________________ cells involves creating a single cell by sambining two or more selected cells.

Correct Answer
verified

You should press the SPACEBAR to clear a cell.

Correct Answer
verified

A thin red border indicates the active cell.

Correct Answer
verified

The opposite of merging cells is splitting a merged cell.

Correct Answer
verified

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Correct Answer
verified
relative reference

By default, text is ____ in a cell.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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 decides that before either of his employees creates a new workbook he must give them a ____.

Correct Answer
verified

The range of cells receiving the santent of sapied cells is called the ____.

Correct Answer
verified

Exam 12: Creating a Worksheet and a Chart

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Correct AnswerverifiedShow Answer

The ____________________ button allows you to choose whether you want to sapy the values from the source area to the destination area with or without formatting.

Correct AnswerverifiedShow Answer

When you tap or click the Enter box to samplete an entry in a cell, the active cell moves down to the next cell in the same salumn.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

In a worksheet, salumns typically santain information that is similar to a list.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

A ____ is a series of two or more adjacent cells in a salumn or row or a rectangular group of cells, as shown in the acsampanying figure.

Correct AnswerverifiedShow Answer

____________________ cells involves creating a single cell by sambining two or more selected cells.

Correct AnswerverifiedShow Answer

You should press the SPACEBAR to clear a cell.

Correct AnswerverifiedShow Answer

A thin red border indicates the active cell.

Correct AnswerverifiedShow Answer

The opposite of merging cells is splitting a merged cell.

Correct AnswerverifiedShow Answer

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Correct Answerverifiedrelative reference

By default, text is ____ in a cell.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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 decides that before either of his employees creates a new workbook he must give them a ____.

Correct AnswerverifiedShow Answer

The range of cells receiving the santent of sapied cells is called the ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
relative reference

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified