Current Affairs PDF

Microsoft Office

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

MS Word

MSWORD programme is called a word-processing package. This means that it is useful for typing and storing letters, articles and anything that consists mainly of words. Many of Word’s most powerful formatting and processing tools may remain hidden until you discover where they are and learn how to use them. MS Word administrative documents are created and stored as files where information can be entered, edited and formatted and saved electronically. MS Word can be used to type letters, memos, notices, fax cover sheets and envelopes for mailing or distribution. Newsletters, brochures and books can also be created using MS Word. Additional graphs, photographs, charts, drawings and tables can be inserted into a Word document to further illustrate and enhance administrative documents. Microsoft Word’s native file formats are denoted either by a .doc or .docx file extension.

Function Keys
F1 Get help or visit Microsoft office Online.
F2 Move text or graphic.
F4 Repeat the last action
F5 Choose the Go To command (Home tab).
F6 Go to the nest pane or frame.
F7 Choose the spelling command (Review tab)
F8 Extend a selection
F9 Update the selected fields
F10 Show key tips
F11 Go to the nest field
F12 Choose the Save As command (Microsoft Office Button).
Control Keys + Function keys
Ctrl+F2 Choose the print preview command (Microsoft office Button)
Ctrl+F3 Cut on the spike
Ctrl+F4 Close the window
Ctrl+F6 Go to the next window
Ctrl+F9 Insert an empty field
Ctrl+F10 Maximise the document window
Ctrl+F11 Lock a field
Ctrl+F12 Choose the Open command (Microsoft Office Button)
Basic Keys Common Tasks
Ctrl + Shift + Spacebar Create a non breaking space
Ctrl + B Make letters bold
Ctrl + I Make letters italic
Ctrl + U Make letters underline
Ctrl + Shift+ < Decrease font size one value
Ctrl + Shift + > Increase the font size one value
Ctrl + [ Increase the font size by 1 point
Ctrl + ] Decrease the font size by 1 point
Ctrl + Spacebar Remove paragraph or character formatting.
Ctrl + C Copy the selected text or object
Ctrl + X Cut the selected text or object
Ctrl + V Paste text or an object
Ctrl + Alt + V Paste special
Ctrl + Shift + V Paste formatting only
Ctrl + Z Undo the last action
Ctrl + Y Redo the last action

 

Ms Excel

Spreadsheets, files and memos are necessary documents in most businesses. Until computers became part of the typical business office, these types of records were created on paper and stored in metal filing cabinets. Today, these records are created using computer software programs such as Microsoft Word or Excel and filed electronically.Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes. Excel can store and calculate the data as directed using existing or new data.

Shortcut Keys of MS-Excel
Key Description
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check selected text and/or document
F11 Create chart
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Shift + F3 Open the Excel formula window
Shift + F5 Bring up search box.
Ctrl + A Select all contents of the worksheet
Ctrl + B Bold highlighted selection
Ctrl + I Italic highlighted selection
Ctrl + U Underline highlighted selection
Ctrl + P Bring up the print dialog box to begin printing
Ctrl + Z Undo last action
Ctrl + F9 Minimise current workbook
Ctrl + F10 Maximise currently selected workbook
Ctrl + F6 Switch between open workbooks/window
Ctrl + page up Move between Excel worksheet in the same Excel document.
Ctrl + Page Down Move between Excel worksheets in the same Excel document
Ctrl + Tab Move between two or more open Excel files
Alt + = Create a formula to sum all of the above cells
Ctrl + ’ Insert the value of the above cell

into cell currently selected.

Ctrl + Arrow key Move to next section to text
Ctrl + Space Select entire column
Shift +

Space

Select entire row

MS-Powepoint

It is a PowerPoint that anyone can use. You can draw pictures with it. MS PowerPoint is a software application that has replaced 35mm slide shows of the past. One creates this presentation tool by creating a series of horizontally formatted “slides”.

Video and audio can also be added here. The uses of PowerPoint seem to be endless. Almost any presentation can be enhanced through visual and sound effects, and this application has become the standard tool to do so.

PowerPoint presentations consist of a number of individual pages or “slides”. Microsoft PowerPoint’s native file formats are denoted either by a .ppt or .pptx file extension.

MS Access

MS-Access is a database management tool of Microsoft. This is given with MS-Office package. There is need for a database management tools like Access for all corporate and private organizations etc., where large amount of data to be handled.

Advantages of MS-Access
MS-Access has very easy operating procedure compared to other database management tools that are available. Also this is fairly cheaper and can be installed in most of the computers. Table creation is simply done by design or wizard options. Data entered and stored in MS-Access can easily be exported or pasted into spreadsheets or statistical software for further analysis.

As part of the MS Office Suite, MS Access integrates seamlessly with MS Word and Excel. Any data stored in MS-Access can be easily used throughout the MS-Office applications.In general users with little programming knowledge can use MS Access effectively.

There are useful menus like “File, Edit etc., to provide users a very effective usage of good database management. There is no console window, no complex Syntaxes, and no complex queries for Ms-Access. These are common characteristics of most of the database management tools. So MS-Access is a very effective database management tool without any normally occurring distractions of a common database management tool.