MS Excel Text formulas: Return ASCII values of characters Concatenate and manipulate text Replace cell references Show formula error value Return ASCII values of characters Concatenate and manipulate text Replace cell references Show formula error value ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Workbooks Worksheets and charts Charts Worksheets Workbooks Worksheets and charts Charts Worksheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Edit the hyperlink Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the data in a excel source application Edit the hyperlink Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the data in a excel source application ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Press Ctrl+ F5 Click Save on the Windows Start button Select Edit > Save Click the save button on the standard toolbar from the menu Press Ctrl+ F5 Click Save on the Windows Start button Select Edit > Save Click the save button on the standard toolbar from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS