Excel Basics - Wall Street Prep Exam Questions and Answers 100% PASS

Excel Basics - Wall Street Prep
Exam Questions and Answers
100% PASS

Create new sheet - CORRECT ANSWER-ctrl i w


switch between sheets - CORRECT ANSWER-ctrl page up / ctrl page down


access anything on the ribbon - CORRECT ANSWER-atl


toggle between excel books - CORRECT ANSWER-ctrl tab


open new file - CORRECT ANSWER-ctrl o


bold - CORRECT ANSWER-ctrl b


options - CORRECT ANSWER-alt f t


auto size cell - CORRECT ANSWER-alt h o i


designate width of box - CORRECT ANSWER-alt h o w


highlight column - CORRECT ANSWER-ctrl space


highlight row - CORRECT ANSWER-shift space


undo - CORRECT ANSWER-ctrl z


redo - CORRECT ANSWER-ctrl y

, formatting - CORRECT ANSWER-ctrl 1


highlight all columns next - CORRECT ANSWER-ctrl shift > / <


paste special - CORRECT ANSWER-alt e s


zoom in / out - CORRECT ANSWER-alt v z


freeze pane - CORRECT ANSWER-alt w f f


To keep selected rows and/or columns of the worksheet visible on the

screen as the rest of the worksheet scrolls.


split pane - CORRECT ANSWER-alt w s


hop between panes - CORRECT ANSWER-F6


go inside cell to see functions - CORRECT ANSWER-F2


go inside cell to clear specific info - CORRECT ANSWER-ALT h e


input comment - CORRECT ANSWER-Shift F2


Fill Highlighted Area Right / Down - CORRECT ANSWER-ctrl r / ctrl d


Input New Row - CORRECT ANSWER-ALT i r


input new column - CORRECT ANSWER-alt i c


deleting columns / rows - CORRECT ANSWER-ALT H D R / ALT H D C


Paste Special Formatting - CORRECT ANSWER-ALT E S T


Trace Precedents - CORRECT ANSWER-ATL M P / (delete it ALT M A A)

allows you to see which cells are referenced in a particular formula or

function


© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law