WorksheetsICT IGCSE Quiz
Total questions: 25
Worksheet time: 12mins
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 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
Which of the below formulae includes absolute cell referencing?
=B7*$D$21
=SUM(A2:D5)
=IF(D5=5,"MET","FAIL")
=AVERAGE(H7:H20)
What is the correct format of an IF statement
=IF (TEST, VALUE IF TRUE, VALUE IF FALSE)
=IF(A1>B1,"YES","NO")
=IF (TEST VALUE IF FALSE VALUE IF TRUE)
=IF(A1>B1,NO, YES)
=IF TEST,VALUE IF TRUE, VALUE IF FALSE
=IFA1>B1,"YES","NO"
What is the difference between HTML and CSS
HTML is the content and CSS is the styles
HTML and CSS can do the same
CSS is the content and HTML is the styles
Select the correct code below to configure the CSS for the table style:
table,td {border:3px solid black; }
table, td { line: #000000; }
table { border:3point black; }
table td { bordar:3px; sold black }
What line contains a syntax error
1
2
3
4
What line contains a syntax error
1
2
3
4
Why use slide master?
To ensure slides contain the same fonts, layout and images (such as logos)
To ensure that the printouts will print in black and white
To add different animations on each slide
To add a background image rather than a plain colour to one slide
You have been given a word processed document that needs to be transferred into powerpoint.
How can you do this easily?
Use File, Open, and select All Outlines
Use Insert, then select Word Documents
Copy and paste each item from the document into Powerpoint
Select Slideshow and then New Slide
Looking at the image, what data type would you suggest to store the field membership start date in a database?
Text
Numeric
Date/Time
Boolean
Looking at the image, what data type would you suggest to store the field Full amount paid in a database?
Currency
Numeric
Date/Time
Boolean
You have been given this task as part of a query/report:
Must contain a new field calculated at run-time called FinalCost. This is calculated using Quantity multiplied by Price.
How would this be written in the final column?
FinalCost:[Quantity]*[Price]
FinalCost=Quantity*Price
[Quantity*Price]=FinalCost
FinalCost:QuantityxPrice
You have been given this task as part of a query/report:
show only the records where the The Destination_Name is London Gatwick, and Vacant_Seats is more than or equal to 5.
Select the correct syntax that you would use to search for this.
What does the image show?
Importing data into a database
A mail merge
A presentation outline
The four main objects of a database consist of:
form, table, query, report
form, list, database, report
table, query, form, sort
table, column, row, report
You are working on a database and have been asked to extract a report to be used in a word processed document.
What should you do?
Create the report and then export it to Excel, to then copy and paste the table into the word processed document
Print it off and scan it as an image
Use the word processed document software to 'insert' a database
Take a screenshot and insert it into the word processed document
A picture is an element of a web page, select two others from below.
Sounds
Hyperlink
Colours
Layout
What is wrong with this line of HTML?
<h3>This is a club aiming to help people of all ages learn ICT<h3>
both h3 should be >h3<
The second h3 should be </h3>
h3 does not exist
The first h3 should be <h3/>
