Question 1

Calculations should be entered into the spreadsheet before data values.

Accepted Answer

Calculations in a spreadsheet require data values to operate on; therefore, data values must be entered first for calculations to be meaningful.

Question 2

_________are a common business application.

Accepted Answer

Spreadsheets

Question 3

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

Accepted Answer

value

Question 4

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

Accepted Answer

The answer of How do you center the text in...

Question 5

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:
A)=F8*.01.
B)=F8*1.01%.
C)=F8*1%.
D)=F8*101%.

Accepted Answer

The new invoice total includes the original amount plus 1% interest, which is calculated as 101% of the original amount. Therefore, the formula is F8*101%.

Question 6

Which of the following values is an example of a currency format with two decimals?
A)$ 2207.27
B)$2,207.27
C)2,207.27
D)2207.27

Accepted Answer

The value "$2,207.27" is in a currency format with two decimals, including a dollar sign and a comma for the thousand separator.

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

The highlighted tab at the bottom of a datasheet typically displays the name of the worksheet or sheet, not the creation date.

Question 9

To center data in a cell:
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.

Accepted Answer

The correct sequence to center data in a cell is to choose Format, then Cells, go to the Alignment tab, and select Center.

Question 10

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

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

Accepted Answer

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

Question 12

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

Accepted Answer

Nested "IF" statements must be structured logically, with each condition evaluated in a specific order to ensure the correct outcome.

Question 13

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 14

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

Accepted Answer

The design and layout of a spreadsheet should be clear and organized to facilitate easy interpretation and analysis, which aids in effective decision making.

Question 15

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

Accepted Answer

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

Question 16

To format data to appear as currency:
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.

Accepted Answer

The answer of To format data to appear as currency:
A)choose...

Question 17

Which command deletes datasheets?
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.

Accepted Answer

The answer of Which command deletes datasheets?
A)Right click on the...

Question 18

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

Accepted Answer

The answer of What do you need to do to...

Question 19

The "IF" statement is considered a conditional formula.

Accepted Answer

The "IF" statement is used to perform logical tests and return different values based on whether the condition is true or false, making it a conditional formula.

Question 20

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

Quiz 17: Spreadsheet Basics