**MS-Excel Quiz for SSC Exams**

1. It is a grid of cells made up of horizontal and vertical columns.

- worksheet
- sheet
- spreadsheet
- page

2.Three types of data can be entered in a worksheet: numbers/ characters, text and

- formulas
- functions
- logic
- none of these

3.General arrangement of data is known as

- arrangement
- overwriting
- manipulating
- formatting

4.Which of the following key combinations is used to select the current row

- Shift + Enter
- Shift + Spacebar
- Ctrl + Spacebar
- Ctrl + C

5. Default height of a row is ______________________ points

- 12.75
- 12.01
- 12.50
- 12.30

6. Default column width is _________________points

- 8.40
- 8.43
- 8.50
- 8.20

7. MS-Excel contains how many rows?

- 65,500
- 65,530
- 65,400
- 65,536

8. MS-Excel contains how many columns?

- 256
- 250
- 240
- 245

9.The extension of saved file in MS-Excel is

- .XIS
- .XAS
- .XLS
- .XLL

10. All formula start with, which sign in MS-Excel?

- +
- -
- @
- =

11. For creating an absolute cell reference, which sign is used?

- $
- @
- #
- !

12.How many data series are there in a chart?

- 250
- 255
- 260
- 265

13.A cell entry can be edited in the cell or in the

- menu bar
- edit menu
- function bar
- formula bar

14.A chart placed in a worksheet is called

- formatting chart
- embedded chart
- aligning chart
- None of these

15.This chart shows the relationship of parts to a whole

- pie
- line
- stacked bar
- embedded

16. Scatter chart is also known as

- XX chart
- YX chart
- XY chart
- YY chart

17. The address of the cell at 20th column and 30th row is

- T30
- T20
- T10
- T40

18.Cell address A4 in a formula means it is a

- mixed cell reference
- absolute cell reference
- relative cell reference
- None of these

19. Cell address $A$4 in a formula means it is a

- mixed cell reference
- absolute cell reference
- relative cell reference
- None of these

20.To add two cells (A1 and A2) together you use use the following formula

- =A1+A2
- =Add(A1 + A2)
- =together(A1:A2)
- A1 plus A2

**Answers**

- (1) Worksheet
- (3) Logic
- (4) Formatting
- (2) Shift + Spacebar
- (1) 12.75
- (2) 8.43
- (4) 65,536
- (1) 256
- (3) .XLS
- (4) =
- (1) $
- (2) 256
- (4) Formula Bar
- (2) Embedded Chart
- (3) Stacked Bar
- (3) XY Chart
- (1) T30
- (3) Relative Cell Reference
- (2) Absolute Cell Reference
- (1) = A1 +A2

####
Get Study Materials in Your E-Mail

In
Computer,
Daily Quizzes

## 0 comments:

## Post a Comment

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