Test Your Knowledge About Microsoft Excel Formulas!
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!
Questions and Answers
- 1.
A function must always start with
- A.
=sumif
- B.
=sum
- C.
=
- D.
=sumif(
Correct Answer
C. = -
- 2.
Common Functions that we use most often are
- A.
=Sum
- B.
=Average
- C.
=Min
- D.
=Max
- E.
All of the above
Correct Answer
E. All of the aboveExplanation
The correct answer is "All of the above" because all the mentioned functions (Sum, Average, Min, Max) are commonly used functions in various data analysis tasks. The Sum function is used to calculate the total sum of a set of numbers, the Average function is used to find the arithmetic mean of a set of numbers, the Min function is used to find the smallest value in a set of numbers, and the Max function is used to find the largest value in a set of numbers. Therefore, all these functions are frequently used and essential in data analysis.Rate this question:
-
- 3.
Excel aloows you to create ____________________________ that refer to column and row labels in place of the cell reference or range.
- A.
Comments
- B.
Natural Language Formulas
- C.
Arguments
- D.
Functions
Correct Answer
B. Natural Language FormulasExplanation
Excel allows you to create natural language formulas that refer to column and row labels in place of the cell reference or range. This means that instead of using traditional cell references like A1 or B2, you can use descriptive labels such as "Sales" or "Expenses" to make your formulas easier to understand and maintain. This feature helps improve the readability and clarity of your formulas, making it easier for others to understand and work with your Excel spreadsheets.Rate this question:
-
- 4.
A block of cells in an Excel worksheet
- A.
Area
- B.
Range
- C.
Cell
- D.
Active cell
Correct Answer
B. RangeExplanation
The term "Range" refers to a block of cells in an Excel worksheet. It represents a group of cells that can be selected and manipulated as a whole. A range can be as small as a single cell or as large as the entire worksheet. It allows users to perform operations on multiple cells simultaneously, such as formatting, entering data, or applying formulas.Rate this question:
-
- 5.
A range of cells can be __________________or ____________________.
- A.
Connected, nonconnected
- B.
Adjancent,non adjancent
- C.
Contiguous, noncontiguous
Correct Answer
C. Contiguous, noncontiguousExplanation
A range of cells can be contiguous or noncontiguous. Contiguous means that the cells are adjacent and form a continuous block, while noncontiguous means that the cells are not adjacent and are scattered across the sheet. Contiguous ranges are useful for performing operations or formatting on a specific block of cells, while noncontiguous ranges are useful for selecting and manipulating multiple separate blocks of cells.Rate this question:
-
- 6.
Worksheets that are selected as a unit; any action performed on this uit will affect all the worksheets in the group.
- A.
Active
- B.
Grouping
- C.
Attached
Correct Answer
B. GroupingExplanation
Grouping refers to the process of selecting multiple worksheets as a unit. When worksheets are grouped, any action performed on one worksheet will be applied to all the worksheets in the group. This allows for efficient and consistent editing or formatting across multiple worksheets simultaneously.Rate this question:
-
- 7.
A Range name may use up to ________ characters.
- A.
355
- B.
155
- C.
255
- D.
555
Correct Answer
C. 255Explanation
A range name may use up to 255 characters. This means that when assigning a name to a range in a spreadsheet or database, the name can consist of up to 255 characters. This allows for more descriptive and meaningful names to be used for ranges, making it easier for users to understand and work with the data.Rate this question:
-
- 8.
The format for an IF statement is:
- A.
=SUM(condition,x,y)
- B.
=IF(condition,x,y)
- C.
=(condition,x,y)
Correct Answer
B. =IF(condition,x,y)Explanation
The correct answer is "=IF(condition,x,y)". This is the correct format for an IF statement in various programming languages and spreadsheet software. The IF statement allows for conditional execution of code or formulas based on a specified condition. The condition is evaluated, and if it is true, the value of x is returned; otherwise, the value of y is returned. This allows for branching logic and decision-making within a program or spreadsheet.Rate this question:
-
- 9.
Correct format for a SUMIF statement is
- A.
=SUMIF(range, critera,sum_range)
- B.
=SUMIF(range,sum_range,critera)
- C.
=SUMIF(sum_range,critera,range)
Correct Answer
A. =SUMIF(range, critera,sum_range)Explanation
The correct format for a SUMIF statement is =SUMIF(range, critera,sum_range). This format specifies the range of cells to be evaluated, the criteria that the cells must meet, and the range of cells to be summed if the criteria are met.Rate this question:
-
- 10.
A graphic that allows you to compare and contrast data in a visual format.
- A.
Plot
- B.
Legend
- C.
Chart
Correct Answer
C. ChartExplanation
A chart is a visual representation that allows you to compare and contrast data. It presents information in a graphical format, making it easier to understand patterns, trends, and relationships between different data points. Charts can include various types such as bar charts, line charts, pie charts, etc. They are commonly used in presentations, reports, and data analysis to provide a clear and concise way of conveying information.Rate this question:
-
- 11.
All charts use axes except
- A.
Bar
- B.
Line
- C.
Plot
- D.
Pie
Correct Answer
D. PieExplanation
All charts typically use axes to represent the different variables being plotted. However, a pie chart does not use axes. Instead, it uses a circular shape to represent the different categories or proportions being compared. The different sections of the pie chart are labeled with the corresponding categories or values, making it easy to visualize the distribution or composition of the data. Therefore, the correct answer is pie.Rate this question:
-
- 12.
A chart actually has two backfrounds: the larger _______ _______ and the smaller ______ ______ which can be formmatted.
- A.
Tick mark, background
- B.
Chart area, plot area
- C.
Data axis, value axis
Correct Answer
B. Chart area, plot areaExplanation
A chart actually has two backgrounds: the larger chart area and the smaller plot area which can be formatted. The chart area refers to the entire area of the chart including the plot area, axis labels, and titles. The plot area, on the other hand, is the specific area within the chart where the data points and series are plotted. Both the chart area and plot area can be customized and formatted to enhance the visual appearance of the chart.Rate this question:
-
- 13.
A chart that occupies its own worksheet
- A.
Embedded chart
- B.
Chart sheet
- C.
Stand alone chart
Correct Answer
B. Chart sheetExplanation
A chart sheet refers to a type of chart that occupies its own worksheet. Unlike an embedded chart, which is inserted within a worksheet, a chart sheet is a separate sheet dedicated solely to displaying the chart. Similarly, a stand-alone chart also implies that the chart is not embedded within a worksheet but exists on its own. Therefore, the correct answer for this question is chart sheet.Rate this question:
-
- 14.
A key that identifies each of the data series in a chart.
- A.
Key
- B.
Map
- C.
Legend
Correct Answer
C. LegendExplanation
A legend is a key that identifies each of the data series in a chart. It provides a visual representation of the different elements or categories in the chart, making it easier for viewers to understand and interpret the information being presented. The legend typically includes labels or symbols that correspond to the different data series or categories, allowing viewers to easily associate them with specific elements in the chart.Rate this question:
-
- 15.
Name the three parts that are typically found in a chart.
- A.
Data series, Series labels and Catefory labels
- B.
Name box, value labels, name labels
- C.
X axis, y axis, z axis
Correct Answer
A. Data series, Series labels and Catefory labelsExplanation
In a chart, the three typical parts are data series, series labels, and category labels. Data series refers to the set of data points that are plotted on the chart. Series labels are used to identify and label each data series on the chart. Category labels, on the other hand, represent the categories or groups to which the data points belong. These labels help provide context and understanding to the chart data.Rate this question:
-
- 16.
A ______________ends the argument.
- A.
Quotation mark
- B.
Closed parenthesis
- C.
Comma
- D.
Period
Correct Answer
B. Closed parenthesisExplanation
A closed parenthesis is used to indicate the end of a group or sub-group within a sentence. It is commonly used in writing to enclose additional information or clarify a specific point. In the context of the question, a closed parenthesis would signal the end of an argument or statement, indicating that no further information or points will be added.Rate this question:
-
- 17.
Name three rules for naming ranges
- A.
Spaces are allowed, can start with a range name, Y2008
- B.
Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes
- C.
Must make sense, can start with a number, spaces are allowed
Correct Answer
B. Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashesExplanation
The correct answer states that spaces are not allowed, range names should not start with range names themselves, and range names may include letters, numbers, underscores, and backslashes. This means that when naming ranges in Excel, spaces should be avoided, range names should not be duplicates of existing range names, and a combination of letters, numbers, underscores, and backslashes can be used in the name.Rate this question:
-
- 18.
To display a comment in a worksheet
- A.
Roll mouse over red triangle
- B.
Open comment cell
- C.
Must highlight cell
Correct Answer
A. Roll mouse over red triangleExplanation
To display a comment in a worksheet, you need to roll the mouse over the red triangle. This action will trigger the display of the comment associated with that specific cell.Rate this question:
-
- 19.
What key should be used to change the content of a cell?
- A.
F1
- B.
F2
- C.
F3
- D.
F4
Correct Answer
B. F2Explanation
The F2 key should be used to change the content of a cell in a spreadsheet. Pressing F2 allows the user to enter the edit mode for the selected cell, where they can modify the existing content or enter new data. This key is commonly used in spreadsheet software like Microsoft Excel to quickly edit cell contents without the need for mouse clicks or menu options.Rate this question:
-
- 20.
What function offers you the possibility to view different results depending on the entered condition?
- A.
=If()
- B.
=Sum()
- C.
=SumIf()
- D.
=TrueFalse()
Correct Answer
A. =If()Explanation
The correct answer is =If(). The If() function allows you to view different results based on a given condition. It evaluates a condition and returns one value if the condition is true, and another value if the condition is false. This function is commonly used in programming and spreadsheet applications to perform conditional operations and make decisions based on certain criteria.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 18, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 24, 2008Quiz Created by
Ljnickleson
Back to top