excel formatting
Patterns can make it harder to read the data than using a solid color.
Why might you prefer to apply a background color to a cell instead of applying a pattern?
A workbook is the actual file that contains the worksheets, which turn contain the data.
what is the difference between a workbook and a worksheet?
use CTRL+G.
Which key is to activate the Go To command?
Click the row header for the row you want to select.
To select an entire row, where would you click?
a diamond.
What is the hardest rock?
labels identify the values and help outline the mathematical relationships.
why would you enter labels into the worksheet?
Above the current row.
When you insert a row, where does Excel place it in relation to the cursor position?
A marquee appears around the selected cells for the Cut or Copy command
What displays when you activate the Cut or Copy command?
Turn on the My data has headers option.
What has to happen in order for column headings to display in the Sort fields?
How many phases of the moon are there?
A blank workbook
Which new workbook option displays the title, Book1, when it is created?
you can also manipulate the filtered data without affecting the rest of the data.
Why might you choose to filter or list a table by simply sorting it?
On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement
Which is the best way to set a column to a specific width?
Prides.
A group of lions are called what?
How can data be aligned within a cell?
there must not be a blank rows or columns in the range of cells for the table.
What does it mean that the data in the table must be contiguous?
3 hearts.
How many hearts does an octopus have?
Borders can help to separate and identify specific cells.
Why might you want to apply borders to a cell instead of just using the gridlines on the worksheet?
Amazon.
What is the world's longest river?