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!
=SUM(condition,x,y)
=IF(condition,x,y)
=(condition,x,y)
Rate this question:
=Sum
=Average
=Min
=Max
All of the above
Rate this question:
Plot
Legend
Chart
Rate this question:
Bar
Line
Plot
Pie
Rate this question:
Area
Range
Cell
Active cell
Rate this question:
Key
Map
Legend
Rate this question:
Quotation mark
Closed parenthesis
Comma
Period
Rate this question:
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
Rate this question:
Active
Grouping
Attached
Rate this question:
Tick mark, background
Chart area, plot area
Data axis, value axis
Rate this question:
355
155
255
555
Rate this question:
Embedded chart
Chart sheet
Stand alone chart
Rate this question:
Roll mouse over red triangle
Open comment cell
Must highlight cell
Rate this question:
F1
F2
F3
F4
Rate this question:
Data series, Series labels and Catefory labels
Name box, value labels, name labels
X axis, y axis, z axis
Rate this question:
=If()
=Sum()
=SumIf()
=TrueFalse()
Rate this question:
=SUMIF(range, critera,sum_range)
=SUMIF(range,sum_range,critera)
=SUMIF(sum_range,critera,range)
Rate this question:
Connected, nonconnected
Adjancent,non adjancent
Contiguous, noncontiguous
Rate this question:
Comments
Natural Language Formulas
Arguments
Functions
Rate this question:
Quiz Review Timeline (Updated): Mar 18, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Spreadsheet Formulas And Functions Quiz #3
Spreadsheet Formulas and Functions Quiz #3 assesses knowledge on Excel's formula creation, including the use of Auto Calculate and function wizard. It validates understanding of...
Questions:
15 |
Attempts:
1820 |
Last updated:
Mar 22, 2023
|
Microsoft Excel 2007- Formulas And Function
This Microsoft Excel 2007 quiz assesses understanding of formulas and functions, focusing on common errors like #VALUE! and #REF!, and nuances in function syntax. It enhances...
Questions:
25 |
Attempts:
539 |
Last updated:
Mar 20, 2023
|
MS Excel Workbook And Formulas! Trivia Quiz
Dive into the essentials of MS Excel with this trivia quiz! Explore key concepts like cell addresses, columns, rows, sheet tabs, and built-in functions. Perfect for enhancing your...
Questions:
20 |
Attempts:
361 |
Last updated:
Mar 17, 2023
|
11KAZEN QUIZ - EXCEL MATH FORMULAS
This quiz is a measurement of your knowledge of the software called Excel. Please use the software to answer any of the questions that are on this quiz.
Questions:
7 |
Attempts:
293 |
Last updated:
Mar 22, 2023
|
Excel Formulas And Functions Trivia Quiz
Get ready for this 'excel formulas and functions trivia quiz'. Have you ever worked on a spreadsheet application or MS Excel? Do you know all the functions and formulas?...
Questions:
10 |
Attempts:
15406 |
Last updated:
Feb 07, 2024
|
Microsoft Excel 2007 Quiz: Formulas And Functions!
Microsoft Excel, often called MS Excel, is a spreadsheet application for data processing and financial presentation. Do you know all the functions and formulas of excel? Are you...
Questions:
28 |
Attempts:
1646 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.