Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

List and briefly describe six chart types from which you can choose in Excel. Mention how you select the appropriate type of chart.

Accepted Answer

Excel includes 10 chart types from which...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

How many chart types does Excel offer?

Accepted Answer

A)   5
B)   10
C)   29
D)   50

Question 5

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

Accepted Answer

A)   INSERT
B)   ENTER
C)   TAB
D)   ALT

Question 6

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

Accepted Answer

A)   revised
B)   relative
C)   recycled
D)   retained

Question 7

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

Question 8

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Accepted Answer

A) True 
 B)False

Question 9

Pressing the ____ key to samplete an entry activates the adjacent cell to the right.

Accepted Answer

A)   RIGHT ARROW
B)   LEFT ARROW
C)   UP ARROW
D)   DOWN ARROW

Question 10

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the acsampanying figure.

Accepted Answer

The answer of  A cell is selected, or ____________________,...

Question 11

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Accepted Answer

A)   scroll box
B)   sheet tab
C)   insertion point
D)   split bar

Question 12

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

Accepted Answer

A)   press ALT+F4
B)   press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu

Question 13

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

Accepted Answer

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

Question 14

____________________ indicates how characters are emphasized.

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

Excel resagnizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

Accepted Answer

A) True 
 B)False

Question 17

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

Accepted Answer

A) True 
 B)False

Question 18

If the next entry you want to make is in an adjacent cell, use the ____________________ keys to samplete the entry in the current cell and make the adjacent cell the active cell.

Accepted Answer

The answer of If the next entry you want to...

Question 19

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

Accepted Answer

If the entry in the cell is long and the...

Question 20

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

Accepted Answer

A)   AutoFormat
B)   Autosamplete
C)   AutoFunction
D)   AutoCalculate

Exam 12: Creating a Worksheet and a Chart

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

Correct AnswerverifiedIf the entry in the cell is long and the...View AnswerShow Answer

____________________ indicates how characters are emphasized.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Excel resagnizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Correct AnswerverifiedShow Answer

Pressing the ____ key to samplete an entry activates the adjacent cell to the right.

Correct AnswerverifiedShow Answer

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Correct AnswerverifiedShow Answer

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

Correct AnswerverifiedShow Answer

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the acsampanying figure.

Correct AnswerverifiedShow Answer

List and briefly describe six chart types from which you can choose in Excel. Mention how you select the appropriate type of chart.

Correct AnswerverifiedExcel includes 10 chart types from which...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How many chart types does Excel offer?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

If the next entry you want to make is in an adjacent cell, use the ____________________ keys to samplete the entry in the current cell and make the adjacent cell the active cell.

Correct AnswerverifiedShow Answer

Correct Answer
verified
If the entry in the cell is long and the...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Excel includes 10 chart types from which...
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