0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What sign is used n Excel to fill a column that is too narrow to display its contents?
A series of # symbols will fill the cell to indicate it is not wide enough to display the contents.
What is a fill destination area that does not create a series?
Copy Cell
Why does the mouse pointer have different views in Excel?
Excel is a versatile application that does lots of things. There are various mouse pointers to indicate what you are doing so that you know things like when you are correctly selecting cells or when you are copying or when you are using the fill handle or when you are widening columns. Often you need to get the mouse pointer to a precise location before you can do something, like having it over the fill handle. The mouse pointer will change to indicate to the user that they are now in the correct position and can proceed with whatever task they need to do.
What is used to copy a cell or range of cells and create a series?
auto fill
Used to copy a cell range of cells and create a series?
fill handle
What are the different forms of mouse pointers in the spreadsheet?
In Excel different mouse pointers perform different tasks. Cross Pointer Used for selecting ranges of cells Fill Handle Used to copy cell contents to adjacent cells Arrow Pointer Used to move cell contents Resizing Arrows Used to change column widths Resizing Arrows Used to change row heights Cursor Used to edit cell contents in Formula Bar
In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?
When you use the fill handle it will copy what is in the cell including the formatting.
What are the Name of mouse pointer shape and functions?
The upper-left pointing arrow pointer is a general-purpose pointer. It is used in most window areas for single-object selection and activation. The hotspot for the arrow pointer should be in the point of the arrow.You can optionally use an I-beam pointer in any Text component. It is used to change the location of the text insertion cursor and to perform actions on text. If the I-beam is used, it can be hidden during the time between any keyboard action and a mouse movement. This helps the user distinguish the I-beam pointer from the text insertion cursor, which can also be an I-beam. The hotspot for the I-beam pointer should be on the vertical bar of the I-beam about one-third up from the bottom.The X pointer can indicate when the pointer is outside of any application area. The hotspot for the X pointer should be where the lines intersect.The resize pointers indicate positions for area resize, and they remain during a resize operation. The direction of the arrow in the pointer indicates the direction of increasing size. The horizontal and vertical pointers indicate resize in either the horizontal or vertical direction. The diagonal pointers indicate resize in both the horizontal and vertical directions simultaneously. The hotspot for the resizing pointers should be on the elbow or the line at the position pointed to by the arrow.The hourglass pointer, a working pointer, indicates that an action is in progress in the area, and that the pointer has no effect in the area. While the hourglass pointer is active, all mouse button and keyboard events are ignored in the area. The hotspot for the hourglass pointer should be located at the center of the hourglass, although it should not be used for activation. The hourglass pointer can be used interchangeably with the watch pointer.The watch pointer, a working pointer, indicates that an action is in progress in the area, and that the pointer has no effect in the area. While the watch pointer is active, all mouse button and keyboard events are ignored in the area. The hotspot for the watch pointer should be located at the top of the watch, although it should not be used for activation. The watch pointer can be used interchangeably with the hourglass pointer.The 4-directional arrow pointer indicates a move operation is in progress, or a resize operation before the resize direction has been determined. During a move operation, the object, or an outline of the object should move to track the location of the pointer. During a resize operation, the pointer is used to indicate a direction for resizing. The 4-directional arrow pointer should change to the appropriate resize arrow when the resize direction is determined, either by crossing an object boundary with the pointer or by pressing a keyboard direction key. The hotspot for the 4-directional arrow pointer should be at the spot where the arrows intersect.The sighting pointer is used to make fine position selections. For example, in a drawing program it can be used to indicate a pixel to fill or the connecting points of lines. The hotspot for the sighting pointer should be at the spot where the lines intersect.The caution pointer is used to indicate that action is expected in another area before input can be given to the current area, and that the pointer has no effect in the area. While the caution pointer is active, all mouse button and keyboard events are ignored in the area. The hotspot for the caution pointer should be located at the center of the caution symbol, although it should not be used for activation.The question pointer is used to request an input position or component from the user. This is often used to input an object for interactive help. The user requests interactive help, then the question pointer is displayed to allow the user to indicate what position or component help is requested for. The hotspot for the question pointer should be at the bottom of the question mark.You can optionally use an arrow pointing to the upper-right corner to indicate a pending Menu action. This shape indicates that a Menu is popped up or pulled down and waiting for a Menu item to be activated or the Menu to be removed. The hotspot for this arrow pointer should be in the point of the arrow.
What will Excel do if you drag the fill handle to the left or up?
It can have various affects, depending on how you to do it. Excel will decrement the series if you also press the Ctrl key. It can also create a normal incrementing series. If there are values already in the cells, it will erase them.
Automatically fill the selected cells with the successive months of the year Excel?
Type the word January into a cell, or a date. Place your pointer on the lower left hand of the cell with the month and/or date, it should turn from a boxed in cross to thin-lined cross hairs,then left-click and hold down the mouse button. Then you drag down to the end cell thats given or to the right to the end cell given. Excel will fill the selected cells with the remaining months or dates.
Fill destination area with series of months?
fill months
How do you continue with a sequence of numbers without typing in each Excel cell?
You can use the Fill handle to enter them. You can detect a pattern using the fill handle. For example if you type 1 into the first cell and 2 into the second, then select both cells and drag down, it will continue with 3, 4, 5 etc. You can also use the Fill Series facility.
