Formatting - Word Drop

By default, data in a spreadsheet is ______, which makes it hard to read. Formatting makes a sheet clear, easy to read and professional looking, and it helps the headings stand out. Heading text is made ______, which makes the characters darker and thicker. The ______ decides the shape of the lettering, for example Arial, while the text size decides how large it is. The ______ tool changes the colour of the characters, leaving the cell background unchanged.

To move data to the left, centre or right of a cell, use ______. The fill colour tool, also called ______, fills a cell background with a chosen colour using the paint bucket icon. The lines drawn around the edge of a cell or group of cells are ______. If a column is too narrow, drag the line between column letters to change its ______.

Numbers that represent money should be given the ______ format, which adds a pound sign and shows two decimal places. Use ______ to hold the top row in place, so the headings stay on screen while you scroll down. When formatting a data sheet, add borders to all the data, then emphasise the heading row. Freeze the top row, centre short codes, then finish with the money columns.