MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ * % & $ * % & ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Standard Formulas Smart Formula Array formula Complex Formulas Standard Formulas Smart Formula Array formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Copy handle Border Fill handle Insert handle Copy handle Border Fill handle Insert handle 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
EXAMIANS