MS Excel Which of the following is an absolute cell reference? #a#1 !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check 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 delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check 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 How do you rearrange the data in ascending or descending order? Data, Form Data, Table Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Read-only Recommended Write Reservation Password Any of the above Protection Password Read-only Recommended Write Reservation Password Any of the above Protection Password ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With a hyperlink With the copy and paste special commands With the right drag method With the copy and paste buttons on the standard toolbar With a hyperlink With the copy and paste special commands With the right drag method With the copy and paste buttons on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Logical Math & Trigonometry Financial Statistical Logical Math & Trigonometry Financial Statistical ANSWER DOWNLOAD EXAMIANS APP