Excel_Basics-01

Excel_Basics-01 - C Column Row 3 Cell C3 1) 2) 3) 4) 5) 6)...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C Column Row 3 Cell C3 1) 2) 3) 4) 5) 6) 7) 8) 9) 11) 12) 13) 14) 15) Cell = Intersection of Column & Row Worksheet = Sheet = all the cells in one sheet Worksheet name = Sheet name = 'Quick_Look' Sheet Tab holds the Worksheet name 'Quick_Look' Some other Worksheet names that Sheet Tabs hold are: 'Cell_References' and 'Assumptions' Use Ctrl + PageUp & PageDown to scroll through Sheets Workbook = file = all the Sheets File type examples; .xls, .xlsx, .xlsm Use .xls if you are going to share files with people that have older versions Use .xlsx if you are going to only share files with people that have Excel 2007 and you will not run Macros (VBA code Use .xlsm if you are going to only share files with people that have Excel 2007 and you will run Macros (VBA code) Scroll Bars The Ribbon replaces the old menus. Click on a Ribbon tab like Home or Data and look for a group such as Clipboar the icon button you want. You can also look for the dialog launchers (small diagonal arrows) in lower right corner of dialog boxes (usually more efficient). Try the dialog launcher in the Page Layout Ribbon tab, Page Setup group. The QAT (Quick Access Toolbar) has buttons on a toolbar so you can complete actions like formatting or Save or U above or below Ribbon (Right-click the QAT to do this). You can add buttons to the QAT in two ways; 1) right-click a 2) Right-click QAT, "Customize QAT", from dropdown select "All Commands", find any item (including items not in R use this method to find items that you can't find in Ribbon tabs). 162 Excel Keyboard Shortcuts Key Alone Shift Ctrl F1 Help What's This Help F2 Edit Mode Edit Comment F3 Paste Name Formula Paste Function Define Name F4 Repeat Action Find Again Close Window F5 Goto Find Restore Window Size F6 Next Pane Prev Pane Next Workbook F7 Spell Check Move Window F8 Extend Selection Add To Selection Resize Window F9 Calculate All Calculate Worksheet Minimize Workbook F10 Activate Menu Context Menu Restore Workbook F11 New Chart New Worksheet New Macro Sheet F12 Save As Save Open A Select All B Bold C Copy D Fill Down E F Find G Goto H Replace I Italics J K Insert Hyperlink L M N New Workbook O Open Workbook P Print Q R Fill Right S Save T U Underline V Paste W Close Workbook X Cut Y Repeat Active Z Undo ` (~) Toggle Formula View 1 (!) Cell Format 2 (@) Toggle Bold http://www.cpearson.com/excel/KeyboardShor 3 (#) Toggle Italics 4 ($) Toggle Underline 5 (%) Toggle Strikethru 6 (^) a 7 (&) a 8 (*) Outline 9 (() Hide Rows 0 ()) Hide Columns- Delete Selection = (+) Formula [ Direct Dependents ] All Dependents ; (semicolon) Insert Date ' (apostrophe) : (colon) Insert Time / Select Array \ Select Differences Insert Insert Mode Copy Delete Clear Delete To End Of Line Home Begin Row Start Of Worksheet End End Row End Of Worksheet Page Up Page Up Previous Worksheet Page Down Page Down Next Worksheet Left Arrow Move Left Select Left Move Left Area Right Arrow Move Right Select Right Move Right Area Up Arrow Move Up Select Up Move Up Area...
View Full Document

This note was uploaded on 06/25/2011 for the course MGSC 290 taught by Professor Johnston during the Fall '09 term at South Carolina.

Page1 / 46

Excel_Basics-01 - C Column Row 3 Cell C3 1) 2) 3) 4) 5) 6)...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online