excel formatting
patterns can make it harder to read the data than using a solid color
instead of a pattern, why might you prefer to apply a background color to a cell?
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
which key can you press to activate the go to command?
=
which indicates the contents of a cell are a formula?
on the home tab, in the cells group, click format, click column width and enter the measurement
which is the best way to set up a column to a specific width?
a blank workbook
which new workbook option displays the title, book 1, when it is created?
a marquee appears around the selected cells for the cut or copy command
what displays when you activate the cut or copy command?
there must be a blank row or column 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?
borders can help to separate and identify specific cells
why might you want to apply borders to a cell instead of just using gridlines on the worksheet?
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?
giraffe
what mammal doesnt have any vocal cords
above the current row
when you insert a row, where does excel place it in a relation to the cursor position?
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?
horizantally, vertically or rotated
how can data be aligned within a cell?
3
how many hearts does an octopus have?