Excel Formatting
Patterns can make it harder to read the data than using a solid color.
What is, 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?
CTRL+G
what is, Which key can you press to activate the Go To command?
what indicates the contents of a cell are a formula?
This team has won 27 World Series championships
what is, the yankees
horisontally, vertically, or rotated
How can data be aligned within a cell?
A blank workbook
Which new workbook option displays the title, Book1, when it is created?
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?
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?
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?
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 contigous?
Click the row header for the row you want to select
To select an entire row, where would you click
Turn on the My data has headers option.
What has to happen in order for column headings to display in the Sort fields?
labels identify the values and help outline the mathematical relationships.
Why would you enter labels into the worksheet?
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 blank workbook
Which new workbook option displays the title, Book1, when it is created?
you can also manipulate the filtered data wihtout affecting the rest of the data
Why might you choose to filter or list a table by simply sorting it?
What is, the most sold Nintendo game