Ch3 Headings Flashcards
1
Q
Excel Window Buttons
A
- Each excel window has five buttons located on the right side of the title bar.
- Buttons are:
- Help
- Full Screen Mode
- Minimize
- Maximize
- Close
2
Q
Excel Window States
A
- Excel windows can be in one of the following states:
- Maximized: Fills the entire screen.
- Minimized: Window is hiddne, but still open.
- Restored: Window is non maximized.
3
Q
Resizing Excel Windows
A
- Make sure the window is not maximized. Click on the title bar and drag it with your mouse.
- To resize the window, Click on one of the borders and drag.
4
Q
Make all windows visible
A
- Choose View -> Window -> Arrange All displays the Arrange Windows dialog box.
- This tiles all of the windows that are currently open in excel.
5
Q
Switching Between Windows
A
- Excel only allows for one window to be active at once. This is the window that accepts input.
- To make another window active:
- Click on the window if it is visiable.
- Press Ctrl+F6 to cycle through all open windows.
- Choose View -> Window -> Switch Windows and select the window from the drop down list.
- Click the Excel Icon in the Windows Taskbar
6
Q
Close Windows
A
- To close windows:
- Choose File -> Close
- Click the close button on the tool bar.
- Press Alt+F4
- Press Ctrl+W
7
Q
Activate a Worksheet
A
- Like workbooks, only one worksheet can be active.
- To activate a worksheet:
- Click the sheet tab.
- Press Ctrl+PGUP or Ctrl+PDDN to move between sheets.
8
Q
Adding New Worksheets to a Workbook
A
- Click the New Sheet Control. It is a plus sign locatd to the right of the last sheet tab.
- Press Shift+F11.
- Right click a sheet tab, choose Insert from the shortcut menu.
9
Q
Delete a worksheet
A
- Right click the sheet tab and choose delete from the shortcut menu.
- Activate the unwanted worksheet and click Home -> Cells -> Delete -> Delete Sheet.
- To select mulitple sheets, press Ctrl while clicking on the sheets that you want to delete.
10
Q
Change the Color of a Worksheet Tab
A
Right click the tab, choose tab color from the shortcut menu.
11
Q
Rearranging Worksheets
A
- To move or copy a worksheet:
- Right click the sheet tab. Choose move or Copy.
12
Q
Prevent Sheet Actions
A
- To prevent sheets from being unhidden, inserting new sheets or other actions:
- Choose Review -> Changes -> Protect Workbook.
- Select the Structure option.
- Enter a password.
13
Q
To make a very hidden sheet
A
- A very hidden sheet does not appear in the Unhide dialog box.
- Choose Developer -> Controls -> Properties.
- In the dialog box, select the visible option and choose 2 xlSheetVeryHidden.
14
Q
Hide and Unhide a Worksheet
A
- To hide a worksheet:
- Right click the sheet tab and click Hide Sheet.
- To unhide a worksheet:
- Right click any sheet tab.
- Choose unhide sheet.
- A dialog box will appear that shows all of the hidden sheets.
- Choose the sheet you want to display.
15
Q
View Two Worksheets at the same time
A
- To create and display a new view of the active workbook:
- Choose View -> Window -> New Window
- Excel will show the difference in the windows within the title bar. You will see the file name followed by a : and a 1 for the first window or a :2 for the second.
16
Q
Compare sheets side by side
A
- To view sheets side by side:
- Make sure the two sheets are in separate windows.
- Choose View -> Window -> New Window.
- Activate the First Window.
- Choose View -> Window -> View Side by Side.
17
Q
Split Worksheet Window into Panes
A
- A worksheet can be split into different panes instead of windows.
- Choose View -> Window -> Split
18
Q
Freeze Panes
A
* Rows can be frozen to keep them in sight.
- To freeze panes:
- Move the cell pointer to the cell below the row that you want to remain visible and to the right of the column.
- Choose View -> Window -> Select the Freeze Panes option form the drop down list.
- Excel will insert dark lines to show the frozen rows and columns.
19
Q
Watch Window
A
- Watch windows can be used to monitor a particular value when you are working in excel.
- It displays the value of any number of cells in a window that is always visible.
- To display a watch window:
- Choose Formula’s -> Formula Auditing -> Watch Window.
- To a cell to watch, click Add Watch and specify the cell to watch.
20
Q
Hide Rows and Columns
A
- To hide a row or column:
- Click Home -> Cells -> Format -> Hide & UnHide.
- Hidden rows and columns have their heights set to zero.