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 The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 #a#1 A1 $A$1 !A!1 #a#1 A1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Divide Goal seek Square Percentage Divide Goal seek Square Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scrolling button Allow you to view additional sheets tabs Allow you to view additional worksheet rows down Allow you to view a different worksheet Allow you to view additional worksheet columns to the right Allow you to view additional sheets tabs Allow you to view additional worksheet rows down Allow you to view a different worksheet Allow you to view additional worksheet columns to the right ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Press Ctrl+ F5 Select Edit > Save Click the save button on the standard toolbar from the menu Click Save on the Windows Start button Press Ctrl+ F5 Select Edit > Save Click the save button on the standard toolbar from the menu Click Save on the Windows Start button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Scenario manager Goal seek Auto Outline Solver Scenario manager Goal seek Auto Outline Solver ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS