OA

Office Automation

Assignment 2 

1. What is Data in concept of excel with excel data type?  
2. What is cell? Explain with cell address.
3. What is cell reference ? Explain types of cell reference.
4.  Explain the concept of formula ,operator and operator precedence?
5. What is If analysis ? Explain with proper example.
6. Explain following formula of excel.

round	sum	max	min
average	upper	lower	len
ceil	floor	fact	count
logical and	logical or	logical not
today	now	day	days360
hours	minutes	second	year
text	find	trim	exact
left	right	text Concatenate
hlookup	vloopup

 Office Automation 
EX - 1

Ex 2

Ex : 3

Ex :4