question What is the purpose of the Slicer feature in Excel

In Excel, what does the term "Circular Reference" mean?

A. A situation where a formula refers to its own cell
B. Summarizing data using charts
C. Merging cells in a table
D. Filtering data based on specific criteria

Which Excel function is used to find the average of cells that meet multiple criteria?

A. =AVERAGE()
B. =AVERAGEIF()
C. =AVERAGEIFS()
D. -

What is the keyboard shortcut for creating a new workbook in Microsoft Excel?

A. CTRL + N
B. CTRL + W
C. CTRL + A
D. CTRL + S

Which Excel feature is used to create a drop-down list in a cell?

A. Data Validation
B. Data Sorting
C. Data Filtering
D. Data Consolidation

In Excel, what does the term "Workbook Views" refer to?

A. Different ways to display a workbook, such as Normal, Page Layout, and Page Break Preview
B. Viewing multiple workbooks simultaneously
C. Changing the color scheme of the workbook
D. Zooming in and out of the entire workbook

What is the purpose of the "Data Consolidation" feature in Excel?

A. Combine data from multiple ranges into a single range
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

Which function in Excel is used to find the highest value in a range of cells?

A. =MIN()
B. =AVERAGE()
C. =MAX()
D. =SUM()

Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling through a large worksheet?

A. Freeze Panes
B. Split Cells
C. Lock Cells
D. Hide Rows

Which Excel function is used to round a number down to the nearest integer?

A. =ROUNDUP()
B. =ROUNDDOWN()
C. =ROUND()
D. -

In Excel, what does the term "Data Bars" refer to in conditional formatting?

A. Color gradients that represent the values in a range of cells
B. Bars displayed in a chart
C. Cell borders with specified colors
D. Font colors based on specified conditions

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise