MS Excel
While Finding and Replacing some data in Excel, which of the following statement is valid?

Both
You can Find and Replace within the sheet or workbook
None of the listed here
Excel does not have option to match case for find

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can use drag-and-drop to embed excel worksheet data in a word document

None of the listed here
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
The autofill feature

Extends a sequential series of data
Automatically adds range of cell values
All of the listed here
Applies a boarder around the selected cells

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you select an entire column?

Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

Concatenate and manipulate text
Return ASCII values of characters
Replace cell references
Show formula error value

ANSWER DOWNLOAD EXAMIANS APP