S3 Admin and IT Spreadsheets

MATCH SPREADSHEET FUNCTIONS

• MULTIPLY

• *

• SUBTRACT

• -

• DIVIDE

• /

• AUTOSUM

• 

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.