MS Excel Which function is not available in the Consolidate dialog box ? Max Pmt Average Sum Max Pmt Average Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column numbers and row letters Column latters and row numbers Cell locator coordinates Cell names Column numbers and row letters Column latters and row numbers Cell locator coordinates Cell names ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Cell locator coordinates Column letters and row numbers Column numbers and row letters Cell names Cell locator coordinates Column letters and row numbers Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu Unfreeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Unfreeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP