230 likes | 253 Views
Test your Excel knowledge with these true or false questions related to formatting, editing, and printing spreadsheets. Learn important functions and shortcuts to enhance your Excel skills. Good luck!
E N D
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 four cell alignment buttons available on the ribbon? • Left, Center, Merge & Right
There is more on the test than these few questions. Please study your notes from chapter two. Good Luck!