Excel

 What is workbook ?

A workbook is a spreadsheet program file that you create in Excel. A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.

How many sheets in Excel workbook?

255 worksheet in a workbook 

In one workbook you can add 255 separate sheets.

How to change the sheet name?

Double-click the sheet tab, and type the new name.

Right-click the sheet tab, click Rename, and type the new name.

Use the keyboard shortcut Alt+H > O > R, and type the new name.

Write the about part of Excel sheet?

Rows: Rows are the horizontal divisions of the worksheet. ...

Columns: Columns are the vertical divisions of the worksheet. ...

Cells: Cells are the intersection of a row and a column. ...

Formulas: Formulas are used to perform calculations on data in the worksheet.

How many types of sort? How to apply write steps?

Select the data to sort    

Select a range of tabular data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include the first row of headings that identify each column.

Example of selected data to sort in Excel

 

Icon image

Sort quickly and easily    

Select a single cell in the column you want to sort.

On the Data tab, in the Sort & Filter group, click A to Z command in Excel that sorts A to Z or smallest number to largest to perform an ascending sort (from A to Z, or smallest number to largest).

Sort buttons in the Sort & Filter group on the Data tab in Excel

Click Z to A command in Excel that sorts Z to A or largest number to smallest to perform a descending sort (from Z to A, or largest number to smallest).

In the Sort by dropdown list, select the first column on which you want to sort.

In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon.

In the Order list, choose the order that you want to apply to the sort operation—alphabetically or numerically, ascending or descending (that is, from A to Z (or Z to A) for text, or lower to higher, or higher to lower for numbers).