1. Which of the following options allows you to apply a set of predefined formatting options to a cell or range of cells in Excel?

A. Cell Styles
B. Data Validation
C. Conditional Formatting
D. Filter

2. To display multiple sheets at once, which view can be used in Excel?

A. Page Break Preview
B. Normal View
C. Split
D. Page Layout View

3. What is the primary function of a Pivot Table in Excel?

A. Formatting cells
B. Summarizing data
C. Creating charts
D. Sorting data

4. Which of the following is NOT a step in recording a macro in Excel?

A. Naming the macro
B. Setting the macro to run on start-up
C. Performing the actions to be recorded
D. Saving the macro

5. What is the primary use of a macro in Excel?

A. To perform complex calculations
B. To automate repetitive tasks
C. To create charts
D. To sort data

6. Which function is used to find the largest value in a range of cells in Excel?

A. MIN
B. MAX
C. SUM
D. AVERAGE

7. What does the VLOOKUP function do in Excel?

A. Looks up a value in a vertical table
B. Looks up a value in a horizontal table
C. Looks up the smallest value
D. Looks up the largest value

8. Which logical function returns TRUE if all its arguments are TRUE?

A. OR
B. AND
C. NOT
D. IF

9. What financial function would you use to calculate the monthly payment for a loan in Excel?

A. PMT
B. FV
C. PV
D. NPV

10. What is an Excel add-in?

A. A built-in function
B. An external tool that adds extra features
C. A formatting style
D. A type of chart

11. Which of the following can be used to integrate internet data into Excel?

A. Data Validation
B. Text to Columns
C. Web Query
D. Sparklines

12. What is the primary benefit of using Conditional Formatting?

A. Changing the structure of a worksheet
B. Highlighting important data trends
C. Creating charts
D. Protecting a worksheet

13. What view should be used to display only the parts of the worksheet that you want to print?

A. Normal View
B. Page Break Preview
C. Custom View
D. Page Layout View

14. How can you execute a recorded macro?

A. By pressing F4
B. By navigating to the Data tab
C. By clicking on the macro button in the Developer tab
D. By selecting the macro from the Insert tab

15. What is the purpose of using Lookup functions in Excel?

A. To find and retrieve specific data
B. To perform arithmetic operations
C. To format cells
D. To create data tables

16. What does the IF function in Excel allow you to do?

A. Perform basic arithmetic operations
B. Make logical comparisons
C. Format cells conditionally
D. Create charts

17. Which of the following is a logical function that returns the opposite of a given logical value?

A. AND
B. OR
C. NOT
D. IF

18. How do you calculate the future value of an investment in Excel?

A. PV function
B. FV function
C. PMT function
D. NPV function

19. Which add-in can be used for statistical analysis in Excel?

A. Solver
B. Analysis ToolPak
C. Euro Currency Tools
D. Power Pivot

20. What is the primary benefit of using Excel with internet data?

A. Automated data entry
B. Enhanced data visualization
C. Access to real-time data
D. Improved data security