Excel Terminology

The compnay president Aaron Nwosu, requested a column chart showing monthly slaes of fruit spreads by catagory.What valuable business information does this chart convey to Aaron that can be used in decision making?

A pattern of overall monthly sales

pro jump rope

As of september 30 , which product had the most cases in stock?

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells

Auto Fill

Anything typed into a cell

Cell Content

why is a chart a valuable method of representing data in a worksheet?

Data in a chart is easier to understand than a table of numbers

The small black square in the lower right corner of a selected cell

Fill Handle

An equation that performs mathematical calculations on values in a worksheet

Formula

A command that enables you to select one or more rows or columns and lock them in place is called ______.

Freeze Panes

A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false are called ______________.

Logical functions

A specific way in which excel displays a number in a cell

Number format

The symbols with which you can specify the type of calculation you want to perform in an Excel formula

Operators

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas

Quick Analysis tool

In this quarter, which month had the highest total product sales?

September

which month had the highest sales of jams?

September

The data in this worksheet in valid as of what date

September 30

The labels along the lower border of the Excel window that identify each worksheet

Sheet Tabs

In this project, how is conditional formatting used to address inventory concerns?

The text color and font style indicate which items need to be order

Typically, what is the purpose of text values in a worksheet?

To provide information about number values in other worksheet cells

The data that displays in the Formula Bar

Underlying Value

The values that an Excel function uses to perform calculations or operations are the __________.

arguments

A worksheet where totals from other worksheets are displayed and summarized is a ________.

summary sheet

A series of rows and columns that contains related data and that is managed independently from other data is an Excel _______.

table

The term used to describe an Excel function that is subject to change each time the workbook is opened is called __________.

volatile

Displaying a portion of the number would provide misleading information

why does Excel display the #### error when a cell does not display the entire number?

The type of cell reference that refers to cells by their fixed position in a worksheet

Absolute

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being _________.

Absoulte cell reference

A cell surrounded by a black border and ready to receive data

Active Cell

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column

AutoFit

An Excel function that adds a group of values and then divides the result by the number of values in the group is called _________.

Average function

As of september 30, which product had the highest inventory valuation in terms of total Retail value

Box sea Salt

Data bars provide a quick way to distinguish the relationship among values.Which type of tree do the data bars indicate as being highest in stock?

Bradford

A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria

COUNTIF function

which of the following calculations would require the use of an absolute cell reference?

Calculating the percentage ny which the total retail value of ground ginger makes up the total for all products

The area along the bottom of a chart that identifies the categories of data

Category Axis

The intersection of a column and a row

Cell

Another name for a cell reference

Cell Address

The graphic representation of data in a worksheet is called a ________

Chart

The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the colums, and the table of charted cells

Chart layout

A vertical group of cells in a worksheet

Column

Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria

Comparison operator

A format that changes the appearance of a cell based on a condition

Conditional format

Numbers, text, dates, or times of day that you type into a cell

Constant Value

Conditions that you specify in a logical function

Criteria

Text or numbers in a cell

Data

An element in the Excel window that displays the value or formula contained in the active cell

Formula Bar

The default format that Excel applies to numbers

General Format

Which product has the second lowest percent of total retail value

Ground Cinnamon

A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false

IF function

by looking only at the sparklines, which product had an overall upward trend in sales?

Jams

An Excel function that determines the largest value in a range is called ________.

MAX function

An Excel function that finds the middle value that has as many values above it in the group as are below it is called __________.

MEDIAN function

An Excel function that determines the smallest value in a range is called ________.

MIN function

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell

Merge & Center

The function that retrieves and then displays the date and time from your computer is the __________.

NOW function

An element of the Excel window that displays the name of the selected cell, table, chart, or object

Name Box

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the ______.

Name box

The process of moving within a worksheet or workbook is to ____________.

Navigate

Constant values consisting of only numbers

Number Values

A feature that outlines cells in color to indicate which cells are used in a formula

Range Finder

which of the following best describes the data in this worksheet

Retail value of a specific products inventory as a specific date

A horizontal group of cells in a worksheet

Row

A predefined formula that adds all the numbers in a selected range is called __________.

SUM Function

by tilting a worksheet third quarter sales for fruit spreads, what information would the reader of the worksheet expect to see?

Sales information during the period July through September

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet

Select All Box

A tiny chart in the background of a cell that gives a visual trend summary alongside your data, makes a pattern move obvious

Sparkline

Tiny charts embedded in a cell that give a visual trend summary alongside your data

Sparklines

Another name for a worksheet

Spreadsheet

A charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa

Switch Row/Column

when calculating percentages, why is it valuable to increase the number of decimal places when analyzing important financial information

The data is more precise

Another name for a constant value

Value

Total Row

What table option is used with the filtering command to provide additional data analysis

Anna

What tree is the highest priced item in inventory?

Statistical

What type of fuction is the COUNTIF fuction?

Oak

Which catergory includes the most types of tree?

it is frequently used

Why are there several ways to insert the SUM fuction

An Excel file that contains one or more worksheets

Workbook

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is _______.

auto fill

A defined set of formatting characteristics, such as font, font size, font color, cell borders , and cell shading

cell style

A shaded bar that provides a visual cue about the value of a cell relative to the other cells is a...

data bar

The worksheets that contain the details of the information summarized on a summary sheet are called _________.

detail sheets

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called ________.

filtering

The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is ___________.

flash fill

An equation that performs mathematical calculations on values in a worksheet is called a __________.

formula

A predefined formula that performs calculations by using specific values in a particular order or structure is called a __________.

function

two

how many production methods does the easy pantry use

Any value or expression that can be evaluated as being true or false

logical test

The command that joins merge selected cells into one large cell and center the data in the merge cell

merge and center

Stock level

one of the goals of the inventory manager at pasadena tree nursery is to ensure that the stock levels do not fall to a level in which more than 50% of the items need to be ordered.Which column in the worksheet can you use to quickly determine if more than 50% of the tiems need to be ordered?

The action of placing cell contents that have been copied or moved to the Clipboard into another location is called __________.

paste

The target destination for data that has been cut or copied using the Office Clipboard is the _____.

paste area

The Excel command that enables you to specify rows and columns to repeat on each printed page is called ____________.

print titles

which is the most effecient way to enter large amount of numerical data into an Excel worksheet

select the range of cells before entering the numbers

The labels along the lower border of the workbook window that identify each worksheet are the ________.

sheet tabs

The process of arranging data in a specific order based on the value in each field is called _________.

sorting

Why are sparklines valuable when analyzing workbook data

sparklines make a pattern more obvious to the eye

Excel functions, such as AVERAGE, that are useful to analyze a group of measurements are called ___________.

statistical functions

In the column chart for third quarter sales for fruit spreads, why would you use the Swith/Row column command?

to change the comparative analysis of the data for example, by month or by the type of product

when presenting financial information in a worksheet , why is it important to apply a double border to a total in a column?

to convey to the reader that the information is complete

A table can be easiy sorted and filtered

why is the table a valuable method of organizing data in a worksheet?

why is the range finder feature useful to verify Excel formuals

workbook cells wincluded in the calculation are visually indicated