Microsoft Excel
MCQS
A. CTRL + N
B. CTRL + W
C. CTRL + A
D. CTRL + S
CTRL + N is used to create a new workbook in Microsoft Excel.
A. =SUM()
B. =AVERAGE()
C. =COUNT()
D. =MAX()
The SUM function in Excel is used to add up the values in a range of cells.
A. Freeze Panes
B. Split Cells
C. Lock Cells
D. Hide Rows
The "Freeze Panes" feature in Excel allows you to freeze rows and columns for easier navigation in large worksheets.
A. The address of a cell, such as A1 or B2
B. The content of a cell
C. A reference to an external workbook
D. The width and height of a cell
Cell Reference in Excel refers to the address of a cell, such as A1 or B2.
A. =MIN()
B. =AVERAGE()
C. =MAX()
D. =SUM()
The MAX function in Excel is used to find the highest value in a range of cells.
A. Combine selected cells into one and center the content
B. Change cell colors
C. Split cells into individual cells
D. Create a table with merged cells
"Merge & Center" in Excel combines selected cells into one and centers the content.
A. Rounds the value in cell A1 to 2 decimal places
B. Adds the values in cell A1 and 2
C. Finds the square root of the value in cell A1
D. Multiplies the value in cell A1 by 2
The ROUND function in Excel rounds the value in cell A1 to 2 decimal places.
A. Data Sorting
B. Data Validation
C. Data Filtering
D. Data Consolidation
The "Data Filtering" feature in Excel is used to filter data based on specific criteria.
A. Search for a value in the first column of a table and return a value in the same row from another column
B. Sum a range of cells
C. Count the number of cells in a range
D. Find the average of a range of cells
No Explanation
A. Data Validation
B. Data Sorting
C. Data Charts
D. Data Filtering
The "Data Charts" feature in Excel is used to create a visual representation of data using bars, lines, or pie slices.
A. Perform conditional logic based on a specified condition
B. Add values in a range of cells
C. Find the average of a range of cells
D. Count the number of cells in a range
No Explanation
A. A collection of worksheets
B. A single sheet within a workbook
C. A formula used for calculations
D. The entire Excel application
In Excel, a "Workbook" refers to a collection of worksheets.
A. =SUM()
B. =AVERAGE()
C. =COUNT()
D. =MAX()
The AVERAGE function in Excel is used to find the average of a range of cells.
A. Summarize and analyze data from a range of cells
B. Merge cells in a table
C. Create a table with dynamic data
D. Filter data based on specific criteria
No Explanation
A. A group of adjacent cells
B. The address of a cell, such as A1 or B2
C. The content of a cell
D. A reference to an external workbook
In Excel, a "Cell Range" refers to a group of adjacent cells.
A. Return a specified value if a formula results in an error
B. Sum a range of cells
C. Count the number of cells in a range
D. Find the highest value in a range
No Explanation
A. Format Painter
B. Cell Styling
C. Format Copier
D. Style Duplicator
The "Format Painter" feature in Excel is used to copy the formatting of one cell and apply it to another.
A. Counts the number of non-empty cells in the range A1:A10
B. Adds the values in the range A1:A10
C. Finds the average of the range A1:A10
D. Rounds the value in cell A1 to the nearest whole number
No Explanation
A. Control the type of data entered into a cell
B. Summarize data using charts
C. Filter data based on specific criteria
D. Merge cells in a table
No Explanation
A. =CONCATENATE()
B. -
C. -
D. -
The CONCATENATE function in Excel is used to combine two or more text strings.
A. Switch the rows and columns of a range of cells
B. Merge cells in a table
C. Summarize data using charts
D. Filter data based on specific criteria
No Explanation
A. The bar displaying the current cell address and content
B. The bar showing the sum of selected cells
C. A bar for entering only mathematical formulas
D. The bar displaying formatting options
No Explanation
A. Find the value needed to reach a desired result in a formula
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. -
B. =SQRT()
C. -
D. -
The SQRT function in Excel is used to find the square root of a number.
A. Formatting cells based on specific conditions
B. Formatting cells with random styles
C. Applying formatting to an entire worksheet
D. Formatting cells with a fixed style
No Explanation
A. Rounds the value in cell A1 up to the nearest whole number
B. Rounds the value in cell A1 down to the nearest whole number
C. Adds the values in cell A1 and 0
D. Finds the square root of the value in cell A1
No Explanation
A. Show the cells that are referred to in a formula
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. =AVERAGEIF()
B. =AVERAGEIFS()
C. -
D. -
The AVERAGETOPN function in Excel is used to find the average of the top N values in a range.
A. Restricting access to certain worksheets or workbook elements
B. Protecting cells from being formatted
C. Creating a backup copy of the workbook
D. Locking the entire workbook from editing
No Explanation
A. AutoFit Column
B. Auto Column Width
C. Resize Column
D. Adjust Content Width
The "AutoFit Column" feature in Excel is used to automatically adjust the width of a column based on its content.
A. A group of related data points
B. The data displayed on the horizontal axis
C. The legend of the chart
D. The title of the chart
No Explanation
A. Assigning a name to a specific range of cells
B. Changing the name of the entire worksheet
C. Sorting cells based on alphabetical order
D. Creating a table with named cells
No Explanation
A. =MIN()
B. =AVERAGE()
C. =COUNT()
D. =MAX()
The MIN function in Excel is used to find the smallest value in a range of cells.
A. Find optimal solutions to complex problems by adjusting variables
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
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
No Explanation
A. =COUNTIF()
B. =SUMIF()
C. =AVERAGEIF()
D. -
The COUNTIF function in Excel is used to count the number of cells that meet a specific condition.
A. Controlling the type of data entered into a cell
B. Summarizing data using charts
C. Filtering data based on specific criteria
D. Merging cells in a table
No Explanation
A. Returns "Yes" if the value in A1 is greater than 10; otherwise, returns "No"
B. Adds the values in A1 and 10
C. Finds the square root of the value in A1
D. Multiplies the value in A1 by 10
No Explanation
A. Monitor the values of specific cells while working with other parts of the workbook
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. =LEN()
B. =COUNT()
C. =CHAR()
D. =TEXT()
The LEN function in Excel is used to find the number of characters in a text string.
A. Cell reference that does not change when copied to another cell
B. The content of a cell
C. A reference to an external workbook
D. The address of a cell, such as A1 or B2
No Explanation
A. Adjusting the formatting of selected cells, including number format, font, and alignment
B. Merging cells in a table
C. Summarizing data using charts
D. Changing the color scheme of the entire workbook
No Explanation
A. Worksheet Security
B. Workbook Lock
C. Excel Security
D. Password Protect
No Explanation
A. A structured range of data that can be easily filtered, sorted, and analyzed
B. Summarizing data using charts
C. Merging cells in a table
D. Filtering data based on specific criteria
No Explanation
A. Formats the date in cell A1 to display as "mm/dd/yyyy"
B. Adds the values in A1 and the date "mm/dd/yyyy"
C. Finds the square root of the date in A1
D. Multiplies the date in A1 by "mm/dd/yyyy"
No Explanation
A. -
B. =SEARCH()
C. =FIND()
D. -
The SEARCH function in Excel is used to find the position of a specific character within a text string.
A. Creating links between different workbooks
B. Summarizing data using charts
C. Merging cells in a table
D. Filtering data based on specific criteria
No Explanation
A. Create and manage different scenarios for what-if analysis
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filtering data based on specific criteria
No Explanation
A. Arranging data in a specific order, such as ascending or descending
B. Summarizing data using charts
C. Merging cells in a table
D. Filtering data based on specific criteria
No Explanation
A. =IRR()
B. =NPV()
C. -
D. =RATE()
The IRR function in Excel is used to calculate the internal rate of return for a series of cash flows.
A. Quickly fill cells with a series or copy cell contents
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Adjusting column widths
No Explanation
A. Adds values in the range A1:A10 based on multiple criteria in columns B and C
B. Counts the number of cells in the range A1:A10 based on a single criterion
C. Finds the average of values in the range A1:A10
D. Multiplies values in the range A1:A10 based on multiple criteria in columns B and C
No Explanation
A. Data Validation
B. Data Sorting
C. Data Filtering
D. Data Consolidation
No Explanation
A. Automatically fill cells based on patterns recognized by Excel
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria
No Explanation
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
No Explanation
A. 45296.041864
B. 45296
C. =DATE()
D. =TIME()
The NOW function in Excel is used to return the current date and time.
A. Provides quick access to various formatting and data analysis options
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria
No Explanation
A. Calculates the sum of values in the range A1:A10, excluding hidden rows
B. Counts the number of visible cells in the range A1:A10
C. Finds the average of visible cells in the range A1:A10
D. Multiplies visible cells in the range A1:A10
No Explanation
A. =MATCH()
B. =INDEX()
C. =SEARCH()
D. =LOOKUP()
The MATCH function in Excel is used to find the position of a specific item within a range.
A. Group and organize data by creating an outline structure
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria
No Explanation
A. A group of related data points
B. The data displayed on the horizontal axis
C. The legend of the chart
D. The title of the chart
No Explanation
A. Splitting text into separate columns based on a delimiter
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria
No Explanation
A. =RANK()
B. =SORT()
C. =INDEX()
D. -
The RANK function in Excel is used to find the rank of a value within a range.
A. Identify and correct errors in formulas
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria
No Explanation
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
No Explanation
A. =ROUNDUP()
B. =ROUNDDOWN()
C. =ROUND()
D. -
The ROUNDDOWN function in Excel is used to round a number down to the nearest integer.
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
No Explanation
A. =CUMIPMT()
B. =CUMPRINC()
C. -
D. =IPMT()
The CUMIPMT function in Excel is used to calculate the cumulative interest paid on a loan between two periods.
A. Visualize the values in a range with colored bars in each cell
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria
No Explanation
A. Validate data entered into a cell based on specified criteria
B. Sum a range of cells
C. Filter data based on specific criteria
D. Merge cells in a table
The "Data Validation" feature in Excel allows you to validate data entered into a cell based on specified criteria.
A. Monitor the values in specific cells while working in a different part of the worksheet
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
The "Watch Window" feature in Excel allows you to monitor the values in specific cells while working in a different part of the worksheet.
A. Returns the value in the third cell of the range A1:A10
B. Adds the values in the range A1:A10
C. Finds the average of the range A1:A10
D. Rounds the value in cell A1 to the nearest whole number
No Explanation
A. -
B. =SEARCH()
C. =FIND()
D. =MATCH()
The MATCH function in Excel is used to find the position of an item in a range.
A. Create and compare different sets of input values to see the resulting outcomes
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. =COUNT()
B. =COUNTIF()
C. =COUNTIFS()
D. =COUNTA()
The COUNTIFS function in Excel is used to count the number of cells that meet multiple criteria.
A. Sets of formatting options applied to an entire workbook
B. Styles applied to individual cells
C. A collection of worksheet templates
D. The color scheme of the Excel application
No Explanation
A. Returns the value in cell A1 of Sheet1
B. Adds the values in the range A1:A10 on Sheet1
C. Finds the average of the range A1:A10 on Sheet1
D. Rounds the value in cell A1 on Sheet1 to the nearest whole number
No Explanation
A. Group and organize rows or columns with a hierarchical structure
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. =RANK()
B. =SORT()
C. -
D. -
The RANK function in Excel is used to find the rank of a number in a list.
A. A formula that performs multiple calculations on one or more items in an array
B. A formula that only works with arrays of numbers
C. A formula that returns an array of values
D. A formula that uses the ARRAY keyword
No Explanation
A. Calculate subtotals for a range of data, grouping by specified criteria
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. Returns the full month name from the date in cell A1
B. Adds the values in the range A1:A10
C. Finds the average of the range A1:A10
D. Rounds the value in cell A1 to the nearest whole number
No Explanation
A. Combine multiple tables into a single table for analysis
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. =NPV()
B. -
C. =IRR()
D. =PV()
The IRR function in Excel is used to calculate the internal rate of return (IRR) of an investment.
A. Import, transform, and combine data from various sources
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
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
No Explanation
A. Identify and correct errors in formulas or functions
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. =AVERAGE()
B. =AVERAGEIF()
C. =AVERAGEIFS()
D. -
The AVERAGEIFS function in Excel is used to find the average of cells that meet multiple criteria.
A. Combining data from multiple ranges into a single range
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. Filter PivotTable or PivotChart data by specific date ranges
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. -
B. =NPV()
C. =IRR()
D. =PV()
The NPV function in Excel is used to calculate the net present value (NPV) of an investment.
A. Filter PivotTable or PivotChart data visually
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. Converts the angle in cell A1 from degrees to radians
B. Adds the values in the range A1:A10
C. Finds the average of the range A1:A10
D. Rounds the value in cell A1 to the nearest whole number
No Explanation
A. Allows only whole numbers to be entered in a cell
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. -
B. =NPV()
C. =IRR()
D. =PV()
The PV function in Excel is used to calculate the present value (PV) of an investment.
A. Retrieve data from a PivotTable based on specific criteria
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. An Excel add-in for data transformation and analysis
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. Automatically fills in values based on patterns it recognizes
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation
A. -
B. =NPV()
C. =IRR()
D. =FV()
The FV function in Excel is used to calculate the future value (FV) of an investment.
A. Provides a quick analysis of selected data with various formatting and visualization options
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria
No Explanation