...Do With Office...But Didn't Know How You use Microsoft Word, Excel and PowerPoint on a daily basis and are still be trying to figure out where things are and how they work, using only 10% of the applications power. Below are 101 customizations and tweaks to help you harness the power of productivity, and customize MS office to work for you. The difference between an Microsoft Office beginner and advanced user is all about knowing how to use the individual applications, and knowing how to use them well. Wondering how to use your everyday Office applications 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...
Words: 4859 - Pages: 20
...ABBYY FineReader ® Version 12 User‘s Guide © 2013 ABBYY Production LLC. All rights reserved. ABBYY FineReader 12 User‘s Guide Information in this document is subject to change without notice and does not bear any commitment on the part of ABBYY. The software described in this document is supplied under a license agreement. The software may only be used or copied in strict accordance with the terms of the agreement. It is a breach of the "On legal protection of software and databases" law of the Russian Federation and of international law to copy the software onto any medium unless specifically allowed in the license agreement or nondisclosure agreements. No part of this document may be reproduced or transmitted in any from or by any means, electronic or other, for any purpose, without the express written permission of ABBYY. © 2013 ABBYY Production LLC. All rights reserved. ABBYY, ABBYY FineReader, ADRT are either registered trademarks or trademarks of ABBYY Software Ltd. © 1984-2008 Adobe Systems Incorporated and its licensors. All rights reserved. Protected by U.S. Patents 5,929,866; 5,943,063; 6,289,364; 6,563,502; 6,185,684; 6,205,549; 6,639,593; 7,213,269; 7,246,748; 7,272,628; 7,278,168; 7,343,551; 7,395,503; 7,389,200; 7,406,599; 6,754,382 Patents Pending. Adobe® PDF Library is licensed from Adobe Systems Incorporated. Adobe, Acrobat®, the Adobe logo, the Acrobat logo, the Adobe PDF logo and Adobe PDF Library are either registered trademarks or trademarks...
Words: 35796 - Pages: 144
...want every student to input his roll number and scan his finger for attendance, you need to have a combination of: (a) Keypad, Mouse, OCR Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array, col_index_num, [range_lookup]) (b) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) (c) VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) (d) VLOOKUP(row_value, table_array, col_index_num, [range_lookup]) The maximum number of IF functions that can be nested as value_if_true and value_if_false arguments is: (a) 4 (b) 16 (c) 32 (d) 64 In an MS Excel worksheet...
Words: 2503 - Pages: 11
...Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner 4. Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip 5. In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk 6. Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array, col_index_num, [range_lookup]) (b) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) (c) VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) (d) VLOOKUP(row_value, table_array, col_index_num, [range_lookup]) 7. The maximum number of IF functions that can be nested as value_if_true and value_if_false arguments is: (a) 4 (b) 16 (c) 32 (d) 64 8. In an MS Excel...
Words: 2510 - Pages: 11
...want every student to input his roll number and scan his finger for attendance, you need to have a combination of: (a) Keypad, Mouse, OCR Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array, col_index_num, [range_lookup]) (b) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) (c) VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) (d) VLOOKUP(row_value, table_array, col_index_num, [range_lookup]) The maximum number of IF functions that can be nested as value_if_true and value_if_false arguments is: (a) 4 (b) 16 (c) 32 (d) 64 In an MS Excel worksheet...
Words: 2503 - Pages: 11
...6/10/2016 UIICL AO 2016 Pattern and Syllabus UIICL AO 2016 Pattern and Syllabus By Aruna - May 7, 2016 Dear Aspirants, Here we are providing you the exam pattern & detailed syllabus for United India Insurance Administrative Officer (Generalist). The Online Exam(objective & Descriptive test) will be held on 12.06.2016.(Tentative). UIICL AO 2016 Exam Pattern UIICL AO 2016 Exam Syllabus Reasoning Total No of Questions: 50 Maximum Marks: 50 The topics to be covered for Reasoning Ability are http://www.affairscloud.com/uiiclao2016patternsyllabus/ 1/5 6/10/2016 UIICL AO 2016 Pattern and Syllabus Machine Input/Output Syllogism Blood Relation Direction Sense Inequalities Puzzles – Seating Arrangement(North – South, Circular, Rectangle) Floor puzzle, etc. Coding Decoding Ranking Statement and Assumptions/Conclusions English Language Total No of Questions: 40 Maximum Marks: 40 The topics to be covered in this section are Reading comprehension including Synonyms and Antonyms Sentence rearrangement or Para jumbles Sentence Correction/ Error Finding Spell Checks Fillers Cloze Test Quantitative Aptitude Total No of Questions: 50 Maximum Marks: 50 The topics to be covered in this section are http://www.affairscloud.com/uiiclao2016patternsyllabus/ 2/5 6/10/2016 UIICL AO 2016 Pattern and Syllabus Simplification Number Series Data Sufficiency Data Interpretation [ Bar Graph, Pie Chart, Table, Line Graph, Radar Chart...
Words: 559 - Pages: 3
...DETAILED SYLLABUS POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS (PGDCA) (EFFECTIVE FROM JULY 2011) Department of Computer Applications Makhanlal Chaturvedi Rashtriya Patrakarita Evam Sanchar Vishwavidyalaya B-38, Press Complex, M.P. Nagar, Zone-I, Bhopal Ph.: 4294448, 2768274 www.mcu.ac.in SCHEME FOR POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS (PGDCA) (Effective From July 2011 Session) SEMESTER -I Subject Code Subject Name Scheme L 1PGDCA1 1PGDCA2 1PGDCA3 1PGDCA4(A) 1PGDCA4(B) Fundamentals of Computers & Information Technology Introduction to Operating Systems (Dos, Windows, Linux) PC Packages Elective - 1 Foxpro MS-Access 4 4 1 3 T P Theory Paper 80 80 Internal Evaluation 20 20 Practical Exams Total Marks 100 100 4 4 1 3 3 80 80 20 20 25 25 125 125 Semester Total 450 (*L-Lecture, T-Tutorial, P-Practical) SEMESTER –II Subject Code Subject Name Scheme L 2PGDCA1 2PGDCA2 2PGDCA3 2PGDCA4(A) 2PGDCA4(B) 2PGDCA5 System Analysis and Design Programming with Visual Basic.NET Internet & E-Commerce Elective - 2 OOPs & Programming with C++ Financial Accounting with Tally Project Work 4 4 4 4 T 1 P 3 3 3 Theory Paper 80 80 80 80 Internal Evaluation 20 20 20 20 Practical Exams Total Marks 100 125 100 125 25 1 25 4 100 Semester Total 550 General Instructions: 1. For passing the subject examination minimum 40% marks must be separately scored in Theory Paper, Practical Exams and Internal Evaluation in the subject. 2. For...
Words: 4021 - Pages: 17
...particular attack is a remote code execution vulnerability which could allow an attacker to remotely take over your system. The vulnerability is caused by a memory corruption error while handling malformed strings in a Microsoft Office document. The attacker would create specially crafted MS Office files send them as email attachments, or they could host a web site and lure you into visiting by simply clicking on a link. Opening the email attachment could corrupt the system memory and allow the attacker to execute arbitrary code. The workaround for this attack is do not open or save files received from unknown sources or that come unexpectedly from trusted sources. The cure is to apply appropriate patches. The next attack is in Outlook Web Access and it could allow Elevation of Privileges. The attacker could hijack the OWA session and perform actions on behalf of the authenticated user without the user’s knowledge. This vulnerability affects Microsoft exchange server 2000, 2003, 2007 so Microsoft suggests upgrading to a non-affected edition. Customers that can’t upgrade should refer to workarounds to avoid being exploited. The third issue being described is vulnerability in Windows Shell which could allow remote code execution. This is a shortcut icon loading vulnerability and it is suggested that for assistance with this problem you should contact support directly because...
Words: 350 - Pages: 2
...plagiarism as per the AOU's rules and regulations. Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work): I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work. Name of Student:……………………………….. Signature:…………………………………………... Date:…………………………………………………… Introduction You should submit your completed assignment to arrive no later than the cut-off date 11/12/2013. This TMA represents 20% of your all over mark of the course. Use the Learning Management System or the ACES to submit your TMA. Use Microsoft office Word to answer the questions in one file. The drawing questions can be answered using the drawing tools in the Word or any other drawing software but at the end the diagrams should be pasted into the Word file. Please send with your submission the signed declaration of no plagiarism by Student. There are THREE questions: You should answer ALL QUESTIONS. Question One (10...
Words: 623 - Pages: 3
...Section –A (10 X 1.5=15) Answer all the questions 1. What is computer? 2. Define operating system. 3. How do you close the word document? 4. State the shortcut Key to copy and paste. 5. Define print preview Ms-Excel. 6. List out the options in view menu. 7. Define Database. 8. What you mean by primary key? 9. How to start the power point? 10. How to move the text in power point? Section-B (5 X 4=20) Answer all the questions 11. Explain various characteristics of computer. (or) Discuss about software. 12. Discuss various alignment of the text in Ms-word. (or) Explain various components of File menu. 13. Explain about Date and Time function in Ms-Excel. (or) Write a note on auto format in Ms-Excel. 14. Write the main feature of Ms-Access database. (or) Write a note on saving table in Ms-Access. 15. Explain about adding animation in power point. (or) Discuss about creating presentation using template. Section-C ( 2 X 7.5 = 15) Answer any two questions 16. Discuss about Input / Output devices in Computer. 17. Describe the steps involved in creating a mail merge. 18. Explain student mark list using formula in MS-Excel. 19. How to Create new presentation in power point. Section –A (10 X 1.5=15) Answer all the questions 1.List out the function of computer. 2.List out any three Output device. 3.What is the Use of find command? 4.How to start...
Words: 1165 - Pages: 5
...Ex2.4.1 - click start, click run, type cmd or command and press enter. Review 1. ? 2. The CLI was the primary means of interaction with most computer systems until the introduction of the video display terminal in the mid-1960s, and continued to be used throughout the 1970s and 1980s on Unix systems and personal computer systems including MS-DOS, CP/M and Apple DOS. The interface is usually implemented with a command line shell, which is a program that accepts commands as text input and converts commands to appropriate operating system functions. Command-line interfaces to computer operating systems are less widely used by casual computer users, who favor graphical user interfaces. Command-line interfaces are often preferred by more advanced computer users, as they often provide a more concise and powerful means to control a program or operating system. Programs with command-line interfaces are generally easier to automate via scripting. Alternatives to the command line include, but are not limited to text user interface menus (see IBM AIX SMIT for example), keyboard shortcuts, and various other desktop metaphors centered on the pointer (usually controlled with a mouse). 3. In computing, graphical user interface (GUI,[1] sometimes pronounced "gooey" or "gwee")[2] is a type of user interface that allows users to interact with electronic devices through graphical icons and visual indicators such as secondary notation, as opposed to text-based interfaces, typed command labels...
Words: 380 - Pages: 2
...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
...Windows 1.0 – 2.0 (1985-1992) Instead of typing MS-DOS commands, Windows 1.0 allowed users to point and click to access the windows. In 1987 Microsoft released Windows 2.0, which was designed for the designed for the Intel 286 processor. This version added desktop icons, keyboard shortcuts and improved graphics support. Q: Why was Windows OS named so? Microsoft Windows 1.0 was named so since the computing boxes, or Windows design represented a fundamental aspect of the operating system. Windows 3.0 – 3.1 (1990–1994) Microsoft released Windows 3.0 in May, 1900 offering better icons, performance and advanced graphics with 16 colors designed for Intel 386 processors. Its popularity grew by manifolds following the release of SDK that helped software developers focus more on writing and less on writing device drivers. With Windows 3.0 Microsoft completely rewrote the application development environment. The OS included Program Manager, File Manager and Print Manager and games, remember Solitare, a complete time waster?? Q: What does SDK stands for? SDK refers to a set of tools that allows for the creation of applications for certain software. Windows 95 (August 1995) A major release of the Microsoft Windows operating system that caused Apple’s Market share to decline or shrink was Windows 95. Windows 95 as the name suggests was released in 1995 represented a significant advance over its precursor, Windows 3.1. By the way, this was also the time when the first version of...
Words: 842 - 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 Windows discussion...
Words: 9310 - Pages: 38
...devices), and portable media players. History In 1975, Bill Gates and Paul Allen form a partnership called Microsoft, deriving the name from the words microcomputer and software. Then in 1980 Microsoft focuses on a new operating system—the software that manages, or runs, the computer hardware and also serves to bridge the gap between the computer hardware and programs, such as a word processor. It’s the foundation on which computer programs can run. They name their new operating system "MS‑DOS." On November 20, 1985, two years after the initial announcement, Microsoft ships Windows 1.0. Now, rather than typing MS‑DOS commands, you just move a mouse to point and click your way through screens, or “windows.” Bill Gates says, “It is unique software designed for the serious PC user.” On December 9, 1987 Microsoft releases Windows 2.0 with desktop icons and expanded memory. With improved graphics support, you can now overlap windows, control the screen layout, and use keyboard shortcuts to speed up your work. Some software...
Words: 886 - Pages: 4