MS Office Excel
When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
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