MS Excel To create a formula, you can use: Value and cell references Cell references but not values Values but not cell references Values or cell references although not both at the same time Value and cell references Cell references but not values Values but not cell references Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F11 F9 F8 F10 F11 F9 F8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Java Visual Basic C Visual C++ Java Visual Basic C Visual C++ ANSWER DOWNLOAD EXAMIANS APP
MS Excel Documentation should include Destination and users of the output data Information on the purpose of the workbook All of these Source of input data Destination and users of the output data Information on the purpose of the workbook All of these Source of input data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Number format Border format Font format All of above Number format Border format Font format All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS