...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
...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
...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
...Master Your Mac simple ways to tweak, customize, and secure os x MAT T CONE Master Your Mac Master Your Mac Simple Ways to Tweak, Customize, and Secure OS X MAT T CONE MASTER YOUR MAC. Copyright © 2013 by Matt Cone. All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher. First printing 16 15 14 13 12 123456789 ISBN-10: 1-59327-406-8 ISBN-13: 978-1-59327-406-1 Publisher: William Pollock Production Editor: Serena Yang Cover Design: Serena Yang Cover Photo: Kazuya Minami Interior Design: Octopod Studios Developmental Editor: Tyler Ortman Technical Reviewer: Wayne Linder Copyeditor: Paula L. Fleming Compositor: Serena Yang Proofreader: Ward Webber Indexer: Nancy Guenther For information on book distributors or translations, please contact No Starch Press, Inc. directly: No Starch Press, Inc. 38 Ringold Street, San Francisco, CA 94103 phone: 415.863.9900; fax: 415.863.9950; info@nostarch.com; http://www.nostarch.com/ Library of Congress Cataloging-in-Publication Data A catalog record of this book is available from the Library of Congress. No Starch Press and the No Starch Press logo are registered trademarks of No Starch Press, Inc. My New is a trademark of No Starch Press, Inc. Other product and company names mentioned herein...
Words: 82954 - Pages: 332
...Mac OS X Lion Power User Keyboard Shortcuts v2.0.1 Visit MacMost.com for Mac and iPhone video tutorials, news, reviews and commentary. ⇧ shift ⌃ control ⌥ option ⌘ command ⇥ tab ↩ return ⌫ delete Finder Commands ⏏ eject ⎋ esc Mission Control ⌘ space Spotlight menu ⌃↑ View Mission Control ⌘ ⌥ space Spotlight window ⌃↓ Show appʼs windows ⌘⌫ Move to trash F11 Show desktop ⇧⌘⌫ Empty Trash F12 ⇧⌥⌘⌫ Force Empty Trash ⌃← ⌘N New Finder window ⇥ Show windows for next app after ⌃ ↓ ⇧⌘N New Folder spacebar Enlarge window under cursor after ⌃ ↑ ⌘I Get Info ⌥⌘I Show Inspector ⌘ Y or space Quick Look ⌃ F2 Focus on menu bar ⌘E Eject selected volume ⌃ F3 Focus on Dock ⌘J Show view options ⌃ F5 Focus on window toolbar ⌘K Connect to server ⌃ F8 Focus on menu bar status icons ⇧⌘A Open Applications folder Then, use ← → ↑↓ to navigate, ↩ to select, and esc to exit ⇧⌘C Open Computer folder ⌘↑ Open enclosing folder ⌘F Find Show Dashboard ⌃→ Move between spaces Keyboard Control Focus Switching Applications and Windows Advance to next app ⌘` Text Editing ⌘⇥ Next window in current app ⌥⌘D Hide/Show Dock ⌘← ⌘→ Go to the start/end of the line ⌘↑ ⌘↓ Go to the start/end of the document ⌥← ⌥→ Go to the previous/next word ⌥⌘8 Toggle zoom feature...
Words: 388 - Pages: 2
...CIS106: Introduction to Operating Systems Study Guide 1 (Unit 1, Test 1) NAME: DATE: Part One: Windows OS Basics (1) VMWare: This keyboard shortcut sends a CTRL-ALT-DEL signal to the VMware Guest (it mimics CTRL-ALT-DEL in our virtual software): CTRL-ALT-INS (2) VMWare: This keyboard shortcut lets you switch from windowed mode to full-screen mode and back again in our virtual software: CTRl-ALT-ENTER (3) Unlike CTRL-ALT-DEL, this keyboard shortcut brings up Task Manager in XP, 2000, Vista and 7 no matter how the system is configured: CTRL-SHIFT-ESC (4) What is the default appearance of the mouse pointer when it is waiting for an action to complete in Windows XP? (I-beam, hour-glass, two-headed arrow, or arrow) (5) What is the default appearance of the mouse pointer when it is not on an active area of the window? (I-beam, hour-glass, two-headed arrow, or arrow) (6) What is the default appearance of the mouse pointer when you wish to resize a window on the desktop? (I-beam, hour-glass, two-headed arrow, or arrow) (7) If you press certain keys (example, the Alt key), the Windows OS will designate hot keys (accelerator keys) by changing them in this way: (boldface, italics, underline, or blinking) (8) Provide two other names for the Status Area (where you see the clock, date, and background programs): System Tray___ , _Notification Area_____ (9) Windows 7 allows you to “pin” applications to the Taskbar...
Words: 929 - Pages: 4
...Lab Report 1 Learn some foundational computer skills, shortcuts, and basic terminology. 1. What are Keyboard shortcuts? Why would we use them? What is the Windows AutoHotkey? What do the following shortcuts do? Keyboard shortcuts are simpler ways to command your computer. We use shortcuts to get around the computer in a much faster way. Windows AutoHotkeys are custom shortcuts that comes for Windows Microsoft. Control + C - Copy Control + V - Paste Control + X - Cut Control + A - Bold Alt + Tab - Switch Between running programs Control + Esc - Start Menu Windows + F - Find files & Folders Windows - Start menu 2. Print Screen is a shortcut that takes a screen shot of what is being displayed. We use when we are going to print what ever is...
Words: 857 - Pages: 4
...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
...Adobe® Muse™ CC Cheat Sheet Common Adobe Muse CC Keyboard Shortcuts FUNCTION New Site... Open Site... Close Site Close Page Save Site Save Site As... Place File Create PSD Button... Exit Export HTML Preview Page in Browser Preview Site in Browser Publish Menu New Site (bypass dialog) MAC OS Command + N Command + O Command + Shift + W Command + W Command + S Command + Shift + S Command + D Command + B Command + Q Command + E Command + Shift + E Command + Option + E Command + Option + P Command + Option + N WINDOWS Ctrl + N Ctrl + O Ctrl + Shift + W Ctrl + W Ctrl + S Ctrl + Shift + S Ctrl + D Ctrl + B Ctrl + Q Ctrl + E Ctrl + Shift + E Ctrl + Alt + E Ctrl + Alt + P Ctrl + Alt + N Your first time using Muse? Be sure to visit www.adobe.com/go/start_muse for step-by-step tutorials. Copyright © 2013 Adobe Systems Incorporated. All rights reserved. Terms of Use | Privacy Adobe® Muse™ CC Cheat Sheet Edit Menu Shortcuts FUNCTION Undo Redo Cut Copy Paste Paste in Place Duplicate Select All Deselect All MAC OS Command + Z Command + Shift + Z Command + X Command + C Command + V Command + Option + Shift + V Command + Option + Shift + D Command + A Command + Shift + A WINDOWS Ctrl + Z Ctrl + Shift + Z Ctrl + X Ctrl + C Ctrl + V Ctrl + Alt + Shift + V Ctrl + Alt + Shift + D Ctrl + A Ctrl + Shift + A Your first time using Muse? Be sure to visit www.adobe.com/go/start_muse for step-by-step tutorials. Copyright © 2013 Adobe Systems Incorporated. All rights reserved...
Words: 254 - Pages: 2