MS Excel Concatenation of text can be done using Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Goal seek Scenario Manager Solver All of above Goal seek Scenario Manager Solver All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Standard Formulas Smart Formula Complex Formulas Array formula Standard Formulas Smart Formula Complex Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Vertical scroll bar Horizontal scroll bar Standard toolbar Formula bar Vertical scroll bar Horizontal scroll bar Standard toolbar Formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet Sheet tabs can be colored The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet Sheet tabs can be colored The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS