Sunday, July 26, 2020

#Microsoft Excel



















it is a spreadsheet program it is part of Microsoft office .
and it is used for creating budget , Mark sheet, Payroll, Invoice etc. it is used for planning project also.

How to open excel 2007
start------all programs-----Microsoft office ---Microsoft office excel
or
windows+r----------------run----------Excel
it is used for all excel versions like 2003, 2007, 2013 etc.

Workbook
 it is collection of worksheets.

Worksheets
it is collection of rows and columns. by default 3 worksheets open with a workbook.

Rows
it is horizontal block of cells that runs through the entire
width of worksheets.
Rows-------------2003-------------65,536
Rows-------------2007,10,13-------------1,048576

Columns
it is vertical block of cells that runs through entire worksheet.

Columns------------2003-------------256(A to IV)
Columns------------2007,10,13-------------16,384 (A to XFD)

Cell
it is an intersection of a row and a column.
Cells----------2003-------------167,77,216,
Cells------------2007, 10, 13-------------17,17,98,69,184

it's Tab in 2007
  • Home
  • Insert
  • Page layout
  • Data
  • Formula
  • Review
  • View


it's Extension-
.xls-------------2003
.xlsx----------------2007
.xlt-----------------Excel template
.xlm---------------Excel macro

Note
The first electronic worksheet was Visicalc.

No comments:

Post a Comment

MCQ QUESTIONS

Loading…