MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Select the sheet, then choose Edit > Delete Sheet None of above Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet None of above Both of above Select the sheet then choose Format > Sheet > Hide ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Workbooks Group of Columns Group of Worksheets Group of Rows Group of Workbooks Group of Columns Group of Worksheets Group of Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Protection Password Write Reservation Password Any of the above Read-only Recommended Protection Password Write Reservation Password Any of the above Read-only Recommended ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP