8.3. Using a spreadsheet
A subsection of Information Technology, 9626, through 8. Spreadsheets
Listing 7 of 7 questions
Below is an extract from a company’s database which shows the details of their factory workers. Workers_Id Cisse Traore Dia Kone Diop Fall Contee Keita Gallo Diallo Koulthum Adama Omar Mame Souleymane Leo Henry Sundiata Jerry Noumu Extrusion Cold rolling Cold rolling Tube production Tube production Extrusion Extrusion Foundry Foundry Hot rolling Family_Name First_Name Department Salary $43,000.00 $35,000.00 $39,000.00 $34,500.00 $32,000.00 $37,500.00 $36,000.00 $29,000.00 $41,500.00 $28,500.00 Describe the steps you would use to create a report containing the Workers_Id number and Salary only, using the most efficient method to extract all the Hot rolling or Cold rolling workers whose salary is greater than $35,000.
9626_w17_qp_11
THEORY
2017
Paper 1, Variant 1
View
Below is an extract from a company’s database which shows the details of their factory workers. Workers_Id Cisse Traore Dia Kone Diop Fall Contee Keita Gallo Diallo Koulthum Adama Omar Mame Souleymane Leo Henry Sundiata Jerry Noumu Extrusion Cold rolling Cold rolling Tube production Tube production Extrusion Extrusion Foundry Foundry Hot rolling Family_Name First_Name Department Salary $43,000.00 $35,000.00 $39,000.00 $34,500.00 $32,000.00 $37,500.00 $36,000.00 $29,000.00 $41,500.00 $28,500.00 Describe the steps you would use to create a report containing the Workers_Id number and Salary only, using the most efficient method to extract all the Hot rolling or Cold rolling workers whose salary is greater than $35,000.
9626_w17_qp_12
THEORY
2017
Paper 1, Variant 2
View
Below is part of a spreadsheet Jose has created to model his personal finances.  A B 1 $2,600 Wages/salary 3 $120 Utilities 4 $100 Satellite/TV 5 $80 Phone 6 $30 Pet food 7 $1,000 Mortgage/rent 8 $80 Internet 9 $100 Insurance 10 $75 Hair/beauty 11 $550 Groceries 12 $150 Eating out 13 $100 Clothing 14 $40 Cinema 15 $160 Car/travel 17 $2,585 Total outgoings 19 $15 Balance Using only the sort feature explain how you would be able to get the following values in the given cells. $80 in cell A11 with Internet in cell B11 and $1,000 in cell A3. $100 in cell A8 with Clothing in cell B8.
9626_m17_qp_12
THEORY
2017
Paper 1, Variant 2
View
Questions Discovered
7