MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Square Percentage Goal seek Divide Square Percentage Goal seek Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Both Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column name on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column name on column header Double clicking on the column left border of column header ANSWER DOWNLOAD EXAMIANS APP