MS Excel Concatenation of text can be done using Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') 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 Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Word Excel Smart cell Lotus 1-2-3 Word Excel Smart cell Lotus 1-2-3 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS