PH490A-QUIZ#1

Insert a Row

A new row is always inserted ABOVE the row you have highlighted. Highlight the row (Right Click ) select "Insert"

Freeze Panes

Click on the views ribbon select "Freeze Panes" on the "View" ribbon to allow you to hold the columns to the left (and rows above) fixed as you scroll across and down. Highlight the cell in the first column to the right of the column(s) you want to remain fixed and in the row just below the rows to be held fixed.

Insert a column

Highlight the column to the RIGHT of the location you want the new column (Right Click) select "Insert"

Hiding Columns

Highlight the columns you want to hide, and with the cursor in the highlighted columns, right click and select "Hide."

Wrap Text

Is used if the text in a cell is too long to fit and you prefer not to extend the width of the cell. Highlight the column (or cell[s]) you want to format and select "Wrap Text" on the "Alignment" menu.

Delete a Cell

Place the cursor in the cell you want to delete, (Right click) select "Delete" --After selecting "Delete Cells" or "Delete, you will see an additional dialog box asking you to decide how you want to fill that empty space.

to include numbered rows in your worksheet

Step 1: Type the number you wish to begin with in the desired cell. Step 2:click on the "Fill" on "Editing" menu on the "Home" ribbon and select"Series." Step 3: select preferences

Delete a Column

To delete a column (or columns), highlight the column(s) to be deleted (Right Click) select "Delete"

Formatting Numbers

To format numbers, highlight the cells to be formatted. (Right Click) select "Format"

To adjust the entire worksheet

To make adjustments to the entire worksheet, click in the box to the left of column A and above row 1. This will highlight all of the cells. You may then adjust rows and columns as previously described. This will adjust all rows or columns to the same height or width.

Adding a new worksheet

You can add a new worksheet to your workbook by selecting "Insert Sheet" on the "Insert" menu.

To make the Hidden Columns visible

highlight the column immediately to the left of the first hidden column and the column immediately to the right of the last hidden column. With the cursor in the highlighted columns, right click and select "Unhide."

Inserting more than one Column

highlight the number of columns to the RIGHT of the location you want them (Right Click) select "Insert"

To adjust multiple columns or rows at the same time

highlight them. Follow the same procedure in adjusting the width/height as you would for one column/row

Formatting Cells

highlighted the desired cells right click on the mouse and select "Format Cells."

Adjusting Column Width and Row Height

move the cursor to the column/row heade and place it on the RIGHT-hand margin or BOTTOM margin of the column/row you want to adjust. Hold the left mouse button down and move the mouse until the column/row is the desired width/height

Cell Reference

referring to cell by name "A1", "C8","K12"

How to "Autofit"

select "Format" on the "Cells" menu (on the "Home" ribbon) Click "AutoFit Column Width" or "AutoFit Row Height" to adjust the height/width of the cells to fit the data present.