Font size
WorksheetsS3 Admin and IT Spreadsheets
Total questions: 15
Worksheet time: 9mins
MATCH SPREADSHEET FUNCTIONS
*
MULTIPLY
/
DIVIDE
AUTOSUM
-
SUBTRACT
Which tool is used to combine multiple cells into one
Merge and Center
Data Validation
Wrap Text
Conditional Formatting
What happens when you apply the "Wrap Text" feature to a cell?
It moves text to another cell
It deletes extra text in the cell
It displays all the text within the cell by adjusting its height
It changes the text font to bold
Which of the following can make text easier to read in a spreadsheet?
Bold and Italics
Text Alignment
Changing Font Size
All of the above
Which number formatting option would you use to show £ symbols in a column?
Percentage
General
Currency
Accounting
Identify what is missing from this Pie Chart?
Data Labels
Legends
Chart Title
All of above
Identify the job role with the highest total salary cost.
Manager
Warehouse Staff
Showroom Staff
Depute Manager
Identify where a Chart Title should be inserted?
What should the Y Axis Title be called?
saLary Cost
Salary Cost
Salaray Cost
SaLAry cOst
What EXTRA Step is required in Printing of Formula view?
Adding Footer
Gridlines Ticked
Fit to One
Row and Column Heading added.
Identify Points on Excel Ribbon
If you want to make the titles in your spreadsheet stand out, which combination of formatting tools would you use?
Increase text size, bold, and add a background color
Decrease text size and change to italic font
Highlight the titles and apply Conditional Formatting
Make no changes
What does it mean when a cell in Excel displays ##### instead of its content?
The cell contains an error in the formula
The column is too narrow to display the content
The content is corrupted and cannot be displayed
The cell has been locked
Why is it important to keep text size consistent in a spreadsheet?
It helps with sorting data
It prevents errors in formulas
It automatically adjusts cell borders
It makes the spreadsheet look professional and easier to read
Which text size would you use for a title to make it stand out compared to the rest of the spreadsheet?
Smaller than the default text size
The default size with a bold style
Same as the rest of the text
Larger than the default text size (e.g., 16 or 18)
