MS Excel What does COUNTA () function do? 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 Counts cells having alphabets ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on Shows the name of cell or range currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search in formula too You can search for bold and replace with italics You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search in formula too You can search for bold and replace with italics You can search by rows or columns or sheets You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Percentage Goal seek Divide Square Percentage Goal seek Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Line Chart Column Chart XY Chart Pie Chart Line Chart Column Chart XY Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain many sheets including worksheets and chart sheets It can be modified You have to work hard to create it It can contain text and data It can contain many sheets including worksheets and chart sheets It can be modified You have to work hard to create it It can contain text and data ANSWER DOWNLOAD EXAMIANS APP