AS & A Level Information Technology (9626) — October–November 2024, Paper 02
17 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.
Start with Question 1 →Open and carefully examine the file n24chain.csv in a spreadsheet. The values in cells T3 to V3 are changed frequently. Merge cells: A1 to R1, A17 to R17, A30 to R30. Format each…
Answer this question and get it marked →Place in cell E18 a replicable formula to convert the weight in ounces (held in cell E5) into grams. The information in columns T, U and V will help you. Replicate this formula…
Answer this question and get it marked →Place in cell E31 a replicable formula to calculate the cost of the metal used to make each chain. The cost of metal is the weight of the metal multiplied by the cost per ounce…
Answer this question and get it marked →Place formulas in appropriate cells in column B to calculate the length of each chain, rounded down to the nearest centimetre. 1 inch = 2.54 centimetres.
Answer this question and get it marked →Place in cell E4 a formula that does not use the concatenate function to extract the first character from cell E2 and concatenate it with the Style for this item. Replicate this…
Answer this question and get it marked →Apply appropriate formatting to the cells containing numeric values. Save your workbook.
Answer this question and get it marked →Add a new worksheet called User Interface to your workbook.
Answer this question and get it marked →In the User Interface worksheet, enter the text shown and format it to match the supplied layout. The layout has, in column A/B: row 1 'Cost calculator', row 2 'Please select the…
Answer this question and get it marked →In cells B4 and B5, create drop-down menus to select the chain code and length.
Answer this question and get it marked →In cell B7, use a function to look up the type of metal selected using the Chain code.
Answer this question and get it marked →In cell B8, use INDEX and MATCH functions to display the weight of metal in grams for the selected Chain code and Length in centimetres.
Answer this question and get it marked →In cell B9, use INDEX and MATCH functions to display the cost of metal for the codes and lengths selected from the drop-down menus.
Answer this question and get it marked →Apply appropriate formatting to column B of the User Interface worksheet. Save your workbook.
Answer this question and get it marked →Create a new word-processed document. Save this document in rich text format with the file name n24Evidence followed by your centre numbercandidate number. Model this spreadsheet,…
Answer this question and get it marked →Change the price of gold to 1900 dollars per ounce. Model this spreadsheet with a chain code of GC2 and a chain length of 50 cm. Place screenshots showing both the data entered…
Answer this question and get it marked →Open the file n24audio.mp3 in a suitable audio-editing package. Change the speed of the track so that it is twice the original speed. Change the pitch of the track from the key of…
Answer this question and get it marked →Jenna's Jewellery requires a small flat-file database to hold details of their customers. Open and carefully examine the data in the file n24cust.csv. In your evidence document,…
Answer this question and get it marked →← October–November 2024 Paper 04 · May–June 2024 Paper 33 →
← All AS & A Level Information Technology (9626) past papers