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 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 Select the cell you want to place the formula into ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Horizontal scroll bar Vertical scroll bar Formula bar Standard toolbar Horizontal scroll bar Vertical scroll bar Formula bar Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS