Paper 3 - Data Analysis and Website Authoring

An individual box within a spreadsheet worksheet is known as?

• square

• range

• refernce

• cell

SUM, AVERAGE, MAX, IF and VLOOKUP are examples of what?

• Functions

• Tables

• Formulae

• Statistical tools

A1:D4 is an example of a cell...

• Range
• Selection
• Highlight
• Choice

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1,A6)

Zoe wants to add together a range of cells in her spreadsheet. She would like Excel to add only the cells in the range that are greater than 50. What function should she use?

• SUMIF

• AVERAGEIF

• TOTALIF

• COUNTIF

If you see this code, what do you need to do?
#####

• Check your function syntax
• Re-enter the function formula
• Widen the column
• Use a different function

If a student scores over 20 in the exam, the adjacent cell must state PASS otherwise it should say FAIL.

Select the correct formula that must be typed in cell C4.

• =IF(B4>20,"PASS","FAIL")

• =IF("PASS"=>20,B4,"FAIL)

• =IF(<20,B4,"PASS","FAIL")

• =IF(B4<20 "PASS","FAIL")

You've been asked to Extract a list of countries that use dollar as their currency. How would you do this?

• Use a filter

• Use a formula

• Use a function

• Use a chart

You have been asked In cell D10 enter a function to lookup the destination for Robert Maxwell.

What function would you use?

• VLOOKUP

• IF

• AVERAGE

• SUMIF

You have been asked In Cell D2 use a count formula that counts the frequency of AQA in cell range E3 to E25.

Which is the most appropriate function to use?

• COUNTIF

• SUMIF

• VLOOKUP

• IF