Flashcards on Computer Applications Technology Overview
Computer Applications Technology Overview: A Student Guide
Tap to flip · Swipe to navigate
Spreadsheets text & formatting
25 cards
Card 1
Question: How do you centre text horizontally across multiple cells for a main heading (e.g., A1 across A1:G1)?
Answer: Merge the cells and click the Centre (Merge & Centre) option to merge and centre the heading across the selected range.
Card 2
Question: How do you wrap column headings so they appear over two lines and are fully visible (e.g., A2:G2)?
Answer: Select the heading cells and enable Wrap Text so the text breaks onto multiple lines and is visible.
Card 3
Question: Which icon aligns text vertically in the middle of a cell from top to bottom?
Answer: Use the Middle Align icon (vertical centre alignment) to centre text vertically within cells.
Card 4
Question: Which steps centre all text vertically for an entire worksheet region (example: select A3:G13)?
Answer: Select the desired cell range, then click the Middle Align (vertical centre) icon to centre text top-to-bottom in those cells.
Card 5
Question: How do you change the number of decimal places for a range (example: A2:A19) using Format Cells?
Answer: Select the range, right-click and choose Format Cells; under the Number tab select Number and change Decimal places to the desired value (e.g., 1).
Card 6
Question: How do you format a range as Currency with a specific symbol (example: B2:B19 to South African Rands)?
Answer: Select the range, right-click Format Cells; under the Number tab choose Currency, set Decimal places (e.g., 2) and choose the symbol (e.g., R English
Card 7
Question: What happens to the underlying cell value when you apply Currency formatting with rounding (example shows 128.3188608)?
Answer: The displayed value is rounded (e.g., R128.32) but the formula bar still shows the full underlying value (e.g., 128.3188608).
Card 8
Question: How do you format a range in Accounting with a currency symbol on the left (example: C2:C19 to Rands)?
Answer: Select the range, right-click Format Cells; under the Number tab choose Accounting, set Decimal places (e.g., 0) and select the symbol (e.g., R Englis
Card 9
Question: What is the difference in symbol placement between Currency and Accounting formats?
Answer: Accounting places the currency symbol at the left of the cell; Currency places the symbol immediately before the value.
Card 10
Question: How do you format a column as Percentage using Format Cells or a shortcut (example: E2:E19)?
Answer: Select the range, right-click Format Cells; under the Number tab choose Percent. Or use the shortcut Ctrl+Shift+% or click the Percent Style icon.