FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?
A
Cell pointer
B
Column marker
C
Fill handle
D
Formula Bar
Explanation: 

Detailed explanation-1: -Fill Handle: The fill handle is the small bold square in the bottom right corner of a cell that can be used to copy (fill) data to adjacent cells in the same row or column.

Detailed explanation-2: -The Fill Handle is the small green square located in the bottom right corner of your selection-be it one cell or a larger group of cells. Double-clicking the Fill Handle causes the selected text, formula, or data to be copied downward, with different behaviors resulting depending on the contents of the cell.

Detailed explanation-3: -Colored triangles that you might see in your worksheet The two colored triangles that can appear in a cell are green (formula error), and red (comment).

Detailed explanation-4: -To use the fill handle: Instead, you can use the fill handle to quickly copy and paste content to adjacent cells in the same row or column. Select the cell(s) containing the content you want to use. The fill handle will appear as a small square in the bottom-right corner of the selected cell(s).

Detailed explanation-5: -The mark is used to resize the table comprising the data, though resizing automatically occurs when data are added to a cell immediately below or to the right of the table. Before making changes to eliminate the mark, you might want to consider any advantages a table offers.

There is 1 question to complete.