Which of the following function will return a value of 8?
You can enter which types of data into worksheet cells?
Long text can be broken down into many lines within a cell. You can do this through
Which of the following methods can not be used to edit the contents of a cell?
What does COUNTA () function do?
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Which of the following format you can decide to apply or not in Auto Format dialog box?
Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Which of the following is correct syntax in Excel?
In Excel, by default Numeric Values appears in
Where can you change automatic or manual calculation mode in Excel?
Status indicators are located on the
How do you select an entire column?
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
What symbol is used before a number to make it a label?
While Finding and Replacing some data in Excel, which of the following statement is valid?
A numeric value can be treated as label value if ________ precedes it.
Which of the following formulas is not entered correctly?
Which command will you choose to convert a column of data into row?
MS-EXCEL is based on __________?
Multiple calculations can be made in a single formula using ________.
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
If the cell B1 contains the formula = $A$1, which of the following statements is true
You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Comments put in cells are called ________.
Which of the following is not true regarding Conditional Formatting?
An excel workbook is a collection of
When you link data maintained in Excel workbook to a Word document
What is represented by the small, black square in the lower-right corner of an active cell or range?
Which of the following is not an option of the spelling dialog box?
Which tool you will use to join some cells and place the content at the middle of joined cell?
In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
A function inside another function is called a ….. function.
When you want to insert a blank imbedded excel object in a word document you can
To show/hide the grid lines in Microsoft Excel 2007