MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 8 3 none of above 255 8 3 none of above 255 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Sort Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals Data, Form ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Now () Date () Time () Today () Now () Date () Time () Today () ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain text and data You have to work hard to create it It can be modified It can contain many sheets including worksheets and chart sheets It can contain text and data You have to work hard to create it It can be modified It can contain many sheets including worksheets and chart sheets ANSWER DOWNLOAD EXAMIANS APP