Year 12 - end of 2nd half term

You have created a spreadsheet to budget for your summer holiday. What function would you use to find the total cost?

• =AVERAGE

• =MIN

• =MAX

• =SUM

What is the following: =(A1/A2)*100

• A statement

• A formula

• A function

What type of lookup would you use if the data in the lookup table is set out in columns like the image?

• =VLOOKUP

• =LOOKUP

• =HLOOKUP

What type of lookup would you use if the data in the lookup table is set out in rows like the image?

• =VLOOKUP

• =LOOKUP

• =HLOOKUP

You want to count up the number of students entered into a spreadsheet and just have their names. Which function would you use to do this?

• =COUNT

• =COUNTA

• =COUNTIF

• =SUM

You want to use an if statement to show the grade a student has attained for their last Math's assessment. They took the higher paper so can only get A*-C. How many IF's will there be in this function - in other words how many true values are there?

• 1

• 2

• 3

• 4

• 5

You have a list of student numbers for each form group in the school and want to see the biggest group size. What function will you use to do this?

• =MIN

• =MAX

• =COUNT

• =SUM

You want to count all students in the school who are in Year 10. Which function will you use to do this?

• =COUNT

• =COUNTA

• =COUNTIF

• =SUM

You have used =AVERAGE to find the average value for a set of data. You have been asked to use a function to display the average to 2 decimal places. Which will you use?

• =ROUND

• =AVERAGE

• =SUM

There are two things wrong with the if statement below. What are they?

=IF(A1>A2,"Level 1",=IF(A1>A3,"Level 2",Stay at current level))

• Not enough brackets at the end

• Second = sign is not needed - you only have one at the start of any function or formula

• No speech marks around the false value - this is needed for any text

• = sign is not needed at the beginning of the if statement