How do you display current date only in MS Excel? Now () Time () Today () Date () TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following action removes a sheet from workbook? Select the sheet, then choose Edit > Delete Sheet Both of above Select the sheet then choose Format > Sheet > Hide None of above TRUE ANSWER : ? YOUR ANSWER : ?
You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source Client None of these TRUE ANSWER : ? YOUR ANSWER : ?
How can you show or hide the gridlines in Excel Worksheet None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar TRUE ANSWER : ? YOUR ANSWER : ?
Which button do you click to add up a series of numbers? The quicktotal button The Formula button The total button The autosum button TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions TRUE ANSWER : ? YOUR ANSWER : ?
Data can be arranged in a worksheet in a easy to understand manner using All of the listed here Auto formatting Applying styles Changing fonts TRUE ANSWER : ? YOUR ANSWER : ?
To save a workbook, you: Click Save on the Windows Start button Select Edit > Save Press Ctrl+ F5 Click the save button on the standard toolbar from the menu TRUE ANSWER : ? YOUR ANSWER : ?
You can activate a cell by Pressing an arrow key Pressing the Tab key All of these Clicking the cell TRUE ANSWER : ? YOUR ANSWER : ?
You can use drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key TRUE ANSWER : ? YOUR ANSWER : ?