1000+ Microsoft Excel Multiple Choice Question Answer [Solved]

1. An Excel Workbook is a collection of .......
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
Answer : D

2. 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
Answer : A

3. Concatenation of text can be done using
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : D

4. The Name box on to the left of formula bar
A. shows the name of workbook currently working on
B. shows the name of worksheet currently working on
C. shows the name of cell or range currently working on
D. None of above
Answer : C

5. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value
B. Cell comments
C. Formatting options
D. The resulting values of a formula instead of the actual formula
Answer : D

6. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
A. Option buttons
B. List boxes
C. Text boxes
D. Combo boxes
Answer : C

7. In a worksheet you can select
A. The entire worksheet
B. Rows
C. Columns
D. All of the above
Answer : B

8. 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
Answer : D

9. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C

10. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl +Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
Answer : A

11. In Excel, a Data Series is defined as what?
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C

12. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
Answer : C

13. Tab scrolling button
A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheets tabs
Answer : D

14. 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
Answer : A

15. Which tool you will use to join some cells and place the content at the middle of joined cell?
A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
Answer : D

16. Where can you set the shading color for a range of cells in Excel?
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer : D

17. Which of the following is the latest version of Excel
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D

18. Which language is used to create macros in Excel?
A. Visual Basic
B. C
C. Visual C++
D. Java
Answer : A

19. Excel files have a default extension of
A. Xls
B. Xlw
C. Wk1
D. 123
Answer : A

20. What is the short cut key to replace a data with another in sheet?
A. Ctrl + R
B. Ctrl + Shift + R
C. Ctrl + H
D. Ctrl + F
Answer : C

21. 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
Answer : C

22. To copy formatting from one area in a worksheet and apply it to another area you would use:
A. The Edit > Copy Format and Edit>Paste Format commands form the menu
B. The Coy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
C. There is no way to copy and apply formatting in Excel You have to do it manually
D. The Format Painter button on the standard toolbar
Answer : D

23. To save a workbook, you:
A. Click the save button on the standard toolbar from the menu
B. Press Ctrl+F5
C. Click Save on the Windows Start button
D. Select Edit>Save
Answer : A

24. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
Answer : B

25. To create a formula, you first:
A. Select the cell you want to place the formula into
B. Type the equals sign (=) to tell Excel that youre about to enter a formula
C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D. Choose the new command from the file menu
Answer : B

26. You can use the formula pallette to
A. format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells
Answer : B

27. You can check the conditions against __________ when applying conditional formatting
A. Cell value
B. Formula
C. Both of above
D. None of above
Answer : C

28. Which of the cell pointer indicates you that you can make selection?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : A

29. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
Answer : D

30. To copy cell contents using drag and drop press the
A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer : A

31. Comments put in cells are called .....
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Answer : B

32. You can auto fit the width of column by
A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer : C

33. A worksheet can have a maximum of …. Number of rows
A. 256
B. 1024
C. 32000
D. 65535
Answer : D

34. To remove the content of selected cells you must issue ______ command
A. Edit >> Delete
B. Edit >> Clear >> Contents
C. Edit >> Clear >> All
D. Data >> Delete
Answer : B

35. The Chart wizard term data categories refers to;
A. A chart plot area
B. A horizontal axis
C. The organization of individual values with a charts data series
D. The data range that supply chart data
Answer : B

36. MS-EXCEL is based on .........?
A. WINDOWS
B. DOS
C. UNIX
D. OS/2
Answer : A

37. How can you print three copies of a workbook?
A. Select File > Properties form the menu and type 3 in the Copies to print text box
B. Select File > Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
D. Press Ctrl+P+3
Answer : B

38. How can you show or hide the gridlines in Excel Worksheet?
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer : C

39. 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
Answer : C

40. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
Answer : A

41. 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
Answer : C

42. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : B

43. You can select a single range of cells by
A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
Answer : D

44. How can you update the values of formula cells if Auto Calculate mode o Excel is disabled?
A. F8
B. F9
C. F10
D. F11
Answer : B

45. A numeric value can be treated as a label value if it precedes with
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : A

46. The autofill feature
A. extends a sequential series of data
B. automatically adds range of cell values
C. applies a boarder around the selected cells
D. none of the above
Answer : D

47. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
Answer : C

48. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
Answer : A

49. How do you select an entire column?
A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column
Answer : B

50. Status indicators are located on the
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
Answer : C