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 To select an entire column in MS - EXCEL, press ? CTRL + Arrow key None of the listed here CTRL + S CTRL + C CTRL + Arrow key None of the listed here CTRL + S CTRL + C ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Value and cell references Values but not cell references Cell references but not values Values or cell references although not both at the same time Value and cell references Values but not cell references Cell references but not values Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Both of above Select the sheet then choose Format > Sheet > Hide None of above Select the sheet, then choose Edit > Delete Sheet Both of above Select the sheet then choose Format > Sheet > Hide None of above Select the sheet, then choose Edit > Delete Sheet 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 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
EXAMIANS