21. A Spreadsheet contains?

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

View Answer

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

View Answer

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

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

View Answer

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

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

View Answer

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.

View Answer

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

View Answer

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

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

View Answer

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

View Answer

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

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

View Answer

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

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

View Answer