MS Excel Which of the following is an absolute cell reference? A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
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 Status indicators are located on the Standard toolbar Vertical scroll bar Horizontal scroll bar Formula bar Standard toolbar Vertical scroll bar Horizontal scroll bar Formula bar 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 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 apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check 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 apply Font, border and pattern formats that meets the specified conditions 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and select Edit >Row from the menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and select Edit >Row from the menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here ANSWER DOWNLOAD EXAMIANS APP