Question 1

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

Accepted Answer

A)  fill 
B)  range 
C)  location 
D)  paste 
A)  fill 
B)  range 
C)  location 
D)  paste

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  merging 
B)  mixing 
C)  combining 
D)  spanning 
A)  merging 
B)  mixing 
C)  combining 
D)  spanning

Question 4

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 5

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Accepted Answer

A)  semi-colon (;) 
B)  colon (:) 
C)  period (.) 
D)  none of the above 
A)  semi-colon (;) 
B)  colon (:) 
C)  period (.) 
D)  none of the above

Question 6

Like an area chart,a(n)____________________ chart often is used to illustrate changes in data over time.

Accepted Answer

The answer of Like an area chart,a(n)____________________ chart often is...

Question 7

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

Accepted Answer

The answer of The automatically adjusted cell reference in a...

Question 8

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

Accepted Answer

A) font 
B) style 
C) size 
D) color 
E)  None of the above. 
A) font 
B) style 
C) size 
D) color 
E)  None of the above.

Question 9

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Accepted Answer

A)  selection handle 
B)  sizing handle 
C)  fill handle 
D)  copy handle 
A)  selection handle 
B)  sizing handle 
C)  fill handle 
D)  copy handle

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Toggles between Insert and Overtype mode.

Accepted Answer

A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR 
A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR

Question 11

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Accepted Answer

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

Question 12

Discuss how to correct errors after entering data into a cell using in-cell editing.

Accepted Answer

If the entry in the cell is long and the

Question 13

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate,easy to read,flexible,and useful.

Accepted Answer

The answer of Careful ____________________ can reduce your effort significantly...

Question 14

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 15

____________________ indicates how characters are emphasized.

Accepted Answer

The answer of ____________________ indicates how characters are emphasized....

Question 16

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)  clear 
A)  save 
B)  print 
C)  format 
D)  clear

Question 17

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area._________________________

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area 
A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area

Question 20

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

Accepted Answer

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

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

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

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

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Like an area chart,a(n)____________________ chart often is used to illustrate changes in data over time.

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

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

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Toggles between Insert and Overtype mode.

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Discuss how to correct errors after entering data into a cell using in-cell editing.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate,easy to read,flexible,and useful.

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

____________________ indicates how characters are emphasized.

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

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area._________________________

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

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

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

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 1: Creating a Worksheet and a Chart

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

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

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

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

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Like an area chart,a(n)____________________ chart often is used to illustrate changes in data over time.

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

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

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Toggles between Insert and Overtype mode.

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Discuss how to correct errors after entering data into a cell using in-cell editing.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate,easy to read,flexible,and useful.

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

____________________ indicates how characters are emphasized.

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

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area._________________________

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

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

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

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters