[Que F] Short answer type questions.
A. What is the use of Microsoft Excel?
B. How can we select non-adjacent ranges in a worksheet? Explain.
C. What is the use of AutoFill feature? Explain.
D. Differentiate between workbook and worksheet.
Answers
A - Excel is typically used to organize data and perform financial analysis. It is used across all business functions and at companies from small to large.
B- Below is how to select two non-adjacent range of cells:
- Click on the first cell that you want to be selected. This will now become the active cell
- Hold the Control key on your keyboard
- Left-click on the mouse and drag to make the selection
- Leave the mouse click. At this point, you would have a selection. Continue to hold the Control key
- Place the cursor on the second cell/range that you want to select
- Left-click on the mouse and drag to make the selection
- Leave the mouse click. This would select two non-contiguous range of cells.
- Release the Control key.
C- A feature found in software and applications, that lets you enter a series of numbers or characters in a specified range, and have the software complete the entry you started typing. In Microsoft Excel, for example, you can use a preset function to automatically fill a cell with data.
D- A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Go ogle Sheets. A workbook is the name given to an Excel file and contains one or more worksheets.
Microsoft excel is used to enter the data it's a program of Microsoft