You typed a long title in cell A1, and you want it to stretch beautifully across the top of your data table from column A to column E as one single, centered block. What formatting tool should you use?, Merge & Center (or Merge Cells + Center Align)., You typed a long paragraph of notes into cell B12. Instead of widening the whole column, you want the text to automatically stack vertically so it all fits inside the current cell width. What tool do you click?, Wrap Text., When you look at your spreadsheet, all the numbers in column C are pushed to the right side of their cells, but the text labels in column A are pushed to the left. What is the name of the ribbon group where you change these positions?, The Alignment group (or Alignment tools)., You typed 0.85 into a cell, but you want it to display to the user as 85%. What formatting button should you click?, Percent Style (or Percentage Format)., Column D shows total revenue, but right now it just looks like raw numbers: 1500.5. You want it to automatically display a dollar sign, commas, and two decimal places ($1,500.50). What specific number format do you choose?, Currency (or Accounting) format., A cell is showing a date as 42736 instead of 1/1/2017 because the computer is reading it as a raw serial number. What formatting dropdown menu do you open to change this back to a readable date?, The Number Format dropdown menu., You just applied a thick border and a yellow fill color to cell A4. You want to instantly copy that exact same yellow fill and border style over to cell H4 without rebuilding it. What tool icon looks like a paintbrush and does this?, Format Painter., Oh no! After applying a currency format to a column of large numbers, the entire column suddenly displays as ### ### ###. What is wrong, and how do you fix it?, The column is too narrow to show the formatted numbers. Fix it by widening the column (or double-clicking the column header boundary to auto-fit)., You want to change the background color of your header row to dark green, but you don't want to change the color of the text itself. What tool icon—which looks like a tipping paint bucket—do you use?, Fill Color., You want to automatically turn a cell's background Bright Red only if the number inside it drops below $0.00. What advanced formatting feature allows you to set up this automatic rule?, Conditional Formatting.

SHOWDOWN

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?