Computer & Main Parts of Computer – MS Excel and MS PowerPoint

Get unlimited access to the best preparation resource for UGC : Get detailed illustrated notes covering entire syllabus: point-by-point for high retention.

Download PDF of This Page (Size: 126K)

Short Cut Keys and Function Keys

Short Cut Keys and Function Keys
Short cut keys and Function keys

Shortcut keys

Functions

Ctrl + Shift + Spacebar

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 + 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

F1

Get help or visit Microsoft office Online.

F4

Repeat the last action

F7

Choose the spelling command

F5

Choose the Go To command

F12

Choose the Save As command

MS Excel

  • Microsoft Excel is a software program developed by Microsoft Corp. that allow users to organize, format and calculate data with formulas using a spreadsheet system. The exact number of rows and columns are 1,048,576 rows and 16,384 columns.

  • It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Some Important Terms Used in Excel

  • Cell – A cell is the intersection of a row and a column. A cell can contain a label, a numeric value, or a formula.

  • Cell address - A cell address is the location of a cell on a worksheet and is defined by the column letter and the row number.

  • Active Cell - cell in which we are currently working .

  • Formula bar - The formula bar is located under the toolbars at the top of the working screen. It contains the edit line for working with formulas, and provides information regarding cell addresses.

  • Functions - A function is a preset formula. Functions consist of the function name and its arguments. The function name tells Excel what calculation you want it to perform.

  • PivotTable Wizard - The PivotTable Wizard is a series of dialog boxes that guides you step-by-step through the process of creating a PivotTable.

  • Print Preview Controls - Print Preview mode offers a set of control buttons to make the feature more useful. Click Close to exit Print Preview mode.

  • Spreadsheet - Spreadsheet is the generic term for applications, such as Excel, that you can use to enter, analyze, and calculate data. It performs mathematical calculations and projections based on data entered. Common spreadsheet uses include analysis, charting, and budgeting.

  • Syntax - The syntax of the function refers to the order of the functions arguments. In some functions, the order of the arguments determines how Excel solves the function.

  • Worksheet - A worksheet is an electronic spreadsheet that lets you enter, analyze, and calculate data. Within a workbook, worksheets can share information, and calculations pertaining to several worksheets can be performed at one time. The default number of worksheets in a new workbook is three.

Shortcut Keys of Ms Excel

Shortcut Keys of Ms Excel
Shortcut keys of Ms Excel

Shortcut keys

Functions

Ctrl + Shift + ;

Enter the current time

Ctrl + ;

Enter the current date

Ctrl + Space/Shift + Space

Select entire column/Select entire row

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

F2

Edit the selected cell

F5

Go to a specific cell

Ctrl + F6

Switch between open workbooks/window

F7

Spell check selected text and/or document

F11

Create chart

MS PowerPoint

  • The application software that can create professional looking visual aids is called Presentation Graphics Software.

  • MS-PowerPoint can be started by clicking at Start—Program---Microsoft PowerPoint.

  • A slide can contain one or more of these components: Titles, Graphs, Drawing objects, ClipArt and Pictures.

  • The slide components that are used for reference are: Handouts, Notes ,Outlines.

A new presentation can be created through one of these methods:

  1. Auto content Wizard

  2. Design Templates

  3. Sample Presentation and

  4. Blank Presentation

Some Important Terms

  • Animations - Animations are effects that allow you to reveal the points on a slide one by one.

  • AutoClipArt - Use the AutoClipArt command to begin a concept keyword search of your slideshow. PowerPoint searches your slideshow for keywords that relate to the keywords associated with clip art images in the Clip Gallery.

  • Background - The Background dialog box provides various options that let you change the background look of a single slide or every slide in the presentation.

  • Presentation - A presentation is a collection of slides, handouts, speaker’s notes, and an outline, all combined into a file that can be printed onto transparencies or projected from a computer.

  • Slides - Slides are the individual pages of your presentation. Slides can be designed with different titles, graphics, text, and much more.

  • Slide Sorter Toolbar - The Slide Sorter toolbar is available only in Slide Sorter view, and allows quick access to special PowerPoint effects such as transitions, builds, rehearse timing, and hide slides.

  • Slide Sorter View - Slide Sorter View displays a reduced image of all the slides in a grid-like fashion. This view makes it easier to rearrange the slides in a presentation and add transitions and special effects.

  • Slide View - Slide View allows you to work on one slide at a time. While in Slide View, you can add any element to a slide, including text, graphics, shapes, and graphs.

Database Management System (DBMS)

Database Management System is About Managing and structuring the collections of data held on computers. A database consists of an organized collection of data for one or more uses, typically in digital form. Database involves the type of their contents. Eg:- bibliographic, document - text, statistical.

Developed by: