MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Divide Square Percentage Goal seek Divide Square Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Choose the new command from the file menu Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Choose the new command from the file menu Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? #a#1 A1 $A$1 !A!1 #a#1 A1 $A$1 !A!1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Select Edit > Save Click the save button on the standard toolbar from the menu Press Ctrl+ F5 Click Save on the Windows Start button Select Edit > Save Click the save button on the standard toolbar from the menu Press Ctrl+ F5 Click Save on the Windows Start button ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS