MS Excel Question Bank Page No. 2
1. 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
2. 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
3. Which of the following is not a way to complete a cell entry?
a. Pressing enter
b. Pressing any arrow key on the keyboard
c. Clicking the Enter button on the Formula bar
d. Pressing spacebar
4. You can activate a cell by
a. Pressing the Tab key
b. Clicking the cell
c. Pressing an arrow key
d. All of the above
5. Text formulas:
a. Replace cell references
b. Return ASCII values of characters
c. Concatenate and manipulate text
d. Show formula error value
6. Which of the following is not a basic step in creating a worksheet?
a. Save workbook
b. Modifiy the worksheet
c. Enter text and data
d. Copy the worksheet
7. Hyperlinks can be
a. Text
b. Drawing objects
c. Pictures
d. All of above
8. Which button do you click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
9. In a worksheet you can select
a. The entire worksheet
b. Rows
c. Columns
d. All of the above
10. Which area in an excel window allows entering values and formulas
a. Title bar
b. Menu bar
c. Formula bar
d. Standard toolbar
11. MS-EXCEL is based on ……….?
A. WINDOWS
B. DOS
C. UNIX
D. OS/2
12. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
13. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
14. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A. ROUND ( )
B. FACT ( )
C. MOD ( )
D. DIV ( )
15. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
16. Which is not the function of “Edit, Clear” command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
17. Microsoft Excel is a powerful………..
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
18. How do you rearrange the data in ascending or descending order?
A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
19. The box on the chart that contains the name of each individual record is called the
a. cell
b. title
c. axis
d. legend
20. Which is an example of a formula?
a. =A1+A2
b. =add(A1:A2)
c. A1+A2
d. SUM(A1:A2)
21. What is the shortcut key to insert new sheet in current workbook?
a. F11
b. Alt + F11
c. Ctrl + F11
d. Shift + F11
22. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above
23. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
A. 5,430.00
B. 5,436.80
C. 5,436.8
D. 6.8
24. How do you display current date and time in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
25. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
26. How do you wrap the text in a cell?
A. Format, cells, font
B. Format, cells, protection
C. format, cells, number
D. Format, cells, alignment
27. What does COUNTA () function do?
A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells
28. What is the short cut key to highlight the entire column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
29. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
30. Excel displays the current cell address in the ……….
A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar
31. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
32. Which language is used to create macros in Excel?
A. Visual Basic
B. C
C. Visual C++
D. Java
33. Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
34. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above
35. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
36. Which setting you must modify to print a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
37. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
38. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
39. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9
40. To record a sequence of keystrokes and mouse actions to play back later we use:
A. Media player
B. Sound Recorder
C. Calculator
D. Macro Recorder
41. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above