What’s a quick way to extend these numbers to a longer sequence for instance 1 through 20?

  1. Home

Question:
What’s a quick way to extend these numbers to a longer sequence for instance 1 through 20?

1.Select both cells and then drag the fill handle over the range you want for instance 18 more rows

2.Select the range you want include both cells point to fill on the Edit menu and then click down.

3.Copy the second cell click in the cell below it on the standard toolbar click the down arrow on the Paste button and then click Paste Special

4.all of above

Posted Date:-2021-02-11 17:23:19

More MCQS Questions and answers

  1. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
  2. A data map is helpful
  3. Charts tips can
  4. Data marker on a chart are linked to data points in a worksheet therefore
  5. Got functions? No? You need the insert function dialog box. How do you get it?
  6. How do you change column width to fit the contents?
  7. Hyperlinks cannot be
  8. In a worksheet you can select
  9. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
  10. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
  11. Rounding errors can occur
  12. Status indicators are located on the
  13. The default header for a worksheet is
  14. The Name box
  15. to activate the previous cell in a pre-selected range press
  16. To center worksheet titles across a range of cell you must
  17. To drag a selected range of data to another worksheet in the same workbook use the
  18. To edit data in an embedded Excel worksheet object in a Word document
  19. To hold row and column titles in places so that they do not scroll when you scroll a worksheet click the
  20. To insert three columns between columns D and E you would
  21. Weight refers to
  22. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
  23. What function displays row data in a column or column data in a row?
  24. What term refers to a specific set of values saved with the workbook?
  25. What’s a quick way to extend these numbers to a longer sequence for instance 1 through 20?
  26. When creating a vertical page break
  27. When integrating Ms-Word and Excel Word is usually the
  28. When the formula bar is activated you can see
  29. when working in the page break preview you can
  30. When you insert an Excel file into a Word document the data are
  31. When you link data maintained in Excel workbook to a Word document
  32. when you print preview a worksheet
  33. When you see a cell with a red triangle in the top right corner what does this signify?
  34. when you use the fill effects in the format data series dialog box you can not
  35. when you work with large worksheets you may need to
  36. Which of the following describes how to select all the cells in a single column?
  37. Which of the following is not a basic step in creating a worksheet?
  38. Which of the following setup options can not be set in the page setup dialog box?
  39. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
  40. You can activate a cell by
  41. You can copy data or formulas
  42. You can group noncontiguous worksheets with
  43. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
  44. You can open the Sort dialog box by choosing Sort from the ….. Menu
  45. You can use the format painter multiple times before you turn it off by
  46. You can use the horizontal and vertical scroll bars to
Search
Olete Team
Online Exam Test Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Test website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!