MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) 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 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 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 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 then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the right drag method With the copy and paste buttons on the standard toolbar With the copy and paste special commands With a hyperlink With the right drag method With the copy and paste buttons on the standard toolbar With the copy and paste special commands With a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Location tabs Position tabs Reference tabs Sheet tabs Location tabs Position tabs Reference tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS