MS Excel When a row of data is to be converted into columns 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 Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel displays the current cell address in the ___ Formula Bar Name Box Title Bar Status Bar Formula Bar Name Box Title Bar Status Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Cancel and Enter buttons appear in the: Formula bar Title bar Menu bar Sheet tabs Formula bar Title bar Menu bar Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press Tab Press Enter Press the Alt key None Press Tab Press Enter Press the Alt key None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP