Question 1

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%.E) C) and D)
F) A) and D)

Question 2

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

Accepted Answer

When Excel locates the first c...

Question 3

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.27E) A) and C)
F) All of the above

Question 4

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

Accepted Answer

Spreadsheets are considered to...

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

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.E) B) and C)
F) A) and D)

Question 8

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 9

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

Accepted Answer

A) True 
 B)False  False

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

_________are a common business application.

Accepted Answer

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

Question 13

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.E) C) and D)
F) All of the above

Question 14

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.E) A) and D)
F) C) and D)

Question 15

The "IF" statement is considered a conditional formula.

Accepted Answer

A) True 
 B)False

Question 16

Calculations should be entered into the spreadsheet before data values.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

By using spreadsheets rather than relyin...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 17: Spreadsheet Basics

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:

Correct Answer
verified

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

Correct Answer
verified
When Excel locates the first c...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified
Spreadsheets are considered to...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

To format data to appear as currency:

Correct Answer
verified

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

Correct Answer
verified
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.

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

Correct Answer
verified
False

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

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

Correct Answer
verified

_________are a common business application.

Correct Answer
verified

To center data in a cell:

Correct Answer
verified

Which command deletes datasheets?

Correct Answer
verified

The "IF" statement is considered a conditional formula.

Correct Answer
verified

Calculations should be entered into the spreadsheet before data values.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
By using spreadsheets rather than relyin...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

Exam 17: Spreadsheet Basics

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:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedWhen Excel locates the first c...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedSpreadsheets are considered to...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To format data to appear as currency:

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedFalse

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

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

Correct AnswerverifiedShow Answer

_________are a common business application.

Correct AnswerverifiedShow Answer

To center data in a cell:

Correct AnswerverifiedShow Answer

Which command deletes datasheets?

Correct AnswerverifiedShow Answer

The "IF" statement is considered a conditional formula.

Correct AnswerverifiedShow Answer

Calculations should be entered into the spreadsheet before data values.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedBy using spreadsheets rather than relyin...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
When Excel locates the first c...
View Answer

Correct Answer
verified

Correct Answer
verified
Spreadsheets are considered to...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
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.

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
By using spreadsheets rather than relyin...
View Answer

Correct Answer
verified

Correct Answer
verified