Photoshop CS2: Project 1 (Multiple Choice)



|Name |Period |Date |

| | | |

Microsoft Excel 2011: Chapter 1 – Vocabulary (Choose 10 and define)

• AutoCalculate area

• AutoCorrect feature

• automatically updated properties

• bold

• Cancel button

• category axis

• copy area

• destination area

• document properties

• Document Properties dialog

• Edit mode

• embedded chart

• Enter button

• fill handle

• font

• font color

• font size

• font style

• format

• green computing

• hardcopy

• in-cell editing

• insertion point

• keyword

• legend

• merging cells

• metadata

• number

• paste area

• point size

• printout

• range

• relative reference

• requirements document

• save

• snaps

• source area

• splitting a merged cell

• standard properties

• SUM function

• text

• to select a cell

• value axis

• x-axis

• y-axis

1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

Microsoft Excel 2011: Chapter 1 – Multiple Choice

Instructions: Highlight the correct response.

Instructions: Circle the correct response.

1. An Excel _________ allows data to be easily summarized and charted.

a. worksheet

b. format

c. display

d. table

2. You know a cell is active when a heavy border surrounds the cell and the active cell reference appears in the _________ box on the left side of the formula bar.

a. Name

b. Language

c. Worksheet

d. Cell

3. ____________ used to place titles on a worksheet.

a. Tables are

b. Text is

c. Tags are

d. Charts are

4. When you begin typing a cell entry, two buttons in the formula bar turn from gray to colored: ____________.

a. the Cell button and the Tab button

b. the Next button and the Previous button

c. the Cancel button and the Enter button

d. the Font button and the Style button

5. The ____________ is a blinking vertical line that indicates where the next typed character will appear.

a. select border

b. ribbon

c. fill handle

d. insertion point

6. The __________ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

a. AutoRepair

b. AutoCheck

c. Grammar

d. AutoCorrect

7. Excel automatically positions text ____________ in a cell.

a. left-aligned

b. right-aligned

c. centered

d. none of the above

8. When you enter numeric data in a cell, Excel automatically positions the entry ___________ in the cell.

a. left-aligned

b. right-aligned

c. centered

d. vertically-aligned

9. A ____________ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

a. range

b. split

c. key

d. merge

10. To enter a number as text, start the entry with a(n) ____________.

a. colon

b. ampersand

c. apostrophe

d. asterisk

Microsoft Excel 2011: Chapter 1 – Short Answer

Instructions: Use the table below question 10 to fill in the best answer.

1. A(n) _______________ conveys a visual representation of data.

1. A(n) _______________ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements.

1. _______________ typically contain information that is similar to items in a list.

1. _______________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

1. The _______________ function adds all of the numbers in a range of cells.

1. A(n) _______________ is a collection of fonts and color schemes.

1. A chart is _______________ when it is drawn on the same worksheet as the data.

1. The horizontal axis for a chart is called the x-axis, or the _______________.

1. Excel helps you organize and identify your files by using _______________, which are the details about a file.

2. You can obtain a total, an average, or other information about the numbers in a range by using the _______________ area in the lower right of the document window.

|1. | |

|2. | |

|3. | |

|4. | |

|5. | |

|6. | |

|7. | |

|8. | |

|9. | |

|10 | |

Microsoft Excel 2011: Chapter 1 - True/False

Instructions: Highlight T if the statement is true or F if the statement is false.

|T |F |To select a cell is to make it active. |

|T |F |In Excel, a number can be between a negative 1 followed by 308 zeros and a positive 1 followed by 308 zeros. |

|T |F |A number can contain only the following characters: 1 2 3 4 5 6 7 8 9 0. |

|T |F |Boolean values, such as TRUE and FALSE, can be summed. |

|T |F |The cell being copied is called the source area. |

|T |F |You merge a worksheet to emphasize certain entries and make the worksheet easier to read and understand. |

|T |F |Splitting cells involves creating a single cell by combining two or more selected cells. |

|T |F |A line chart often is used to show the contribution of each piece of data to the whole. |

|T |F |Worksheet names can be up to 31 characters (including spaces) in length. |

|T |F |With Excel in Edit mode, you can edit the contents directly in the cell—a procedure called in-cell editing |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download