Microsoft Excel is a spreadsheet software which was developed by Microsoft. To become an expert one needs to master the basic formulas and functions used in the excel spreadsheet. MS Excel is mostly used for data processing, financial modelling and presentation. Take this quiz to test your knowledge and learn new formulas and functions used in excel. So, let's try out the quiz. Good Luck!
=sumif
=sum
=
=sumif(
=Sum
=Average
=Min
=Max
All of the above
Comments
Natural Language Formulas
Arguments
Functions
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
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
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
F1
F2
F3
F4
=If()
=Sum()
=SumIf()
=TrueFalse()