AS & A Level Information Technology (9626) — February–March 2023, Paper 02
12 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.
Start with Question 1 →Create a new spreadsheet that looks like this: Row A B C --- --- --- --- 1 Tile Calculator (merged A1:C1) 2 3 Length of wall 3 metres 4 Height of wall 2 metres 5 Is there a…
Answer this question and get it marked →Open a separate worksheet in your workbook using an appropriate worksheet name and import the data from the file m23sizes.csv Examine this data. Enter formulae in column C to…
Answer this question and get it marked →In the worksheet created in step 1, make sure that cell B5 can only contain a blank cell or the letters Y or N in upper or lower case. Add appropriate text for the user. Do not…
Answer this question and get it marked →In cell B7 make sure that a user can select from a drop down list containing the Size of the tiles from step 2.
Answer this question and get it marked →In cell B8 make sure that a user can select from a drop down list containing only Landscape and Portrait. This cell must not be blank.
Answer this question and get it marked →Enter a formula in cell B13 that uses the orientation of the tile and the tile size to display the horizontal tile size. For example, if the tile is 60 x 30 and is in portrait…
Answer this question and get it marked →Enter a formula in cell B16 to calculate the number of tiles required for a wall with no window. To calculate the number of tiles on a wall, the tiler calculates the number of…
Answer this question and get it marked →Enter a formula in cell B17 to calculate the number of tiles required for a wall with a window. The tiler: - calculates the number of tiles for the whole wall. If a tile has to be…
Answer this question and get it marked →Place formulae in your spreadsheet so that if the tile is square the contents of the cells in A8 and B8 are not visible. Place formulae in your spreadsheet so that when the letter…
Answer this question and get it marked →Test this spreadsheet with the following test data and save each test as a spreadsheet with the given file name followed by your centre numbercandidate number (e.g.…
Answer this question and get it marked →You work for Tracy's Tilers who are creating a number of instructional video clips showing how to tile a room. You will create one of these short video clips. All video and audio…
Answer this question and get it marked →Edit your video clip to match this storyboard: 0 seconds: Take a still image from the first frame of the video clip and set this as a background image. Place the name of the…
Answer this question and get it marked →← February–March 2023 Paper 04 · October–November 2024 Paper 33 →
← All AS & A Level Information Technology (9626) past papers