Cyber Olympiad Class 10 - Sample question paper 08

Q1. In Microsoft Excel, what function is used to count the number of cells that contain numbers within a specified range?

a) COUNTIF

b) SUMIF

c) AVERAGEIF

d) MAXIF

Q2. What is the purpose of the VLOOKUP function in Excel?

a) Vertical Lookup

b) Value Lookup

c) Variable Lookup

d) Vertical Linkup

Q3. What does the term "cell reference" in Excel mean?

a) The location of the cell in the worksheet

b) The content of the cell

c) The formatting applied to the cell

d) The function applied to the cell

Q4. In Excel, what function is used to find the largest value in a range?

a) MAX

b) LARGE

c) MAXIMUM

d) BIG

Q5. What is the purpose of the "PivotTable" feature in Excel?

a) To create data visualizations

b) To filter data based on criteria

c) To summarize and analyze data

d) To perform mathematical calculations

Q6. What does the term "data validation" refer to in Excel?

a) Verifying the accuracy of data

b) Restricting data entry to a specific set of values

c) Validating data sources

d) Cleaning up data inconsistencies

Q7. Which Excel function is used to calculate the future value of an investment based on a constant interest rate?

a) FV

b) PV

c) NPV

d) RATE

Q8. What is the purpose of the "IF" function in Excel?

a) To format cells based on a condition

b) To perform calculations on a range of cells

c) To insert comments in cells

d) To make decisions based on a condition

Q9. What does the term "freeze panes" mean in Excel?

a) Locking cells to prevent editing

b) Keeping selected rows or columns visible while scrolling

c) Applying a special formatting to cells

d) Creating a backup of the worksheet

Q10. In Excel, what is the purpose of the "PMT" function?

a) To calculate the payment for a loan

b) To perform matrix transformations

c) To generate a payment receipt

d) To measure project management tasks

Q11. How can you remove duplicate values from a column in Excel?

a) Use the DELETE key

b) Apply the "Remove Duplicates" feature

c) Filter and manually delete duplicates

d) Sort the column in ascending order

Q12. What does the term "conditional formatting" mean in Excel?

a) Automatically adjusting cell size based on content

b) Applying formatting based on specified conditions

c) Formatting cells containing formulas

d) Customizing the appearance of the ribbon

Q13. What is the purpose of the "Goal Seek" feature in Excel?

a) To set goals for data validation

b) To seek information from online sources

c) To find a specific value by adjusting another value

d) To search for formulas in the worksheet

Q14. What does the term "sparkline" refer to in Excel?

a) A small-sized cell in a worksheet

b) A type of data validation

c) A tiny chart embedded in a cell

d) A special type of hyperlink

Q15. What Excel feature is used to create dynamic and interactive reports by linking multiple tables?

a) Data Validation

b) Power Query

c) Data Consolidation

d) Power Pivot

Q16. In Excel, what does the "PivotChart" feature allow users to do?

a) Create dynamic charts linked to PivotTables

b) Generate random charts for analysis

c) Plot 3D charts in Excel

d) Design pie charts with customized colors

Q17. How can the "Scenario Manager" in Excel be utilized?

a) To manage file scenarios in different folders

b) To create and compare different sets of input values

c) To organize charts and graphs in a worksheet

d) To schedule automated scenarios based on time

Q18. What Excel function is suitable for calculating the standard deviation of a sample?

a) STDEVP

b) STDEV

c) STDEV.S

d) VAR.S

Q19. How does the "What-If Analysis" feature in Excel assist users?

a) By automatically correcting formula errors

b) By suggesting alternate data input options

c) By analyzing and forecasting potential outcomes

d) By generating random scenarios for testing

Q20. What is the purpose of the "Watch Window" in Excel?

a) To monitor and display formulas in a separate window

b) To track changes made by multiple users in a shared workbook

c) To display a watchlist of frequently used functions

d) To create a visual timeline for data analysis

Q21. What does the Excel function "HLOOKUP" stand for?

a) Horizontal Lookup

b) Highlight Lookup

c) Header Lookup

d) High-Level Lookup

Q22. In Excel, what is the purpose of the "Data Table" feature?

a) To create a table of data entries

b) To analyze and compare multiple sets of data

c) To manage data connections with external sources

d) To organize data into a structured format

Q23. What Excel feature can be used to filter data based on specific criteria?

a) Data Sorting

b) Data Validation

c) AutoFilter

d) Data Consolidation

Q24. What Excel function is used to calculate the internal rate of return (IRR) of a series of cash flows?

a) IRRATE

b) IRR

c) RATE

d) NPV

Q25. How can you apply a custom sort order to data in Excel?

a) Use the "Sort" button on the Home tab

b) Create a pivot table and use the "Sort" option

c) Define a custom list in the "Sort" dialog box

d) Apply the "Ascending" or "Descending" sort order

Q26. In Excel, how can the "Data Validation" feature be used to create a dropdown list?

a) Enter a list of values directly into the cell

b) Use the "Dropdown" function on the Home tab

c) Apply the "Data Validation" feature with a list source

d) Enable the "List" option in the cell properties

Q27. What does the "Consolidate" feature in Excel allow users to do?

a) Combine data from multiple worksheets or workbooks

b) Split data into separate worksheets

c) Validate data entries for consistency

d) Compare data across different cells

Q28. How can you prevent others from making changes to a specific range of cells in Excel?

a) Use the "Protect Sheet" feature

b) Apply a password to the entire workbook

c) Set cells to read-only in the "Cell Format" options

d) Convert the range to an Excel table

Q29. In Excel, what is the purpose of the "Text to Columns" feature?

a) To split text into multiple columns based on a delimiter

b) To merge cells containing text

c) To apply different text formats to a range

d) To create a hyperlink from selected text

Q30. What does the "Transpose" option in Excel do when applied to a range of cells?

a) Converts numbers to text

b) Switches rows and columns

c) Changes cell formatting

d) Highlights duplicate values