Terms
Formulas
Functions
Miscellaneous
Charts
100
Within the workbook is where you'll find?
You will find the WORKSHEET
100
All Formulas begin with this?
an = sign
100
What are the 5 autosum functions?
=Sum
=Average
=Countnumbers
=Max
=Min
100
What is excel?
Spreadsheet program
100
What is at the top of the chart?
The chart title
200
When two or more cells are combined
Merged cells
200
This formula allows you to insert today's date?
=TODAY
200
Why do spreadsheet wizards have their screens on the ceiling?
Lookups
200
According to Liams Excel class what is the answer to everything?
EGG
200
What are 2 chart elements?
Axes, Axis titles, chart title, data label, data table, error bars, gridlines, legend, treadlines, up/down bars.
300
This enables you to effortlessly copy data to more than one cell?
Autofill
300
This formula allows for you to find the average in a range of cells
=AVERAGE
300
what was the hardest function in Liams class that he used in every exam.
Nested If Ands
300
How can you select the whole table without dragging and clicking?
you push the little triangle to the left of A1
300
What kind of charts can you use?
Columns, Lines, Pie (not apple), Bar, Area, Scatter, Stock, Surface, Radar, Treemap, Sunburst, Histogram, Box & Whisker, Waterfall, and Combo.....and Pivot
400

this allows you to select specific columns and/or rows to remain visible on the worksheet, even if you are scrolling, such as header cells that label a column.

freeze panes

400
This formula can figure out the payments left on a loan
=PMT
400
This function adds all numbers in a range, that has one or more criteria
SUMIFS
400
A cat goes to prison and starts a gang with 8 other cats. What was the name of the gang?
Con Cat and 8
400
What is a pivot chart?
A pivot chart is a chart that is made to show a pivot table.
500
Something we frequently seen when we didn't type in the formulas correctly?
An error message
500

Why does this function returns the cosine of angle given in radians

=COS
500
A function that can perform a logical test and return one value for true, and one for false.
An If function
500
What is the answer to everything? According to our class.
vlookup
500
Which excel function is most popular with alcoholics?
Bar charts
M
e
n
u