Homework 2 ITCM 205 – Construction Estimating and Costs
Points: 20
Robert Bartley Due: Monday, Feb-2-2015

1. What is the difference between a workbook and a worksheet?
An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A. Each cell can contain a number, text or formula
2. What three ways can be used to save a workbook?
You can save to a one drive or to a cloud, or like usual and save to a jump drive or to your computer.
3. How are worksheets added to a workbook?
To insert a new worksheet into the workbook, right-click a sheet tab, click Insert on the shortcut menu, select a sheet type, and then click the OK button
4. How can a copy of a worksheet be created? To copy a worksheet, just press the Ctrl key as you drag and drop the sheet tab
5. How are worksheets renamed?
Double click the sheet tab to select the name, type a new name for the sheet and press enter
6. If you were to cut the contents from Cell H15 and then save the worksheet, what would happen to the contents from Cell H15? The contents would be erased because you used the cut feature not the copy feature.
7. Besides using the Column Width dialogue box, what are two other ways to change the width of a column? You can use the ribbon option for the cells or click the line between the two cells to change the size.
8. What are two ways to change the font for a cell? Double click the font you want to change, or at the top left on the ribbon of excel
9. What does the Merge and Center button do? When you merge two or more adjacent horizontal or vertical cells, the cells become one larger cell that is displayed across multiple columns or rows.

10. How do you add the worksheet name to the header of the worksheet?
Click the worksheet to which you want to add a predefined