Deck 17: Spreadsheet Basics

Question 1

Calculations should be entered into the spreadsheet before data values.

Answer 1

False

Question 2

are a common business application.

Answer 2

Spreadsheets

Question 3

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

Answer 3

value

Question 4

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

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

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

Question 7

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

Question 8

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

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.

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

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.

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.

Question 18

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

Question 19

The "IF" statement is considered a conditional formula.

Question 20

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