How many charts or graphs are commonly used in Excel
What is 6
100
returns the current date
What is the NOW function
200
means to put things in chronological order
What is sorting
200
The formula that returns the current date?
What is =Now
200
calculates difference in days between two dates
What is the Days360 function
200
object that explains the symbols, colors or patterns used to differentiate the data
What is a legend
200
used for two column vectors
What is LookUp function
300
spreadsheets perform ___ and ___
What is functions and calculations
300
A Days360 formula requires what three components?
What is start date, end date, method
300
used when there are more than two columns in the array
What is the VLookup function
300
shows trends or changes in data over time
What is a line chart
300
used to assist in organizing spreadsheet information
What is List
400
logical test, value if true and value if false
What is an IF statement
400
Components required to correctly write a VLookup formula
What is value, table array, column index number
400
there are two types of formatting for date
What is long and short
400
The components that make up a Graph
What is y-axis, x-axis, data markers, data series, grid lines, plot area and tick marks
400
the required components for an IF function
What is the logical test, value if true, value if false
500
Daily double: Name the different count functions and their use
What is Count, CountA, CountIF
500
Write a function to find the average in cells A1 through G1
What is =AVG(A1:G1)
500
the required components to write a DAYS360 function
What is the start date, end date, and method
500
list all of the components to correctly identify a chart
What is 11 components
500
I am running my own cola business and need to write an if statement to correctly display when I need to reorder inventory or not. My reorder point for cola is 10.