Question 1

The highlighted tab at the bottom of a datasheet displays the creation date of the datasheet.

Accepted Answer

A) True 
 B)False  False

Question 2

What do you need to do to enter data without the values exceeding the size of the cells?

Accepted Answer

Begin by making the column widths wide enough so that they hold the values and the headings by using the mouse to select columns, then choose the "Format" command followed by the "Column" and "Width" commands.

Question 3

How do you center the text in a range of cells?

Accepted Answer

Highlight the entire area by clicking the mouse on the first cell, and while holding the mouse button down drag the cursor to the last cell. Release the mouse button (the entire area will be highlighted)and choose the "Format" command followed by the "Cells" subcommand. Choose the alignment tab and choose the Center option from the drop- down menu for the horizontal text alignment.

Question 4

To center data in a cell:

Accepted Answer

A) choose Format, Alignment, then Center. 
B) choose Cells, Format, the Alignment tab, then Center. 
C) choose Format, Cells, the Alignment tab, then Center. 
D) choose Cells, the Alignment tab, then Center.

Question 5

An "IF" statement tells Excel that a_________  will be placed in the cell based on certain conditions.

Accepted Answer

The answer of An "IF" statement tells Excel that a_________...

Question 6

The tab that is highlighted at the bottom of the screen tells you which_________ is being displayed.

Accepted Answer

The answer of The tab that is highlighted at the...

Question 7

If a customer is charged 1% interest for an invoice that is 30 days, and the invoice amount is in Cell F8, the formula for the new invoice total would be:

Accepted Answer

A) =F8*.01. 
B) =F8*1.01%. 
C) =F8*1%. 
D) =F8*101%.

Question 8

How do managers reduce the risk of mathematical errors and why?

Accepted Answer

The answer of How do managers reduce the risk of...

Question 9

_________are a common business application.

Accepted Answer

The answer of _________are a common business application....

Question 10

Calculations should be entered into the spreadsheet before data values.

Accepted Answer

A) True 
 B)False

Question 11

The ordering of the "IF" statements is critical when_________ or more are nested in a formula.

Accepted Answer

The answer of The ordering of the "IF" statements is...

Question 12

Nested "IF" statements can be entered in no particular order.

Accepted Answer

A) True 
 B)False

Question 13

Why is the ordering in nested "IF" statements critical?

Accepted Answer

The answer of Why is the ordering in nested "IF"...

Question 14

To format data to appear as currency:

Accepted Answer

A) choose View, Format, then choose Currency. 
B) choose Format, Cells, then choose Currency. 
C) choose Format, Cells, Number, then choose Currency. 
D) choose Cells, Format, then choose Currency.

Question 15

Which of the following values is an example of a currency format with two decimals?

Accepted Answer

A) $ 2207.27 
B) $2,207.27 
C) 2,207.27 
D) 2207.27

Question 16

_________can be used to perform calculations and conditional logic that would otherwise be difficult for managers to carry out.

Accepted Answer

The answer of _________can be used to perform calculations and...

Question 17

The appearance of a spreadsheet should be in a form that aids decision making.

Accepted Answer

A) True 
 B)False

Question 18

Explain why spreadsheets are considered to be a common business application.

Accepted Answer

The answer of Explain why spreadsheets are considered to be...

Question 19

The "IF" statement is considered a conditional formula.

Accepted Answer

A) True 
 B)False

Question 20

Which command deletes datasheets?

Accepted Answer

A) Right click on the sheet, then choose Delete. 
B) Choose Format, then choose Delete Sheet. 
C) Choose Edit, then choose Delete Sheet. 
D) Choose Edit, then choose Delete.

Exam 17: Spreadsheet Basics

The highlighted tab at the bottom of a datasheet displays the creation date of the datasheet.

What do you need to do to enter data without the values exceeding the size of the cells?

How do you center the text in a range of cells?

To center data in a cell:

An "IF" statement tells Excel that a_________ will be placed in the cell based on certain conditions.

The tab that is highlighted at the bottom of the screen tells you which_________ is being displayed.

If a customer is charged 1% interest for an invoice that is 30 days, and the invoice amount is in Cell F8, the formula for the new invoice total would be:

How do managers reduce the risk of mathematical errors and why?

_________are a common business application.

Calculations should be entered into the spreadsheet before data values.

The ordering of the "IF" statements is critical when_________ or more are nested in a formula.

Nested "IF" statements can be entered in no particular order.

Why is the ordering in nested "IF" statements critical?

To format data to appear as currency:

Which of the following values is an example of a currency format with two decimals?

_________can be used to perform calculations and conditional logic that would otherwise be difficult for managers to carry out.

The appearance of a spreadsheet should be in a form that aids decision making.

Explain why spreadsheets are considered to be a common business application.

The "IF" statement is considered a conditional formula.

Which command deletes datasheets?