Learn The Basics of MS Office For Bank Exam

Computers Knowledge is gaining importance in the Bank Exams of IBPS or SBI and Microsoft Office is one of the key components. It’s very essential to know the basics of Microsoft Office as it’s used in the day-to-day activity of banks and so the candidates are expected to answer correctly in exams.

Also learn about the History of ComputersComputer Hardware, Operating Systems, Computer Software, and Database.

Basics of MS Office
Basics of MS Office

What is Microsoft Office?

Microsoft Office is a suite of desktop productivity applications that is specifically designed to be used for offices or business areas.

Microsoft Office is available in 35 different languages which are supported by Windows, Mac, and most Linux variants. It mainly consists of Word, Excel, PowerPoint, Access, OneNote, Outlook, and Publisher applications.

What is Microsoft Word?

Microsoft word known as MS-WORD is a graphical word processing program. Its made by Microsoft company. It allows users to type and save
documents. MS-WORD has a few helpful tools which make the document easy and very presentable.

Such tools are Spelling and Grammar checker, Speech recognition, word count, font formatting, HTML support, Insert picture, Insert Audio, Insert Video, and many more.

MS-WORD is available for Microsoft Windows, Apple macOS, Andriod, and Apple iOS. It can also run on a Linux operating system using WINE.
If your MS-WORD or Microsoft office is installed in your system then you can find MS-WORD in the start menu. There are default 29 lines on a page in MS-WORD.

Earlier versions of Microsoft word primarily create a .doc file and a newer version can create a .docx file extension. The most recent version can create and open the following types of files: .doc, .docx, .htm, .html, .pdf, .txt, and many more. The latest version of MS-WORD is MS-WORD 2019.

Useful shortcut keys for MS-WORD

Sr No.KeyDescription
1Ctrl + NOpen new/blank document
2Ctrl + OOpen options
3Ctrl + P Open the print window
4Ctrl + FOpen find box
5Ctrl + MIndent the paragraph
6Ctrl + THanging indent
7Ctrl + DFont options
8Alt + Shift + DInsert the current date
9Alt + Shift + TInsert the current time
10Shift + F7Activate the thesaurus.

What is Microsoft Excel?

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It’s a spreadsheet program that contains a number of columns and rows, where each intersection of a column and a row is a “cell”.

Each cell contains one point of data or one piece of information. Each Excel file is a workbook that can hold many worksheets. This worksheet is a grid of columns and rows. A cell can contain text, numbers, or formulas for automatic calculations.

Useful shortcut keys for Microsoft Excel

Sr No.KeyDescription
1F2Edit the selected cell
2F5Go to a specific cell
3F7Spell check selected text and/or document
4F11Create chart
5Ctrl + Shift + ;Enter the current time
6Ctrl + ;Enter the current date
7Alt + Shift + F1Insert new worksheet
8Shift + F3Open the Excel formula window
9Alt + =Create the formula to sum all of the above cells
10Ctrl +Insert the value of above cell into the current cell

What is Microsoft PowerPoint?

Microsoft PowerPoint is a presentation program. It was developed by Dennis Austin and Thomas Ruskin. Later Microsoft acquired PowerPoint. In August 1987, Microsft bought it and bundled it together with Word, Excel, and other office tools.

It is a standard component of the company’s Microsoft Office suite. A powerpoint presentation is prepared by a group of slides, each PowerPoint Slide can be created from scratch or a template can be used. Each Slide contains information you want to present.

The presentation can also have animations and images. However, a good presentation contains only the main idea and that idea is presented by the speaker. Once the presentation is ready to show the audience it can be opened in full-screen mode which covers up the entire screen.

Useful shortcut keys for Microsoft PowerPoint

Sr No.KeyDescription
1Ctrl+NCreate a new presentation
2Ctrl+OOpen an existing presentation
3Ctrl+QSave and close a presentation
4Alt+QGo to the “Tell me what you want to do” box
5F7Check to spell
6Alt or F10Turn key tips on or off
7Ctrl+F1Show or hide the ribbon
8Ctrl+FSearch in a presentation or use Find and Replace
9Alt+SGo to the Slide Show tab
10Alt+RGo to the Review tab

What is Microsoft Outlook?

Microsoft Outlook is an application that is used to send or receive emails. It also manages various types of personal data including calendar appointments and similar entries, tasks, contacts, and notes.

Microsoft Outlook can be downloaded online and get installed on the system. It can be used as a standalone application but is also part of the Microsoft Office Suite.

Once installed, we need to configure it before we can start sending emails and etc. Check do you have already any version of Microsoft Outlook installed on the system. To check type “Outlook” on the search window on Taskbar and press enter. If it’s installed it will open else need to download the latest version of outlook.

Useful shortcut keys for Microsoft Outlook

Sr No.KeyDescription
1Alt + SSend the email
2Ctrl + KComplete name/email typed in the address bar
3Ctrl + RReply to an email
4Ctrl + FForward an email
5Ctrl + NCreate a new email
6Ctrl + Shift + ACreate a new appointment to your calendar
7Ctrl + Shift + OOpen the outbox
8Ctrl + Shift + KAdd a new task
9Ctrl + Shift + CCreate a new contact
10Ctrl + Shift+ JCreate a new journal entry

What is Microsoft Access?

Microsoft Access is a Database Management System (DBMS) from Microsoft. It is a member of the Microsoft Office suite of applications,
included in the professional and higher versions. It combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.

It stores data in its own format based on the Access Jet Database Engine. Access can work directly with data from other sources, which
includes SQL (Structured Query Language) databases on the desktop, on servers, on minicomputers, or on mainframes, and with data stored on Internet or intranet web servers.

Access can work with the most popular databases that support the Open Database Connectivity (ODBC) standard, including SQL Server, Oracle, and DB2.