1. Microsoft Office Shortcuts

Question 1

To see the keyboard shortcuts for the items on the Ribbon, press ___.

Answer 1

Alt

Question 2

Excel 2007: You can easily add headers and footers and see page breaks using ________ ________ View.

Answer 2

Page Layout

Question 3

Excel 2007: You can save very large Workbooks in this file type so that they will open faster.

Answer 3

Excel Binary Workbook (.xlsb)

Question 4

Excel 2007: To quickly move from one Worksheet to another press ____ and ____ .

Answer 4

Ctrl-PageUp, Ctrl-PageDown

Question 5

Excel 2007: To enter data in the cell below the one that is currently active, hit ___ and start typing your data.

Answer 5

Enter

Question 6

Excel 2007: To enter data in the cell to the right of the one that is currently active, press ________ and start typing your data.

Answer 6

Tab

Question 7

Excel 2007: To quickly enter the current date, press ____ .

Answer 7

Ctrl - ;

Question 8

Excel 2007: To enter the fraction 1/4, type ___ and ___ and ___.

Answer 8

0, space, 1/4

Question 9

Excel 2007: Your are entering 20 rows of data with 4 columns in each. As you enter data in the 4th column of the first row, hit ___ to get you back to column A in the next row.

Answer 9

Enter

Question 10

Excel 2007: To enter 9:00 PM in a cell type ___ ___ ___.

Answer 10

9:00, space, p

Question 11

Excel 2007: To enter 9:00 AM in a cell type ___.

Answer 11

9:00, space, a

Question 12

Excel 2007: You have data in cells with colored fonts, borders and filled yellow backgrounds. You want to completely delete that data and all formatting so that the cells will be blank. On the ________ tab in the ________ group, click on the drop down arrow next to ________ and select ________ ________.

Answer 12

Home, Editing, Clear, Clear All

Question 13

When viewing a folder, (directory), in Windows Explorer, to go up one level press ___ .

Answer 13

Backspace

Question 14

To quickly select a contiguous block of cells in Microsoft Excel press ___ .

Answer 14

Ctrl-Shift-Arrow

Question 15

To enter data or a formula in a selected contiguous block of cells in Microsoft Excel, enter it in the first cell and press ___ .

Answer 15

Ctrl-Enter

Question 16

Excel 2007: You have data in cells with colored fonts, borders and filled yellow backgrounds. You want to completely delete that data and all formatting so that the cells will be blank. Press ___ .

Answer 16

Alt-h-e-a

Question 17

To minimize a window in Windows press ___ and then ___.

Answer 17

Alt-Space, n

Question 18

To rename a highlighted file in Windows press ___ .

Answer 18

F2

Question 19

To switch tabs in Internet Explorer and Firefox press ___ .

Answer 19

Ctrl-Tab

Question 20

In Excel 2007, to format data in contiguous rows and columns into a Table, select a cell anywhere in the data and press ___, ___ then ___ .

Answer 20

Alt-n, t, Enter

Question 21

In Excel 2007, to remove table formatting from a Table, select a cell anywhere in the Table and ___, select ___, ___ and ___ .

Answer 21

R-Click, Table, Convert to Range, Yes

Question 22

In Excel 2007, the procedure to unhide the first column of a worksheet with shortcuts.

Answer 22

Press F5 type “A1” - Enter, Alt-h, Alt-o, u, l

Question 23

In Excel 2007, the procedure to unhide the first row of a worksheet with shortcuts.

Answer 23

Press F5 type “A1” - Enter, Alt-h, Alt-o, u, o

Question 24

To display your Excel Worksheet in Page Layout view using shortcuts, press ____ .

Answer 24

Alt-w, p

Question 25

To display your Excel Worksheet in Normal view using shortcuts, press ____ .

Answer 25

Alt-w, l

Question 26

To open a new tab in Internet Explorer and Firefox press ___ .

Answer 26

Ctrl-t

Question 27

To close a tab in Internet Explorer and Firefox press ___.

Answer 27

Ctrl-w

Question 28

To search using the Search Bar in Firefox press ___ .

Answer 28

Ctrl-k

Question 29

To go to the top of a webpage press ___ .

Answer 29

Ctrl-Home

Question 30

To go to the bottom of a webpage press ___ .

Answer 30

Ctrl-End

Question 31

To go to the next item on a webpage press ___ .

Answer 31

Tab

Question 32

To go to the previous item on a webpage press ___ .

Answer 32

Shift-Tab

Question 33

To enter a URL in the address bar in Internet Explorer and Firefox press ___ .

Answer 33

Ctrl-l

Question 34

To add “www” before and “.com” after a URL typed in the address bar in Firefox and Internet Explorer, type the name and press ___ .

Answer 34

Ctrl-Enter

Question 35

To go to the previous webpage viewed press ___ or ___.

Answer 35

Backspace, Alt-Left Arrow

Question 36

To go to your home page press ___ .

Answer 36

Alt-Home

Question 37

To make the Column Index Number, (“5”), in this formula relative, (so that the formula can be copied horizontally), enter ________ instead of 5. =VLOOKUP($B8,HT_AMT_Y.XLS!$C$2:$AO$442,5,FALSE)

Answer 37

COLUMNS($A8:E8)

Question 38

To open a new browser window in Internet Explorer and Firefox press ___ .

Answer 38

Ctrl-n

Question 39

To go to the next webpage viewed press ___ .

Answer 39

Alt-Right Arrow

Question 40

To zoom in on a web page in Firefox and Internet Explorer press ___.

Answer 40

Ctrl-plus

Question 41

To zoom out from a web page in Firefox and Internet Explorer press ___.

Answer 41

Ctrl-minus

Question 42

To password protect a Worksheet in Excel 2007 press ___, ___ and ___.

Answer 42

Alt-h, Alt-o, p

Question 43

In Excel 2007, a quick way to unhide the first row or column of a worksheet.

Answer 43

Press F5 type “A1” - select entire Worksheet - double click between row or column divider to auto-size

Question 44

In Excel 2007, activate the “Save As” dialog box by pressing ___ .

Answer 44

F12

Question 45

To open the Start Menu in Windows 7 press ___ .

Answer 45

Ctrl-Esc

Question 46

To select all the cells in a Worksheet in Excel 2007, all the files in a window in Windows 7, all of a web page or other document press ___ .

Answer 46

Ctrl-A

Question 47

To view the system properties in Windows 7 press ___ .

Answer 47

Windows key-Pause or Break

Question 48

To open a shortcut menu with your keyboard, (without right-clicking your mouse), press ___ .

Answer 48

Shift-F10

Question 49

To delete a file, folder or shortcut without placing it in the recycle bin press ___ .

Answer 49

Shift-Delete

Question 50

To cycle through buttons for open applications on the task bar and switch between applications in Windows 7 press ___ .

Answer 50

Windows key-Tab

Question 51

To minimize all open windows in Windows 7 press ___ .

Answer 51

Windows key-d

Question 52

To open Windows Explorer press ___ .

Answer 52

Windows key-e

Question 53

To start a program press ___ + ___ and a keyboard character. Right-click the program’s icon or shortcut, select Properties, select the Shortcut tab, then click your mouse pointer in the Shortcut keys text box and type in whatever character (a letter, number, etc.) you want in the box.

Answer 53

Ctrl-Alt

Question 54

To select data from where your cursor is to the beginning of a document, Worksheet, etc. press ___ .

Answer 54

Ctrl-Shift-Home

Question 55

To select data from where your cursor is to the end of a document, Worksheet, etc. press ___ .

Answer 55

Ctrl-Shift-End

Question 56

To delete a Worksheet in Excel 2007 press ___ then ___ .

Answer 56

Alt-e, l

Question 57

To insert a new Worksheet in Excel 2007 press ___ .

Answer 57

Shift-F11

Question 58

To move or copy a Worksheet in Excel 2007 press ___ .

Answer 58

Alt-e, m