Excel Basics - Wall Street Prep Study Guide

Excel Basics - Wall Street Prep Study Guide Create new sheet - Answer-ctrl i w switch between sheets - Answer-ctrl page up / ctrl page down access anything on the ribbon - Answer-atl toggle between excel books - Answer-ctrl tab open new file - Answer-ctrl o bold - Answer-ctrl b options - Answer-alt f t auto size cell - Answer-alt h o i designate width of box - Answer-alt h o w highlight column - Answer-ctrl space highlight row - Answer-shift space undo - Answer-ctrl z redo - Answer-ctrl y EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED. FIRST PUBLISH OCTOBER 2024. Page 2/9 formatting - Answer-ctrl 1 highlight all columns next - Answer-ctrl shift / paste special - Answer-alt e s zoom in / out - Answer-alt v z freeze pane - 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 - Answer-alt w s hop between panes - Answer-F6 go inside cell to see functions - Answer-F2 go inside cell to clear specific info - Answer-ALT h e input comment - Answer-Shift F2 Fill Highlighted Area Right / Down - Answer-ctrl r / ctrl d Input New Row - Answer-ALT i r input new column - Answer-alt i c deleting columns / rows - Answer-ALT H D R / ALT H D C EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED. FIRST PUBLISH OCTOBER 2024. Page 3/9 Paste Special Formatting - Answer-ALT E S T Trace Precedents - Answer-ATL M P / (delete it ALT M A A) allows you to see which cells are referenced in a particular formula or function Trace Dependents - Answer-ALT M D find and replace - Answer-ctrl h IF - Answer-criteria, output if true, output if false IF(AND( - Answer-IF(AND(first test, 2nd test), output is true, output if false) Date function - Answer-(year,month,day) but if you do DATE(Year(cell w/ date to reference)+1, Month(cell w/ date), Day(cell with date)) makes easier to drag out a list of dates increasing each year by 1 YearFrac - Answer-Start, End, Basis (Basis = 0 or omitted = 30/360, 1 = actual / actual, 2 = actual over / 360, 3 = actual / 365) _____ is a function that will return the number of years between two dates. HLookup - Answer-(look up value, table range, row number) - searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array - use HLOOKUP when your comparison values are located in row across the top of a table of data, and you want to look a specified number of rows. Vlookup - Answer-(look up value, table range, column number) - searches for a value in the leftmost column of a table, and then returns a value in the same ro