MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: 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 Choose the new command from the file menu Select the cell you want to place the formula into ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? $A$1 !A!1 A1 #a#1 $A$1 !A!1 A1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Standard Formulas Array formula Smart Formula Complex Formulas Standard Formulas Array formula Smart Formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Use the word menu bar and toolbars Embedded Hyperlinked placed in a word table Linked Use the word menu bar and toolbars Embedded Hyperlinked placed in a word table Linked ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7+14 =B7*B1 10+50 =10+50 =B7+14 =B7*B1 10+50 ANSWER DOWNLOAD EXAMIANS APP