Microsoft Excel MCQs Questions With Answer 
In the Army, Navy, and Pakistan Air Force’s initial academic exams of ICTOs, Cyber Security, IT Officers, multiple-choice questions on Microsoft Excel questions with answers are essential. The computer-based assessments that are given during the selection process heavily rely on the computer knowledge that these Microsoft excel multiple-choice questions (MCQs) cover. A solid grasp of Microsoft Excel is essential whether one’s goal is to join the Army, Navy and PAF ICTOs.
Microsoft Excel MCQs (Part-1)
In MS Excel, cell formatting refers to the visual appearance of the cell, including its ___, ___, and ___.
- A) Border, Size, Style
- B) Font, Color, Alignment
- C) Background, Height, Shape
- D) Width, Font Size, Shadow
The ___ ribbon tab in Excel contains tools for formatting cells.
- A) View
- B) Formulas
- C) Home
- D) Data
The ___ option is used to change the font of the cell content.
- A) Font Style
- B) Font Name
- C) Font Size
- D) Font Color
The ___ option is used to make the contents of a cell bold.
- A) Italics
- B) Underline
- C) Bold
- D) Strikethrough
The ___ option is used to italicize the contents of a cell.
- A) Bold
- B) Italics
- C) Underline
- D) Highlight
The ___ option is used to change the font color of the cell content.
- A) Font Style
- B) Font Size
- C) Font Color
- D) Font Background
The ___ option is used to change the background color of a cell.
- A) Fill Color
- B) Font Color
- C) Border Color
- D) Text Color
The ___ option is used to increase or decrease the font size of the cell content.
- A) Font Style
- B) Font Color
- C) Font Size
- D) Font Name
The ___ option is used to align the contents of a cell to the left.
- A) Align Center
- B) Align Right
- C) Align Left
- D) Wrap Text
The ___ option is used to center the contents of a cell.
- A) Align Left
- B) Align Right
- C) Center
- D) Wrap Text
Microsoft Excel MCQs (Part-2)
The ___ option is used to align the contents of a cell to the right.
- A) Align Center
- B) Align Right
- C) Align Left
- D) Wrap Text
The ___ option is used to wrap text in a cell according to the column width.
- A) Merge Cells
- B) Text Wrap
- C) Align Text
- D) Font Size
The ___ option is used to add borders to the cell.
- A) Border
- B) Fill Color
- C) Font Style
- D) Alignment
The ___ option is used to merge multiple cells into one cell.
- A) Combine and Center
- B) Split Cells
- C) Border
- D) Wrap Text
In MS Excel, a formula always starts with ___.
- A) @
- B) !
- C) $
- D) =
The ___ function is used to calculate the sum of a range of cells in Excel.
- A) AVERAGE
- B) MAX
- C) MIN
- D) SUM
The ___ function returns the average value of a range of cells in Excel.
- A) COUNT
- B) SUM
- C) AVERAGE
- D) MAX
The ___ function finds the largest value in a range of cells in Excel.
- A) MIN
- B) AVERAGE
- C) MAX
- D) COUNT
Microsoft Excel MCQs for competitive Exam
Microsoft Excel mcqs questions and answers are quite helpful for anyone who want to work in the Navy Education Branch, Army Education branch, or PAF Education branches. The main topics of these Microsoft excel multiple-choice questions (MCQs) include functions, formulae, and data manipulation in Microsoft Excel. Candidates can take the computer examinations that make up a big portion of the academic evaluation procedure with confidence if they have mastered these abilities.
Microsoft Excel MCQs (Part-3)
The ___ function finds the smallest value in a cell range in Excel.
- A) MAX
- B) MIN
- C) AVERAGE
- D) SUM
The ___ function counts the number of cells in a range containing numbers in Excel.
- A) AVERAGE
- B) COUNT
- C) MAX
- D) MIN
The ___ function checks a condition and returns one value in Excel if the condition is true and another value if the condition is false.
- A) SUM
- B) IF
- C) VLOOKUP
- D) COUNTIF
The ___ function is used to search for the value in the left column of the table and return the value of the specified column in the same row in Excel.
- A) SUMIF
- B) AVERAGEIF
- C) VLOOKUP
- D) INDEX
___ is used to join (concatenate) two or more text strings in Excel.
- A) CONCATENATE
- B) SPLIT
- C) REPLACE
- D) TEXTJOIN
The ___ function calculates the square root of a number in Excel.
- A) SQRT
- B) POWER
- C) EXP
- D) LOG
The ___ function converts a value to a percentage in Excel.
- A) VALUE
- B) PERCENTAGE
- C) FORMAT
- D) MULTIPLY
The ___ function returns the current date in Excel.
- A) NOW
- B) TODAY
- C) DATE
- D) TIME
The ___ function calculates the number of days between two dates in Excel.
- A) DATE
- B) DATEDIF
- C) DAYS
- D) NETWORKDAYS
Microsoft Excel MCQs (Part-4)
The function ___ returns the current time in Excel.
- A) NOW
- B) CURRENT
- C) TIME
- D) DATE
The ___ function in Excel rounds a number to a specified number of decimal places.
- A) ROUNDUP
- B) ROUNDDOWN
- C) ROUND
- D) TRUNC
Excel’s _________ function allows you to define a condition and perform different actions depending on whether the condition is true or false.
- A) VLOOKUP
- B) SUMIF
- C) AVERAGEIF
- D) IF
Excel’s _________ function is used to count the number of cells in a range that meet a certain condition.
- A) COUNT
- B) SUM
- C) COUNTIF
- D) AVERAGE
Excel’s _________ function is used to sum values ​​in ranges that meet a certain condition.
- A) COUNTIF
- B) AVERAGEIF
- C) SUMIF
- D) MAX
Excel’s _________ function is used to average the values ​​in a range that meet a given condition.
- A) COUNTIF
- B) SUMIF
- C) AVERAGEIF
- D) MIN
See Related MCQs for ICTOs / Cyber Security / IT Branch Jobs in Army Navy and PAF
Microsoft Excel MCQs with Answers
For individuals hoping to become PAF IT Branch, Navy IT Branch, Lady Cadet Course and Army ICTOs tests, Cyber security officers tests, Microsoft Excel MCQs are quite important. The computer assessments that are administered as part of the hiring process frequently highlight ability with Microsoft Excel, thus candidates must be highly proficient with this program.
Microsoft Excel MCQs (Part-5)
Excel’s _________ function is used to check multiple conditions and return results based on those conditions.
- A) OR
- B) AND
- C) IF
- D) NOT
Excel’s _________ function is used to test multiple conditions and return a result if any condition is true.
- A) AND
- B) OR
- C) IF
- D) ISNUMBER
Excel’s _________ function is used to check if a value is in a range of values and return the result based on the search results.
- A) INDEX
- B) VLOOKUP
- C) MATCH
- D) FIND
Excel’s _____ function is used to find the largest value that matches a given condition in a range.
- A) MINIFS
- B) MAXIFS
- C) MAX
- D) SUMIFS
Excel’s _____ function is used to find the smallest value in a range that meets a given condition.
- A) MAXIFS
- B) MINIFS
- C) MIN
- D) AVERAGEIFS
Excel’s _________ function is used to check if a value meets a given condition and return the result accordingly.
- A) IF
- B) IFS
- C) OR
- D) AND
The Excel function _________ is used to round a number to a specified multiple.
- A) ROUND
- B) CEILING
- C) FLOOR
- D) MROUND
Excel’s _________ function is used to check if a value is within a specified range and return the result.
- A) OR
- B) AND
- C) NOT
- D) ISNUMBER
Excel’s _________ function is used to check if a value differs from a given value and return the result.
- A) OR
- B) NOT
- C) IF
- D) ISERROR
Microsoft Excel MCQs (Part-6)
Excel’s _________ function is used to check if a value is null or empty and return the result.
- A) ISNUMBER
- B) ISBLANK
- C) BLANK
- D) IFERROR
The Excel function ______ is used to check if a value is an error value and return the result.
- A) ISERROR
- B) ERROR
- C) IFERROR
- D) ISBLANK
In MS Excel, a range is called _________ which represents a cell or a range of cells.
- A) Cell Reference
- B) Name
- C) Address
- D) Label
Named ranges in Excel allow _________ to add a cell or range with a meaningful name.
- A) Define
- B) Identify or Mark
- C) Label
- D) Create
Excel’s _____ ribbon tab contains tools for managing named ranges.
- A) Data
- B) Formulas
- C) Home
- D) View
Named ranges can be used instead of _________ cell references in formulas.
- A) Dynamic
- B) Absolute or Relative
- C) Fixed
- D) Standard
You can create a named range in Excel using the _________ option on the Formulas tab.
- A) Define Name
- B) Specify a Name
- C) Name Manager
- D) Name Box
The scope of a named range in Excel determines _________ that it can be used in a workbook.
- A) Its location
- B) On which worksheets
- C) Its color
- D) Its size
Excel’s _________ function is used to return a value from a named range.
- A) OFFSET
- B) INDEX
- C) INDIRECT
- D) VLOOKUP
Excel’s _________ dialog allows you to view, edit, and delete named ranges.
- A) Name Manager
- B) Name Manager
- C) Manage Names
- D) Named Ranges
Named ranges can create formulas in Excel to understand and store _________.
- A) Easier
- B) Easier
- C) Simpler
- D) Faster
_________ is an advantage of using named ranges in Excel.
- A) Better Clarity
- B) Faster Processing
- C) Increased Speed
- D) More Formulas
Microsoft Excel MCQs Questions with Solved Answers
Microsoft Excel MCQs are very helpful for people who are interested in careers in the administrative and logistical branches of the Pakistan Air Force, such as the PAF IT Branch, Cyber Security branch, LCC in Pak Army, Army Education branch, Navy Education Branch, these Microsoft Excel multiple-choice questions address concepts including pivot tables, filtering, and data sorting.
Microsoft Excel MCQs(Part-7)
Selected areas allow you to easily move the _________ formula to different spreadsheets or workbooks.
- A) Copy
- B) Paste
- C) Delete
- D) Move
Named ranges can be used to create _________ in Excel for navigation or data entry.
- A) Validation of Data
- B) Drop-Down Lists
- C) Formulas
- D) Charts
Excel’s _________ function is used to check the existence of a named range.
- A) NAME
- B) FIND
- C) INDIRECT
- D) SEARCH
The Excel function _____ is used to retrieve the name of a named range.
- A) CELL
- B) ADDRESS
- C) NAME
- D) FORMULATEXT
Excel’s _________ option allows you to use a named range in a chart series.
- A) Data Validation
- B) Select Data
- C) Data Labels
- D) Format Data Series
In MS Excel, _________ is the sorting of data in a specific order based on one or more criteria.
- A) Sort
- B) Filter
- C) Group
- D) Find
Excel’s _________ option allows you to sort data in ascending or descending order.
- A) Filter
- B) Sort A to Z or Sort Z to A
- C) Group
- D) Conditional Formatting
Excel’s _________ option allows you to sort data based on numerical values from smallest to largest or largest to smallest.
- A) Filter by Size
- B) Sort Smallest to Largest or Sort Largest to Smallest
- C) Sort by Order
- D) Sort by Value
Excel’s _____________ option allows you to sort data by date and time in chronological or reverse chronological order.
- A) Sort by Date
- B) Sort Oldest to Newest or Sort Newest to Oldest
- C) Sort by Time
- D) Sort by Calendar
Microsoft Excel MCQs (Part-8)
Excel’s _____________ option allows you to sort data according to custom criteria defined by a formula or function.
- A) Sort by Icon
- B) Sort by Color or Sort by Icon
- C) Sort by Value
- D) Sort by Date
Excel’s _________ option allows you to sort data by a specific column or multiple columns.
- A) Sort by Range
- B) Sort by Column
- C) Filter by Column
- D) Group by Column
Excel’s _________ option allows you to sort data by row or column values.
- A) Sort by Range
- B) Sort by Row or Sort by Range
- C) Sort by Sheet
- D) Group by Row
Excel’s _________ option allows you to sort data by range and keep related rows intact.
- A) Filter Range
- B) Sorting Range
- C) Group Range
- D) Sort by Selection
Excel’s _________ option allows you to filter data according to specific criteria and display only matching records.
- A) Filter or AutoFilter
- B) Conditional Formatting
- C) Data Validation
- D) Advanced Filter
Excel’s _________ option allows you to filter data based on a custom formula or expression.
- A) AutoFilter
- B) Advanced Filter
- C) Standard Filter
- D) Filter by Color
Excel’s _________ option allows you to filter data based on multiple criteria using logical operators.
- A) Filter by Color
- B) Filter by Icon
- C) Advanced Filter
- D) AutoFilter
Excel’s _________ option allows you to filter data by text or numeric values under certain conditions.
- A) Date Filters
- B) Text Filters or Numeric Filters
- C) Color Filters
- D) Icon Filters
Excel’s _________ option allows you to filter data by date and time under certain conditions.
- A) Date Filters
- B) Time Filters
- C) Custom Filters
- D) Text Filters
Excel’s _________ option allows you to filter data based on the highest or lowest values in a range.
- A) Top 10 or Bottom 10
- B) Top 10 or Bottom 10
- C) Value Filters
- D) Rank Filters
Microsoft Excel Multiple Choice Questions
Microsoft Excel Multiple-choice questions are not just used in military exams; they are also used in civilian defense force exams. These Microsoft excel multiple-choice questions (MCQs) can help prospective candidates for roles like LCC, Army ICTOs, Technical Cadet Course, Army Education Officers, and Army ICTOs Officers improve their knowledge and score well on computer-based assessments.
Microsoft Excel MCQs (Part-9)
Excel’s _________ option allows you to remove all filters and display all data in a spreadsheet.
- A) Reset Filters
- B) Clear Filter
- C) Show All
- D) Remove Filters
Excel’s _________ tool is used to summarize large amounts of data and calculate various statistical measures.
- A) Data Analysis Tool
- B) Analysis ToolPak
- C) Pivot Table
- D) Solver
Excel’s _________ tool is used to generate random numbers based on certain probability distributions.
- A) Random Number Generator
- B) Random Number Generation
- C) Data Generator
- D) Probability Tool
The Excel tool _________ is used to do some kind of analysis by changing the input values and observing the results.
- A) Goal Seek
- B) What-If Analysis
- C) Solver
- D) Scenario Manager
Excel’s _________ tool is used to analyze data and identify patterns or relationships.
- A) Data Analysis
- B) Descriptive Statistics
- C) Correlation Analysis
- D) Pivot Table
Excel’s _____ tool is used to create descriptive statistics for various data, such as the mean, median, and standard deviation.
- A) Summary Statistics
- B) Descriptive Statistics
- C) Data Summary
- D) Analysis ToolPak
Excel’s _________ tool is used to perform regression analysis and determine the relationship between variables.
- A) Correlation Tool
- B) Regression
- C) Forecasting
- D) Trend Analysis
Excel’s _________ tool is used to perform Fourier analysis and divide the time series into frequency components.
- A) Time Series Analysis
- B) Fourier Analysis
- C) Signal Analysis
- D) Frequency Analysis
Microsoft Excel MCQs (Part-10)
Excel’s _________ tool is used for exponential smoothing and predicting future values based on historical data.
- A) Forecasting Tool
- B) Exponential Smoothing
- C) Trend Analysis
- D) Moving Average
Excel’s _________ tool is used to take data and create a representative subset of a larger data set.
- A) Sampling Tool
- B) Sample
- C) Subset Generator
- D) Data Extractor
Excel’s _________ tool is used to perform an analysis of variance (ANOVA) and compare the means of several groups.
- A) Variance Analysis
- B) ANOVA
- C) Group Comparison
- D) Statistical Analysis
Excel’s _________ tool is used to perform t-tests and compare the means of two groups.
- A) t-Test
- B) Two-Sample Test
- C) Mean Comparison
- D) Statistical Test
Excel’s _________ tool is used for correlation analysis and to measure the strength of the relationship between variables.
- A) Regression Tool
- B) Correlation
- C) Data Analysis
- D) Trend Analysis
Excel’s _________ tool is used for histogram analysis and visualization of data distribution.
- A) Frequency Distribution
- B) Histogram
- C) Data Visualization
- D) Distribution Chart
The Excel tool _________ is used to analyze the values and percentages of various data.
- A) Data Analysis
- B) Rank and Percentage
- C) Summary Statistics
- D) Value Analysis
Excel’s _________ tool is used to construct a sample and estimate population parameters based on sample statistics.
- A) Sample Analysis
- B) Population Estimator
- C) Confidence Interval
- D) Sample Statistics
Join us on Social Media for more MCQs on Media and Society
- Join Facebook Group for current jobs and your Queries
- · Join WhatsApp Community Group of Shaheen Forces Academy
- · Subscribe YouTube Channel
For ahmadpoint and psychspirit
Prism Intelligence 2026
Refract your potential into the full spectrum of success for 2026. Access verified Verbal and Non-Verbal reasoning banks for Pakistan Army, Navy, and PAF officer selection.
Army Navy PAF Success Hub
The 2026 spectral core for military preparation. Download high-clarity PDF past papers and master ISSB and Cadet College entrance exams with prismatic focus.
Career Matrix & Experience
See more MCQs other than Microsoft Excel below
