MS Excel
The autofill feature

All of the listed here
Extends a sequential series of data
Automatically adds range of cell values
Applies a boarder around the selected cells

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When a row of data is to be converted into columns

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK
Copy the cells in column then choose Paste Special, then click Transpose and OK
Copy the cells in row, select the same number of cells in row and paste
Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can set Page Border in Excel from

From Border tab in Farmat cells dialog box
You can not set Page Border in Excel
From Border tool in Formatting toolbar
From Line style tool in Drawing toolbar

ANSWER DOWNLOAD EXAMIANS APP