8 Spreadsheets (3)
Resources |
Revision Questions |
Information Technology IT
Login to see all questions
Click on a question to view the answer
1.
Question 3
A survey was conducted to find out people's preferred method of communication. The results are shown in the pie chart below:
(a) State the percentage of people who prefer email as their preferred method of communication.
(b) Calculate the number of people who prefer face-to-face communication, assuming a total of 500 people were surveyed.
(c) Explain why a pie chart is a suitable way to represent this type of data.
(a) From the pie chart, the slice representing email occupies 30% of the circle. Therefore, 30% of people prefer email as their preferred method of communication.
(b) The pie chart shows that 20% of people prefer face-to-face communication. If 500 people were surveyed, then the number of people who prefer face-to-face communication is 20% of 500, which is (20/100) * 500 = 100 people.
(c) A pie chart is a suitable way to represent this type of data because it effectively shows the proportion of different categories relative to a whole. Each slice of the pie represents a category, and the size of the slice is proportional to the percentage of people who prefer that category. This makes it easy to visually compare the relative popularity of different communication methods.
2.
A small business uses a spreadsheet to track inventory. The spreadsheet contains columns for Product ID, Product Name, Quantity in Stock, and Unit Price. The business owner wants to automatically calculate the total value of the inventory for each product. Describe how you would use a spreadsheet function to achieve this, including the specific function and the arguments required. Explain how you would apply this function to the entire inventory table.
To calculate the total value of inventory for each product, I would use the SUMPRODUCT function. This function allows you to sum the products of arrays. In this case, we need to multiply the Quantity in Stock by the Unit Price for each product and then sum these individual values.
The formula would be: =SUMPRODUCT(Quantity in Stock, Unit Price)
To apply this to the entire inventory table, I would enter this formula into a new column (e.g., 'Total Value') and then use the autofill feature (by dragging the small square at the bottom-right corner of the cell) to copy the formula down to all rows in the table. The spreadsheet software will automatically adjust the cell references to calculate the total value for each product.
3.
Explain how you would set up the page setup in a spreadsheet to ensure that a table of data, including headers, fits entirely on a single printed page. Describe at least three specific settings you would adjust and justify your choices.
To ensure a table of data, including headers, fits entirely on a single printed page, I would adjust the following page setup settings in Microsoft Excel:
- Margins: I would reduce all four margins (Top, Bottom, Left, Right) to the minimum acceptable value (typically 0.5 inches or 1.27cm). Justification: Reducing margins maximizes the printable area of the page, allowing the entire table to be accommodated.
- Orientation: I would set the orientation to Landscape. Justification: Landscape orientation significantly increases the width of the page, providing more horizontal space for the table.
- Scaling: I would use the "Fit to" scaling option and select "Fit to one page". Justification: This ensures that the entire spreadsheet is scaled down to fit within the single page, even if it means reducing the font size. This is preferable to "Fit to width" which might truncate the table.
By adjusting these settings, the spreadsheet will be formatted to ensure that the entire table, including headers, is printed on a single page without being cut off or requiring multiple pages.