Excel Formatting
Patterns can make it harder to read the data than using a solid color.
What is applying a background color instead of applying a pattern to the cell?
A blank workbook.
Which new workbook option displays the title, Book1, when it is created?
On Ebay with price tags in the thousands.
Where are the Nvidia 3000 series cards, and what are their prices?
Borders can help to separate and identify specific cells.
What is the application of borders to a cell instead of gridlines on the worksheet?
Horizontally, vertically, or rotated
How can data be aligned within a cell?
$474.00
What is the MSRP for the Intel i9-10900KF?
Above the current row
What is the insertion location relative to the cursor when you insert a row?
Click the row header for the row you want to select
To select an entire row, where would you click
CTRL+G
What is the key can you press to activate the Go To command?
Labels indentify the values and help outline the matematical relationships
Why would you enter labels into the worksheet?
$499.00
What is the MSRP for the Nvidia 3070 Founders Edition?
Turn on the My data has headers option.
What has to happen in order for column headings to display in the Sort fields?
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?
A marquee appears around the selected cells for the Cut or Copy command
What displays when you activate the Cut or Copy command?
What indicates the contents of a cell are a formula?
$549.99
What is the MSRP for a AMD Ryzen 9 5900X?
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?
Expenses appear to increase in the first three months
What do you notice about the chart in the following?
$1499.00
What is the MSRP for the Nvidia 3090 Founders Edition?