Question 1

Match between columns
                        Premises: Selects cell A1.

Accepted Answer

The Answer of FN-F2 and SPACE BAR and ARROW and is...

Question 2

To cancel an entire entry before entering it into the cell, press the ____ key.

Accepted Answer

A) COMMAND 
B) ESC 
C) CONTROL 
D) TAB

Question 3

Cell ____ are adjusted automatically to accommodate new formatting.

Accepted Answer

A) widths 
B) heights 
C) resolutions 
D) dimensions

Question 4

You can select any cell by entering its cell reference in the ____________________.

Accepted Answer

The answer of You can select any cell by entering...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

The AutoFill Options button allows you to choose whether you want to copy the values from the source area to the destination area ____.

Accepted Answer

A) without formatting 
B) with formatting 
C) by copying only the function 
D) by copying only the format

Question 8

To enter data in a cell, you must first ____ the cell.

Accepted Answer

A) control 
B) scroll 
C) function 
D) select

Question 9

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

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

Excel can display characters in only three font colors: black, red, and blue.

Accepted Answer

A) True 
 B)False

Question 13

____________________ indicates how text characters are emphasized.

Accepted Answer

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

Question 14

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

Accepted Answer

The Answer of SHIFT-RIGHT ARROW and SPACE BAR and FN-F2 is...

Question 15

To enter a number as text, precede it with a(n)____.

Accepted Answer

A) quotation mark (") 
B) colon (:) 
C) plus (+) 
D) apostrophe (')

Question 16

____ is/are used to place worksheet, column, and row titles on a worksheet.

Accepted Answer

A) Color 
B) Text 
C) Links 
D) Tabs

Question 17

Clicking the ____ button completes an entry.

Accepted Answer

A) Cancel 
B) Formula 
C) Enter 
D) Tab

Question 18

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

Accepted Answer

The Answer of FN-RIGHT ARROW and COMMAND-FN-LEFT ARROW and SPACE is...

Question 19

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then double-click the AutoCalculate area to display the AutoCalculate shortcut menu.

Accepted Answer

A) True 
 B)False

Question 20

An increased ____________________ gives more impact to the text in a cell.

Accepted Answer

The answer of An increased ____________________ gives more impact to...

Exam 3: Excel: Creating a Worksheet and an Embedded Chart

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

To cancel an entire entry before entering it into the cell, press the ____ key.

Cell ____ are adjusted automatically to accommodate new formatting.

You can select any cell by entering its cell reference in the ____________________.

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

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

The AutoFill Options button allows you to choose whether you want to copy the values from the source area to the destination area ____.

To enter data in a cell, you must first ____ the cell.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

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

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

Excel can display characters in only three font colors: black, red, and blue.

____________________ indicates how text characters are emphasized.

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

To enter a number as text, precede it with a(n) ____.

____ is/are used to place worksheet, column, and row titles on a worksheet.

Clicking the ____ button completes an entry.

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

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then double-click the AutoCalculate area to display the AutoCalculate shortcut menu.

An increased ____________________ gives more impact to the text in a cell.