DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Use the fill handle to create a natural series, such as the months of the year. Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel. To allow Excel to distinguish formulas from data, all formulas begin with an Equal sign (=).
Detailed explanation-2: -You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.
Detailed explanation-3: -Click File > Options. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.
Detailed explanation-4: -Fill handle is a very small black box always available at the right bottom corner of every cell, and the users just need to click on it and drag it with the help of a mouse or double press on it and it will auto-fill the cells and creates a series based on the values you have in the selected cells.