MS-Excel MCQ Set-1

---

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

2. What symbol is used before a number to make it a label?
A) “ (quote)
B) = (equal)
C) _ (underscore)
D) ‘ (apostrophe)
Answer : B

3. Which symbol must all formula begin with?
A) =
B) +
C) (
D) @
Answer : A

4. Which of the following formulas is not entered correctly?
A) =10+50
B) =B7*B1
C) =B7+14
D)10+50
Answer : D

5. Which of the following formulas will Excel Not be able to calculate?
A) =SUM(Sales)-A3
B) =SUM(A1:A5)*.5
C) =SUM(A1:A5)/(10-10)
D) =SUM(A1:A5)-10
Answer : A

6. In MS Excel, in which bar have the currency option
A) Formatting Toolbar
B) Standard Toolbar
C) Status Bar
D) Formula bar
Answer : A

7. Which menu contains macro options in MS Excel
A) Insert
B) Format
C) Tools
D) Data
Answer : C

8. Which function is used to input the date only in MS Excel?
A) Today
B) Now
C) Time
D) Calendar
Answer : A

9. Which Function is used to calculate Remainder in MS Excel?
A) INT ( )
B) FACT ( )
C) MOD ( )
D) DIV ( )
Answer : C

10. Which menu have the Fill option in MS Excel?
A) View
B) Format
C) Tools
D) Edit
Answer : D

11. Excel is a collection of workbook ………….
A) Workbooks
B) Worksheets
C) Charts and Slides
D) Data
Answer : B

12. Which of these data types is not in MS.excel?
A) Number
B) Currency
C) Label
D) Date/Time
Answer : C

13. In MS Excel, which menu does have Sort option
A) Edit
B) Format
C) Tool
D) Data

Answer : D

14. Which of these charts does not exist in MS Excel
A) Scatter
B) Line
C) Doughnut
D) Graph
Answer : D

15. Which of these options is not available in the Chart Options in MS Excel “CHART WIZARD”?
A) Axes
B) Data Label
C) Data Series
D) Data Table
Answer : C

16. MS EXCEL Based on ___________Software
A) WINDOWS
B) DOS
C) UNIX
D) LINUX
Answer : A

17. A spreadsheet is a collection of pages is called a _______
A) Workbook
B) Art book
C) Worksheet
D) Documents
Answer : A

18. What is the Extension of Excel Workbook in MS Excel 2007?
A) .xlx
B) .xlsx
C) .xlcx
D) .xlxx
Answer : B

19. Which option of Chart Wizard contains the option of Series Name, Category and Value in Data?
A) Legend
B) Chart area
C) Data label
D) Data Titles
Answer : C

20. Which sign display when Formula Error in MS Excel
A) $
B) *
C) \
D) #
Answer : D