1 / 23

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.

lala
Download Presentation

Chapter 2 Excel Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 2 Excel Review

  2. True or False? • A series of number signs (######) appearing in a cell indicates that the data is wider than the column. • True

  3. 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

  4. 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

  5. True or False? • You can place a border around the entire cell or only on certain sides of the cell. • True

  6. True or False? • If you copy into cells already containing data, the data will be replaced by the copied data. • True

  7. True or False? • The default format for data in a cell is Text. • False – the default is called general

  8. True or False? • The Fill Down and Fill Right Commands are available only if you plan to fill to adjacent cells. • True

  9. True or False? • The Paste Command is used for both Copy and Paste. • False

  10. True or False? • Deleting a row or column will erase the data contained in the row or column. • True

  11. True or False? • The Insert Row is in the Cells group on the Home Ribbon. • True

  12. You are tired of keying repetitive data - you should… • Use the Fill Command

  13. Moving part of a spreadsheet somewhere else – you should … • Highlight – drag & drop

  14. You forgot to key a row of data – you should… • Choose Insert from the Cells group and insert a new row

  15. You don’t need a certain row any longer – you should… • Click the number to the left of that row and delete the row.

  16. Printing a copy of the spreadsheet – you should… • Go to the Office Button - Print

  17. You would like to only print part of your spreadsheet • Highlight the data you want to print. Go to Office Button - Print – Print Selection

  18. Short Answer • What cell format displays numerical data preceded by a dollar sign? • Currency

  19. 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

  20. Short Answer • What are three reasons for rotating text? • Save Space • Looks Attractive • Labels for columns

  21. 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

  22. Short Answer • What are the three cell alignment buttons available on the toolbar? • Left, Center, Merge & Right

  23. There is more on the test than these few questions. Please study your notes from chapter two. Good Luck!

More Related