Excel Learning.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Excel Learning.xlsx as PDF for free.
More details
- Words: 424
- Pages: 13
Overwriting and Editing Cells Editing Formulas/Functions Using Undo/Redo Find and replace Goto
Mondays Tuesdays Wednesday Thursdays Fridays Saturdays Mondays
40 45 50 55 60 65 70 385
235
Type of data a cell can accept Relative Reference Day
Expenses Income
Revenue
Text 1 0 89 #DIV/0! #DIV/0!
Sunday Monday Tuesday Wednesda Thursday Friday Saturday
20000 19000 13578 21344 22234 23344 12345
13000 12007 6578 13563 14567 5345 5433
7000 6993 7000 7781 7667 17999 6912
Formating in Excel Font Alignment Number
Font
Alignment
Bold Italics Underline Border Background Color
Text
Font Color Font 1
Font 2 Font 3
Numbers 10 20 30 40
Dates 12 December 2018 13 December 2018 14 December 2018 15 December 2018
Currency $10.00 $20.00 $30.00 $40.00
Absolute Reference Name Grade Totals Max Score Prakash Satyam Yakshit Mamta Bachi Kamla Bishan
Percentage 100 60 65 70 75 80 85 90
60% 65% 70% 75% 80% 85% 90%
Mixed Reference
Multiplication Table Row Header
Column Header 10 20 30 40 50 60
1 10 20 30 40 50 60
2 20 40 60 80 100 120
3 30 60 90 120 150 180
4 40 80 120 160 200 240
Speak Cells speak cells speak cells by row speak cells by coumn speak cells on Enter stop speaking cells
tutorials Point
class maths science computer prakash vijay
class maths science computer prakash vijay
class maths science computer prakash vijay
Separator is space Names Prakash Singh Dasila Bachi Singh Dasila Bishan singh Dasila Satyam Singh Dasila Kamla Dasila Mamta Dasila Yakshit Singh Dasila
Devices Mobile&Laptop Indoor&outdoor
Pra Bac Bis Sat Kam Mam Yak
Mobile Indoor
Laptop outdoor
kash S hi Sin han si yam Si la Das ta Das shit S
ingh Dasila gh Dasila ngh Dasila ngh Dasila ila ila ingh Dasila
Comments Insert comments Edit comments Delete comments Show all Comments
copy paste paste special copying cell(s) to one/many cells copying to different worksheets Using fill for quick copying
vijay vijay vijay vijay
name price in USD rita ₹ 10.00 $25.00 neeta ₹ 20.00 $30.00 siddhart ₹ 30.00 $35.00 raja ₹ 40.00 $40.00 john ₹ 50.00 $45.00
name price rita ₹ 10.00 neeta ₹ 20.00 siddhart ₹ 30.00 raja ₹ 40.00 john ₹ 50.00
vijay vijay vijay vijay name price in USD
rita neeta siddhart raja ₹ 10.00 ₹ 20.00 ₹ 30.00 ₹ 40.00 $25.00 $30.00 $35.00 $40.00
0:08 12/24/2018 24-12-201824-12-2018 0:10 12/24/2018 12/24/2018 24-12-20180:10 0:10
in USD $25.00 $30.00 $35.00 $40.00 $45.00
john ₹ 50.00 $45.00
no.1
no.2 10 20 30 40 50
35 50 65 80 95
vijay
Mondays Tuesdays Wednesday Thursdays Fridays Saturdays Mondays
40 45 50 55 60 65 70 385
235
Type of data a cell can accept Relative Reference Day
Expenses Income
Revenue
Text 1 0 89 #DIV/0! #DIV/0!
Sunday Monday Tuesday Wednesda Thursday Friday Saturday
20000 19000 13578 21344 22234 23344 12345
13000 12007 6578 13563 14567 5345 5433
7000 6993 7000 7781 7667 17999 6912
Formating in Excel Font Alignment Number
Font
Alignment
Bold Italics Underline Border Background Color
Text
Font Color Font 1
Font 2 Font 3
Numbers 10 20 30 40
Dates 12 December 2018 13 December 2018 14 December 2018 15 December 2018
Currency $10.00 $20.00 $30.00 $40.00
Absolute Reference Name Grade Totals Max Score Prakash Satyam Yakshit Mamta Bachi Kamla Bishan
Percentage 100 60 65 70 75 80 85 90
60% 65% 70% 75% 80% 85% 90%
Mixed Reference
Multiplication Table Row Header
Column Header 10 20 30 40 50 60
1 10 20 30 40 50 60
2 20 40 60 80 100 120
3 30 60 90 120 150 180
4 40 80 120 160 200 240
Speak Cells speak cells speak cells by row speak cells by coumn speak cells on Enter stop speaking cells
tutorials Point
class maths science computer prakash vijay
class maths science computer prakash vijay
class maths science computer prakash vijay
Separator is space Names Prakash Singh Dasila Bachi Singh Dasila Bishan singh Dasila Satyam Singh Dasila Kamla Dasila Mamta Dasila Yakshit Singh Dasila
Devices Mobile&Laptop Indoor&outdoor
Pra Bac Bis Sat Kam Mam Yak
Mobile Indoor
Laptop outdoor
kash S hi Sin han si yam Si la Das ta Das shit S
ingh Dasila gh Dasila ngh Dasila ngh Dasila ila ila ingh Dasila
Comments Insert comments Edit comments Delete comments Show all Comments
copy paste paste special copying cell(s) to one/many cells copying to different worksheets Using fill for quick copying
vijay vijay vijay vijay
name price in USD rita ₹ 10.00 $25.00 neeta ₹ 20.00 $30.00 siddhart ₹ 30.00 $35.00 raja ₹ 40.00 $40.00 john ₹ 50.00 $45.00
name price rita ₹ 10.00 neeta ₹ 20.00 siddhart ₹ 30.00 raja ₹ 40.00 john ₹ 50.00
vijay vijay vijay vijay name price in USD
rita neeta siddhart raja ₹ 10.00 ₹ 20.00 ₹ 30.00 ₹ 40.00 $25.00 $30.00 $35.00 $40.00
0:08 12/24/2018 24-12-201824-12-2018 0:10 12/24/2018 12/24/2018 24-12-20180:10 0:10
in USD $25.00 $30.00 $35.00 $40.00 $45.00
john ₹ 50.00 $45.00
no.1
no.2 10 20 30 40 50
35 50 65 80 95
vijay
Related Documents
Excel
November 2019 4
Excel
November 2019 5
Excel
October 2019 18
Excel
May 2020 7
Excel
November 2019 21
Excel
May 2020 8More Documents from ""
Game Design Document.docx
December 2019 2
Excel Learning.xlsx
December 2019 7
Out Of The Night That Covers Me
May 2020 100
Intake System.docx
May 2020 102
Tari Padoa Tarian Tradisional Dari Sabu Raijua.docx
June 2020 96