Spreadsheets - H Admin

Identify the function used to calculate Total Hours

• VLookup

• Average

• Sum

• Count

Identify the function that would be used to make a decision in a spreadsheet

• Sum

• Average

• IF

• VLookup

Here is an example of a Nested IF statement. Will the result of this formula show the percentage value or monetary value of pension contributions?

• Percentage

• Monetary

To show a monetary value in a spreadsheet, cells should be formatted to (a)  

The Price per Person data for each activity is stored in a separate worksheet in a list. Identify the function to be used to return the correct price for each activity.

• Name Cells

• IF Statement

• VLookup

• Linked cell

Identify the correct formula to be entered to calculate Income in cell G4

• =E4*F4

• =D4*E4*F4

• =(D4*E4)*F4

• =(E4*F4)*D4

Values for Discount Amount (column G) will be formatted to ...........

• Percentage

• Currency

• Date

• Text

Identify the formula used to calculate Net Income in cell H4

• =E4*G4

• =E4-G4

• =(E4/D4)*G4

• =E4/G4

Identify the advantages of using named cells in a spreadsheet

• Data can be linked between worksheets easily

• Cell references cannot be used more than once

• Cell reference do not change when copied to other cells

• Easier for the user to understand formula

Identify the function that would be used to specify the number of decimal places to be displayed

• Decimal PLace

• Round

• Autosum

• HLookup