_______ is used as shortcut key to save an Excel workbook?

1. A) Ctrl + S       ms excel mcqs     ms excel mcqs
2. B) Ctrl + C
3. C) Ctrl + V
4. D) Ctrl + P

Correct Answer: A) Ctrl + S

Which function is used to sum a range of cells in Excel?

1. A) AVG()                   ms excel mcqs     ms excel mcqs
2. B) MAX()
3. C) SUM()
4. D) COUNT()

Correct Answer: C) SUM()

Which feature in Excel is used to apply a consistent format to a range of cells?

1. A) AutoFill
2. B) Merge Cells
3. C) Conditional Formatting
4. D) Format Painter

Correct Answer: D) Format Painter

What does the function VLOOKUP do in Excel?

1. A) Counts the number of cells in a range that meet a certain condition
2. B) Looks up a value in the first column of a range and returns a value in the same row from a specified column
3. C) Finds the highest value in a range
4. D) Calculates the average of a range of cells

Correct Answer: B) Looks up a value in the first column of a range and returns a value in the same row from a specified column

Which chart type is suitable for comparing values over categories and showing trends over time?

1. A) Pie Chart
2. B) Bar Chart
3. C) Line Chart
4. D) Scatter Plot

Correct Answer: C) Line Chart

Which keyboard shortcut is used to select the entire column in Excel?

1. A) Ctrl + A
2. B) Ctrl + C
3. C) Ctrl + X
4. D) Ctrl + Spacebar

Correct Answer: D) Ctrl + Spacebar

_______ is used as default file extension for Excel workbooks?

1. A) .xls                           ms excel mcqs     ms excel mcqs
2. B) .xlsx
3. C) .xlsm
4. D) .exe

Correct Answer: B) .xlsx

_______  is used to count the number of cells that contain numbers within a range in Ms Excel?

1. A) COUNT()
2. B) AVERAGE()
3. C) MAX()
4. D) MIN()

Correct Answer: A) COUNT()

What does the function IFERROR do in Excel?

1. A) Returns a specified value if a formula evaluates to an error; otherwise, returns the result of the formula
2. B) Calculates the sum of values in a range that meet a certain condition
3. C) Checks whether a condition is met and returns one value if true and another value if false
4. D) Sorts a range of cells based on specified criteria

Correct Answer: A) Returns a specified value if a formula evaluates to an error; otherwise, returns the result of the formula

Which keyboard shortcut is used to insert a new worksheet in Excel?

1. A) Ctrl + N
2. B) Ctrl + W
3. C) Ctrl + Shift + N
4. D) Ctrl + Shift + W

Correct Answer: C) Ctrl + Shift + N

Which Excel feature is used to filter data based on specific criteria?

1. A) Data Validation
2. B) PivotTables
3. C) AutoFilter
4. D) VLOOKUP

Correct Answer: C) AutoFilter

What does the function MAX do in Excel?

1. A) Finds the smallest value in a range of cells
2. B) Calculates the sum of values in a range that meet a certain condition
3. C) Finds the highest value in a range of cells
4. D) Returns the number of characters in a text string

Correct Answer: C) Finds the highest value in a range of cells

Which chart type in Excel is best suited for comparing individual values across categories?

1. A) Line Chart
2. B) Bar Chart
3. C) Pie Chart
4. D) Scatter Plot

Correct Answer: B) Bar Chart

Which Excel feature is used to protect a worksheet from being modified by other users?

1. A) Freeze Panes
2. B) Data Validation
3. C) Password Protection
4. D) Track Changes

Correct Answer: C) Password Protection

What is the purpose of the AutoFill feature in Excel?

1. A) Automatically corrects spelling errors in a worksheet
2. B) Automatically fills cells with data based on a pattern or series
3. C) Automatically formats cells based on their contents
4. D) Automatically calculates formulas in a worksheet

Correct Answer: B) Automatically fills cells with data based on a pattern or series

_______   is shortcut  to open the Format Cells dialog box in MS Excel?

1. A) Ctrl + F
2. B) Ctrl + 1
3. C) Ctrl + Shift + F
4. D) Ctrl + Alt + F

Correct Answer: B) Ctrl + 1

Which Excel feature is used to group and summarize large amounts of data?

1. A) Goal Seek
2. B) Scenario Manager
3. C) PivotTables
4. D) Solver

Which Excel feature is used to display two different sets of data in a single chart?

1. A) Data Tables
2. B) Sparklines
3. C) Combo Charts
4. D) Goal Seek

Correct Answer: C) Combo Charts

What does the function TRIM do in Excel?

1. A) Removes all formatting from a range of cells
2. B) Rounds a number to a specified number of decimal places
3. C) Removes leading and trailing spaces from text
4. D) Converts a value from one unit of measurement to another

Correct Answer: C) Removes leading and trailing spaces from text

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

1. A) MAX()                 ms excel mcqs     ms excel mcqs
2. B) MIN()                   ms excel mcqs     ms excel mcqs
3. C) AVERAGE()
4. D) COUNT()

Correct Answer: C) AVERAGE()

What is the purpose of the Freeze Panes feature in Excel?

1. A) Locks specific rows or columns in place so they remain visible when scrolling
2. B) Removes all formatting from a range of cells
3. C) Collect data from two or more cells into one cell
4. D) Automatically fills cells with data based on a pattern or series

Correct Answer: A) Locks specific rows or columns in place so they remain visible when scrolling

Which keyboard shortcut is used to copy cell contents in Excel?

1. A) Ctrl + C
2. B) Ctrl + V
3. C) Ctrl + X               ms excel mcqs     ms excel mcqs
4. D) Ctrl + Z               ms excel mcqs     ms excel mcqs

Correct Answer: A) Ctrl + C

What does the function ROUND do in Excel?

1. A) A number is rounded upto nearest interger
2. B) Rounds a number to a specified number of decimal places
3. C) Checks whether a condition is met and returns one value if true and another value if false
4. D) Finds the maximum value in a range of cells

Correct Answer: B) Rounds a number to a specified number of decimal places

Which Excel feature is used to automatically adjust the width of a column to fit its contents?

1. A) Merge Cells
2. B) AutoFit Column Width
3. C) Wrap Text
4. D) Format Painter

Correct Answer: B) AutoFit Column Width

What is the purpose of the Goal Seek feature in Excel?

1. A) Finds the highest value in a range of cells
2. B) Calculates the present value of an investment
3. C) Automatically fills cells with data based on a pattern or series
4. D) Determines the input value needed to achieve a desired result in a formula

Correct Answer: D) Determines the input value needed to achieve a desired result in a formula

Which Excel feature is used to visualize trends and relationships between two sets of data?

1. A) Data Tables
2. B) Sparklines
3. C) Scenario Manager
4. D) Solver

Correct Answer: B) Sparklines

What does the function UPPER do in Excel?

1. A) Converts text to uppercase
2. B) Converts text to lowercase
3. C) Removes leading and trailing spaces from text

Correct Answer: A) Converts text to uppercase

Which keyboard shortcut is used to select the entire worksheet in Excel?

1. A) Ctrl + A
2. B) Ctrl + Shift + End
3. C) Ctrl + Home
4. D) Ctrl + Shift + Spacebar

Correct Answer: A) Ctrl + A

Why the  Data Validation feature is used in MS Excel?

1. A) Automatically corrects spelling errors in a worksheet
2. B) Validates the accuracy of data entered into a cell based on specified criteria
3. C) Locks specific rows or columns in place so they remain visible when scrolling
4. D) Protects a worksheet from being modified by other users

Correct Answer: B) Validates the accuracy of data entered into a cell based on specified criteria

Which Excel function is used to count the number of cells in a range that meet a certain condition?

1. A) COUNT()
2. B) AVERAGE()
3. C) MAX()
4. D) SUMIF()

Correct Answer: D) SUMIF()

What is the purpose of the Text to Columns feature in Excel?

1. A) Converts text to lowercase
2. B) Splits text in a cell into multiple columns based on a delimiter
3. C) Removes all formatting from a range of cells
4. D) Combines text from two or more cells into one cell

Correct Answer: B) Splits text in a cell into multiple columns based on a delimiter

________ shortcut is used to undo the last action in Ms Excel?

1. A) Ctrl + Z
2. B) Ctrl + X
3. C) Ctrl + C
4. D) Ctrl + V

Correct Answer: A) Ctrl + Z

What does the function TODAY do in Excel?

1. A) Returns the current date and time
2. B) Returns the current date
3. C) Converts a value from one unit of measurement to another
4. D) Checks whether a condition is met and returns one value if true and another value if false

Correct Answer: B) Returns the current date

Which Excel feature is used to identify and correct errors in formulas?

1. A) AutoFill
2. B) Trace Precedents
3. C) Conditional Formatting
4. D) Goal Seek

Correct Answer: B) Trace Precedents

Which Excel feature is used to find an optimal solution to a problem by adjusting multiple variables?

1. A) Data Tables
2. B) Goal Seek
3. C) Solver
4. D) Scenario Manager

Correct Answer: C) Solver

What is the purpose of the Merge & Center feature in Excel?

1. A) Converts text to lowercase
2. B) Combines multiple cells into one cell and centers the contents
3. C) Splits text in a cell into multiple columns based on a delimiter
4. D) Removes all formatting from a range of cells

Correct Answer: B) Combines multiple cells into one cell and centers the contents

Which keyboard shortcut is used to delete cell contents in Excel?

1. A) Delete
2. B) Ctrl + D
3. C) Ctrl + Del
4. D) Backspace

Correct Answer: D) Backspace

What is the purpose of the Format Painter feature in Excel?

1. A) Removes all formatting from a range of cells
2. B) Copies the formatting from one cell or range of cells to another
3. C) Locks specific rows or columns in place so they remain visible when scrolling
4. D) Validates the accuracy of data entered into a cell based on specified criteria

Correct Answer: B) Copies the formatting from one cell or range of cells to another

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

1. A) MAX()
2. B) MIN()
3. C) AVERAGE()
4. D) COUNT()

Correct Answer: B) MIN()

What does the function LOWER do in Excel?

1. A) Converts text to lowercase
2. B) Converts text to uppercase
3. C) Removes leading and trailing spaces from text

Correct Answer: A) Converts text to lowercase

Which Excel feature is used to define a specific range of cells to print?

1. A) Page Layout
2. B) Print Area
3. C) Page Break Preview
4. D) Print Titles

Correct Answer: B) Print Area

What is the purpose of the HLOOKUP function in Excel?

1. A) Looks up a value in the first row of a range and returns a value in the same column from a specified row
2. B) Looks up a value in the first column of a range and returns a value in the same row from a specified column
3. C) Counts the number of cells in a range that follow some conditions
4. D) Checks whether a condition is met and returns one value if true and another value if false

Correct Answer: A) Looks up a value in the first row of a range and returns a value in the same column from a specified row

Which Excel feature is used to format numbers, dates, and text in a cell?

1. A) Format Painter
2. B) Number Formatting
3. C) Conditional Formatting
4. D) AutoFormat

Correct Answer: B) Number Formatting

What is the purpose of the INDIRECT function in Excel?

1. A) Returns the reference specified by a text string
2. B) Checks whether a condition is met and returns one value if true and another value if false
3. C) Converts a value from one unit of measurement to another

Correct Answer: A) Returns the reference specified by a text string

Which keyboard shortcut is used to select non-adjacent cells in Excel?

1. A) Ctrl + Shift + End
2. B) Ctrl + Spacebar
3. C) Shift + Spacebar
4. D) Ctrl + Click

Correct Answer: D) Ctrl + Click

What is the purpose of the Data Tables feature in Excel?

1. A) Converts text to lowercase
2. B) Calculates multiple results based on different input values
3. C) Locks specific rows or columns in place so they remain visible when scrolling
4. D) Validates the accuracy of data entered into a cell based on specified criteria

Correct Answer: B) Calculates multiple results based on different input values

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

1. A) MEDIAN()
2. B) MODE()
3. C) AVERAGE()
4. D) COUNT()

Correct Answer: A) MEDIAN()

What is the purpose of the Conditional Formatting feature in Excel?

1. A) Automatically corrects spelling errors in a worksheet
2. B) Applies formatting to cells based on specified criteria
3. C) Validates the accuracy of data entered into a cell based on specified criteria
4. D) Locks specific rows or columns in place so they remain visible when scrolling

Correct Answer: B) Applies formatting to cells based on specified criteria

________  shortcut is used to insert the current date in Excel?

1. A) Ctrl + D
2. B) Ctrl + ;
3. C) Ctrl + Shift + :
4. D) Ctrl + Shift + “

Correct Answer: B) Ctrl + ;

What is the purpose of the SUBTOTAL function in Excel?

1. A) Calculates the sum of values in a range that meet a certain condition
2. B) Finds the highest value in a range of cells
3. C) Calculates subtotals for a range of cells using a specified function

Correct Answer: C) Calculates subtotals for a range of cells using a specified function

Which Excel feature is used to automatically adjust the height of a row to fit its contents?

1. A) AutoFit Row Height
2. B) Merge Cells
3. C) Wrap Text
4. D) Format Painter

Correct Answer: A) AutoFit Row Height

What is the purpose of the Split feature in Excel?

1. A) Converts text to lowercase
2. B) Splits text in a cell into multiple columns based on a delimiter
3. C) Removes all formatting from a range of cells

Correct Answer: B) Splits text in a cell into multiple columns based on a delimiter