Question 3 1 pts 0%. The image below is an excerpt from a spreadsheet showing weekly sales at a local car yard. In examining this excerpt we can see that the user is about to: B % Manufacturer Sale Price Position Sold by Held Commissio 21 Sort A to Z ulie Sales At Sort Z to A D Sales 0% Sort by Color rendan Senior Sales 0% buie Senior Sales 0% Clear Filter From "Manufacturer rendan Senior Sales 0% Filter by Color Senior Sales 0% Text Filters Sales 0% Search . Sales 0% (Select All) rendan Senior Sales 0% Audi buie Senior Sales 0% BMW Sales 0% Holden Mitsibushi Toyota buie Select all the sales with the exception of cars manufactured by Holden Sort the manufacturers into alphabetical order View only the data relating to Holden cars Filter the data by manufacturer and sale price D Question 4 1 pts "The most improved sales figure at Commercial Dry Cleaning in 2018 in Victoria was achieved by Richard". What form of business analytics was conducted to generate this piece of information? Prescriptive analytics Predictive analytics Descriptive analytics Learning analytics Question 5 1 pts Jenny Nguyen owns a seaside cottage which she rents out for the holiday season. She offers a discount to customers if they rent for five nights or more. She has created a spreadsheet to calculate any discount and revenue for each booking that she makes. She uses an IPO chart to plan the spreadsheet design. With regard to the discount calculation which of the following would be listed as 'input'? Number of nights booked Discount (5) If number of nights booked is greater than or equal to minimum nights to receive discount apply discount %, otherwise leave blank Customer name Question 6 1 pts The spreadsheet below shows class enrolments. The class limit is 20 students. If more than 20 students are enrolled in any one class a limit warning has been generated. An if function has been entered correctly in column C2 and filled down to C5. With reference to this example the correct formula for cell C5 is: D 2 Class Limit 20 1 Class ID Number enrolled Limit Warning 15 3 21 over the limit 18 23 over the limit 1 2 4 5 3 4 if(B55>F2, "over the limit", "") if(5>$F$2,over the limit, o) =f(B5>$F$2, "over the limit") =ff(B5>$F$2,"over the limit","") Question 7 1 pts The spreadsheet below is used to calculate the costs for purchases of paper for an organisation. They require several sizes and colours for photocopying. They use a higher grade of presentation paper to produce pamphlets and other advertising materials. What is the name of the formula that will be used to look up the costs of different paper types from the table H2:16? B16 G H Hammer Wines - April Orders - Stationery cost for IN 2 Order date Paper type Colour 3-Apr Copy paper A4 White 3-Apr copy paper A3 White Copy paper A4 5 10-Apr coloured Pink Number of Per rheem Rheems Total cost ordered paper type for order 100 30 Paper cost (per Paper type rheem) Copy paper A4 $ 5.00 Copy Paper A3 $ 9.50 Coloured copy paper A4 $ 6.00 High gloss presentation paper $ 20.00 20 6 20 Copy paper A4 15-Apr coloured Blue High gloss presentation 15-Apr paper White 20 Apr copy paper A4 White 20-Apr Copy paper A3 7 8 100 100 201 Total cost 10 11 HLOOKUP VLOOKUP COUNT RANGE LOOKUP Question 8 1 pts The graph below describes the house and unit market in Melbourne from 2004 to 2012. With reference to this graph which of the following is true? Monthly Property Prices Annual Property Prices Median sale prices in Melbourne Median House Price 515M Median Unit Price $10M A 3500K SO 2004 2005 2006 2007 2000 2009 2010 2011 2012 Between 2004 and 2012 Median sales prices for houses outperformed units every year. Unit prices spiked in 2006 During 2008 all houses sold for a higher price than a unit. Throughout the eight year period median unit prices have shown an upward trend. When designing a spreadsheet model we aim to make the workbook dynamic. In this instance 'dynamic refers to a feature enabling Excel to: O copy and paste from one worksheet to another link data so that data within a workbook is automatically updated when the source data cell is updated. embed an object into a spreadsheet. O copy and paste from one workbook to another. Question 10 1 pts With reference to the Excel spreadsheet below, the heading "Friday_Classes is an example of: Friday_Classes Friday B 1 Course Class Type Day 2 busines computing 1 Practical Friday 3 busines computing 1 Practical Friday 4 busines computing 1 Practical Friday 5 busines computing 1 Practical Friday 6 busines computing 1 Practical Friday 7 busines computing 1 Practical Monday 8 busines computing 1 Practical Monday 9 D Begin Time End Time 8.30 10.30 10.30 12.30 12.30 14.30 16.30 18.30 18.30 20.30 10.30 12.30 12.30 14.30 O A range name A worksheet name A cell reference A column heading