MS Excel To create a formula, you first: 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 Type the equals sign (=) to tell Excel that you’re about to enter a formula 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 Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Font format All of above Border format Number format Font format All of above Border format Number format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Fill down in the selection Open the font dialog box Apply double underline for the active cell None of the listed here Fill down in the selection Open the font dialog box Apply double underline for the active cell None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Fill series Fill across worksheet Auto fill options Custom List Fill series Fill across worksheet Auto fill options Custom List ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 #a#1 $A$1 A1 !A!1 #a#1 $A$1 A1 ANSWER DOWNLOAD EXAMIANS APP