S.NO UNIT CHAP. PART Q.

TYPE QUESTION CO KL QL MARK

1 1 1 A OBJ CO1 R E 1
To enter data into an Excel cell, you can ________ the
cell and start typing.
Double-click the cell and Select the cell and press
A. B.
start typing the F2 key
Click the cell and type
C. D. All of the above
the data
All of the above

Answer is : D
2 1 1 B DESC CO1 An M 5
Explain the different techniques for moving data within
an Excel workbook and analyze their effectiveness in
various scenarios.
3 1 1 C DESC CO1 E D 10
Develop a comprehensive guide on various methods for
entering and revising data in Excel, including a
discussion on best practices and common pitfalls.
4 1 2 A OBJ CO1 R E 1
_____________ is used to move data from one cell to
another in Excel.

A. Copy and paste B. Cut and paste

C. Drag and drop D. Both B and C
Answer is : D
5 1 2 A OBJ CO1 R E 1
__________ is the keyboard shortcut to open the Find
and Replace dialog box in Excel.

A. Ctrl + F B. Ctrl + H
C. Ctrl + G D. Ctrl + E
Answer is : B
6 1 2 B DESC CO1 E M 5
Discuss the steps involved in using the Find and Replace
feature in Excel, and evaluate its usefulness in data
management.
7 1 2 C DESC CO1 Ap D 10
Create a step-by-step tutorial on how to effectively use
the Find and Replace feature in Excel, including
advanced options and practical examples.
8 1 3 A OBJ CO1 R E 1
Which of the following can you NOT do with the Find and
Replace feature?
Replace all occurrences of
A. Find specific text B.
specific text
Format cells based on
C. D. Change the sheet name
found text
Answer is : D
9 1 3 B DESC CO1 E M 5
Create an Excel Table from a given range of data and
explain the benefits of using tables for data
management.
10 1 3 B DESC CO1 Ap M 5
Demonstrate how to use basic Excel functions to perform
calculations on data, and explain their importance in
data analysis.
11 1 3 C DESC CO1 C D 10
Explain the process of defining Excel Tables from a range
of data, and discuss the advantages and potential
limitations of using Excel Tables for data management.
12 1 4 A OBJ CO1 R E 1
___________________ feature allows you to add
additional information to cells in Excel.

A. Comments B. Conditional Formatting

C. Data Validation D. Macros
Answer is : A
13 1 4 B DESC CO1 E M 5
Create and explain the use of complex formulas in Excel
to calculate values, including the use of cell references
and functions.
14 1 4 C DESC CO1 An D 10
Demonstrate the use of various Excel functions to
perform calculations on data, providing examples of each
function and discussing their applications in real-world
scenarios
15 1 5 B DESC CO1 E M 5
Apply conditional functions in Excel to summarize data
that meets specific conditions and evaluate their
effectiveness.
16 1 5 C DESC CO1 E D 10
Design a series of conditional functions in Excel to
summarize data that meets specific criteria, explaining
the logic behind each function and demonstrating their
practical applications.
17 1 6 A OBJ CO1 R E 1
_____________ feature is NOT automatically provided
when you define a range as an Excel Table.

A. Automatic filtering B. Banded rows

C. Table name D. Chart creation

Answer is : D
18 1 7 A OBJ CO1 R E 1
_________ function is used to calculate the sum of a
range of cells in Excel.

A. SUM() B. AVERAGE()
C. COUNT() D. MAX()
Answer is : A
19 1 7 A OBJ CO1 R E 1
___________ functions will give you the average value
in a range.

A. MEDIAN() B. AVERAGE()
C. SUM() D. MODE()
Answer is : B
20 1 8 A OBJ CO1 R E 1
____________ feature in Excel allows you to assign a
name to a cell or range of cells

A. Conditional Formatting B. Data Validation

C. Named Range D. Data Table
Answer is : C
21 1 9 A OBJ CO1 R E 1
_____________ symbol is used to start a formula in
Excel.

A. + B. =
C. # D. @
Answer is : B
22 1 9 A OBJ CO1 R E 1
______________ function would you use to count the
number of cells that meet a specific condition.

A. COUNT() B. COUNTA()
C. COUNTIF() D. COUNTBLANK()
Answer is : C
23 1 9 A OBJ CO1 R E 1
To apply a predefined style to a PivotTable, you use the
_______.

A. Conditional Formatting B. Data Validation

C. PivotTable Styles D. Chart Tools

Answer is : C
24 1 10 A OBJ CO1 R E 1
_____________ function allows you to sum values
based on a condition.

A. SUMIF() B. SUM()
C. AVERAGEIF() D. SUMPRODUCT()
Answer is : A
25 1 10 A OBJ CO1 R E 1
To automatically run a macro when a workbook is
opened, you place the macro in the _______ event.

A. Workbook_BeforeSave B. Workbook_BeforeClose
C. Workbook_SheetChange D. Workbook_Open
Answer is : D
26 2 2 A OBJ What button would you use to make text bold in an Excel worksheet CO2 R E 1

A. Font Color B. Italic

C. Bold D. Underline

Answer is : C
27 2 2 A OBJ How can you apply a predefined style to a cell CO2 R E 1

A. Use the Format Painter B. Click Cell Styles on the Home tab

C. Manually adjust the font and color D. Use the Insert tab

Answer is : B
28 2 2 A OBJ PWhat is the purpose of a data label in Excel CO2 R E 1

To provide information about the data in a

A. To change the font of the cell B.
worksheet

C. To insert a picture into a worksheet D. To create a new worksheet

Answer is : B
29 2 2 A OBJ Which feature in Excel allows you to format a cell based on its value CO2 U M 1

A. Conditional Formatting B. Data Validation

C. AutoFilter D. Sorting

Answer is : A
30 2 2 A OBJ How can you save a custom theme in Excel CO2 R E 1

By selecting Save Current Theme in the

A. By using the Save As command B.
Themes group

C. By using the Format Painter D. By applying a predefined style

Answer is : B
31 2 2 A OBJ What is the function of the Format Painter in Excel CO2 R E 1

A. To insert a picture B. To format multiple cells manually

C. To copy the format of one cell to another D. To change the cell alignment

Answer is : C
32 2 2 A OBJ What is the purpose of a workbook theme in Excel CO2 U M 1

To apply a consistent look and feel across

A. To save the workbook B.
the workbook

C. To change the data values D. To insert a new worksheet

Answer is : B
33 2 2 A OBJ Which command would you use to create a filter in Excel CO2 R E 1

A. Sort & Filter B. Format Painter

C. Insert Picture D. Conditional Formatting

Answer is : A
34 2 2 A OBJ How can you define a new style in Excel CO2 R E 1

Use the New Cell Style option in the

A. Use the Format Painter B.
Styles group on the Home tab

C. Apply a predefined style D. Change the worksheet background

Answer is : B
35 2 2 A OBJ Which of the following tools helps in making the right edge of data bars easier to discern CO2 R E 1

A. Conditional Formattingg B. Solid fill pattern

C. Gradient fill pattern D. Data Validation

Answer is : B
36 2 2 B DESC CO2 R E 5
Describe the steps to create a custom number format in Excel
37 2 2 B DESC CO2 R E 5
How can you apply and modify conditional formatting rules in Excel

38 2 2 B DESC CO2 R E 5
What are the steps to insert and format a picture in an Excel worksheet

39 2 2 B DESC CO2 R E 5
Explain how to create a filter in Excel and its purpose

40 2 2 B DESC CO2 R E 5
Explain the purpose and benefits of using data labels in Excel worksheets

41 2 2 C DESC CO2 R M 10
Discuss with an examples of how styles can be applied to improve data management

42 2 2 C DESC CO2 R M 10
Provide detailed steps and examples of different types of conditional formats

43 2 2 C DESC CO2 R M 10
Disucss the role of data labels and annotations in creating meaningful Excel charts.
Describe how to add and customize these elements in a chart

44 2 2 C DESC CO2 R M 10
Elaborate on the process of creating and using filters and sorting in Excel to manage large
datasets. Provide an example

45 2 2 C DESC CO2 R E 10
Discuss in detail the various methods of formatting cells in Excel

46 3 1 A OBJ CO3 R E 1
___________is the primary benefit of sorting data in a
worksheet.

To highlight important To organize data in a specific

A. B.
information order
To merge cells for better
C. To format cells uniformly D.
visibility

Answer is : B
47 3 1 B DESC CO3 U M 5
Explain the process and benefits of sorting data in an Excel
worksheet.
48 3 1 C DESC CO3 Ap M 10
Describe the steps needed to combine multiple data sets into
one workbook in Excel.
49 3 2 A OBJ CO3 R E 1
__________ is NOT an option when sorting data in Excel

A. Sort by cell color B. Sort by cell icon

C. Sort by font size D. Sort by values
Answer is : C
50 3 2 B DESC CO3 U M 5
Describe the various lookup functions in Excel
51 3 2 C DESC CO3 U M 10
Explain how Vlookup, Hlookup, Index, and Match functions work
in Excel, and describe how they are different from each other.
52 3 3 A OBJ CO3 R E 1
In sorting data, __________ feature allows you to add multiple
levels of sorting

A. Sort Z to A B. Filter
C. Data Validation D. Custom Sort
Answer is : D
53 3 3 B DESC CO3 U M 5
Explain the process of combining data from multiple sources in
Excel.
54 3 3 C DESC CO3 U M 10
Discuss why using workbook templates in Excel is beneficial and
explain the steps to create and use a workbook template.
55 3 4 A OBJ __________ function would you use to find a value in a row. CO3 R E 1

A. VLOOKUP B. MATCH

C. HLOOKUP D. INDEX

Answer is : C
56 3 4 B DESC CO3 U M 5
How can you create and use a workbook template effectively?
57 3 4 C DESC CO3 Ap M 10
Describe how to link data between different worksheets and
workbooks in Excel, and explain the benefits of doing this.
58 3 5 A OBJ CO3 R E 1
__________ feature in Excel allows you to import data from an
external source such as a database or a web page

A. Power Query B. Solver

C. Data Validation D. Conditional Formatting
Answer is : A
59 3 5 B DESC CO3 Ap M 5
Explain the process of linking data between different worksheets
and workbooks in Excel.
60 3 5 C DESC CO3 Ap D 10
Explain how to combine data from multiple worksheets into a
single workbook in Excel. Provide an example to illustrate your
process
61 3 6 A OBJ CO3 R E 1
___________ is NOT a valid method to combine data from
multiple sources in Excel.

A. Copy and paste B. VLOOKUP

C. Power Query D. Transpose

Answer is : D
62 3 7 A OBJ CO3 R E 1
_________ file extension is used for Excel templates.

A. .xlsx B. .xlsm
C. .xltx D. .xltm
Answer is : C
63 3 8 A OBJ CO3 R E 1
________________ feature allows you to reference data in
another worksheet within the same workbook.

A. Cell referencing B. Data Validation

C. Conditional Formatting D. Hyperlink
Answer is : A
64 3 9 A OBJ CO3 R E 1
The correct way to reference cell A1 in a worksheet named
"Data" from another worksheet is _________________.

A. =A1!Data B. =Data!A1
C. Sheet(Data)!A1 D. =Data:A1
Answer is : B
65 3 9 A OBJ CO3 R E 1
To group data in Excel is choose through the way of
____________________.

A. Data > Group B. View > Group

C. Insert > Group D. Home > Group
Answer is : A
66 3 10 A OBJ CO3 R E 1
_________ consistent across multiple data ranges when using
the Consolidate tool.

A. Data types B. Number formats

C. Labels and layout D. Cell colors
Answer is : C
67 4 1 A OBJ __________ feature in Excel allows you to define alternative data sets within the same CO4 R E 1
workbook.

A. Data Validation B. Scenario Manager

C. Pivot Table D. Conditional Formatting

Answer is : B
68 4 1 B DESC CO4 U M 5
Explain how to use Scenario Manager in Excel to define and
manage different data sets. Provide an example of creating an
alternative data set.
69 4 1 C DESC CO4 Ap D 10
Explain how to define multiple alternative data sets in Excel and
analyze their combined impact on your worksheet. Provide an
example to illustrate your explanation.
70 4 2 A OBJ CO4 R E 1

______ tool in Excel helps find the required input value for a
formula to reach a specific result.

A. Solver B. Data Table

C. Forecast Sheet D. Goal Seek
Answer is : D
71 4 2 B DESC CO4 U M 5
What are local receptive fields and convolutional kernels in a
CNN, and how do they help in processing images?
72 4 2 C DESC CO4 Ap D 10
Describe how Goal Seek and Solver can be used in Excel for
making business decisions. Provide detailed examples of how
each tool can be applied in a business context.
73 4 3 A OBJ CO4 R E 1
_________ is the maximum number of cells that can be changed
in a single scenario in Excel.

A. 32 B. 128
C. 64 D. 255
Answer is : A
74 4 3 A OBJ _______________ is NOT a type of summary that can be created using Scenario Manager. CO4 R E 1

A. Scenario Summary B. PivotTable Report

C. Scenario PivotTable Report D. Descriptive Statistics

Answer is : D
75 4 3 B DESC CO4 Ap M 5
Outline the steps to create multiple scenarios in Excel and
explain how to switch between them.
76 4 3 C DESC CO4 An D 10
Analyze the process of creating a scenario summary report in
Excel and discuss its benefits. How does it help in comparative
analysis and decision-making?
77 4 4 B DESC CO4 Ap M 5
Explain how to use Solver in Excel to determine the best possible
solution for a problem with multiple constraints. Provide an
example of its use.
78 4 4 C DESC CO4 U D 10
Discuss how descriptive statistics in Excel are used for data
analysis. Provide examples of how these statistics can be
applied to interpret business data effectively.
79 4 5 A OBJ CO4 R E 1
In Goal Seek, _______ field is used to set the target value

A. Set cell B. By changing cell

C. To value D. Goal value
Answer is : C
80 4 5 B DESC CO4 U M 5
Discuss why it is important to create a 'Normal' scenario in Excel
before applying other scenarios. How does this help in analyzing
different scenarios?
81 4 5 C DESC CO4 An D 10
Compare and contrast the functionalities of Goal Seek and
Solver in Excel. In what types of scenarios would you use each
tool?
82 4 6 A OBJ CO4 R E 1
___________ tab contains the 'What-If Analysis' tools in Excel.

A. Home B. Insert
C. Formula D. Data

Answer is : D
83 4 7 A OBJ CO4 R E 1
____________ must be installed in Excel to use the Solver tool.

A. Power Pivot B. Analysis ToolPak

C. Solver Add-in D. Data Analysis ToolPak
Answer is : C
84 4 8 A OBJ CO4 R E 1
Excel handle multiple scenarios that change the same cell
_________________.
It applies the value from the
A. It averages the values B.
last applied scenario
C. It combines the changes D. It ignores all changes

Answer is : B
85 4 9 A OBJ CO4 R E 1
________________ can be analyzed using descriptive statistics
in Excel.

A. Data distribution B. Scenario outcomes

C. Solver solutions D. Chart data
Answer is : A
86 4 10 A OBJ CO4 R E 1
______________ is used to add a new scenario in Scenario
Manager.

A. Edit B. Add
C. Show D. Merge

Answer is : C
87 5 1 A OBJ CO1 R E 1
A key feature of PivotTables for analyzing data
dynamically is the ability to _______ fields.

A. Filter B. Sort
C. Drag-and-drop D. Highlight

Answer is : C
88 5 1 B DESC CO5 Ap M 5
Demonstrate how to filter, show, and hide data in a
PivotTable to focus on sales trends for the last quarter.
89 5 1 C DESC CO5 An D 10
Analyze the impact of filtering, showing, and hiding data
in a PivotTable on the clarity and focus of a sales
performance report.
90 5 2 A OBJ CO1 R E 1
To filter data in a PivotTable, you can use _______.

A. Charts B. Data Tables

C. Slicers D. Conditional Formatting
Answer is : C
 91 5 2 B DESC CO5 An M 5
Analyze the process and impact of changing the data
source in a PivotTable to ensure accurate data analysis.
92 5 2 C DESC CO5 C D 10
Design a modified PivotTable by changing its data source
and adding calculated fields to enhance the analysis of
financial data.
93 5 3 A OBJ CO1 R E 1
When editing a PivotTable, you can _______ the data
source to update the data.

A. Format B. Change
C. Hide D. Sort
Answer is : B
94 5 3 B DESC CO5 Ap M 5
Illustrate the steps to create a PivotTable from an
external data source such as an Access database or an
online CSV file.
95 5 3 C DESC CO5 E D 10
Explain the process of creating a PivotTable from an
external data source, detailing each step and the
benefits of integrating external data into Excel.
96 5 4 A OBJ CO1 R E 1
To create a PivotTable from external data, you must first
_______ the data into Excel.

A. Copy B. Sort
C. Filter D. Import
Answer is : D
97 5 4 B DESC CO5 An M 5
Examine a given macro's code to understand its
functionality and the tasks it automates in Excel.
98 5 4 C DESC CO5 C D 10
Describe the procedure for enabling and examining
macros in Excel, including the importance of macro
security settings.
99 5 5 A OBJ CO1 R E 1
Before you can run a macro in Excel, you need to
_______ macros in the settings.

A. Enable B. Disable
C. Format D. Edit
Answer is : A
100 5 5 A OBJ CO1 R E 1
To create or modify a macro, you typically use the
_______ editor.

A. Text B. Formula
C. VBA D. Data
Answer is : C
101 5 5 B DESC CO5 C M 5
Create a macro to automate formatting a range of cells
with specific styles and data validation rules.
102 5 5 C DESC CO5 Ap D 10
Implement a form control button in Excel that runs a
macro when clicked, and describe the steps and benefits
 of this automation.
103 5 6 A OBJ CO1 R E 1
To run a macro with a button click, you must assign the
macro to a _______.

A. Chart B. Cell
C. Form control button D. Worksheet
Answer is : C
104 5 7 A OBJ CO1 R E 1
To view the code of a macro, you open the _______.

A. Formula Bar B. PivotTable Options

Visual Basic for
C. D. Macro Recorder
Applications (VBA) editor
Answer is : C
105 5 9 A OBJ CO5 R E 1
To automatically run a macro when a workbook is
opened, you place the macro in the _______ event.

A. Workbook_BeforeSave B. Workbook_BeforeClose
C. Workbook_SheetChange D. Workbook_Open

Answer is : D
106 5 10 A OBJ CO5 R E 1
___________ a common action you can perform when
editing a PivotTable.

A. Merge Cells B. Add a Chart

C. Change the data source D. Apply Data Bars
Answer is : C