1000+ Microsoft Excel Multiple Choice Question Answer [Solved]

1. Which of the following format you can decide to apply or not in AutoFormat dialog box?
A. Number format
B. Border format
C. Font format
D. All of above
Answer : D

2. Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
Answer : C

3. Which of the following is not a worksheet design criterion?
A. Efficiency
B. Aditibility
C. Description
D. Clarity
Answer : C

4. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
A. From Edit menu choose Clear and then Formats
B. From Edit menu choose Delete
C. Click on Remove Formatting tool on Standard Toolbar
D. Double click the Format Painter and then press Esc key in keyboard
Answer : A

5. The Delete key of keyboard is assigned to which command in Excel?
A. Edit >> Clear >> Contents
B. Edit >> Clear >> All
C. Edit >> Delete
D. All of above
Answer : A

6. The active cell:
A. is defined by a bold border around the cell
B. Receives the data the user enters
C. It is the formula bar
D. Only A and B
Answer : D

7. 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

8. When you link data maintained in an excel workbook to a word document
A. The word document cannot be edit
B. The word document contains a reference to the original source application
C. The word document must contain a hyperlink
D. The word document contains a copy of the actual data
Answer : B

9. A circular reference is
A. Geometric modeling tool
B. A cell that points to a drawing object
C. A formula that either directly or indirectly depends on itself
D. Always erroneous
Answer : C

10. Edit >> Delete command
A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
Answer : D

11. Which elements of worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of above
Answer : D

12. Multiple calculations can be made in a single formula using
A. standard formulas
B. array formula
C. complex formulas
D. smart formula
Answer : B

13. 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

14. 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

15. 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

16. Long text can be broken down into many lines within a cell. You can do this through
A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer : A

17. Comments can be added to cells using
A. Edit > Comments
B. Insert > Comments
C. File > Comments
D. View > Comments
Answer : B

18. 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

19. 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

20. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
A. server
B. source
C. client
D. none
Answer : C

21. Which setting you must modify to print a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
Answer : B

22. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9
Answer : C

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

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

25. How do you rearrange the data in ascending or descending order?
A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
Answer : A

26. How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
Answer : D

27. 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

28. Text formulas:
A. Replace cell references
B. Return ASCII values of characters
C. Concatenate and manipulate text
D. Show formula error value
Answer : C

29. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
Answer : D

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

31. It is acceptable to let long text flow into adjacent cells on a worksheet when
A. data will be entered in the adjecent cells
B. no data will be entered in the adjacent cells
C. there is no suitable abbrevition for the text
D. there is not time to format the text
Answer : B

32. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
A. None of these
B. Select Format > Money from the menu
C. Click the Currency Style button on the formatting toolbar
D. You have to retype everything and manually add the dollar signs, commas, and decimals
Answer : C

33. What are the tabs that appear at the bottom of each workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer : D

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

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

36. Which of the following is a correct order of precedence in formula calculation?
A. Multiplication and division exponentiation positive and negative values
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. All of above
Answer : D

37. Which of the following is a popular DOS based spreadsheet package?
A. Word
B. Smart cell
C. Excel
D. Lotus 1-2-3
Answer : D

38. Which of the following series type is not valid for Fill Series dialog box?
A. Linear
B. Growth
C. Autofill
D. Time
Answer : D

39. You cannot link excel worksheet data to a word document
A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer : D

40. In help menu of Excel, which of the following tabs are found?
A. Contents tab
B. Answer Wizard tab
C. Index tab
D. all of the above
Answer : D

41. When a row of data is to be converted into columns
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Answer : D

42. You can use the horizontal and vertical scroll bars to
A. Split a worksheet into two panes
B. View different rows and columns edit the contents of a cell
C. Edit the contents of a cell
D. view different worksheets
Answer : B

43. 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

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