What is the shortcut key to insert new sheet in current workbook?a. F11b. Alt + F11c. Ctrl + F11d. Shift + F11Which one is the last column header in Excel 2007?a. XFDb. XFXc. XFLd. XFTIn maximum, how many sheets can be set as default while creating new workbook?a. 254b. 255c. 256d. No Limit“New Comment” option can be found under _ taba. Insertb. Datac. Reviewd. ViewIn Excel, by … [Read more...]

Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?a. 2 Rows will be inserted after Row 4b. 2 Rows will be inserted after Row 5c. 2 Rows will be inserted after Row 6d. 2 Rows will be inserted after Row 7If 4/6 entered in a cell without applying any formats, Excel will treat this asa. Fractionb. Numberc. Textd. DateIf the values in A1 is “MCQ” and B1 is … [Read more...]

How to specify cell range from A9 to A99 in Excel?a. (A9, A99)b. (A9 to A99)c. (A9 : A99)d. (A9 – A99)Selecting the Column G & H then choose Insert->Column, What will happen?a. 2 Columns will be inserted after Column Fb. 2 Columns will be inserted after Column Gc. 2 Columns will be inserted after Column Hd. 2 Columns will be inserted after Column IHow to restrict the … [Read more...]

Which of the following function will return a value of 8?a. ROUNDUP(8.4999, 0)b. ROUNDDOWN(8.4999, 0)c. ROUND(8.4999, 0)d. Only B and CHow to restrict to run a macro automatically when starting Microsoft Excel?a. Hold down the SHIFT key during startupb. Hold down the CTRL key during startupc. Hold down the ESC key during startupd. Hold down the ALT key during startupHow to … [Read more...]

Formulas in Excel start witha. %b. =c. +d. -The default header for a worksheet isa. Usernameb. Date and Timec. Sheet tab Named. NoneWhich of the following is not an option of the spelling dialog box?a. Ignoreb. Ignore allc. Editd. ChangeWhich of the following methods will not enter data in a cell?a. Pressing the Esc keyb. Pressing an arrow keyc. Pressing the tab keyd. Clicking … [Read more...]