Excel Crash Course Complete Study
Questions with Verified Answers Already
Graded A+ | Guarantee Pass
1. move back and forth between the worksheets in a workbook - ANSWER
*Ctrl PageUp* or *Ctrl PageDown*
2. open a file - ANSWER *alt f o*
*ctrl o*
3. navigating the 'Format Cells' menu - ANSWER after hitting Ctrl 1 to pull up
the 'Format Cells' menu, you can navigate around tabs by hitting *Ctrl tab*
each category within a tab can be accessed by pressing *Alt* and the
appropriate underlined letter, or by hitting *tab* to move clockwise and *shift
tab* to move counter clockwise
when on the desired tab, horizontal alignment can be accessed through *Alt h*
and vertical alignment through *Alt v*
4. paste special - ANSWER *Alt v s t* or *Alt e s t*
5. changing zoom size - ANSWER *Alt w q* or *Alt v z*
6. Move/copy a tab - ANSWER *Alt h o m*
,7. freezing panes - ANSWER click the cell BELOW the desired row and to
the RIGHT of the desired column where you want to freeze panes and hit
*Alt w f f*
to unfreeze panes: press *Alt w f f* again
8. splitting panes - ANSWER splitting panes allows users to scroll in both
areas of the worksheet, while rows and columns in the non-scrolled area
remain visible
to split panes:
-click the cell BELOW the desired row and to the RIGHT of the desired column
where you want to split panes and hit *Alt w s*
-to unspilt panes, click *Alt w s* again
-press *F6* to move from pane to pane in a clockwise direction; press *Shift
F6* to move from pane to pane in a counter-clockwise direction
9. manipulating data inside a cell - ANSWER *F2* is the command that puts
you inside a cell:
-pressing the F2 key once shows you the components of the formula you
created earlier, puts you inside a cell and enables you to navigate through it to
edit the existing cell data
-pressing the F2 key twice activates the cursor and enables you to move to
different cells, worksheets, and even other open Excel files
*Shift arrow key* will highlight characters one at a time
*Shift Ctrl arrow key* will highlight contiguous ranges of characters
,10.deleting and clearing cell data - ANSWER hitting *Delete* does NOT
delete the formatting in the cell
to truly delete a cell:
-*Alt h e* (Home tab > Clear)
-from the drop-down, chose the appropriate actions
*(Alt h e) a*: clears ALL contents of the cell
*(Alt h e) f*: clears only the cell FORMAT
*(Alt h e) c*: clears only the cell CONTENT
-this is the same as hitting Delete
*(Alt h e) m*: clears only the cell COMMENTS
11.save a file - ANSWER *alt f s*
*ctrl s*
12.print a file - ANSWER *alt f p*
*ctrl p*
13.navigating to the toolbars without the mouse - ANSWER hit *Alt and the
appropriate letter* (or use the right/left arrow keys) to get to the desired tab
once there, use the Tab and Shift Tab keys to navigate around
, 14.accessing settings - ANSWER File > Options (*Alt f t*)
*Alt t o*
15.Disabling the Start Screen and adding more worksheets on startup -
ANSWER click on 'Blank worksheet'
Hit *Alt f t* go go to Excel options (you can also get there by clicking the file
tab)
Under 'General' unselect "Show the Start screen when this application starts"
16.password protecting files - ANSWER File
Info
password protect files: "Encrypt with Password"
password protect individual worksheet (so that people can't see or edit
formulas): "Protect Current Sheet"
17.highlighting columns and rows - ANSWER columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
18.widening columns and rows - ANSWER highlight column by pressing *Ctrl
Spacebar*
*Alt h o i* to auto-fit the column width
Questions with Verified Answers Already
Graded A+ | Guarantee Pass
1. move back and forth between the worksheets in a workbook - ANSWER
*Ctrl PageUp* or *Ctrl PageDown*
2. open a file - ANSWER *alt f o*
*ctrl o*
3. navigating the 'Format Cells' menu - ANSWER after hitting Ctrl 1 to pull up
the 'Format Cells' menu, you can navigate around tabs by hitting *Ctrl tab*
each category within a tab can be accessed by pressing *Alt* and the
appropriate underlined letter, or by hitting *tab* to move clockwise and *shift
tab* to move counter clockwise
when on the desired tab, horizontal alignment can be accessed through *Alt h*
and vertical alignment through *Alt v*
4. paste special - ANSWER *Alt v s t* or *Alt e s t*
5. changing zoom size - ANSWER *Alt w q* or *Alt v z*
6. Move/copy a tab - ANSWER *Alt h o m*
,7. freezing panes - ANSWER click the cell BELOW the desired row and to
the RIGHT of the desired column where you want to freeze panes and hit
*Alt w f f*
to unfreeze panes: press *Alt w f f* again
8. splitting panes - ANSWER splitting panes allows users to scroll in both
areas of the worksheet, while rows and columns in the non-scrolled area
remain visible
to split panes:
-click the cell BELOW the desired row and to the RIGHT of the desired column
where you want to split panes and hit *Alt w s*
-to unspilt panes, click *Alt w s* again
-press *F6* to move from pane to pane in a clockwise direction; press *Shift
F6* to move from pane to pane in a counter-clockwise direction
9. manipulating data inside a cell - ANSWER *F2* is the command that puts
you inside a cell:
-pressing the F2 key once shows you the components of the formula you
created earlier, puts you inside a cell and enables you to navigate through it to
edit the existing cell data
-pressing the F2 key twice activates the cursor and enables you to move to
different cells, worksheets, and even other open Excel files
*Shift arrow key* will highlight characters one at a time
*Shift Ctrl arrow key* will highlight contiguous ranges of characters
,10.deleting and clearing cell data - ANSWER hitting *Delete* does NOT
delete the formatting in the cell
to truly delete a cell:
-*Alt h e* (Home tab > Clear)
-from the drop-down, chose the appropriate actions
*(Alt h e) a*: clears ALL contents of the cell
*(Alt h e) f*: clears only the cell FORMAT
*(Alt h e) c*: clears only the cell CONTENT
-this is the same as hitting Delete
*(Alt h e) m*: clears only the cell COMMENTS
11.save a file - ANSWER *alt f s*
*ctrl s*
12.print a file - ANSWER *alt f p*
*ctrl p*
13.navigating to the toolbars without the mouse - ANSWER hit *Alt and the
appropriate letter* (or use the right/left arrow keys) to get to the desired tab
once there, use the Tab and Shift Tab keys to navigate around
, 14.accessing settings - ANSWER File > Options (*Alt f t*)
*Alt t o*
15.Disabling the Start Screen and adding more worksheets on startup -
ANSWER click on 'Blank worksheet'
Hit *Alt f t* go go to Excel options (you can also get there by clicking the file
tab)
Under 'General' unselect "Show the Start screen when this application starts"
16.password protecting files - ANSWER File
Info
password protect files: "Encrypt with Password"
password protect individual worksheet (so that people can't see or edit
formulas): "Protect Current Sheet"
17.highlighting columns and rows - ANSWER columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
18.widening columns and rows - ANSWER highlight column by pressing *Ctrl
Spacebar*
*Alt h o i* to auto-fit the column width
