Q 1. Excel Is a Program of?
A.Spreadsheet
B.Word processing
C.Presentation program
D.None of these
Q 2. The cell reference for the range from
A12 to F30 is?
A.A12 , F30
B.A12 .F30
C.A12 ; F30
D.A12:F30
Q 3. Which of the following Excel functions
returns FALSE if all its arguments are FALSE and returns TRUE otherwise ?
A.OR
B.AND
C.NOT
D.EXACT
Q 4. Which of the following Excel Function
change TRUE to FALSE?
A.OR
B.NOT
C.IF
D.AND
Q 5. The Value of the Expression = LEN(“The Tiger”)?
A.6
B.9
C.11
D.15
Q 6. MS excel File Name is ?
A.Spreadsheet
B.Workbook
C.Worksheet
D.None of these
Q 7. How many default Sheet in MS excel?
A.4
B.3
C.1
D.None of these
Q 8. Which of the following automatically
moves a word that is too
long to fit on a line to the beginning of the next
line?
A.Word Wrap
B.Hyphenation
C.Format Painter
D.Data Validation
Q 9. The default vertical alignment of text
in MS Excel worksheet is?
A.Top
B.Center
C.Bottom
D.Middle
Q 10. Which of the following Excel features
allows you to quickly find the sum of numbers in a range?
A. Auto-fill
B.Sort & Filter
C. Auto Sum
D.Merge & Center
Q 11. The Row in MS Excel are called ?
A.Vertical Line
B.Horizontal Line
C.Diagonal Line
D.None of these
Comments
Post a Comment