Transcript Chapter 2 Excel Review

Chapter 2 Excel Review
True or False?
 A series of number signs (######)
appearing in a cell indicates that the
data is wider than the column.
 True
True or False?
 Wrapped text will begin a new line
within the cell of a worksheet when
the data exceeds the width of a
column.
 True
True or False?
 The Merge and Center button will
combine several cells into one cell
and place the text in the middle of
the merged cell.
 True
True or False?
 You can place a border around the
entire cell or only on certain sides of
the cell.
 True
True or False?
 If you copy into cells already
containing data, the data will be
replaced by the copied data.
 True
True or False?
 The default format for data in a cell is
Text.
 False – the default is called general
True or False?
 The Fill Down and Fill Right
Commands are available only if you
plan to fill to adjacent cells.
 True
True or False?
 The Paste Command is used for both
Copy and Paste.
 False
True or False?
 Deleting a row or column will erase
the data contained in the row or
column.
 True
True or False?
 The Insert Row is in the Cells group
on the Home Ribbon.
 True
 You are tired of keying repetitive data
- you should…
 Use the Fill Command
 Moving part of a spreadsheet
somewhere else – you should …
 Highlight – drag & drop
 You forgot to key a row of data – you
should…
 Choose Insert from the Cells group
and insert a new row
 You don’t need a certain row any
longer – you should…
 Click the number to the left of that
row and delete the row.
 Printing a copy of the spreadsheet –
you should…
 Go to the Office Button - Print
 You would like to only print part of
your spreadsheet
 Highlight the data you want to print.
Go to Office Button - Print – Print
Selection
Short Answer
 What cell format displays numerical
data preceded by a dollar sign?
 Currency
Short Answer
 What is one way to let Excel
determine the best width of a
column?
 Home–Cells–Format-Auto Fit, or click
on the right side of the cell
Short Answer
 What are three reasons for rotating
text?
 Save Space
 Looks Attractive
 Labels for columns
Short Answer
 What is the difference between the
Fill Color and Font Color buttons?
 Fill Color fills the background of the
cell, Font Color colors the font
Short Answer
 What are the three cell alignment
buttons available on the toolbar?
 Left, Center, Merge & Right
 There is more on the test than these
few questions. Please study your
notes from chapter two. Good Luck!