21. A Spreadsheet contains?

1. columns
2. rows
3. rows and columns
4. None of above

22. The autofill feature

1. Extends a sequential series of data
2. Automatically adds range of cell values
3. Applies a boarder around the selected cells
4. All of the above

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

1. =currentTime()
2. =time()
3. =now()
4. All of the above

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

1. Standard formulas
2. Array formula
3. Complex formulas
4. Smart formula

25. In Excel, Columns are labeled as _____

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

26. Which type of charts can excel produce?

1. Line Graphs And Pie Charts Only
2. Bar Charts, Line Graphs And Pie Charts
3. Bar Charts And Line Graphs Only
4. Only Line Graphs

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

1. Filter
2. Wrap
3. Pivot
4. Merge

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

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

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

1. Pattern
2. Gradient
3. Texture
4. Velvet

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

1. Bar
2. Pie
3. Line
4. Function