Have you ever worked on spreadsheet application or MS Excel? Do you know all the functions and formulas? If yes, then take this quiz to test where do you stand and learn new formulas and functions used in excel. Microsoft Excel is a spreadsheet software which is used for data processing and financial presentation. To become an expert one needs to learn the formulas and functions. So, let's try out the quiz. All the best!
=B2+C3
=C3+B3
=6+4
=B+C
Data
Finances
Numbers
All of the above
=SUM(A1:A5)
Add A1 - A5
Subtract the numbers from A1 to A5
A1 = A5
To add all the data together using addition only
To tell the person viewing that this is a function and it should be added together
To calculate all the data correctly without any mistakes
To inform the computer that an arithmetic function will occur
Piece of graph paper
Single page in a workbook
Excel file
All of the above
Group
Range
Reference
Package
Formularizing
Prefixing
Cell referencing
Cell mathematics
+
=
%
#
Normal view
Page layout view
Page break preview
Header/Footer
=IF(condition, condition if false, condition if true)
=IF(condition, condition if true, condition if false)
=IF(condition:condition if true:condition if false)