MS Excel Which would you choose to create a bar diagram? Insert, Chart Tools, Chart Format, Chart Edit, Chart Insert, Chart Tools, Chart Format, Chart Edit, Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and 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 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 Copy the cells in column then choose Paste Special, then click Transpose and 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 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 When a label is too long to fit within a worksheet cell, you typically must Adjust the row height Decrease the column width Increase the column width Shorten the label Adjust the row height Decrease the column width Increase the column width Shorten the label ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When many sheets are selected None of the listed here One sheet is selected When no sheet is selected When many sheets are selected None of the listed here One sheet is selected When no sheet is selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Both Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None Both Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None ANSWER DOWNLOAD EXAMIANS APP