<< Chapter < Page Chapter >> Page >

Wrapping Text: Sometimes the titles of columns or data entered in rows and columns is long and make the column extend beyond an inch or two. You can “wrap” the text so that all columns are about the same width if you like. Wrapping text is accomplished by (1) selecting (highlighting) by placing the cursor over the cell you want to have wrapped text, over the letter of the column you want to wrap text, or over the row number that you want to wrap text and then left clicking; and then (2) selecting the appropriate symbol from the ribbon in Excel and Google Spreadsheet by moving the cursor over that symbol and left clicking. Below is a picture of the symbols used in Excel and in Google Spreadsheet. Place your cursor over the symbol you want, left click on the symbol and the data cell you have selected will be wrapped. Below is also a picture of the label row (row 1) not wrapped (in Google Spreadsheet) followed by the labels wrapped (in Excel). Note that the first row has been wrapped and also column B. Note also that when the column is too narrow for numerical data, the pound symbol “#” will appear. If you make the column wider by placing your cursor in the line between the two letters of the columns or two numbers for rows a line with double arrows (pointing right and left for column width and up and down for row height) will appear. While you can see the line with double arrows left click and hold until the row or column is the right height or width. When you have the width or height to correctly display your data release your hold on the mouse and the new height or width will be displayed and held.

Non-wrapped text in the headings or row 1 of a google spreadsheet with the wrap test symbol highlighted in blue.

Wrapped text in the headers (row 1) and wrapped text in column B of a Excel spreadsheet. Note that the timestamp is indicated by a pound symbol in the Excel spreadsheet rather than in numeric characters as in the Google Spreadsheet. This indicated that the column is too narrow for proper display.

All other elements of displaying a spreadsheet can be done in a similar manner. You could use the same technique to center data, center column headings, right justify numeric data, change type or size of type, change number format.

Other Important functions of spreadsheets: Two other functions that would be good to present here are the formula function and the absolute value function. These two functions will be used throughout the semester. Any time you are indicating to the spreadsheet that you have a formula for the computer to compute you must start with an “=” equal sign . If you type in 1 + 1 into an empty spreadsheet cell, it will keep the 1 + 1 in that cell. If you type in =1+1 into an empty cell, it will produce 2. Try it, the main point here is a formula for the spreadsheet must start with an “=” equal sign. I could also pick the cell addresses of two or more cells and write =h2+h5 into an empty cell (for instance cell K2 on our sample spreadsheet, this would add the contents of cell h2 and h5. In our example spreadsheet that would add 124 + 95 which would equal 215.

Questions & Answers

explain and give four Example hyperbolic function
Lukman Reply
The denominator of a certain fraction is 9 more than the numerator. If 6 is added to both terms of the fraction, the value of the fraction becomes 2/3. Find the original fraction. 2. The sum of the least and greatest of 3 consecutive integers is 60. What are the valu
SABAL Reply
1. x + 6 2 -------------- = _ x + 9 + 6 3 x + 6 3 ----------- x -- (cross multiply) x + 15 2 3(x + 6) = 2(x + 15) 3x + 18 = 2x + 30 (-2x from both) x + 18 = 30 (-18 from both) x = 12 Test: 12 + 6 18 2 -------------- = --- = --- 12 + 9 + 6 27 3
Pawel
2. (x) + (x + 2) = 60 2x + 2 = 60 2x = 58 x = 29 29, 30, & 31
Pawel
ok
Ifeanyi
on number 2 question How did you got 2x +2
Ifeanyi
combine like terms. x + x + 2 is same as 2x + 2
Pawel
Mark and Don are planning to sell each of their marble collections at a garage sale. If Don has 1 more than 3 times the number of marbles Mark has, how many does each boy have to sell if the total number of marbles is 113?
mariel Reply
Mark = x,. Don = 3x + 1 x + 3x + 1 = 113 4x = 112, x = 28 Mark = 28, Don = 85, 28 + 85 = 113
Pawel
how do I set up the problem?
Harshika Reply
what is a solution set?
Harshika
find the subring of gaussian integers?
Rofiqul
hello, I am happy to help!
Shirley Reply
please can go further on polynomials quadratic
Abdullahi
hi mam
Mark
I need quadratic equation link to Alpa Beta
Abdullahi Reply
find the value of 2x=32
Felix Reply
divide by 2 on each side of the equal sign to solve for x
corri
X=16
Michael
Want to review on complex number 1.What are complex number 2.How to solve complex number problems.
Beyan
yes i wantt to review
Mark
use the y -intercept and slope to sketch the graph of the equation y=6x
Only Reply
how do we prove the quadratic formular
Seidu Reply
please help me prove quadratic formula
Darius
hello, if you have a question about Algebra 2. I may be able to help. I am an Algebra 2 Teacher
Shirley Reply
thank you help me with how to prove the quadratic equation
Seidu
may God blessed u for that. Please I want u to help me in sets.
Opoku
what is math number
Tric Reply
4
Trista
x-2y+3z=-3 2x-y+z=7 -x+3y-z=6
Sidiki Reply
can you teacch how to solve that🙏
Mark
Solve for the first variable in one of the equations, then substitute the result into the other equation. Point For: (6111,4111,−411)(6111,4111,-411) Equation Form: x=6111,y=4111,z=−411x=6111,y=4111,z=-411
Brenna
(61/11,41/11,−4/11)
Brenna
x=61/11 y=41/11 z=−4/11 x=61/11 y=41/11 z=-4/11
Brenna
Need help solving this problem (2/7)^-2
Simone Reply
x+2y-z=7
Sidiki
what is the coefficient of -4×
Mehri Reply
-1
Shedrak
the operation * is x * y =x + y/ 1+(x × y) show if the operation is commutative if x × y is not equal to -1
Alfred Reply
A soccer field is a rectangle 130 meters wide and 110 meters long. The coach asks players to run from one corner to the other corner diagonally across. What is that distance, to the nearest tenths place.
Kimberly Reply
Jeannette has $5 and $10 bills in her wallet. The number of fives is three more than six times the number of tens. Let t represent the number of tens. Write an expression for the number of fives.
August Reply
What is the expressiin for seven less than four times the number of nickels
Leonardo Reply
How do i figure this problem out.
how do you translate this in Algebraic Expressions
linda Reply
why surface tension is zero at critical temperature
Shanjida
I think if critical temperature denote high temperature then a liquid stats boils that time the water stats to evaporate so some moles of h2o to up and due to high temp the bonding break they have low density so it can be a reason
s.
Need to simplify the expresin. 3/7 (x+y)-1/7 (x-1)=
Crystal Reply
. After 3 months on a diet, Lisa had lost 12% of her original weight. She lost 21 pounds. What was Lisa's original weight?
Chris Reply
Got questions? Join the online conversation and get instant answers!
Jobilize.com Reply

Get the best Algebra and trigonometry course in your pocket!





Source:  OpenStax, Collaborative statistics using spreadsheets. OpenStax CNX. Jan 05, 2016 Download for free at http://legacy.cnx.org/content/col11521/1.23
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Collaborative statistics using spreadsheets' conversation and receive update notifications?

Ask