Prepare for your exams
Get points
Guidelines and tips

Sell on Docsity

Prepare for your exams

Study with the several resources on Docsity

Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips

Sell on Docsity

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents

20 Points

For each uploaded document

Answer questions

5 Points

For each given answer (max 1 per day)

All the ways to get free points

Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study

Go to the blog

Advanced Mathematical Calculations-Advanced Excel Computations-Lecture Slides, Slides of MS Microsoft Excel skills

Indian Institute of Tourism and Travel Management MS Microsoft Excel skills

This lecture was delivered by Sameer Kapoor at Indian Institute of Tourism and Travel Management, Bhubaneswar to explain following points related Microsoft Excel: Align, Cell, Entries, Perform, Advanced, Mathematical, Calculations, Insert, Delete, Columns

Typology: Slides

2011/2012

Uploaded on 07/12/2012

divakar 🇮🇳

4.1

(25)

72 documents

1 / 21

This page cannot be seen from the preview

Don't miss anything!

Align Cell Entries

When you type text into acell, by default your entry

aligns with the left side of the cell.When you type

numbers into acell, by default your entry aligns with

the right side of the cell.You can change the cell

alignment.You can center, left-align, or right-align any

cell entry.Look at cells A1 to D1. Note that they are

aligned with the left side of the cell.

Docsity.com

Partial preview of the text

Download Advanced Mathematical Calculations-Advanced Excel Computations-Lecture Slides and more Slides MS Microsoft Excel skills in PDF only on Docsity!

Align Cell Entries

 When you type text into a cell, by default your entry

aligns with the left side of the cell. When you type

numbers into a cell, by default your entry aligns with

the right side of the cell. You can change the cell

alignment. You can center, left-align, or right-align any

cell entry. Look at cells A1 to D1. Note that they are

aligned with the left side of the cell.

Centre align

Right align

Perform Advanced Mathematical Calculations

Cont…

 1. Move to cell A7.

 2. Type =3+3+12/2*4.

 3. Press Enter.

Cont…

 To change the order of calculation, use parentheses.

Microsoft Excel calculates the information in

parentheses first.

 1. Double-click in cell A7.

 2. Edit the cell to read =(3+3+12)/2*4.

 3. Press Enter.

Copy with the Mini Toolbar

Insert and Delete Columns and

Rows  To delete columns F and G

 Click the column F indicator and drag to column G.

 Click the down arrow next to Delete in the Cells group. A menu appears.

 Click Delete Sheet Columns. Excel deletes the columns you selected.

 Click anywhere on the worksheet to remove your selection.

insert a column: To insert rows:

 Click on A to select column A.

 Click the down arrow next to Insert in the Cells group. A menu appears.

 Click Insert Sheet Columns. Excel inserts a new column.

 Click anywhere on the worksheet to remove your selection.

 Click on 1 and then drag down to 2 to select rows 1 and

 Click the down arrow next to Insert in the Cells group. A menu appears.  Click Insert Sheet Rows. Excel inserts two new rows.  Click anywhere on the worksheet to remove your selection.

Create Borders

 You can use borders to make entries in your Excel

worksheet stand out. You can choose from several

types of borders. When you press the down arrow

next to the Border button , a menu appears. By

making the proper selection from the menu, you can

place a border on the top, bottom, left, or right side

of the selected cells; on all sides; or around the

outside border. You can have a thick outside border

or a border with a single-line top and a double-line

bottom. Accountants usually place a single underline

above a final number and a double underline below.

Borders will be added like this

Merge and Center

 Sometimes, particularly when you give a title to a

section of your worksheet, you will want to center a

piece of text over several columns or rows. The

following example shows you how.

Add Background Color

Change the Font, Font Size, and

Font Color

Advanced Mathematical Calculations-Advanced Excel Computations-Lecture Slides, Slides of MS Microsoft Excel skills

Related documents

Partial preview of the text

Download Advanced Mathematical Calculations-Advanced Excel Computations-Lecture Slides and more Slides MS Microsoft Excel skills in PDF only on Docsity!

Align Cell Entries

 When you type text into a cell, by default your entry

aligns with the left side of the cell. When you type

numbers into a cell, by default your entry aligns with

the right side of the cell. You can change the cell

alignment. You can center, left-align, or right-align any

cell entry. Look at cells A1 to D1. Note that they are

aligned with the left side of the cell.

Centre align

Right align

Cont…

 1. Move to cell A7.

 2. Type =3+3+12/2*4.

 3. Press Enter.

Cont…

 To change the order of calculation, use parentheses.

Microsoft Excel calculates the information in

parentheses first.

 1. Double-click in cell A7.

 2. Edit the cell to read =(3+3+12)/2*4.

 3. Press Enter.

Copy with the Mini Toolbar

Create Borders

 You can use borders to make entries in your Excel

worksheet stand out. You can choose from several

types of borders. When you press the down arrow

next to the Border button , a menu appears. By

making the proper selection from the menu, you can

place a border on the top, bottom, left, or right side

of the selected cells; on all sides; or around the

outside border. You can have a thick outside border

or a border with a single-line top and a double-line

bottom. Accountants usually place a single underline

above a final number and a double underline below.

Borders will be added like this

 Sometimes, particularly when you give a title to a

section of your worksheet, you will want to center a

piece of text over several columns or rows. The

following example shows you how.

 A font is a set of characters represented in a single

typeface. Each character within a font is created by

using the same basic style.

 Excel provides many different fonts from which you

can choose.

 The size of a font is measured in points. There are 72

points to an inch. The number of points assigned to a

font is based on the distance from the top to the

bottom of its longest character.

 You can change the Font, Font Size, and Font Color of

the data you enter into Excel.