MS Office Excel
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
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
All of above
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
Related posts
Which tool you will use to join some cells and place the content at the middle of joined cell?A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
A(n) _________ is a prewritten formula that is built into EXCEL.
A. function
B. problem
C. equation
D. equal sign
The design of text.
A. Font
B. Cell
C. Range
D. Merge
You can print only an embedded chart by
A. Moving the chart to a chart sheet before you print.
B. Formatting the chart before you print
C. Selecting the chart before you print
D. a and c
Colton is calculating his GPA. If he uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
A. Values
B. Formulas
C. Labels
D. Functions
Which of the following is the oldest spreadsheet package?
A. VisiCalc
B. Lotus 1-2-3
C. Excel
D. StarCalc
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cell in that range that contain 100. Wha
A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF
Leave a Reply