MS Excel In the formula, which symbol specifies the fixed columns or rows ? * % & $ * % & $ ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Scenario manager Goal seek Auto Outline Solver Scenario manager Goal seek Auto Outline Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Hash (#) Tilde (~) Exclamation (!) Apostrophe (') Hash (#) Tilde (~) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To select an entire column in MS - EXCEL, press ? CTRL + Arrow key CTRL + C None of the listed here CTRL + S CTRL + Arrow key CTRL + C None of the listed here CTRL + S ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them 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 apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP