ch 7 advanced tables & graphics

Question 1

convert text into a table

convert the selected text to a table with 3 columns. Autofit the contents and ensure that text is separated by the tab key

Answer 1

1. insert tab
2. click table button
3. convert text to table
4. confirm that the table size will be 3 columns. Select Autofit to contents in the Autofit behavior area

Question 2

convert a table to text

convert the selected table to text using tabs to separate cells

Answer 2

1. click table layout tab
2. click the convert to text button
3. confirm the seperate text with section is set to tabs and click ok

Question 3

sort text in a table

sort the selected table by age using a number type; using paragraphs in ascending order. this table has headers

Answer 3

1. table layout tab
2. click sort
3. click the sort by arrow
4. click age
5. click type arrow
6. click number
7. click ok

Question 4

create a formula

Answer 4

1. table layout tab
2. formula button
3. formula text box: =220-A14
4. click the number format drop-down list
5. select 0
6. click ok

Question 5

use a function in a formula

Answer 5

1. table layout tab
2. formula button
3. click paste function drop down arrow
4. select AVERAGE
5. type C3:D3 between the parantheses
6. click number format drop down arrow
7. select 0
8. click ok

Question 6

change cell margins and spacing

Answer 6

1. table layout tab
2. cell margins button
3. type .04 in the top margin area
4. verify that the Automatically resize to fit contents box is checked
5. click ok

Question 7

split a cell

Answer 7

1. table layout tab
2. split cells button
3. click the Up button on the number of columns
4. click ok

Question 8

repeat header rows

Answer 8

1. table layout tab
2. repeat header rows [data group]

Question 9

use the border painter

Answer 9

1. table design tab
2. click the border painter button
3. click the line style drop down list
4. click the triple line option (9th option)
5. click the line weight drop down list
6. select 1/2 pt
7. click the pen color drop down list
8. select orange accent 2
9. click the right border of the max and target heart rates cell in the top table
10. click the border painter button

Question 10

save a table to the quick tables gallery

Answer 10

1. insert tab
2. click the table button
3. quick tables
4. click save selection to quick tables gallery
5. type heart rate table in the name box
6. click ok

Question 11

crop a picture

Answer 11

1. picture format tab
2. click the top half of the crop button

Question 12

picture styles

Answer 12

1. picture format tab
2. click the more button in the picture styles gallery
3. select the metal frame (1st row 3rd option)

Question 13

corrections

Answer 13

1. picture format tab
2. corrections button
3. select sharpen 25% from the soften/sharpen section

Question 14

color

Answer 14

1. picture format tab
2. color button
3. select blue-gray text color 2 dark

Question 15

artistic effects

Answer 15

1. picture format tab
2. artistic effects button
3. select pencil grayscale

Question 16

compress pictures

Answer 16

1. picture format tab
2. compress pictures button
3. select Print (220 ppi)
4. click ok

Question 17

change a picture in a document

Answer 17

1. picture format tab
2. change picture button
3. click from a file….
4. select RunnerWoman-01 image
5. click insert

Question 18

shape styles

Answer 18

1. shape format tab
2. shape fill button
3. select blue-gray text 2 darker 50%
4. click shape outline button
5. select no outline
6. click shape effects
7. preset –> preset 5

Question 19

add text to a shape

Answer 19

1. click arrow:pentagon shape
2. type 220-

Question 20

align shapes

align the selected images in the middle, vertically

Answer 20

1. shape format tab
2. click align button
3. align middle button

Question 21

group middle objects

Answer 21

1. shape format tab
2. group button
3. select group