...Efficiency Improvements To improve your efficiency, it is helpful to know and use keyboard shortcuts. These allow you to use Excel much more quickly than by using a mouse. The following is a list of commonly used functions in Excel that you are expected to memorize. We encourage you to practice these shortcut keys, and if you do not understand a shortcut description to look it up via the Internet to learn more about how it works. These shortcuts will be tested on future quizzes and exams. For those interested, additional shortcuts can be found at http://office.microsoft.com/en-us/excelhelp/excel-shortcut-and-function-keys-HP001111659.aspx (these will not be tested). Code CTRL+( CTRL+) CTRL+9 CTRL+0 CTRL+A Description Unhides any hidden rows within the selection. Unhides any hidden columns within the selection. Hides the selected rows. Hides the selected columns. Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet. Applies or removes bold formatting. Copies the selected cells. Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Displays the Find dialog box. Applies or removes italic formatting. Creates a new, blank file. Displays the Print dialog box. Saves the active file with its current file name, location, and file format. Applies or removes underlining. Inserts the contents of the Clipboard at the insertion...
Words: 627 - Pages: 3
...What is the average value of processor queue length on the W2kzzcomputer? 0.700 6.What subheading are available in the system stability report selection? Software unitalls, application failure, hardware failure, windows and miscellaneous 7.Waht logs are available by default? Application,security,setup,system and forward event 8.What is most recent Event id logged to the Application log? Application,security,setup,system,forward events 9.What is the most recent Event ID logged to security log? 4634 10.What is most recent event id logged to setup log? 1610 11. What is most recent event id logged to system log? 7036 12.How many events are displayed in this custom view? 52 13.What is the keyboard shortcut to begin a network capture? F5 14.What appears in the Capture Filter pane? 15.Does anything appear in the Network Conversations pane? no 16.Does anything appear in the Network Conversations pane? All traffic,my traffic, 17.Where will WSUS downloads be stored by default? (c:/wsus) 18.What database does WSUS use by Default? MSDE 19.What types of updates does WSUS download by default? Automatic updates 20.What nodes are available under the W2K40 node?...
Words: 260 - Pages: 2
...desktop Turning off your computer Start screen and tiles Apps Closing an app Snapping apps 12 13 13 14 14 14 14 More Information 15 Setting Up Your Computer Connecting To The Internet Connecting to the Internet Using LAN Connecting to the Internet Using WLAN Connecting to the Internet Using WWAN Setting up Audio Configuring 5.1/7.1 Audio Connecting 5.1 Speakers Connecting 7.1 Speakers Setting Up Your Printer 16 16 16 16 17 18 18 19 20 21 Contents 3 Setting Up Your Webcam Integrated Webcam External Webcam Setting up Bluetooth 22 22 22 22 About Your Computer Power Adapter Battery Coin-Cell Battery Touchpad Display Touchscreen 3D 3D Camera 23 23 24 24 25 25 25 25 26 Keyboard Physical Keyboard Keyboard Backlight On-Screen Keyboard Keyboard Connection Types Wired Wireless 26 27 27 28 28 28 28 Service Tag and Express-Service Code Locating the Label on Your Computer Dell Support Website BIOS Setup Program 29 29 29 29 4 Contents Storage Device Internal Storage Devices Removable...
Words: 18778 - Pages: 76
...Show All The shortcut keys described in this Help topic refer to the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard. For keyboard shortcuts in which you press two or more keys simultaneously, the keys to press are separated by a plus sign (+) in Microsoft Word Help. For keyboard shortcuts in which you press one key immediately followed by another key, the keys to press are separated by a comma (,). To print this topic, press TAB to select Show All, press ENTER, and then press CTRL+P. Help task pane and Help window Using the Help task pane and Help window Menus, toolbars, task panes, and dialog boxes Access and use menus and toolbars Access and use task panes Resize and move toolbars, menus, and task panes Use dialog boxes Use edit boxes within dialog boxes Use the Open, Save As, and Insert Picture dialog boxes Quick reference Common tasks done in a Microsoft Word document Language bar Speech and handwriting recognition E-mail Sending e-mail messages Working with documents and Web pages Create, view, and save documents Find, replace, and browse through text Undo and redo actions Switch to another view Outline view Printing and previewing documents Reviewing documents Reading layout view References, footnotes, and endnotes Working with Web pages Editing and moving text and graphics Delete text and graphics Copy and move text and graphics Insert special characters Insert characters by using character...
Words: 438 - Pages: 2
...Florida Department of Law Enforcement 2011 Table of Contents Introduction.............................................................................................................. 1 File.............................................................................................................................2 Edit............................................................................................................................3 Setting Preferences ...................................................................................................4 Fonts .........................................................................................................................5 Message Filters .........................................................................................................6 Forms ....................................................................................................................... 8 Window .....................................................................................................................9 Help.........................................................................................................................10 Form Features......................................................................................................... 11 Today Window ........................................................................................................ 17 Example of Open Form With…...........................
Words: 5140 - Pages: 21
...Ctrl+Z Undo Ctrl+C Enter, Ctrl+V Ctrl+X Copy, Paste, Multiple Paste, Cut Ctrl+F, Ctrl+H Find, Find&Replace Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4 Print, Save, Close, Close Excel Ctrl+Arrow Move to edge of region Ctrl+* Select current region Ctrl+A Select all cells Ctrl+Home Ctrl+End Select A1, Select last cell in used range Ctrl+Shift+End Select from active cell to last cell in used range. Ctrl+Shift+Home Select from active cell to A1 Ctrl+Page Down Ctrl+Page Up Move to the next sheet, Move to the previous sheet Ctrl+Tab Move to next open workbook Ctrl+N Open new workbook Shift+F11 Insert new worksheet Shift+F3 Paste function window =+FunctionName+Ctrl+A Insert new function Alt+F11 Open VBE Ctrl+Shift+Enter Array formula Ctrl+F3, F3 Define name, Paste name Ctrl+Spacebar Shift+Spacebar Select columns, Select rows Ctrl+1, Ctrl+B, Ctrl+U Format cells, Bold, Underline Ctrl+; , Ctrl+shift+: Current date, Current time | | | | |Rate this tip | | RATING: | |Email Tip | |Top of Form | |2.96 | | | | ...
Words: 1257 - Pages: 6
...LAB 1.6 USE WINDOWS KEYBOARD SHORTCUTS OBJECTIVES The goal of this lab is to introduce you to some keyboard shortcuts. After completing this lab, you will be able to use the keyboard to: · Display the Start menu · Switch between open applications · Launch utilities with the Windows logo key MATERIALS REQUIRED This lab requires the following: · Windows XP operating system LAB PREPARATION Before the lab begins, the instructor or lab assistant needs to do the following: · Verify that Windows starts with no errors. ACTIVITY BACKGROUND You can use certain keys or key combinations (called keyboard shortcuts) to perform repeti-tive tasks more efficiently. These shortcuts are also useful when the mouse isn't working. In this lab, you learn to use some common keyboard shortcuts. You can find a full list of key-board shortcuts by searching for "keyboard shortcuts" in the Windows Help and Support Center. ESTIMATED COMPLETION TIME: 30 minutes Activity The F1 key is the universal keyboard shortcut for launching Help. To learn more, follow these steps: 1. Open Paint and then minimize it. 2. Open Control Panel and then minimize it. 3. Click the desktop, and then press F1. Windows Help opens. 4. Close Windows Help, and restore Paint. 5. Press Fl. Because Paint is the active window, Help for Paint opens. Close Help for Paint. 6. Restore Control Panel, and then press Fl. Help for Control Panel opens. You can...
Words: 994 - Pages: 4
...The Complete Windows 7 Shortcuts eBook The Complete Windows 7 Shortcuts eBook Nitin Agarwal TheWindowsClub Publications Page | - 2 - The Complete Windows 7 Shortcuts eBook The Complete Windows 7 Shortcuts eBook Published by The Windows Club www.thewindowsclub.com Copyright ©2010 reserved to Nitin Agarwal Legal Policy This book is free to download and distribute all over the world but no part of this book can be reproduced without the prior information and permission of author & publisher. You are free to copy the content of the book but with the proper actions. Mention the name and link of the book wherever you use the content of the book. All the trademarks and logos used in this eBook are the property of their respective owners. Windows 7, Microsoft, Windows 7 logo & icons are either registered trademarks or trademarks of Microsoft Corporation in US & rest of the world. Uses of these trademarks in this eBook are for educational or reference purpose only. For more information on distribution and legal policies, visit www.thewindowsclub.com Page | - 3 - The Complete Windows 7 Shortcuts eBook About the Author The author of this eBook, Nitin Agarwal is an independent technology analyst for Windows IT Pro and other Microsoft products. He writes about Windows 7 and gives tech updates on his blog, known as Windows Lifestyle (www.windowslifestyle.com). He is an active member of Microsoft forums & communities. TheWindowsClub is his favorite...
Words: 9310 - Pages: 38
...The Complete Windows 7 Shortcuts eBook The Complete Windows 7 Shortcuts eBook Nitin Agarwal TheWindowsClub Publications Page | - 2 - The Complete Windows 7 Shortcuts eBook The Complete Windows 7 Shortcuts eBook Published by The Windows Club www.thewindowsclub.com Copyright ©2010 reserved to Nitin Agarwal Legal Policy This book is free to download and distribute all over the world but no part of this book can be reproduced without the prior information and permission of author & publisher. You are free to copy the content of the book but with the proper actions. Mention the name and link of the book wherever you use the content of the book. All the trademarks and logos used in this eBook are the property of their respective owners. Windows 7, Microsoft, Windows 7 logo & icons are either registered trademarks or trademarks of Microsoft Corporation in US & rest of the world. Uses of these trademarks in this eBook are for educational or reference purpose only. For more information on distribution and legal policies, visit www.thewindowsclub.com Page | - 3 - The Complete Windows 7 Shortcuts eBook About the Author The author of this eBook, Nitin Agarwal is an independent technology analyst for Windows IT Pro and other Microsoft products. He writes about Windows 7 and gives tech updates on his blog, known as Windows Lifestyle (www.windowslifestyle.com). He is an active member of Microsoft forums & communities. TheWindowsClub is his favorite Windows discussion...
Words: 9310 - Pages: 38
...100+ Keyboard shortcuts (Windows) The General Shortcuts CTRL+C (Copy) CTRL + Insert = Copy CTRL+X (Cut) CTRL+V (Paste) CTRL+Z (Undo) CTRL+A (Select all) CTRL+ESC (Display the Start menu) CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) CTRL+SHIFT with any of the arrow keys (Highlight a block of text) CTRL while dragging an item (Copy the selected item) CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously) ALT+ENTER (View the properties for the selected item) ALT+F4 (Close the active item, or quit the active program) ALT+ENTER (Display the properties of the selected object) ALT+SPACEBAR (Open the shortcut menu for the active window) ALT+TAB (Switch between the open items) ALT+ESC (Cycle through items in the order that they had been opened) ALT+ Underlined letter in a menu name (Display the corresponding menu) F2 key (Rename the selected item) F3 key (Search for a file or a folder) F4 key (Display the Address bar list in My Computer or Windows Explorer) F5 key (Update the active window) F6 key (Cycle through the screen elements in a window or on the desktop) ...
Words: 1979 - Pages: 8
...Pro Tools Shortcuts Guide ® Version 11.2 Legal Notices © 2014 Avid Technology, Inc., (“Avid”), all rights reserved. This guide may not be duplicated in whole or in part without the written consent of Avid. 003, 192 Digital I/O, 192 I/O, 96 I/O, 96i I/O, Adrenaline, AirSpeed, ALEX, Alienbrain, AME, AniMatte, Archive, Archive II, Assistant Station, AudioPages, AudioStation, AutoLoop, AutoSync, Avid, Avid Active, Avid Advanced Response, Avid DNA, Avid DNxcel, Avid DNxHD, Avid DS Assist Station, Avid Ignite, Avid Liquid, Avid Media Engine, Avid Media Processor, Avid MEDIArray, Avid Mojo, Avid Remote Response, Avid Unity, Avid Unity ISIS, Avid VideoRAID, AvidRAID, AvidShare, AVIDstripe, AVX, Beat Detective, Beauty Without The Bandwidth, Beyond Reality, BF Essentials, Bomb Factory, Bruno, C|24, CaptureManager, ChromaCurve, ChromaWheel, Cineractive Engine, Cineractive Player, Cineractive Viewer, Color Conductor, Command|8, Control|24, Cosmonaut Voice, CountDown, d2, d3, DAE, D-Command, D-Control, Deko, DekoCast, D-Fi, D-fx, Digi 002, Digi 003, DigiBase, Digidesign, Digidesign Audio Engine, Digidesign Development Partners, Digidesign Intelligent Noise Reduction, Digidesign TDM Bus, DigiLink, DigiMeter, DigiPanner, DigiProNet, DigiRack, DigiSerial, DigiSnake, DigiSystem, Digital Choreography, Digital Nonlinear Accelerator, DigiTest, DigiTranslator, DigiWear, DINR, DNxchange, Do More, DPP-1, D-Show, DSP Manager, DS-StorageCalc, DV Toolkit, DVD Complete...
Words: 13199 - Pages: 53
...1. Deleting the data and clearing the row. Deleting Cells and Data in Excel 2007 In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell. Clearing cell contents Clearing just deletes or empties the cell’s contents or formatting without removing the cell from the worksheet, which would alter the layout of the surrounding cells. To get rid of just the contents of a cell selection, just select the range of cells to be cleared and press the Delete key. If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, select the cell(s) and follow these steps: 1. Click the Clear button (the one with the eraser) in the Editing group on the Ribbon’s Home tab. 2. Click one of the following options on the Clear drop-down menu: * Clear All gets rid of all formatting, notes, and entries in the cell selection. * Clear Formats deletes only the formatting from the cell selection without touching anything else. * Clear Contents deletes only the cell entries, just like pressing the Delete key. * Clear Comments removes the notes in the cell selection but leaves everything else intact. Deleting cells, rows, or columns Deleting gets rid of the whole kit and caboodle...
Words: 5625 - Pages: 23
...effectively? The best way is to customize them. When you learn how to customize an application the way you want it--especially when it’s a productivity tool like an Microsoft Office program, you increase your productivity and effectiveness by leaps and bounds. All you need is a guide on getting the best customizations out there. Read on and make the leap from Microsoft Office beginner to expert with the following list of resources, tips, tricks and tutorials. Microsoft Word Microsoft Excel Microsoft Powerpoint Microsoft Outlook Streamline Document Formatting Keyboard shortcut/Cheat sheets Editing Importing Fonts Exporting to Different Doc Types General Word Tips and tricks Interface Customizations Formatting Text & Numbers in Spreadsheets Templates Macros and Calculations Keyboard shortcut/cheat sheets General Excel Tips and Tricks Interface customizations Printing Exporting Keyboard shortcuts Editing General PowerPoint Tips and Tricks Interface Customization Email Organization Tasks Calendaring and Scheduling General Tips and Tricks MICROSOFT WORD Streamline Document Formatting – It’s faster and easier to tweak a few things here or there to make a document truly your own. Start tweaking your own documents with a complete document theme. ...
Words: 4859 - Pages: 20
...Word basics Word is a powerful word processing and layout application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features that you can use in all documents. Before you begin ....................................................................................................................................... 1 1. Create a new blank document ............................................................................................................... 2 2. Explore the Word user interface ............................................................................................................. 4 3. Navigate through a document ............................................................................................................... 5 5. Format text ........................................................................................................................................... 9 6. Copy, paste, and drag ......................................................................................................................... 11 7. Change the document layout ............................................................................................................... 14 8. Save a document in a new folder ......................................................................................................... 16 Quick Reference Card ..............................................
Words: 2451 - Pages: 10
...Getting Started * Menus * Shortcut menus * Toolbars * Customizing toolbars Working With Files * Creating and opening documents * Saving documents * Renaming documents * Working on multiple documents * Close a document Working With Text * Typing and inserting text * Selecting text * Deleting text * Undo * Formatting toolbar * Format Painter Formatting Paragraphs * Paragraph attributes * Moving, copying, and pasting text * The clipboard * Columns * Drop caps Styles * Apply a style * Apply a style from the style dialog box * Create a new styles from a model * Create a simple style from the style dialog box * Modify or rename a style * Delete a style Lists * Bulleted and numbered lists * Nested lists * Formatting lists Tables * Insert Table button * Draw a table * Inserting rows and columns * Moving and resizing a table * Tables and Borders toolbar * Table properties | | | | Graphics * Adding clip art * Add an image from a file * Editing a graphic * AutoShapes Spelling and Grammar * AutoCorrect * Spelling and grammar check * Synonyms * Thesaurus Page Formatting * Page margins * Page size and orientation * Headers and footers * Page numbers * Print preview and printing Macros * Recording a macro * Running a macro Table of Contents * Mark TOC entries * Generate a table of contents Web Wizard * Using the Web Wizard Creating Web Pages...
Words: 7811 - Pages: 32
