MS Excel A ________ is a grid with labeled columns and rows. Worksheet Dialog box Toolbar Clipboard Worksheet Dialog box Toolbar Clipboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste 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 then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting None Both Cell value Formula None Both Cell value Formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Worksheets Group of Workbooks Group of Columns Group of Rows Group of Worksheets Group of Workbooks Group of Columns Group of Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Array formula Standard Formulas Smart Formula Complex Formulas Array formula Standard Formulas Smart Formula ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS