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