MS Excel Which elements of a worksheet can be protected from accidental modification? All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values but not cell references Values or cell references although not both at the same time Cell references but not values Value and cell references Values but not cell references Values or cell references although not both at the same time Cell references but not values Value and cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Divide SQRT Add Subtract Divide SQRT Add Subtract ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS