Name:Excel and Publisher Review Sheet

Name:Excel and Publisher Review Sheet

MS EXCEL

1. Microsoft Excel 2010 –

1. Sheet Tab –

1. Columns –

1. Rows –

1. Cell –

1. Cell Reference –

1. Active Cell –

1. Name Box –

1. Formula Bar –

1. Formula –

1. A(n) Excel ______allows data to be easily summed and charted.
2. Excel automatically positions the text ______in a cell.
3. A ______is a series of two or more adjacent cells in a column or a row or rectangular group of cells.
4. To create a workbook you must use more than one ______
5. ______is a spreadsheet program in MS Office.
6. ______is a function when you double click to make the column wider.
7. A ______is a preset collection of design elements, including fonts, colors and other effects.
8. When a number does not fit in a cell it shows up as ______.
9. An intersection of a row and a column is called a ______.
10. Use the ______key when you want to clear a cell.
11. This ------> ( A2:B2) is called a ______.

Matching

1. Displays cell contents on multiple lines ______
2. Aligns text to the right, left or center. ______
3. Combines Several cells into one and places the contents in the middle of the cell ______
4. Moves text to several spaces to the right or left ______
5. Displays text at an angle, vertically, up and down______

Merge and CenterAlignmentIndenting

OrientationWrapping

1. This page view ______shows you how your worksheet will appear on paper.
2. This is the blank space around the top, bottom and sides of your paper. You can set them in your page layout ______

1. This is located at the top and bottom of your worksheet and is broken up into left, center and right and you can put your page number, the date or any other info into these ______

1. Cell reference that adjusts to its new location when copied or moved to another cell ______
2. A constant text, number or cell reference used in a formula ______
3. A symbol that indicates what type of calculation will be performed ______
4. Cell references that contain both relative and absolute Cell references ______
5. This cell references doesn’t change when copied to a new cell ______
6. Clicking each cell rather than typing a cell reference ______
7. An equation used to calculate values based on numbers entered into a cell______
8. The sequence used to calculate the value of a formula ______

1. This formula =A4+B4 is an example of a ______
2. This formula =$A$4+$B$4 is an example of a ______
3. This formula =$A$4 +B4 is an example of a ______
4. This function means you are looking for the lowest number in a given range ______
5. This function means you are looking for the Highest number in a given range ______

T or F

1. ______Charts are graphical representations of data
2. ______An embedded Chart can be moved
3. ______A Sparkline is a mini chart that is inserted within a cell
4. ______When the data source changes so does the chart created
5. ______After you create a chart you can change it to a different type of chart

1. ______To alert Excel that you are about to type a formula, you must first type the (*) sign
2. ______The fill handle copies a formula in one cell to adjacent cells

Fill in the Blank

1. A(n) ______is a chart that looks like a circle with pieces
2. A group of unrelated information is charted into this type of chart ______
3. A(n) ______chart is place on the same sheet as the data source
4. The pieces in this chart can be pulled apart ______
5. These X & Y ______need to be labeled

PUBLISHER:

1. How do you change the color scheme?
2. What is the name of the publisher feature that allows you to create a collection of information about an individual?
3. What does the design checker do?
4. The ______page is a background page that includes placeholders for text and graphics.

1. ______allows you to treat a batch of items as one.

Vocabulary:

1. Building Block
2. Business information set
3. Design Checker
4. Quick Access Toolbar
5. Status Bar
6. Master page