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 A numeric value can be treated as a label value if it precedes with Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Solver Goal seek Scenario manager Auto Outline Solver Goal seek Scenario manager Auto Outline ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto correct AutoFill Auto format Auto sum Auto correct AutoFill Auto format Auto sum 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 Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The cancel button All of these The edit formula button The enter button The cancel button All of these The edit formula button The enter button ANSWER DOWNLOAD EXAMIANS APP