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.
