MS Excel MCQs Multiple Choice Questions and Answers PDF

MS Excel MCQs Multiple Choice Questions and Answers PDF: This post is all about Excel questions with answers.

MS Excel MCQ Questions and Answers PDF | Top 100 MCQs of Excel

What is the shortcut key to create a new workbook in Excel?

a) Ctrl + N

b) Ctrl + O

c) Ctrl + S

d) Ctrl + W
Answer: a) Ctrl + N

Which function is used to find the largest number in a range?

a) MIN()

b) MAX()

c) AVERAGE()

d) COUNT()
Answer: b) MAX()

Which of the following will not be considered as a text in Excel?

a) 12345

b) =A1+A2

c) “Hello”

d) “12345”
Answer: b) =A1+A2

What is the intersection of a row and a column in Excel called?

a) Formula

b) Cell

c) Chart

d) Address
Answer: b) Cell

What is the default file extension for an Excel workbook?

a) .xls

b) .doc

c) .xlsx

d) .txt
Answer: c) .xlsx

Which of the following functions is used to calculate the total of a range of cells?

a) AVERAGE

b) SUM

c) COUNT

d) MAX
Answer: b) SUM

Which symbol is used in Excel to begin a formula?

a) @

b) &

c) =

d) %
Answer: c) =

What is the function of Ctrl + D in Excel?

a) Copy the selected text

b) Fill down the values in the selected cells

c) Delete the selected row

d) Open a new worksheet
Answer: b) Fill down the values in the selected cells

In Excel, which function is used to join two or more text strings together?

a) CONCATENATE

b) JOIN

c) MERGE

d) COMBINE
Answer: a) CONCATENATE

What is the name of the Excel feature that suggests different chart types based on your data?

a) Smart Charts

b) Quick Analysis

c) Data Visualizer

d) Chart Assistant
Answer: b) Quick Analysis

Which of the following options is used to protect a worksheet from changes?

a) Save As

b) Freeze Panes

c) Protect Sheet

d) Lock Workbook
Answer: c) Protect Sheet

MS Excel Objective Questions and Answers PDF

Which function returns the current date and time in Excel?

a) TODAY()

b) NOW()

c) DATE()

d) TIME()
Answer: b) NOW()

How do you activate the “Go To” dialog box in Excel?

a) Ctrl + G

b) Ctrl + H

c) Ctrl + F

d) Ctrl + P
Answer: a) Ctrl + G

Which of the following is NOT a valid chart type in Excel?

a) Bar

b) Line

c) Bubble

d) Image
Answer: d) Image

What is the purpose of the IF function in Excel?

a) To format cells based on criteria

b) To return one value if a condition is true and another if it’s false

c) To join multiple text strings

d) To find the sum of cells
Answer: b) To return one value if a condition is true and another if it’s false

How can you remove data validation from a cell?

a) Right-click and delete

b) Home > Clear > Clear Formats

c) Data > Data Validation > Clear All

d) Press Ctrl + X
Answer: c) Data > Data Validation > Clear All

Which of these is a conditional formatting option?

a) Highlight Cells Rules

b) Data Bars

c) Color Scales

d) All of the above
Answer: d) All of the above

What does the VLOOKUP function do?

a) Looks for a value in a column

b) Looks for a value in a row

c) Sorts values in a column

d) Filters data in a sheet
Answer: a) Looks for a value in a column

Which command will you use to restrict the value range of a cell?

a) Data > Filter

b) Data > Data Validation

c) Formulas > Data Tables

d) Review > Protect Workbook
Answer: b) Data > Data Validation

What happens when you press Ctrl + Spacebar in Excel?

a) It selects the entire worksheet

b) It selects the entire row

c) It selects the entire column

d) It selects the entire cell content
Answer: c) It selects the entire column

Which of the following can be used to add comments to a cell?

a) Insert > Comment

b) Review > New Comment

c) Data > Add Comment

d) View > Show Comments
Answer: b) Review > New Comment

Which function is used to count only the numeric values in a range?

a) COUNTA()

b) COUNTIF()

c) COUNT()

d) COUNTBLANK()
Answer: c) COUNT()

What is the default alignment for text entered in a cell?

a) Left

b) Center

c) Right

d) Justify
Answer: a) Left

Which of the following errors appears when a formula has a divide-by-zero error?

a) #VALUE!

b) #DIV/0!

c) #NUM!

d) #NULL!
Answer: b) #DIV/0!

Which of the following Excel features allows users to automatically complete a series of data?

a) AutoComplete

b) AutoFill

c) AutoSum

d) AutoCorrect
Answer: b) AutoFill

What does the PMT function calculate?

a) Loan interest rate

b) Loan payment amount

c) Total loan amount

d) Future value of investment
Answer: b) Loan payment amount

What is the keyboard shortcut to open the “Format Cells” dialog box?

a) Ctrl + 1

b) Ctrl + 2

c) Ctrl + 3

d) Ctrl + 4
Answer: a) Ctrl + 1

Which function returns the number of characters in a text string?

a) LEN()

b) LEFT()

c) RIGHT()

d) MID()
Answer: a) LEN()

Advanced Excel Objective Questions and Answers pdf

How can you select non-adjacent cells in Excel?

a) By holding Shift and clicking the cells

b) By holding Alt and clicking the cells

c) By holding Ctrl and clicking the cells

d) By holding Enter and clicking the cells
Answer: c) By holding Ctrl and clicking the cells

Which function is used to find the average of a group of numbers in Excel?

a) SUM()

b) AVERAGE()

c) COUNT()

d) MEDIAN()
Answer: b) AVERAGE()

Which of the following is the correct syntax of the IF function in Excel?

a) IF(logical_test, [value_if_true], [value_if_false])

b) IF([value_if_true], logical_test, [value_if_false])

c) IF(logical_test, [value_if_false], [value_if_true])

d) IF([value_if_false], [value_if_true], logical_test)
Answer: a) IF(logical_test, [value_if_true], [value_if_false])

What is the use of Freeze Panes in Excel?

a) To lock a specific column or row to keep it visible while scrolling

b) To protect a worksheet

c) To prevent data editing

d) To format cells
Answer: a) To lock a specific column or row to keep it visible while scrolling

Which of the following charts is best for showing trends over time?

a) Pie Chart

b) Line Chart

c) Column Chart

d) Bar Chart
Answer: b) Line Chart

Which Excel function will you use to find the smallest value in a range?

a) MIN()

b) MAX()

c) SMALL()

d) LOWER()
Answer: a) MIN()

What does the shortcut Ctrl + Shift + L do in Excel?

a) Applies bold formatting

b) Filters the selected data

c) Selects the entire column

d) Opens the Print Preview window
Answer: b) Filters the selected data

Which of the following is NOT a valid data type in Excel?

a) Text

b) Number

c) Formula

d) Date/Time
Answer: c) Formula

How can you quickly multiply the contents of two cells in Excel?

a) Use the formula =A1+B1

b) Use the formula =A1*B1

c) Use the formula =A1/B1

d) Use the formula =A1-B1
Answer: b) Use the formula =A1*B1

Which function can be used to count the number of blank cells in a range?

a) COUNTBLANK()

b) COUNTA()

c) COUNT()

d) COUNTIF()
Answer: a) COUNTBLANK()

What is the shortcut key to insert a new worksheet in Excel?

a) Shift + F11

b) Ctrl + N

c) Alt + Shift + N

d) Ctrl + F11
Answer: a) Shift + F11

How can you remove duplicate entries from a range of cells?

a) Data > Sort

b) Data > Remove Duplicates

c) Home > Clear Formats

d) Data > Data Validation
Answer: b) Data > Remove Duplicates

What does the shortcut Ctrl + ; (semicolon) do in Excel?

a) Inserts the current date

b) Inserts the current time

c) Deletes the contents of the selected cell

d) Opens the Find and Replace dialog box
Answer: a) Inserts the current date

Which Excel feature allows you to combine data from multiple sheets into one?

a) Data Validation

b) Consolidate

c) Subtotal

d) Scenario Manager
Answer: b) Consolidate

Which of the following functions will return the remainder after a number is divided by a divisor?

a) MOD()

b) ROUND()

c) INT()

d) FLOOR()
Answer: a) MOD()

What is the keyboard shortcut to edit the active cell?

a) F2

b) F4

c) F7

d) F10
Answer: a) F2

In Excel, what is a Pivot Table used for?

a) To summarize, analyze, and explore data

b) To create charts

c) To create scenarios

d) To format a table
Answer: a) To summarize, analyze, and explore data

What does the TRIM function do in Excel?

a) Removes all spaces from text

b) Removes extra spaces from text, leaving single spaces between words

c) Deletes text in a cell

d) Concatenates text
Answer: b) Removes extra spaces from text, leaving single spaces between words

Which of the following Excel functions can be used to look up values horizontally in a table?

a) VLOOKUP

b) HLOOKUP

c) INDEX

d) MATCH
Answer: b) HLOOKUP

Which function can be used to find the position of a character in a text string?

a) SEARCH()

b) FIND()

c) LEFT()

d) MID()
Answer: b) FIND()

How do you insert a comment in Excel?

a) Review > New Comment

b) Data > Data Validation

c) Insert > Comment

d) File > Options
Answer: a) Review > New Comment

Which of the following is used to link data from one workbook to another?

a) Hyperlink

b) External Reference

c) Data Validation

d) Text Box
Answer: b) External Reference

Which function is used to round a number to a specified number of digits?

a) ROUNDUP()

b) ROUNDDOWN()

c) ROUND()

d) MROUND()
Answer: c) ROUND()

What does the shortcut Ctrl + Shift + “+” do in Excel?

a) Insert a new worksheet

b) Insert a new row or column

c) Delete a row

d) Insert a chart
Answer: b) Insert a new row or column

Which function would you use to find the largest value that is less than or equal to a specific value in a lookup array?

a) VLOOKUP with TRUE as the range_lookup argument

b) HLOOKUP with FALSE as the range_lookup argument

c) MATCH with 0 as the match_type argument

d) INDEX with 1 as the match_type argument
Answer: a) VLOOKUP with TRUE as the range_lookup argument

Which function in Excel checks whether a condition is met and returns TRUE or FALSE?

a) AND()

b) IF()

c) ISERROR()

d) OR()
Answer: b) IF()

Which feature allows you to copy formatting from one cell to another?

a) Format Painter

b) Conditional Formatting

c) Copy and Paste Special

d) AutoFormat
Answer: a) Format Painter

What does the COUNTIF function do in Excel?

a) Counts the number of cells that meet a single condition

b) Counts the number of cells that meet multiple conditions

c) Counts all cells with numerical values

d) Counts blank cells
Answer: a) Counts the number of cells that meet a single condition

Which of the following functions will return today’s date?

a) DATE()

b) NOW()

c) TODAY()

d) TIME()
Answer: c) TODAY()

What happens when you press Alt + Enter in Excel?

a) Moves to the next cell

b) Adds a line break within a cell

c) Opens the Find dialog box

d) Inserts a new worksheet
Answer: b) Adds a line break within a cell

Which of the following is used to calculate the total number of cells in a range that are not empty?

a) COUNT()

b) COUNTA()

c) COUNTBLANK()

d) SUM()
Answer: b) COUNTA()

What is the default alignment for numeric values in a cell?

a) Left

b) Center

c) Right

d) Justify
Answer: c) Right

Which Excel function is used to find the middle value in a range?

a) AVERAGE()

b) MEDIAN()

c) MODE()

d) MIN()
Answer: b) MEDIAN()

Which of the following can be used to group rows or columns in Excel?

a) Data Validation

b) Data Consolidation

c) Data Grouping

d) Data Subtotal
Answer: c) Data Grouping

Which of these functions would you use to calculate the monthly payment for a loan in Excel?

a) PMT()

b) NPV()

c) RATE()

d) FV()
Answer: a) PMT()

How can you remove all the borders applied to a cell?

a) Home > Clear > Clear Formats

b) Home > Delete > Remove Borders

c) Home > Border > No Border

d) Format > Clear Borders
Answer: c) Home > Border > No Border

Which function would you use to count the number of cells that meet multiple conditions?

a) COUNTIF()

b) COUNTBLANK()

c) SUMIF()

d) COUNTIFS()
Answer: d) COUNTIFS()

Which of the following is true about a worksheet in Excel?

a) It can contain only text data

b) It can contain only one chart

c) It can contain multiple sheets

d) It cannot be renamed
Answer: c) It can contain multiple sheets

How can you display formulas in the worksheet instead of the results?

a) Press Ctrl + F3

b) Press Ctrl + `

c) Press F2

d) Press Alt + =
Answer: b) Press Ctrl + `

Which of the following functions will return the largest value less than or equal to the lookup value in a lookup array?

a) LOOKUP()

b) VLOOKUP()

c) MATCH()

d) HLOOKUP()
Answer: a) LOOKUP()

Which of the following is NOT a text function in Excel?

a) LEFT()

b) PROPER()

c) CONCATENATE()

d) SUM()
Answer: d) SUM()

How do you apply a filter to data in Excel?

a) Data > Sort

b) Data > Filter

c) Home > Sort & Filter

d) Review > Protect Sheet
Answer: b) Data > Filter

What is the primary purpose of the CONCATENATE function in Excel?

a) To sum numbers in a range

b) To join multiple text strings into one

c) To count text strings in a range

d) To format text
Answer: b) To join multiple text strings into one

Which Excel function would you use to retrieve a value from a specific row and column in a table?

a) INDEX()

b) MATCH()

c) VLOOKUP()

d) HLOOKUP()
Answer: a) INDEX()

How do you open the Format Cells dialog box quickly?

a) Right-click and select Format Cells

b) Press Ctrl + Shift + 1

c) Press Ctrl + 1

d) Press Alt + F1
Answer: c) Press Ctrl + 1

What is the effect of using the absolute cell reference ($A$1) in a formula?

a) The cell reference will change when copied to another cell

b) The cell reference will remain constant when copied

c) The cell reference will change in rows only

d) The cell reference will change in columns only
Answer: b) The cell reference will remain constant when copied

Which of the following is true about Named Ranges in Excel?

a) They can only refer to a single cell

b) They make formulas easier to read

c) They cannot be used in charts

d) They are automatically deleted when the workbook is closed
Answer: b) They make formulas easier to read

Which function calculates the future value of an investment based on periodic, constant payments and a constant interest rate?

a) FV()

b) PV()

c) PMT()

d) NPV()
Answer: a) FV()

How can you change the format of multiple cells at once?

a) Select cells and press Ctrl + 1

b) Format > Cells

c) Select cells and right-click to choose Format Cells

d) All of the above
Answer: d) All of the above

What is the result of the formula =A1 + A2 * A3 if A1=2, A2=3, and A3=4?

a) 14

b) 20

c) 12

d) 10
Answer: c) 14 (according to order of operations)

What feature would you use to create a chart from selected data in Excel?

a) Data Validation

b) Chart Wizard

c) PivotTable

d) Insert Chart
Answer: d) Insert Chart

Which of the following actions would NOT create a hyperlink in Excel?

a) Using the HYPERLINK function

b) Right-clicking a cell and selecting Hyperlink

c) Pressing Ctrl + K

d) Selecting Data Validation
Answer: d) Selecting Data Validation

Which function can be used to remove all non-printable characters from a text string?

a) TRIM()

b) CLEAN()

c) SUBSTITUTE()

d) REPLACE()
Answer: b) CLEAN()

What is the purpose of the IFERROR function in Excel?

a) To calculate errors in formulas

b) To handle errors and return a specified value if an error occurs

c) To find the first error in a range

d) To format error messages
Answer: b) To handle errors and return a specified value if an error occurs

Which of the following will NOT work as a data validation rule in Excel?

a) Whole number

b) List

c) Decimal

d) Formula
Answer: d) Formula

What feature allows you to create a visual representation of data trends over time in Excel?

a) Sparkline

b) Data Bar

c) Conditional Formatting

d) SmartArt
Answer: a) Sparkline

Which of the following shortcuts will allow you to quickly sum a column of numbers?

a) Alt + =

b) Ctrl + S

c) Shift + S

d) Ctrl + R
Answer: a) Alt + =

What does the DATEDIF function calculate?

a) The difference between two dates in years, months, or days

b) The current date and time

c) The total number of days in a month

d) The end date of a given period
Answer: a) The difference between two dates in years, months, or days

Which of the following can be used to create a dropdown list in a cell?

a) Data > Filter

b) Data > Data Validation

c) Home > Conditional Formatting

d) Insert > Comment
Answer: b) Data > Data Validation

What does the LOOKUP function do in Excel?

a) Searches for a value in a range and returns a corresponding value

b) Counts the number of occurrences of a value

c) Sorts data in ascending or descending order

d) Merges multiple cells into one
Answer: a) Searches for a value in a range and returns a corresponding value

Which of the following options can you use to highlight duplicate values in a range?

a) Conditional Formatting

b) Data Validation

c) Data Consolidation

d) Sorting
Answer: a) Conditional Formatting

How can you protect a worksheet in Excel?

a) File > Options > Protect Workbook

b) Review > Protect Sheet

c) Home > Format > Protect Sheet

d) Data > Security > Protect Sheet
Answer: b) Review > Protect Sheet

Which of the following functions can be used to calculate the average of a range of cells?

a) AVERAGEIF()

b) MEAN()

c) AVERAGEA()

d) AVERAGE()
Answer: d) AVERAGE()

What does the function TEXT() do in Excel?

a) Converts text to numbers

b) Formats a number and converts it to text

c) Removes text from a cell

d) Counts the number of text entries
Answer: b) Formats a number and converts it to text

Which of the following is NOT a valid option in the Sort dialog box?

a) Sort by values

b) Sort by color

c) Sort by formula

d) Sort by font
Answer: c) Sort by formula

Which shortcut can you use to quickly create a chart from the selected data?

a) Alt + F1

b) Ctrl + C

c) Shift + F11

d) Ctrl + N
Answer: a) Alt + F1

What does the COUNT function do?

a) Counts the number of cells containing any text

b) Counts all cells with numeric values

c) Counts only blank cells

d) Counts the number of unique values
Answer: b) Counts all cells with numeric values

What happens when you use the F4 key after selecting a cell reference in a formula?

a) It opens the Function Arguments dialog box

b) It toggles between relative and absolute references

c) It calculates the formula

d) It copies the cell reference
Answer: b) It toggles between relative and absolute references

Which of the following formulas will find the total of cells A1 through A10?

a) =TOTAL(A1)

b) =SUM(A1)

c) =ADD(A1)

d) =AGGREGATE(A1)
Answer: b) =SUM(A1)

Which of the following features allows you to group data and perform calculations on it?

a) Filter

b) PivotTable

c) Chart

d) Table
Answer: b) PivotTable

What does the ROUNDUP function do in Excel?

a) Rounds a number down to the nearest integer

b) Rounds a number up to the nearest integer

c) Rounds a number to the nearest multiple of a specified value

d) Rounds a number to a specified number of digits
Answer: b) Rounds a number up to the nearest integer

Which of the following statements is true regarding data in Excel?

a) Data can only be stored in rows

b) Data can only be stored in columns

c) Data can be stored in both rows and columns

d) Data cannot be stored in Excel
Answer: c) Data can be stored in both rows and columns

For More Quiz Click Here

FAQs on MS Excel

---

---