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 Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Solver All of above Goal seek Scenario Manager Solver All of above Goal seek Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu 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 Insert handle Fill handle Border Copy handle Insert handle Fill handle Border ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? StarCalc Excel VisiCalc Lotus 1-2-3 StarCalc Excel VisiCalc Lotus 1-2-3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS