MS Excel When you link data maintained in an excel workbook to a word document The word document cannot be edit The word document contains a copy of the actual data The word document must contain a hyperlink The word document contains a reference to the original source application The word document cannot be edit The word document contains a copy of the actual data The word document must contain a hyperlink The word document contains a reference to the original source application ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula 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 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can be modified You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can contain text and data It can be modified You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can contain text and data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS