standard formulas

array formula

complex formulas

smart formula

**In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?****You can merge the main document with data source in Excel. In mail merge operation, Word is usually****You can activate a cell by****Comments can be added to cells using****When you want to insert a blank imbedded excel object in a word document you can****How can you print three copies of a workbook?****To copy cell contents using drag and drop press the****Status indicators are located on the****Which of the following is a popular DOS based spreadsheet package?****An Excel Workbook is a collection of .......****Comments can be added to cells using ......****How can you remove borders applied in cells?ACC****Which language is used to create macros in Excel?****We can save and protect the workbook by****In Excel, a Data Series is defined as what?****To view a cell comment****Which of the following Excel screen components can NOT be turned on or off?****Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?****If you begin typing an entry into a cell and then realize that you dont want your entry placed into…****How do you rearrange the data in ascending or descending order?****When the formula bar is active, you can see****Tab scrolling button****How many characters can be typed in a single cell in Excel?****To remove the content of selected cells you must issue ______ command****It is acceptable to let long text flow into adjacent cells on a worksheet when****Which of the following is a correct order of precedence in formula calculation?****Excel uniquely identifies cells within a worksheet with a cell name****Which of the following methods cannot be used to enter data in a cell****The spelling dialog box can be involved by choosing spelling from ________ menu.****To create a formula, you can use:**