Sunday, June 28, 2015

MS-Excel Quiz for SSC Exams with Solution

MS-Excel Quiz for SSC Exams
1. It is a grid of cells made up of horizontal and vertical columns.
  1. worksheet
  2. sheet
  3. spreadsheet
  4. page
2.Three types of data can be entered in a worksheet: numbers/ characters, text and 
  1. formulas
  2. functions
  3. logic
  4. none of these
3.General arrangement of data is known as
  1. arrangement
  2. overwriting
  3. manipulating
  4. formatting
4.Which of the following key combinations is used to select the current row
  1. Shift + Enter
  2. Shift + Spacebar
  3. Ctrl + Spacebar
  4. Ctrl + C
5. Default height of a row is ______________________ points
  1. 12.75
  2. 12.01
  3. 12.50
  4. 12.30
6. Default column width is _________________points
  1. 8.40
  2. 8.43
  3. 8.50
  4. 8.20
7. MS-Excel contains how many rows?
  1. 65,500
  2. 65,530
  3. 65,400
  4. 65,536
8. MS-Excel contains how many columns?
  1. 256
  2. 250
  3. 240
  4. 245
9.The extension of saved file in MS-Excel is
  1. .XIS
  2. .XAS
  3. .XLS
  4. .XLL
10. All formula start with, which sign in MS-Excel?
  1. +
  2. -
  3. @
  4. =
11. For creating an absolute cell reference, which sign is used?
  1. $
  2. @
  3. #
  4. !
12.How many data series are there in a chart?
  1. 250
  2. 255
  3. 260
  4. 265
13.A cell entry can be edited in the cell or in the 
  1. menu bar
  2. edit menu
  3. function bar
  4. formula bar
14.A chart placed in a worksheet is called
  1. formatting chart
  2. embedded chart
  3. aligning chart
  4. None of these
15.This chart shows the relationship of parts to a whole
  1. pie
  2. line
  3. stacked bar
  4. embedded
16. Scatter chart is also known as
  1. XX chart
  2. YX chart
  3. XY chart
  4. YY chart
17. The address of the cell at 20th column and 30th row is
  1. T30
  2. T20
  3. T10
  4. T40
18.Cell address A4 in a formula means it is a 
  1. mixed cell reference
  2. absolute cell reference
  3. relative cell reference
  4. None of these
19. Cell address $A$4 in a formula means it is a 
  1. mixed cell reference
  2. absolute cell reference
  3. relative cell reference
  4. None of these
20.To add two cells (A1 and A2) together you use use the following formula
  1. =A1+A2
  2. =Add(A1 + A2)
  3. =together(A1:A2)
  4. A1 plus A2










Answers
  1. (1) Worksheet
  2. (3) Logic
  3. (4) Formatting
  4. (2) Shift + Spacebar
  5. (1) 12.75
  6. (2) 8.43
  7. (4) 65,536
  8. (1) 256
  9. (3) .XLS
  10. (4) =
  11. (1) $
  12. (2) 256
  13. (4) Formula Bar
  14. (2) Embedded Chart
  15. (3) Stacked Bar
  16. (3) XY Chart
  17. (1) T30
  18. (3) Relative Cell Reference
  19. (2) Absolute Cell Reference
  20. (1) = A1 +A2

Get Study Materials in Your E-Mail


0 comments:

Post a Comment

Leave your comment but never use bad words otherwise you will be blocked.