Formulas
What formula should be used to average all cells between C2 to C8
=Average(C2:C8)
What is the name of the box where you enter data?
Cell
When was Tarleton State University founded?
September 4, 1899 as John Tarleton College
What is the name of this type of chart?
Scatterplot
What is the current ratio if the current liabilities = $13,284 and current assets = $48,037?
3.616
What does the function SUM do in excel
Adds all the selected numbers together
What is the symbol that must be used in every excel formula?
Equals (=)
What famous U.S. Navy Seal attended Tarleton State University?
What is one of the examples used in class where it is best to use a line graph?
What does the function =DDB() do in excel
Calculates double declining depreciation for an asset
What formula should be used to add all cells between B2 to B12
=SUM(B2:B12)
What is the shortcut to save a workbook?
Ctrl + S
When did Tarleton become a full-fledged Division 1 institution?
July 1, 2024
What type of graph is best for espense categories, machinery inventories, and agribusiness divisions?
Bar graphs
What are the 3 inputs needed to calculate depreciation?
Original cost, salvage value, and useful life
What is a cell reference?
The location of a cell in a worksheet, identified by its column letter and row number
What does Alt + H + O+ I do in excel?
Resizes the width of the selected column to fit the longest word
How many oak trees are on TSU Stephenville campus and what do they represent?
254 oak trees for each county in Texas
How many different types of graphs were covered in class?
7
What is the name of the =SLN() function?
Straight line depreciation function
What does the MAX/MIN functions do in excel?
The find the highest/lowest values on the selected data set
What is the name of a group of selected cells?
Range
What is the official name of the TSU Homecoming Bonfire?
L.V. Risinger Memorial Bonfire
What is the purpose of using graphs and charts?
To create a visualization of data
What is the Equity-to-Asset ratio is assets = $25,763 and equity = $18,475
0.717