Spreadsheets and Presentations Actual Questions 2024 with Solved Solutions

Identify the parts of a spreadsheet by using the drop-down menus to select the part that corresponds to the labeled diagram to the right. A B C D E - row column workbook cell sheet The spreadsheet below shows how much money each store raised for charity during the months of January, February, and March. Using this information, answer the following questions. To obtain the total amount raised by Store 1, which range of cells would you use? - B2:B4 Which function will yield the total amount raised by each store from January through March? - SUM Suppose one hundred stores participated in the fund-raiser for one year. What would be the most efficient way to calculate totals and store averages by month? - Using the sum and average functions on the range of cells Read the scenario below, and then answer the question to the right. The manager of a small engineering company is setting up a spreadsheet to help track cash flow for each month. The spreadsheet will track incoming payments from clients. It will also track outgoing payments for rent, utilities, employee salaries, and insurance.