MS Excel Concatenation of text can be done using Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Auto fill options Fill series Fill across worksheet Custom List Auto fill options Fill series Fill across worksheet Custom List ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells 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 Home Press Alt + Home Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 5436.8 6.8 5436.80 5430 5436.8 6.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS