15 Top Microsoft Excel Questions and Answers with PDF Set-1 - Microsoft Excel
Microsoft Excel Questions and Answers
SET-I
PDF Download Click Here
1. In MS Excel, in which bar have the currency option
A) Formatting Toolbar
B) Standard Toolbar
C) Status Bar
D) Formula bar
1. In MS Excel, in which bar have the currency option
A) Formatting Toolbar
B) Standard Toolbar
C) Status Bar
D) Formula bar
2. Which menu contains
macro options in MS Excel
A) Insert
B) Format
C) Tools
D) Data
A) Insert
B) Format
C) Tools
D) Data
3. Which function is used
to input the date only in MS Excel?
A) Today
B) Now
C) Time
D) Calendar
A) Today
B) Now
C) Time
D) Calendar
4. Which Function is used
to calculate Remainder in MS Excel?
A) INT ( )
B) FACT ( )
C) MOD ( )
D) DIV ( )
A) INT ( )
B) FACT ( )
C) MOD ( )
D) DIV ( )
5. Which menu have the
Fill option in MS Excel?
A) View
B) Format
C) Tools
D) Edit
A) View
B) Format
C) Tools
D) Edit
6. Excel is a collection
of workbook ………….
A) Workbooks
B) Worksheets
C) Charts and Slides
D) Data
A) Workbooks
B) Worksheets
C) Charts and Slides
D) Data
7. Which of these data
types is not in MS-excel?
A) Number
B) Currency
C) Label
D) Date/Time
A) Number
B) Currency
C) Label
D) Date/Time
8. In MS Excel, which
menu does have Sort option
A) Edit
B) Format
C) Tool
D) Data
A) Edit
B) Format
C) Tool
D) Data
9. Which of these charts does not exist in MS Excel
A) Scatter
B) Line
C) Doughnut
D) Graph
A) Scatter
B) Line
C) Doughnut
D) Graph
10. 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
A) Axes
B) Data Label
C) Data Series
D) Data Table
11. MS EXCEL Based on
_______ Software
A) WINDOWS
B) DOS
C) UNIX
D) LINUX
A) WINDOWS
B) DOS
C) UNIX
D) LINUX
12. A spreadsheet is a
collection of pages is called a _______
A) Workbook
B) Art book
C) Worksheet
D) Documents
A) Workbook
B) Art book
C) Worksheet
D) Documents
13. What is the Extension
of Excel Workbook in MS Excel 2007?
A) .xlx
B) .xlsx
C) .xlcx
D) .xlxx
A) .xlx
B) .xlsx
C) .xlcx
D) .xlxx
14. 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
A) Legend
B) Chart area
C) Data label
D) Data Titles
15. Which sign display
when Formula Error in MS Excel
A) $
B) *
C) \
D) #
A) $
B) *
C) \
D) #
PDF Download Click Here
ANSWERS SHEET
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
|
A
|
C
|
A
|
C
|
D
|
B
|
C
|
D
|
D
|
C
|
A
|
A
|
B
|
C
|
D
|
