FUNCTIONS
This function grabs the current date and time.
What is the TODAY() function?
Every formula and function always starts with this.
What is an equal sign?
Absolute References are marked with this.
What is a $?
A pie slice is a data marker that represents how many value(s) from a data series?
What is one?
If you don't want to widen your column just to show the column headers you could do this?
What is Wrap Text?
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
What is nested?
PEMDAS stands for this.
What is Parenthesis, Exponents, Multiplication, Division, Addition and Subtraction
What keyboard shortcut will bring you to cell A1?
What is CTRL+Home?
This type of chart allows you have two chart types in one chart.
What is a combo chart?
If you want to center text across a range you should use this.
What is Merge and Center?
In the following function PMT(rate, nper, pv [, fv=0] [, type=0]) - What does nper represent?
What is total number of payment periods?
In order to see the function or formula behind a result in a cell you need to look here.
What is the formula bar?
$A1 is this type of reference.
What is mixed reference?
If you want to format only one point in a line chart what do you need to do?
What is double click that point?
If you only want to print C1:D50 you would need to do this.
What is set print area?
This function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
What is the COUNT function?
Enters texts based on patterns it finds in the data.
What is Flash Fill?
What is $B$7?
The ____ identifies which data markers are associated with each data series.
What is the legend?
This code will display the filename of the current workbook.
What is &[File]
In the following formula: =IF(A1<100, "Order", "Don't Order"), what happens if A1= 250?
What is the formula will return "Don't Order".
The little box in the lower right corner of a cell that copies the content and format is called this.
What is the fill handle?
If the following formula is in cell X2: = A1*E$1-$C1 and is then copied to cell Y4, what would it become:
A ________ contains the actual values that are plotted on the chart.
What is the data series?
As a general rule how should text, numbers and titles each be aligned?
Text - Left aligned
Numbers - Right aligned
Titles - Centered