NEW
Font size
WorksheetsS3 Spreadsheet Formatting Skills
Total questions: 15
Worksheet time: 8mins
What feature in spreadsheets allows text to display on multiple lines within a single cell?
Text Split
Wrap Text
Multi-line Format
Cell Expansion
Which option must be selected to combine multiple cells into one larger cell?
Join Cells
Combine and Center
Merge and Centre
Unite Cells
When applying currency formatting to a cell, what symbol automatically appears?
Percentage sign (%)
Pound sign (£)
Hash symbol (#)
At symbol (@)
Which feature allows you to add color to the background of cells?
Cell Color
Background Fill
Shading
Cell Paint
What happens when you apply a border to selected cells?
The text becomes bold
A line appears around the selected cells
The cells merge together
The text becomes centered
Which menu typically contains the Wrap Text feature?
Insert
Home
View
Data
What happens if you merge cells that contain different values?
All values are preserved
Only the leftmost value is kept
Values are added together
All values are deleted
How can you quickly remove all formatting from a cell?
Press Delete key
Clear Formatting option
Reset Cell option
Format Painter tool
Which feature allows you to copy formatting from one cell to another?
Format Painter
Copy Style
Format Clone
Style Brush
What is the primary purpose of cell shading?
To make text bold
To highlight important information
To merge cells
To wrap text
When inserting graphics into a spreadsheet, what is important to consider?
Graphics must be black and white
Graphics can only be placed between cells
Graphics can affect cell sizing
Graphics must be square-shaped
Which formatting option affects how numbers with decimals are displayed?
Text wrapping
Number formatting
Cell shading
Border style
What happens to merged cells when you sort data?
The merge is automatically removed
The sort cannot be performed
Only the visible cells are sorted
The worksheet crashes
Which border option allows you to add lines to specific sides of a cell?
Outside Borders
All Borders
Custom Borders
Border Styles
What happens when you apply currency formatting to text?
Text converts to numbers
Nothing changes
An error message appears
The cell shows #VALUE!
