Question

7. Select entire row
E. Answer in short.
1. How is a range of cell from A1 to D4 represented?
2. What happens if you click to the top left corner of worksheet area?
4. How can we select non-adjacent ranges in a worksheet? Explain.
F. Answer in detail.
1. What is the use of Microsoft Excel?
2. What is the use of AutoFill feature? Explain.
3. Differentiate between workbook and worksheet.
4. What is fill handle? Explain its use.
5. What is a range?
3. Which option does allow you to create your predefined own series in Excel?​

Answer 1

Answer:

1.a1:d4

2.What happens if you click to the top left corner of worksheet area?

entire worksheet gets selected

3.How can we select non-adjacent ranges in a worksheet? Explain.

To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

4.What is the use of Microsoft Excel?

Excel is a handy software that can be used to store and organize many data sets. Using its features and formulas, you can also use the tool to make sense of your data. For example, you could use a spreadsheet to track data and automatically see sums averages and totals.

5.What is the use of AutoFill feature? Explain.

Essentially, Microsoft Excel's AutoFill lets you create spreadsheets more efficiently, allowing you to quickly fill cells with a series of data. ... Select the cell that you wish to AutoFill. Move the cursor to the bottom right corner of the cell. It will turn into a solid cross. This is called the Fill Handle.

6.Differentiate between workbook and worksheet.

The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook.