MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5436.8 5430 6.8 5436.80 5436.8 5430 6.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Copy handle Fill handle Insert handle Border Copy handle Fill handle Insert handle Border ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Cut and Paste Both of above Paste Special > Transpose None of above Cut and Paste Both of above Paste Special > Transpose None of above 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 then go to Cells then on Alignment tab click 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 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 then go to Cells then on Alignment tab click 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which setting you must modify to print a worksheet using letterhead? Orientation Paper Margin Layout Orientation Paper Margin Layout ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C ANSWER DOWNLOAD EXAMIANS APP