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 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 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 across worksheet Fill series Custom List Auto fill options Fill across worksheet Fill series Custom List Auto fill options ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline None Both Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Average Max Pmt Sum Average Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scrolling button Allow you to view additional sheets tabs Allow you to view a different worksheet Allow you to view additional worksheet columns to the right Allow you to view additional worksheet rows down Allow you to view additional sheets tabs Allow you to view a different worksheet Allow you to view additional worksheet columns to the right Allow you to view additional worksheet rows down ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS