MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Tilde (~) Hash (#) Apostrophe (') Exclamation (!) Tilde (~) Hash (#) Apostrophe (') Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Click the column heading letter Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
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 The shortcut key Ctrl + R is used in Excel to None of above Right align the content of cell Remove the cell contents of selected cells Fill the selection with active cells to the right None of above Right align the content of cell Remove the cell contents of selected cells Fill the selection with active cells to the right ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet None Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline Both None Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline Both ANSWER DOWNLOAD EXAMIANS APP