MS Excel The auto calculate feature Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Apostrophe (') Tilde (~) Exclamation (!) Hash (#) Apostrophe (') Tilde (~) Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Client None of these Source Server Client None of these Source ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals Data, Sort Data, Form ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Max Pmt Average Sum Max Pmt Average Sum ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS