Advanced Excel
Unit – I
Section – A
Which of the following is the correct way to enter data into an Excel cell?
A. Double-click the cell and start typing
B. Select the cell and press the F2 key
C. Click the cell and type the data
D. All of the above
What keyboard shortcut allows you to quickly enter the current date in a cell?
A. Ctrl + D
B. Ctrl + T
C. Ctrl + ;
D. Ctrl + '
Which method is used to move data from one cell to another in Excel?
A. Drag and drop
B. Cut and paste
C. Copy and paste
D. Both A and B
To quickly move a selected cell range to a different location using the keyboard, which
combination of keys would you use?
A. Ctrl + X, then Ctrl + V
B. Ctrl + C, then Ctrl + V
C. Ctrl + Z, then Ctrl + Y
D. Ctrl + A, then Ctrl + B
What 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
Which of the following can you NOT do with the Find and Replace feature?
A. Find specific text
B. Replace all occurrences of specific text
C. Format cells based on found text
D. Change the sheet name
Which of the following options is used to correct data in a cell?
A. Double-click the cell and edit directly
B. Use the formula bar to edit
C. Press F2 to edit the cell content
D. All of the above
Which feature allows you to add additional information to cells in Excel?
A. Comments
B. Conditional Formatting
C. Data Validation
D. Macros
How do you convert a range of data to an Excel Table?
A. Select the range, go to the Insert tab, and click Table
B. Select the range, right-click and choose "Format as Table"
C. Select the range, go to the Data tab, and click Table
D. Select the range, press Ctrl + T
Which 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
Which function is used to calculate the sum of a range of cells in Excel?
A. SUM()
B. AVERAGE()
C. COUNT()
D. MAX()
Which of the following functions will give you the average value in a range?
A. MEDIAN()
B. AVERAGE()
C. SUM()
D. MODE()
What 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
How can you create a named range in Excel?
A. Use the Name Manager
B. Define Name from the Formulas tab
C. Use the name box next to the formula bar
D. All of the above
Which symbol is used to start a formula in Excel?
A. +
B. @
C. =
D. #
Answer: C. =
How do you refer to cell A1 in a formula?
A. $A1$
B. A1
C. @A1
D. #A1
Which function would you use to count the number of cells that meet a specific condition?
A. COUNT()
B. COUNTA()
C. COUNTIF()
D. COUNTBLANK()
Which function allows you to sum values based on a condition?
A. SUMIF()
B. SUM()
C. AVERAGEIF()
D. SUMPRODUCT()
What does Excel display in a cell if there is a divide-by-zero error?
A. #NAME?
B. #REF!
C. #DIV/0!
D. #VALUE!
Which tool helps you find and correct errors in formulas?
A. Trace Error
B. Data Validation
C. Goal Seek
D. Solver
Section B (5 Mark Questions)
1. Explain the different techniques for moving data within an Excel workbook and
analyze their effectiveness in various scenarios. (Analysis)
2. Discuss the steps involved in using the Find and Replace feature in Excel, and
evaluate its usefulness in data management. (Evaluation)
3. Create an Excel Table from a given range of data and explain the benefits of using
tables for data management. (Evaluation)
4. Demonstrate how to use basic Excel functions to perform calculations on data,
and explain their importance in data analysis. (Application)
5. Create and explain the use of complex formulas in Excel to calculate values,
including the use of cell references and functions. (Evaluation)
6. Apply conditional functions in Excel to summarize data that meets specific conditions
and evaluate their effectiveness. (Evaluation)
7. Describe and demonstrate the methods for entering and revising data in Excel.
(Application)
8. Identify and describe the methods for correcting and expanding upon worksheet data in
Excel, providing examples. (Knowledge)
9. Explain the process of naming groups of data in Excel and analyze the advantages of
using named ranges in formulas. (Analysis)
10. Identify common calculation errors in Excel, describe the tools available for error
correction, and explain how to troubleshoot these errors. (Knowledge)
Section C (10 Mark Questions)
1) Develop a comprehensive guide on various methods for entering and revising
data in Excel, including a discussion on best practices and common pitfalls.
(Synthesis)
2) Create a step-by-step tutorial on how to effectively use the Find and Replace
feature in Excel, including advanced options and practical examples.
(Application)
3) 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. (Comprehension)
4) 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. (Application)
5) 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. (Synthesis)
6) Write a detailed procedure for moving data within a workbook in Excel, including
the use of both mouse and keyboard shortcuts, and evaluate the efficiency of each
method. (Evaluation)
7) Analyze different methods for correcting and expanding worksheet data in Excel,
providing examples and explaining the benefits of each method. (Analysis)
8) Evaluate the importance of naming groups of data in Excel, describing the steps to
create and manage named ranges, and illustrating their use in complex formulas.
(Evaluation)
9) Construct complex formulas in Excel to calculate values, explaining each component
of the formula and providing examples of how these formulas can be used to solve
specific problems. (Synthesis)
10)Identify common errors in Excel calculations, explain the tools available for finding
and correcting these errors, and provide strategies for troubleshooting and
resolving them effectively. (Analysis)
