Home

The autofill feature

A. extends a sequential series of data

B. automatically adds range of cell values

C. applies a boarder around the selected cells

D. none of the above

You can do it
  1. A numeric value can be treated as label value if ...... precedes it.
  2. Which of the following is the oldest spreadsheet package?
  3. Which of the following is not the correct method of editing the cell content?
  4. To view a cell comment
  5. What is represented by the small, black square in the lower-right corner of an active cell or range?
  6. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  7. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  8. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  9. How do you rearrange the data in ascending or descending order?
  10. Which area in an Excel window allows entering values and formulas?
  11. You can copy data or formulas
  12. Where can you set the shading color for a range of cells in Excel?
  13. You can set Page Border in Excel from
  14. Which tool you will use to join some cells and place the content at the middle of joined cell?
  15. To copy cell contents using drag and drop press the
  16. In Excel, a Data Series is defined as what?
  17. What does COUNTA () function do?
  18. How do you display current date only in MS Excel?
  19. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  20. A worksheet range is a
  21. Hyperlinks can be
  22. How many worksheets can a workbook have?
  23. When a range is selected, how can you activate the previous cell?
  24. Which of the following options is not located in the Page Setup dialog box?
  25. Excel probably considers the cell entry January 1, 2000 to be a
  26. Which elements of worksheet can be protected from accidental modification
  27. Each excel file is called a workbook because
  28. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  29. Which of the following is an absolute cell reference?
  30. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?