How do you insert a row.

Text formula in excel mcq. Long text can be broken down into many lines within a cell. How do you display current date only in MS Excel. Show formula error value.

In Excel Text formulas. Return ASCII values of characters. Excel adjusts absolute cell references.

ANALYTICS TRAINING HUB is a journey of humble beginnings with the sole focus aimed at equipping our clients with the necessary training support to aid in educating them in multiple distinct data analytic tools courses in Delhi and ncr. Multiple Choice Questions of Microsoft Excel. To showhide the grid lines in Microsoft Excel 2007 A.

How do you insert a row. Formulas are the key to getting things done in Excel In this accelerated training youll learn how to use formulas to manipulate text work with dates and times lookup values with VLOOKUP and INDEX MATCH count and sum. Return ASCII values of characters.

View - Grid lines - View D. Return ASCII values of characters. What will be the result if you type A1B1 in cell C1.

Page Layout - Grid lines - View B. These Microsoft Excel multiple-choice questions will help students with skill enhancement and exam preparation for MS-CIT Entrance and University exams. Most of the questions are applicable to all versions of MS Excel including Excel 97-2003 XP 2007 2010 etc.