Wall Street Prep: Excel Crash Course Knowledge check with complete solutions | Latest 2023/2024

Wall Street Prep: Excel Crash Course Knowledge check with complete solutions | Latest 2023/2024 Move back and forth between the worksheets in a workbook -- *Ctrl PageUp* or *Ctrl PageDown* open a file -- *alt f o* *ctrl o* save a file -- *alt f s* *ctrl s* print a file -- *alt f p* *ctrl p* navigating to the toolbars without the mouse -- 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 accessing settings -- File Options (*Alt f t*) *Alt t o* Disabling the Start Screen and adding more worksheets on startup -- 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" password protecting files -- File Info password protect files: "Encrypt with Password" password protect individual worksheet (so that people can't see or edit formulas): "Protect Current Sheet" highlighting columns and rows -- columns: *Ctr