MS Excel You can enter which types of data into worksheet cells? Labels and values but not formulas Formulas only Labels, values, and formulas Values and formulas but not labels Labels and values but not formulas Formulas only Labels, values, and formulas Values and formulas but not labels 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel MS Excel provides the default value for step in fill Series dialog box 10 O 5 1 10 O 5 1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? C Visual C++ Java Visual Basic C Visual C++ Java Visual Basic ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column latters and row numbers Cell locator coordinates Column numbers and row letters Cell names Column latters and row numbers Cell locator coordinates Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP