Assignment title: Information
Select the application for which a spreadsheet would be least appropriate: a. Class list b. Publishing c. Budget d. Mortgage repayments 2 The active cell is: a. A cell where the formula appears b. Filled with values only c. The cell holding the cursor d. Anywhere that data can be entered When entering data, which of these represents a correctly entered formula a. (C17*C18) b. SALES c. =A9/B9 d. -IF(A16>B15),*B9,/16) 4 A cell in a spreadsheet is: a. a row b. a column c. a row/column intersection d. a piece of data Which of the following is not a benefit normally obtained from using an electronic spreadsheet: a. Accuracy of calculations b. Ability to produce charts c. Savings on disk space d. Ease of update 6 A group of cells in a spreadsheet could be described as a: a. range b. formula c. text d. macro 7 Which of the following is an example of text in a spreadsheet? a. 2763 b. Sales 1994 1995 c. =A1+A2+A3 d. =sum (A1+A2+A3) 8 Which of the following represents a range in Excel: a. B2+B7 b. B2-B7 c. B2:B7 d. B2*B7 9 When you have a problem, what kind of assistance can you get from the spreadsheet program: a. the help facility provided by the program b. none, you have to ask somebody c. you have to access a different program d. none of the above 10 Which function key is used to access on-line help a. F3 b. F2 c. F5 d. F1 11 Name three tasks that electronic spreadsheets may be used for: 12 Explain briefly what is done by the Excel formula =SUM (A1:A6).