atp
ntp
gcib
xxxx
xxxx
100
True or False.....To create a minus sign in a formula, use the hyphen key.
What is True
100
The ____ error occurs when the column is not wide enough or a negative date is entered. a. #VALUE! c. #### b. #N/A d. #REF!
What is C?
100
All Excel formulas begin with ____.
What is equal sign
100
Rajit decides to show snapshots of the data for each row in his worksheet. He inserts ____. a. functions c. charts b. sparklines d. graphics
What is B
100
____ formulas perform calculations that you could perform using a scientific calculator.
What is mathematical?
200
True or False.....You can change the order of evaluation by using hyphens.
What is False
200
The ____ error occurs when the wrong type of argument or operand is used. a. #VALUE! c. #### b. #N/A d. #REF!
What is A
200
A(n) ____ cell reference does not change when the formula is copied or moved.
What is absolute?
200
A(n) ____________________ is a graphic representation of your worksheet data.
What is chart
200
____ formulas perform calculations that describe large quantities of data.
What is statistical?
300
True or False...The COUNT and SUM functions are not interchangeable.
What is True
300
The ____ error occurs when the contents of cells referred to by other formulas are deleted. a. #VALUE! c. #### b. #N/A d. #REF!
What is D
300
Two non-adjacent cells are distinguished in a function using a ____. a.comma c.semi-colon b.colon d.hyphen
What is A?
300
Illustrates scientific data, specifically uneven intervals
What is scatter chart?
300
The ____ function multiples values in the specified cells. a. =PRODUCT c.=COUNT b. =SUM d.=MEDIAN
What is A
400
A(n) ____________________ is a symbol that indicates the mathematical operation to perform.
What is operator
400
Using the ____________________ feature, Excel scans the worksheet and identifies the most logical column or row of adjacent cells containing numbers to add.
What is autosum
400
Tyler tells Eleni that ____ is an absolute cell reference. a. A1 c. A$1 b. $A1 d. $A$1
What is D
400
Compares the sizes of portions as they relate to a whole unit
What is Pie Chart?
400
The ____ is a value, cell reference, range, or text used in a function.
What is argument?
500
Formulas containing more than one operator are called ____________________ formulas.
What is complex
500
Illustrates trends in data at equal intervals
What is Line Chart?
500
The ____________________ reference enables you to access data from multiple worksheets.
What is 3D
500
Effective for emphasizing trends
What is are chart?
500
Tyler tells Eleni that the * (asterisk) character is used to represent ____.
What is multiplication?
M
e
n
u