EXCEL QUESTIONS

1.	Which of the following is not the correct method of editing the cell content?  A) Press the Alt key  B) Press the F2 key  C) Click the formula bar  D) Double click the cell	2.	You can activate a cell by a.   Pressing the Tab key b.   Clicking the cell c.   Pressing an arrow key d.   All of above
3.	MS Excel provides the default value for step in Fill Series dialog box  A) 0  B) 1  C) 5  D) 10	4.	Which of the cell pointer indicates that you can fill series?  A) Doctor’s symbol (Big Plus)  B) small thin plus icon  C) Mouse Pointer with anchor at the tip  D) None of above
5.	How do you change column width to fit the contents? a.   Single-click the boundary to the left to the column heading b.   Double click the boundary to the right of the column heading c.   Press Alt and single click anywhere in the column d.   All of above	6.	Which of the following is not a basic step in creating a worksheet? a.   Save the workbook b.   Modify the worksheet c.   Enter text and data d.   Copy the worksheet
7.	What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20? a.   Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows b.   Select the range you want, include both cells, point to fill on the Edit menu, and then click down. c.   Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special d.   All of above	8.	Charts tips can a.   Show the formatting of a data label b.   Show the name of a data series c.   Show the value of data point d.   b and c
9.	To insert three columns between columns D and E you would a.   Select column D b.   Select column E c.   Select columns E, F and G d.   Select columns D, E, and F.	10.	How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?  A) F8  B) F9  C) F10  D) F11
11.	Which of the following Excel screen components can NOT be turned on or off?  A) Formula Bar  B) Status Bar  C) Tool Bar  D) None of above	12.	Which of the following option is not available in Paste Special dialog box?  A) Add  B) Subtract  C) Divide  D) SQRT
13.	Which of the following is an absolute cell reference? a. !A!1 b. $A$1 c. #a#1 d. A1	14.	Which of the following action removes a sheet from workbook?  A) Select the sheet, then choose Edit >> Delete Sheet  B) Select the sheet then choose Format >> Sheet >> Hide  C) Both of above  D) None of above
15.	Which symbol must all formula begin with? a. = b. + c. ( d. @	16.	Which of the following formulas is not entered correctly? a. =10+50 b. =B7*B1 c. =B7+14 d. 10+50
17.	A worksheet can have a maximum of …. Number of rows a. 256 b. 1024 c. 1048576 d. 65,535	18.	How many characters can be typed in a single cell in Excel? a. 256 b. 16384 c. 32,000 d. 65,535
19.	To delete an embedded objects, first a. Double click the object b. Select the object by clicking it c. Press the Shift + Delete keys d. Select it and then press the delete key	20.	Which of the following is the latest version of Excel a. Excel 2010 b. Excel 2008 c. Excel 2007 d. Excel 2013
21.	Format > window b. View > window > split c. Window > split d. View > split	22.	Which of the following will not cut information? a. Pressing Ctrl + C b. Selecting Edit>Cut from the menu c. Clicking the Cut button on the standard d. Pressing Ctrl+X
23.	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	24.	To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the a. Unfreeze panes command on the window menu b. Freeze panes command on the window menu c. Hold titles command on the edit menu d. Split command on the window menu