# data[].attributes.headline
(Q1) What does the autofill feature of MS Excel do? Give examples.

# data[].attributes.subject
(Q1) What does the autofill feature of MS Excel do? Give examples.

# data[].attributes.headline
(Q1) What is a spreadsheet? Give its 2 uses.

# data[].attributes.subject
(Q1) What is a spreadsheet? Give its 2 uses.

# data[].attributes.headline
(A1) A Spreadsheet is a table with many rows and columns. Spreadsheets are generally used to analyse data and make projections based on the data 

# data[].attributes.subject
(A1) A Spreadsheet is a table with many rows and columns. Spreadsheets are generally used to analyse data and make projections based on the data 

# data[].attributes.headline
(Q2) Define a cell. What is a cell pointer?  

# data[].attributes.subject
(Q2) Define a cell. What is a cell pointer?  

# data[].attributes.headline
(A2) A cell is an intersection of a row with a column. A cell pointer is a black bordor that highlights the specific cell.

# data[].attributes.subject
(A2) A cell is an intersection of a row with a column. A cell pointer is a black bordor that highlights the specific cell.

# data[].attributes.headline
(Q3) How is worksheet different from a workbook?

# data[].attributes.subject
(Q3) How is worksheet different from a workbook?

# data[].attributes.headline
(A3) A worksheet is a collection of cells in which we enter data. A  workbook is a spreadsheet file in which we can enter multiple worksheet.

# data[].attributes.subject
(A3) A worksheet is a collection of cells in which we enter data. A  workbook is a spreadsheet file in which we can enter multiple worksheet.

# data[].attributes.headline
(Q4) How is a cell different from a cell range? 

# data[].attributes.subject
(Q4) How is a cell different from a cell range? 

# data[].attributes.headline
(A4) A cell is an intersection of a row with a column. A group of cells in a worksheet is called a range.

# data[].attributes.subject
(A4) A cell is an intersection of a row with a column. A group of cells in a worksheet is called a range.

# data[].attributes.headline
(Q5) Differentiate between adjacent and non-adjacent range.

# data[].attributes.subject
(Q5) Differentiate between adjacent and non-adjacent range.

# data[].attributes.headline
(A5) A adjacent range is is the selected or highlighted are next to each other. A non-adjacent range is a multiple group of cells that are separated by  rows and columns.

# data[].attributes.subject
(A5) A adjacent range is is the selected or highlighted are next to each other. A non-adjacent range is a multiple group of cells that are separated by  rows and columns.

# data[].attributes.headline
(Q1) What is a formula? give example. What symbol sould it start with?

# data[].attributes.subject
(Q1) What is a formula? give example. What symbol sould it start with?

# data[].attributes.headline
(A1) A formula is to solve an mathematical program. Eg- SUM(C4:C9).  A formula always starts with the (=) symbol

# data[].attributes.subject
(A1) A formula is to solve an mathematical program. Eg- SUM(C4:C9).  A formula always starts with the (=) symbol

# data[].attributes.headline
(Q2) What is a function? Give example. How is it different from a formula.

# data[].attributes.subject
(Q2) What is a function? Give example. How is it different from a formula.

# data[].attributes.headline
(A2) A function is a predefined formula in a spreadsheet. Eg-Max, Average, Sum. Formula is to solve an equation and function helps to perform a formula.

# data[].attributes.subject
(A2) A function is a predefined formula in a spreadsheet. Eg-Max, Average, Sum. Formula is to solve an equation and function helps to perform a formula.

# data[].attributes.headline
(A1) Autofill help us to automatically generates a series in MS Excel. Eg- If we write 1,2 and make its autofill it will make a series of 1,2,3,4,5 and so on

# data[].attributes.subject
(A1) Autofill help us to automatically generates a series in MS Excel. Eg- If we write 1,2 and make its autofill it will make a series of 1,2,3,4,5 and so on

# data[].attributes.headline
(Q2) Explain count () function with syntax.

# data[].attributes.subject
(Q2) Explain count () function with syntax.

# data[].attributes.headline
(Q3) Define any 3 function with their syntax

# data[].attributes.subject
(Q3) Define any 3 function with their syntax

# data[].attributes.headline
(A1) Autosum is a function that help us to take the sum of the given numbers without writing the formula.

# data[].attributes.subject
(A1) Autosum is a function that help us to take the sum of the given numbers without writing the formula.

# data[].attributes.body
Even your work!!!

# data[].attributes.headline
(A3) (i) Max function help us to find the maximum value from a set of numbers. Syntax =Max(c2:c10) .                         (ii) Min function help us to find the minimum value from a set of numbers. Syntax =min(b2:b7).                             (iii) Average function is used to calculate the average of two or more value. Syntax =Average(a1:a5) .

# data[].attributes.subject
(A3) (i) Max function help us to find the maximum value from a set of numbers. Syntax =Max(c2:c10) .                         (ii) Min function help us to find the minimum value from a set of numbers. Syntax =min(b2:b7).                             (iii) Average function is used to calculate the average of two or more value. Syntax =Average(a1:a5) .

# data[].attributes.headline
Prepare a monthly expenditure chart for your mother.

# data[].attributes.subject
Prepare a monthly expenditure chart for your mother.

# data[].attributes.body
Given the budget for the month is 45000. Calculate the total amount spent on groceries, dairy products, ration, vegetables and fruits for 4 weeks.
To the total sum add the school fees, data bill and house help.
Now calculate what is the total saving or over expenditure for the month.

# data[].attributes.attachment_link.title
Book1 - Microsoft Excel 31-Aug-20 8_59_48 PM