## 21. A Spreadsheet contains?

- columns
- rows
- rows and columns
- None of above

Answer : C

Explanation: A Spreadsheet contains rows and columns.

## 22. The autofill feature

- Extends a sequential series of data
- Automatically adds range of cell values
- Applies a boarder around the selected cells
- All of the above

Answer : D

Explanation: AutoFill feature of Excel is a great time saver. This command can automatically extend the sequence, adds a range of cell values, applies a border around the selected cells.

23. Which function is used to enter current time in a worksheet cell?

- =currentTime()
- =time()
- =now()
- All of the above

Answer : C

Explanation: None.

## 24. **Multiple calculations can be made in a single formula using**

- Standard formulas
- Array formula
- Complex formulas
- Smart formula

Answer : B

Explanation: None.

## 25. In Excel, Columns are labeled as _____

- A, B, C, etc
- 1,2,3 etc
- A1, A2, etc.
- $A$1, $A$2, etc.

Answer : A

Explanation: In Excel, Columns are labeled as A, B, C, etc

## 26. Which type of charts can excel produce?

- Line Graphs And Pie Charts Only
- Bar Charts, Line Graphs And Pie Charts
- Bar Charts And Line Graphs Only
- Only Line Graphs

Answer : B

Explanation: Excel can be used to create Bar Charts, Line Graphs And Pie Charts.

## 27. Which term is used to join the selected cells into one cell?

- Filter
- Wrap
- Pivot
- Merge

Answer : D

Explanation: Merge is used to join the selected cells into one cell.

## 28. **In Microsoft Excel spreadsheets, ROWS are labelled as** ___

- A, B, C, …
- 1, 2, 3, …
- A1, B1, C1, …
- None of the above

Answer : B

Explanation: In Microsoft Excel spreadsheets, ROWS are labelled as 1,2,3,… .

## 29. What term describes a background that appears as a grainy, non-smooth surface?

- Pattern
- Gradient
- Texture
- Velvet

Answer : B

Explanation: A background that appears as a grainy, non-smooth surface is called Gradient.

## 30. Which of the following Excel charts represents only one value for each variable?

- Bar
- Pie
- Line
- Function

Answer : B

Explanation: Pie charts represents only one value for each variable.

Pingback: Cloud Computing MCQ Questions and Answers - cozmocard