Formatting

Card 1 of 19 0 got it 0 still learning

Question

TapClick or press space to see the answer

Answer

All 19 cards in this set

Why is formatting added to a spreadsheet of data?: It makes the data clearer and easier to read
The text in one column is cut off because the column is too narrow. Which action shows all of the data?: Dragging the line between the column letters
A student needs to format columns A, C and E at the same time. What should they do?: Click A, hold Ctrl and click C and E
A student wants every letter in the sheet to use a different style of lettering. Which formatting option do they change?: Font
A student selects a cell and changes the text size to 18. What does this change?: The letters in the cell are shown larger
A student needs to select exactly the cells from A1 to D20 before adding borders. Which action does this?: Click A1, hold Shift and click D20
A sheet lists product codes, quantities and prices. Which column should be formatted as currency?: The column of prices
A student applies bold and a fill colour to a cell holding the number 12.5. What has changed?: How the number looks on screen
A student has selected a table of data and wants a line around every cell, including the edge of the table. Which Borders option should they choose?: All borders
A student gives the heading row a fill colour that is different from the rest of the sheet. Why does this help?: The headings look different from the data below
Which term describes making the data in a cell darker so that it stands out from the rest?: Bold
What is meant by shading?: Filling a cell or group of cells with a chosen colour
What is the name for the lines drawn around the edge of a cell or group of cells?: Borders
What is meant by alignment?: Moving the data to the left, centre or right of a cell
Which term describes keeping the headings on screen at the top of a sheet while you scroll down through lots of data?: Freezing the top row
What is meant by currency format?: A format that adds a pound sign and shows numbers to two decimal places
Which formatting tool changes the colour of the letters shown in a cell?: Text colour
A column of short product codes would look neater in the middle of each cell instead of at the left edge. Which formatting should be applied?: Set the alignment to centre
A student wants the headings in row 1 to stand out from the data below them. Which formatting is best?: Bold text and a different fill colour

Formatting

Round complete