Moving around task ribbon - Study guides, Class notes & Summaries

(Updated) Wall Street Prep: Excel Crash Course Complete Study Guide | Latest 2023/2024 . Keyboard Versus the Mouse -- Almost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel using only the keyboard Name Box -- Tells you what cell you are in (top left below the ribbon) Formula Bar -- When you insert a formula into a cell and hit return, the cell will show you the output The ...

Add/delete sheets - Answer-alt-i-w OR alt h-i-s Moving around task ribbon - Answer-Tab and shift (to select) Auto fit cell - Answer-alt-h-o-i Custom fit columns - Answer-alt h-o-w Custom fit rows - Answer-alt h-o-h Select entire column/row - Answer-ctrl shift-arrow key Format cells - Answer-ctrl 1 Paste special - Answer-alt e-s Freeze panes - Answer-alt w-f-f Split panes - Answer-alt w-s Move between panes - Answer-F6 Get in cell AND navigate to others while insi...

Add/delete sheets - ANSWERSalt-i-w OR alt h-i-s Moving around task ribbon - ANSWERSTab and shift (to select) Auto fit cell - ANSWERSalt-h-o-i Custom fit columns - ANSWERSalt h-o-w Custom fit rows - ANSWERSalt h-o-h Select entire column/row - ANSWERSctrl shift-arrow key Format cells - ANSWERSctrl 1 Paste special - ANSWERSalt e-s Freeze panes - ANSWERSalt w-f-f Split panes - ANSWERSalt w-s

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside - alt h-e

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside - alt h-e

Add/delete sheets - Correct Answer alt-i-w OR alt h-i-s Moving around task ribbon - Correct Answer Tab and shift (to select) Auto fit cell - Correct Answer alt-h-o-i Custom fit columns - Correct Answer alt h-o-w Custom fit rows - Correct Answer alt h-o-h Select entire column/row - Correct Answer ctrl shift-arrow key Format cells - Correct Answer ctrl 1 Paste special - Correct Answer alt e-s Freeze panes - Correct Answer alt w-f-f Split panes - Correct Answer ...

Add/delete sheets Correct Answer alt-i-w OR alt h-i-s Moving around task ribbon Correct Answer Tab and shift (to select) Auto fit cell Correct Answer alt-h-o-i Custom fit columns Correct Answer alt h-o-w Custom fit rows Correct Answer alt h-o-h Select entire column/row Correct Answer ctrl shift-arrow key Format cells Correct Answer ctrl 1 Paste special Correct Answer alt e-s Freeze panes Correct Answer alt w-f-f Split panes Correct Answer alt w-s Move between panes ...

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside -...

A 73-year-old patient who sustained a right hip fracture in a fall requests pain medication from the nurse. Based on his injury, which type of pain is this patient most likely experiencing? 1) Phantom 2) Visceral 3) Deep somatic 4) Referred Answer: 3) Deep somatic Rationale: Deep somatic pain originates in ligaments, tendons, nerves, blood vessels, and bones. Therefore, a hip fracture causes deep somatic pain. Phantom pain is pain that is perceived to originate from a part that was rem...

Wall Street Prep Excel Crash Course Exam 246 Questions with Verified Answers Keyboard Versus the Mouse - CORRECT ANSWER Almost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel using only the keyboard Name Box - CORRECT ANSWER Tells you what cell you are in (top left below the ribbon) Formula Bar - CORRECT ANSWER When you insert a formula into a cell and hit return, the ce...