(Q.25) How do you insert a row?
A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B. Select the row heading where you want to insert the new row and select Edit >Row from the menu
C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D. All of the above
(Q.26) Which of the following methods cannot be used to enter data in a cell
A. Pressing an arrow key
B. Pressing the Tab key
C. Pressing the Esc key
D. Clicking on the formula bar
(Q.27) To center worksheet titles across a range of cells, you must
A. Select the cells containing the title text plus the range over which the title text is to be centered
B. Widen the columns
C. Select the cells containing the title text plus the range over which the title text is to be enfettered
D. Format the cells with the comma style
(Q.28) You can move a sheet from one workbook into new book by
A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B. From Edit menu choose Move of Copy then choose (Move to end) and click OK
C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D. None of above
(Q.29) Multiple calculations can be made in a single formula using
A. standard formulas
B. array formula
C. complex formulas
D. smart formula
(Q.30) Which of the following is not true about Find and Replace in Excel
A. You can search for bold and replace with italics
B. You can decide whether to look for the whole word or not
C. You can search in formula too
D. You can search by rows or columns or sheets
(Q.31) Ctrl + D shortcut key in Excel will
A. Open the font dialog box
B. Apply double underline for the active cell
C. Fill down in the selection
D. None of above
(Q.32) The short cut key Ctrl + R is used in Excel to
A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above