MS Excel To create a formula, you first: 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 Choose the new command from the file menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by Double clicking the cell to edit it in place None of these Clicking the formula button Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place None of these Clicking the formula button Selecting Edit > Edit cell from the menu 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 In help menu of Excel, which of the following tabs are found? Contents tab All of these Index tab Answer Wizard tab Contents tab All of these Index tab Answer Wizard tab ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when One sheet is selected When no sheet is selected None of the listed here When many sheets are selected One sheet is selected When no sheet is selected None of the listed here When many sheets are selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar ANSWER DOWNLOAD EXAMIANS APP