WorksheetsSpreadsheets - H Admin
Total questions: 14
Worksheet time: 8mins
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
Identify the function that would be used to calculate the total number of tickets sold for each show
CountIF
SumIF
VLookup
NestedIF
Identify the type of lookup that would be used to extract data from this table
VLookup
HLookup
Identify the correct formula to calculate the Packing Cost in cell D6
=IF(C6>=30,$G$11,IF(C6>=60,$G$10,IF(C6>=90,$G$9,0)))
=IF(C6>=90,$G$9,IF(C6>=30,$G$11,IF(C6>=60$G$10,0)))
=IF(C6>=90,G9,IF(C6>=60,G10,IF(C6>=30,G11,0)))
=IF(C6>=90,$G$9,IF(C6>=60,$G$10,IF(C6>=30,$G$11,0)))
What is the purpose of a pivot table?
Removes unnecessary data
Summarises large amounts of data
Adds functions and formulae to the worksheet
Highlights key data in the worksheet
