.
=sumif
=sum
=
=sumif(
=Sum
=Average
=Min
=Max
All of the above
Comments
Natural Language Formulas
Arguments
Functions
Green triangle, note
Red triangle, comment
Green triangle, comment
Red triangle, note
Area
Range
Cell
Active cell
Connected, nonconnected
Adjancent,non adjancent
Contiguous, noncontiguous
Active
Grouping
Attached
355
155
255
555
=SUM(condition,x,y)
=IF(condition,x,y)
=(condition,x,y)
=SUMIF(range, critera,sum_range)
=SUMIF(range,sum_range,critera)
=SUMIF(sum_range,critera,range)
Plot
Legend
Chart
Chart sheets
Embedded chart
Categories
Bar
Line
Plot
Pie
Tick mark, background
Chart area, plot area
Data axis, value axis
Embedded chart
Chart sheet
Stand alone chart
Key
Map
Legend
Data series, Series labels and Catefory labels
Name box, value labels, name labels
X axis, y axis, z axis
Delete table
I D K
Ask my buddy
Quotation mark
Closed parenthesis
Comma
Period
Spaces are allowed, can start with a range name, Y2008.
Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes.
Must make sense, can start with a number, spaces are allowed.
Roll mouse over red triangle
Open comment cell
Must highlight cell
NO
YES
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.