Part C: Information Systems (10 Marks) 11- Based on the following spreadsheet: B с D E F 1 Sales 01 02 03 Q4 Total 2 Van

[answerhappygod]

1 (52.96 KiB) Viewed 25 times

Part C: Information Systems (10 Marks) 11- Based on the following spreadsheet: B с D E F 1 Sales 01 02 03 Q4 Total 2 Vancouver $321.00 $123.00 $99.00 $88.00 $631.00 3 $999.00 $75.00 $32.00 $27.00 $1,133.00 Burnaby Richmond 4 $12.00 $34.00 $56.00 $78.00 $180.00 5 Average $444.00 $77.33 $62.33 $64.33 a) What must be the formula in cell F3? b) What must be the formula in cell ES? c) Circle the cells that would change if Richmond Q4 sales is doubled (goes from $78.00 to $156.00) 12- Write an SQL statement that returns the address and owner of all houses that have a price not less than $200,000 in the following table called ForSale. ID SqFt 2500 110 Address 330 Lougheed. 470 Lindquist St. 12 Ridge Circle. 940 Midway Dr. Price 490000 156000 205999 103 1500 Owner Sharon Yates James Owens Alice Perez Robert Gallant 155 2000 165 1800 304100