Unit 7 - Excel Workbook

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Truncated

A cell value that has been cut off from view has been truncated. The complete value is still there, but is not visible. To make the data visible, simply widen the column.

Chart

A chart is used to graphically display data.

Data marker

A data marker is a column in the chart that represents a single data point.

Data series

A data series includes the individual colored columns, lines, or slices that represent the data in the chart.

Formula

A formula is an equation that performs mathematical calculations on number values.

Chart elements

Chart elements are the different parts of a chart. These include the title, legend, labels, and so forth.

Chart styles

Chart styles are the visual designs, such as color and shape of the pie slice or bar(s). You can manually adjust these design features, or you can use one of the predefined styles in the Chart Styles group.

Chart tools

Chart tools are additional tools on the ribbon bar for use in designing and formatting charts. These appear when a chart is selected.

Deselect

Clicking the mouse anywhere outside the currently selected cell or range of cells will deselect the cells.

Chart tools are additional tools on the ribbon bar for use in designing and formatting charts. These appear when a chart is selected.

Contextual tabs are additional tools that appear only when a chart is selected.

Value

Data inside the cell is called a value. The value can be a text value such as number values or words for labels.

Workbook

Excel files are called workbooks. This includes the individual worksheets and charts.

A First Look at Excel

Excel shares many of the same features and organization as Microsoft Word.

=

Excel uses the equal sign to designate the beginning of a formula.

Cell reference

Formulas often use the values found in other cells to make calculations. The cell reference is the part of a formula that gives the cell address used to make calculations. Example: =SUM(C4+D4) "C4" and "D4" are cell references. This formula will add whatever values are found in C4 and D4.

Highlighting

Highlighting is selecting cells by clicking and dragging with your mouse.

Absolute cell reference

If you don't want a cell reference to change when a formula is moved, it needs to be designated as an absolute cell reference. This is done by adding a $ before the column and row. In the formula below, the value found in cell C4 would be added regardless of where the formula was moved, but D4 would change if the formula was moved. =SUM($C$4+D4)

How do you know which cell is active?

It is the cell with a thicker black box around it.

Cell styles

Located under the Home tab, this button provides a list of predefined formatting to add emphasis to cell values.

Function

Predefined formulas such as SUM or MIN are functions. These are found on the Home tab in the Editing group.

End+←,↑,→, or ↓

Pressing End and an arrow key moves the active cell to the first or last cell containing data in that row or column.

Relative cell reference

Relative cell references adjust if the formula is moved or if columns or rows are inserted. If the formula =SUM(C4+D4) was copied down one row, the cell references would automatically change to =SUM(C5+D5) in the new formula.

Scroll bars

Slide the scroll bars to control what portion of the worksheet you view. You can also use arrows at the ends of the bars to change views.

What keyboard key would you use to move from cells left to right?

Tab

Use the Sum Function

The Sum function is one of the most frequently used formulas for spreadsheets. It allows you to add up large numbers quickly and automatically. Even if some of the numbers are changed later on, Excel adjusts the results to match.

Active cell

The active cell is the one that is currently outlined in black and ready for data to be entered into it.

Column width

The boundary line of columns can be dragged to increase or decrease their width. You can also double-click the line between column letters to automatically adjust the width to fit the largest value.

Category axis, or X axis

The category axis, or X axis, is located at the bottom of the chart and is used to label the categories in the chart. Excel uses the row titles for the category axis.

Cell reference

The cell reference is the name of the cell that describes where a certain column and row intersect. The cell reference consists of a letter and the number, such as C4, which is where column C and row 4 intersect. The cell reference is also called the cell address.

Chart layout

The chart layout determines how data is displayed and how the different chart elements are arranged. You can choose layout options manually or select from one of the predefined chart layouts in the Charts Layout group.

Fill handle

The fill handle is located in the lower right corner of an active cell. Click and then drag the fill handle to copy the cell contents. Copying formulas using the fill handle will adjust the cell addresses in the formulas relative to their new column and row location.

Formula bar

The formula bar displays the underlying value of the cell, which may be text, numbers, or calculations.

Underlying data

The formula being used to calculate the displayed data in a cell is the underlying data. For example, =B5+c7 is underlying data. The result, 24, would be the displayed data.

Row height

The height can be adjusted to give emphasis to the data in the row.

Row

The horizontal location of data that is labeled with numbers is a row.

Cell

The intersection of a column and a row is a cell.

Legend

The legend identifies the labels or colors assigned to the data series.

Mini toolbar

The mini toolbar is a toolbar with common formatting functions that appears by your mouse pointer.

Name box

The name box displays the name or address of the active cell. It also allows you to quickly go to a desired cell by typing the cell name and pressing the Enter key.

Range

The range is a group of two or more adjacent cells that have been selected. In the cell address box you would identify the top left of the range and the bottom right of the range. For example, B5:C7 is a range.

Data point

The range used to create the chart is outlined in a blue border. Each cell within a data series contains a data point.

Value axis, or Y axis

The value axis, or Y axis, is located on the left side of the chart. This is the numerical scale based on the charted data.

Displayed data

The value you actually see in the cell is the displayed data.

Column

The vertical location of data that is labeled with letters is a column.

AVERAGE

This function calculates the average of the values found in a range.

MAX

This is the abbreviation for "maximum." You can use this when you want to find the largest number in a list.

MIN

This is the abbreviation for "minimum." You can use this when you want to find the smallest number in a list.

Alt+=

This is the shortcut for SUM.

Go to key

This is used to move immediately to any cell location. Click Find & Select on the Home tab and then select Go to. Enter any cell address. The shortcut for this option is F5.

Ctrl+End

This moves the active cell to the last row and column containing data.

Ctrl+Home

This returns the active cell to the first cell of the row.

Arrow keys

Use the arrow keys to move between cells.

Worksheet

Workbooks are made up of one or more individual worksheets. Individual worksheets can be accessed by using the tabs across the bottom.

Enter

You can use the Enter key on your keyboard to move to the next row when entering data.

Merge & Center

You can use the Merge & Center button to combine cells for holding a title and centering text on the line.

SUM

You can use the SUM function when you want to get a total of several numbers. Use the drop-down menu next to the sum function to access the other commonly used functions.

Tab

You can use the Tab key on your keyboard to move to the next column when entering data.

Selecting a range

You can use the mouse to select a range by clicking and dragging the alphabetical column headings or row numbers.

COUNT

You can use this when you want to find how many cells have numbers in them.

Insert column or row

You may insert a column or a row by right-clicking the column name or row number and choosing Insert.

What is a workbook?

an electronic book used to organize data

The columns are named with what?

letters of the alphabet

The rows are named with what?

numbers

What is a worksheet?

one page inside the workbook


संबंधित स्टडी सेट्स

Cognitive Neuroscience Module #3

View Set

Technical Writing Formal Quiz english 365

View Set

PSY120 TopHat Chapters 3-14 Review

View Set

ESTRUCTURA | 7.1 Reflexive verbs- Completar

View Set

EDAPT Nursing Care: Intrapartum Period

View Set