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 Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Goal seek Divide Percentage Square Goal seek Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears to the left of the formula bar Appears below the status bar Appears below the menu bar Shows the location of the previously active cell Appears to the left of the formula bar Appears below the status bar Appears below the menu bar Shows the location of the previously active cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel probably considers the cell entry January 1, 2020 to be a Value Text string Formula Label Value Text string Formula Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Pressing the F2 key Double clicking the cell Clicking the formula bar Press the Alt key Pressing the F2 key Double clicking the cell Clicking the formula bar Press the Alt key ANSWER DOWNLOAD EXAMIANS APP