13 Layout (3)
Resources |
Revision Questions |
Information Communication Technology ICT
Login to see all questions
Click on a question to view the answer
1.
A teacher has created a table in a spreadsheet to list students and their attendance records. The table contains columns for 'Student Name', 'Date', and 'Present/Absent'. A student, 'Alice Smith', was absent on 2024-03-15. The teacher wants to delete the entire row corresponding to Alice Smith's absence. Explain how the teacher would achieve this using the spreadsheet software and what considerations should be made before deleting a row.
To delete a row, the teacher should:
- Select the row number corresponding to Alice Smith's absence (e.g., click on the row number '5' if it's the fifth row).
- Right-click on the selected row number.
- Choose the 'Delete' option from the context menu. This will remove the entire row, including all the data within it.
Considerations before deleting a row:
- Data Integrity: Ensure that deleting the row will not cause any data loss or break any formulas that rely on that row.
- Backup: It's always a good practice to save a backup copy of the spreadsheet before deleting any data.
- Accidental Deletion: Be certain about the row to be deleted to avoid accidental data loss. Some spreadsheet programs offer an 'Undo' function, but it's not always reliable.
2.
A student is designing a report and wants to include an image alongside a short description. The image is wider than the text description. Explain how the student can ensure the text wraps around the image to create a visually appealing layout. Describe the steps involved and the benefits of using this technique.
To wrap text around an image, the student should use the 'Wrap Text' feature in their word processing software (e.g., Microsoft Word, Google Docs). This feature allows the text to flow around the image, creating a more integrated and visually appealing layout.
Steps Involved:
- Insert the image into the document.
- Select the text that needs to wrap around the image.
- Right-click on the image and choose 'Wrap Text' from the context menu.
- Select one of the wrapping options:
- Square: The text will wrap to fill the entire width of the image.
- Tight: The text will wrap to fit within the image's width, with minimal spacing. This is usually the most readable option.
- Above and Below: Text wraps above and below the image.
Benefits of using text wrapping around images:
- Improved visual appeal: Creates a more dynamic and engaging layout.
- Better readability: Keeps the text and image together, making it easier to understand the relationship between them.
- Efficient use of space: Utilizes the available space effectively, preventing wasted areas on the page.
3.
A company is creating a spreadsheet to list products and their prices. The table has columns for 'Product Name', 'Cost', and 'Selling Price'. Two products, 'Widget A' and 'Widget B', have very similar selling prices (differing by only £0.50). The company wants to merge the cells in the 'Selling Price' column for these two products to display a combined selling price and a note indicating that they are similar in price. Describe how the company would merge these cells and what information should be included in the merged cell.
To merge cells, the company should:
- Select the two cells in the 'Selling Price' column that contain the selling prices of 'Widget A' and 'Widget B'.
- Right-click on the selected cells.
- Choose the 'Merge Cells' option from the context menu.
Information to include in the merged cell:
- Combined Selling Price: Display the average or a representative selling price of the two products (e.g., (£X.Y5)).
- Note of Similarity: Include a brief note indicating that the products have similar selling prices (e.g., "Similar Selling Price").
- Product Names: Clearly indicate the product names associated with the merged price (e.g., "Widget A & Widget B").
Example of the merged cell content:
The content of the cell would be formatted to clearly convey the combined selling price and the reason for the merge.