Embedded Files
Q1 What is Data?
A1 Any structured information is called Data.
Q2 What are different types of DataTypes?
A2
Numeric – Contains only numbers. Example StudentID
Text – Contains alphabets numbers and symbols also. Example Address
Date – Contains data in date format like dd/mm/yy.
Image – Contains image data example. Example Photo
Audio – Contains data in audio format that is sound. Example Songs in gaane.com.
Video – Contains data in Video format. Example Videos in Youtube.
Q3 What is a Spreadsheet?
A3 Spreadsheet is a computer application that stores and manages data. Example Microsoft Exel, Libre Office Calc, Google Sheets.
Q4 Explain parts of Spreadsheet.
Columns – Vertical lines are called colums.
Rows – Horizontal lines are called Rows.
Worksheet – Each working space/page is called a worksheet or sheet.
Cell – Each Box is called a cell.
Explain Address of a cell.
Cell Addressing – Each Cell has its address which can be identified by Column and Row
Excel Formulae
1) Calculations(example add)
=A1+A2
2) Sum
=sum(A1:A6) (find sum from A1 to A6)
2) Max
=max(A1:A6) (find max from A1 to A6)
3) Min
=min(A1:A6) (find min from A1 to A6)
3) Count
=count(A1:A6) (count number of cells from A1 to A6)
4) Average
=average(A1:A6) (find average of A1 to A6)
Google Sites
Report abuse