You can edit a cell by Selecting Edit > Edit cell from the menu Clicking the formula button Double clicking the cell to edit it in place None of these TRUE ANSWER : ? YOUR ANSWER : ?
In the formula, which symbol specifies the fixed columns or rows ? % $ * & TRUE ANSWER : ? YOUR ANSWER : ?
To create a formula, you first: Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula TRUE ANSWER : ? YOUR ANSWER : ?
Ctrl+ D shortcut key in Excel will None of the listed here Apply double underline for the active cell Open the font dialog box Fill down in the selection TRUE ANSWER : ? YOUR ANSWER : ?
When you insert an excel file into a word document. The data are Use the word menu bar and toolbars Embedded Linked Hyperlinked placed in a word table TRUE ANSWER : ? YOUR ANSWER : ?
Data can be arranged in a worksheet in a easy to understand manner using Changing fonts Auto formatting Applying styles All of the listed here TRUE ANSWER : ? YOUR ANSWER : ?
You can select a single range of cells by Pressing the Ctrl key while dragging over the desired cells 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 Shift key and an arrow key Dragging over the desired cells TRUE ANSWER : ? YOUR ANSWER : ?
How do you display current date and time in MS Excel ? Date () Time() Today () Now () TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) TRUE ANSWER : ? YOUR ANSWER : ?
While Finding and Replacing some data in Excel, which of the following statement is valid? None of the listed here Both You can Find and Replace within the sheet or workbook Excel does not have option to match case for find TRUE ANSWER : ? YOUR ANSWER : ?