MS Excel Question & Answer MCQ SET 1
1. How many sheets are there in Excel Workbook by default?
A) 4
B) 3
C) 6
D) 7
ANSWER: OPTION B
2. By default column width of Excel
A) 9.43
B) 8.43
C) 5.34
D) 7.34
ANSWER: OPTION B
3. Excel files have a default extension of
A) Xls
B) Xlw
C) Wk1
D) 123
ANSWER: OPTION A
4. The number of columns in a worksheet is
A) 36500
B) 16384
C) 256
D) 64536
ANSWER: OPTION B
5. How many characters can be typed in a single cell in Excel?
A) 1024
B) 32000
C) 256
D) 65535
ANSWER: OPTION D
6. In Microsoft Office 2007 version, an Excel sheet contain _______ no of rows
A) 65565
B) 255
C) undetermined
D) 1048576
ANSWER: OPTION D
7. By Formatting a cell in Currency format, you can specify?
A) Currency Symbol
B) Decimal Places
C) Both 1 and 2 Options
D) None of above
ANSWER: OPTION C
8. The cell reference for a range of cells that starts in cell B1 and goes over to
column G and down to row 10 is..
A) G1-G10
B) B1.G10
C) B1.G10
D) B1:G10
ANSWER: OPTION D
9. You can open the Sort dialog box by choosing Sort from the………menu
A) View
B) Format
C) Tools
D) Data
ANSWER: OPTION D
10.A Worksheet Range is a
A) A Group of Worksheets
B) Command used for Data Modeling
C) A Group of Cells
D) A Range of Values such as from 23 to 234
ANSWER: OPTION C
0 Comments