Excel

An Excel file is made up of Worksheets, which collectively are called a Workbook. Worksheets are pages within a workbook orksheets can contain information and work independently of each other or can be linked together to form a workbook. Each worksheet contains horizontal rows and vertical columns. The maximum number of rows is 18,278 (A to ZZZ) columns and 1,048,576 rows. The intersection of a row and column is a cell. 

FREEZE

Sometimes, you want some rows or columns always in your worksheet. Here, freeze panes feature help to lock the cells so that you can see the worksheet however you want. Freeze pane locks the specific row or column and makes them visible for the entire sheet scrolling.

Excel has a freeze pane feature to freeze the part of the Excel worksheet. It is used to freeze the row and column. When the Excel worksheet is large, freeze pane is a useful option to freeze the particular part of the worksheet and make the other part scrollable. 

QUESTION BANK

Q. What are the uses of ‘Formula’ in Excel? 

Ans. 

Formula is used in: (a) simple addition, subtraction, multiplication and division

 (b) complex formula involving a combination of arithmetic operators. 

Q.  What do you mean by Range in Excel? 

Ans. Range is a collection of selected cells. 

Q. What is Chart? What are the different types of Charts in Excel ? 

Charts allows to present data entered in the worksheet in a visual format using a variety of graph types. Before making a chart, first enter data into a worksheet.

Column Charts - They compare distinct items. In this chart category axis is horizontal (Xaxis) and value axis is vertical (Y-axis). Column charts are used for making comparisons.

Bar Charts - Compare different items or show single items at different intervals. It is

similar to column chart except that the chart value axis is horizontal (X-axis) and

category axis is vertical (Y-axis).

Area Charts – They show the relative contributions of each value to a total over time.

Line Charts - These charts are useful to compare the trends over time.

Pie Charts - The chart show the proportion of each part value to the total value in a data series. They are used to show proportional sales figures or representation of different

categories of population like workers/non-workers, male/female, adults/children, etc.

Q. What is function in Excel? Explain SUM and COUNT function?

The built-in formulas are called functions. The users have to provide the cell references or addresses only. These are called arguments of the functions that are given between a pace of parentheses ( ). 

-SUM() function - Adds all the numbers in a range of cells 

The Syntax is =SUM(number1,number2,……) 

Ex. =SUM (A1:A4) finds the sum of cells A1 through A4 

-COUNT() function – Returns the number of cells that contain numbers. 

The Syntax is =COUNT(value1,value2,…….) 

Ex. =COUNT(A1:A10) 

Q. What are formulas? What are the benefits of using formula in Excel.

1. A formula may consist of operators, cell references, range names, values and functions. 

2. A formula always start with an equal to (=) sign. 

3.When a formula is entered in the cell, and then the ENTER key is pressed, only the calculated result is displayed in the cell and not the formula. 

4.If a cell containing formula is made an active cell, though it still shows the value, but in the formula bar, the formula is 

Q. ________is used to fill the automatically fill a series of numbers. 

Q.  The syntax of MIN() function is: 

=MIN (Number1, number2…..) 

Q. Differentiate between a workbook and worksheet 

An Excel file is called workbook and each work is a collection of one or more worksheets. Excel file is made of worksheets. The worksheet contains horizontal rows and vertical columns and these are the pages within the workbook. Worksheet can work independently of each other or can be linked together to form a workbook. 

Q. Explain the two methods to resize the rows and columns 

Q. Which cell address is valid – B12 or 12B? What will be the address of a Cell at Column Z and row number 35? 

B12 is a valid cell address. Z35 will be the address of a Cell at Column Z and row number 35 

Q. What do you understand about an Active Cell in a Spreadsheet? 

An active cell helps to identify what cell is being worked with data and where the data will be entered. 

Q. Explain the basic properties of a formula in excel 

Ans. Formula is used in: (a) simple addition, subtraction, multiplication and division, (b) complex formula involving a combination of arithmetic operators. 

Q. Discuss the use of ‘Autosum’ function in MS Excel with an example. 

AutoSum is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. For example, if you want to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button.