Alisha is preparing a financial report and needs to display the total sales amount. Which number format should she apply if she wants the value to display a currency symbol and two decimal places?

Mira is working on a spreadsheet and needs to adjust the formatting of some cells. She wonders, what is the keyboard shortcut to open the 'Format Cells' dialog box?

Neha is working on a spreadsheet and wants to make sure that the formatting of one cell is consistent with another. Which tool allows her to copy the formatting of one cell and apply it to another cell or range?

Arjun is working on a spreadsheet for his school project. He wants to make certain cells stand out by changing their background color. How can he change the background color of a cell?

Myra is designing a presentation and needs to ensure that the text in a tall cell of her slide starts at the very top. Which alignment option should she choose?

Aarush is managing a large spreadsheet for his school project. He wants to highlight the cells that contain scores above 80 to easily identify high performers. What is the primary purpose of 'Conditional Formatting'?

Akhil is preparing a presentation for his class and wants to show the decimal '0.5' as '50%' to make it easier for his classmates to understand. Which format should he select?

Mira is trying to create a budget spreadsheet in Excel. She knows that every formula she writes must begin with which character?

Ananya is managing a project and needs to calculate the total expenses recorded in cells A1 through A10 of her budget spreadsheet. Which formula would she use to find the total of these values?

In a spreadsheet, Sneha is working on a budget plan. She uses a formula to calculate the total expenses based on different categories. What is the difference between a Relative reference (A1) and an Absolute reference ( $$A$$ 1)?

Akhil is analyzing the sales data for his store, and he wants to find the highest sales figure recorded between the dates of B2 to B20. Which function should he use?

Tara is a student who has received grades in her math class for the last five tests, which are recorded in cells C1 to C5. Which formula correctly calculates the mathematical mean of her grades?

Siya is calculating the total cost of items in her shopping cart. She has the price of item A in cell A1 and the price of item B in cell B1. When she copies the formula =A1*B1 from cell C1 to C2 to calculate the total cost of another set of items, what does the formula become in cell C2?

Ananya is organizing her study materials and wants to refer to a range of pages in her textbook. Which symbol should she use to denote the pages from page 1 through page 10?

Naira is organizing her spreadsheet for a project. She needs to reference a cell that combines both a column and a row in a unique way. Which of these is a "Mixed Reference"?

Naira is baking cookies and needs to calculate the total number of cookies she will have. She plans to bake 2 batches of cookies, with each batch containing 5 cookies. What is the correct order of operations Excel follows when calculating =2+5*2?

Aanya is preparing a presentation in Excel and wants to emphasize some important points by making the text bold. Which shortcut should she use to achieve this?

Ria is designing a presentation and wants to make sure that the text in her slides looks perfect. Which option should she choose to align the text to the center of a cell?

Aanya is preparing a presentation in a spreadsheet application and wants to make a title that spans across several columns. Which option should she use to merge multiple cells into one?

Eesha is creating a report in a spreadsheet and wants to ensure that all the text in a cell is visible. Which option allows her to display the text on multiple lines within the cell?

Myra is preparing a report in Excel and wants to emphasize certain text by underlining it. Which option should she use to underline the text?

Aashi is creating a spreadsheet for her school project. She wants to ensure that the width of each column adjusts to fit the content she has entered. Which option should she choose to achieve this?

Alisha is designing a presentation and wants to make her text stand out in a cell. Which option allows her to rotate the text inside that cell?

During a presentation, Arjun needs to ensure that all the text in his PowerPoint slides fits neatly within the designated cells. Which option should he use to reduce the font size so the text fits inside a cell?

Aanya is a teacher who wants to highlight students' scores in her class. She wants to highlight the cells in her grade sheet where students scored more than 80 marks. Which option will help her achieve this?

Arjun is designing a presentation and wants to highlight certain text in a cell. Which option should he choose to change the text color inside that cell?

Riyaan is working on a spreadsheet for his school project and wants to make the data more visually appealing. Which option allows him to add borders around the cells?

Eesha is working on a spreadsheet for her school project. She wants to ensure that the height of the rows adjusts automatically to fit the content she has entered. Which option should she choose to achieve this?

Shortcut Keys in Excel – MCQ: Avyaan is working on an important project in Excel and needs to save his workbook. Which shortcut key should he use to save his work quickly?

Aanya is working on a project in Excel and needs to create a new workbook to organize her data. Which shortcut key should she use to create a new workbook?

Shortcut Keys in Excel – MCQ: Aashi is working on an important report in Excel and needs to print the worksheet quickly. Which shortcut key should she use to print the worksheet?

Shortcut Keys in Excel – MCQ: Anika is working on a project in Excel and needs to remove some data from her spreadsheet. Which shortcut key should she use to cut the selected cells?

Shortcut Keys in Excel – MCQ: Dia is working on a project in Excel and needs to duplicate some data. Which shortcut key should she use to copy the selected cells?

Shortcut Keys in Excel – MCQ: Krish is working on a report in Excel and needs to paste some data he copied from another document. Which shortcut key should he use to paste the copied or cut content?

Shaan is working on an important Excel spreadsheet for his project. He accidentally deleted a crucial formula and needs to revert his last action. Which shortcut key should he use to undo the last action?

Shortcut Keys in Excel – MCQ: Rohan was working on a spreadsheet in Excel and accidentally deleted a row of important data. He quickly wanted to redo the last undone action. Which shortcut key should he use to redo the last undone action?

Shortcut Keys in Excel – MCQ: Krish is working on a large spreadsheet in Excel and wants to quickly select the entire worksheet. Which shortcut key should he use?

Excel Charts & Graphs – MCQ: Siya is analyzing her sales data over the past year and wants to visualize the trends in her monthly sales. Which chart type is best for showing trends over time?

Excel Charts & Graphs – MCQ: Aanya is analyzing the sales data of her bakery and wants to present how much each type of pastry contributes to the total sales. Which chart is most suitable for comparing parts of a whole?

Excel Charts & Graphs – MCQ: Advait is analyzing the sales data of different products in his store. He wants to create a chart that best compares the sales values across various product categories. Which chart should he use?

Excel Charts & Graphs – MCQ: Myra is analyzing the relationship between the amount of time she studies and her exam scores. Which chart type is most useful for showing relationships between these two variables?

Excel Charts & Graphs – MCQ: Ishika is analyzing her sales data over the past year and wants to visualize how her total sales have accumulated over time. Which chart is best for showing cumulative data over time?

Excel Charts & Graphs – MCQ: Tisha is preparing a presentation for her team and wants to enhance her data visuals. Which Excel feature allows her to change chart colors, styles, and layouts quickly?

Excel Charts & Graphs – MCQ: Ishika is creating a presentation for her school project and wants to make her chart more informative. Which option allows her to add titles, labels, and legends to her chart?

Excel Charts & Graphs – MCQ: Ishika is creating a presentation for her school project and needs to visualize her data using a chart. Which option allows her to change the data range used in the chart?

Aarav is managing a project and wants to visually represent the team's progress toward their goal of completing a task. He is considering different chart types to show the completion percentage effectively. Which chart type is best for showing progress toward a single goal (e.g., completion percentage)?

Excel Charts & Graphs – MCQ: Shreya conducted a survey to understand the distribution of ages among her classmates. Which chart type is best for displaying the frequency distribution of the age data she collected?

Excel Charts & Graphs – MCQ: Aarush is analyzing stock market data for a company he is interested in, which includes the open, high, low, and close prices. Which chart type should he use to best visualize this data?

Excel Charts & Graphs – MCQ: Anika is analyzing her monthly expenses and income using Excel. She wants to create a chart that clearly shows her positive income and negative expenses. Which chart type is best for showing positive and negative values clearly?

Aanya is working on a financial report in Excel and needs to reference data from another worksheet. Which symbol should she use in her formulas to refer to that other worksheet?

Nikita is working on a financial report and needs to link a cell from another worksheet named Sales in the same workbook. Which formula should she use to correctly reference cell A1 from the Sales worksheet?

Avni is working on a financial report in Excel that links data from another workbook. One day, she realizes that the linked workbook is closed. What happens to the data in her report?

Eshaan is working on a financial report that requires data from another workbook. He needs to link a specific cell from that workbook to his current sheet. Which of the following is the correct syntax for linking a cell from another workbook?

Avni is working on a spreadsheet where she has created a linked formula in one cell. If she copies this linked formula to another cell, what happens?

Ria is working on a financial report in Excel and wants to share the data with her team without including any formulas. Which option in Paste Special allows her to paste only the values without formulas?

Sanya is working on a presentation and wants to apply the same formatting from one slide to another without copying the content. Which Paste Special option should she use to paste only the formatting of the copied slide?

Arjun is working on a financial report in Excel and needs to copy some formulas from one sheet to another. He wants to ensure that the formatting of the destination cells remains unchanged while pasting the formulas. Which Paste Special option should he choose?

Ananya is organizing a data report in her spreadsheet. She needs to rearrange the data so that the rows become columns and the columns become rows. Which Paste Special option should she use to achieve this?

Neha is analyzing a large dataset in Excel and needs to organize her data efficiently. Which tab in Excel contains the Filter and Sort options that she should use?

Viaan is organizing a list of his favorite books and wants to arrange them in alphabetical order from A to Z. Which option should he choose to sort the data alphabetically?

Aanya is organizing a charity event and has a list of donations received. She wants to display the donations in order from the largest to the smallest amount. Which option allows her to sort the data numerically from largest to smallest?

Aditi is organizing a company event and needs to arrange the guest list. She wants to sort the guests first by Department, and then by Name. Which feature allows her to apply multiple sorting levels?

Ria is analyzing a dataset of sales figures and wants to find all transactions that exceeded a certain amount. Which filter option allows her to filter numbers greater than a specific value?

Aarav is working on a data analysis project in a spreadsheet application. He has applied several filters to his worksheet to view specific data. However, he now wants to see all the data again without any filters. Which option allows him to clear all filters applied to the worksheet?

Aanya is organizing a charity event and has a list of participants with their names, ages, and donation amounts. She wants to sort this list by both age and donation amount to prioritize the participants. Which option allows her to sort data by multiple columns at once?

Rohan is analyzing a list of customer orders for his online store. He wants to ensure that there are no duplicate entries in the list. Which option allows him to filter out duplicate values?

Tisha is analyzing sales data for her store and wants to identify the top 10 selling items from her inventory. Which option allows her to filter these top 10 items in the list?

Aisha is analyzing sales data in Excel and wants to summarize it using a Pivot Table. Which tab in Excel should she go to in order to insert a Pivot Table?

Aditi is a data analyst at a marketing firm. She needs to present the sales data from the last quarter to her team. What is the primary purpose of a Pivot Table in her analysis?

Aashi is analyzing her monthly expenses using a Pivot Table. She wants to know which area of the Pivot Table is used to display numeric calculations like sums or averages of her spending.

Aashi is analyzing sales data for her online store using a Pivot Table. She wants to categorize the data horizontally to compare different product categories. Which Pivot Table field area should she use?

Saisha is analyzing her sales data and wants to create a graphical representation of her Pivot Table to better understand her sales trends. Which feature should she use?

Shaan is analyzing sales data for different product categories using a Pivot Table. He wants to visually compare the sales figures across these categories. Which type of chart should he use to best represent this comparison?

Tisha wants to secure her financial report in Excel. Which option allows her to set a password to open the file?

Kavya wants to ensure that her financial worksheet is secure and only she can make changes to it. Which option should she use to restrict editing of the worksheet with a password?

Aarush is working on a financial report in Excel and wants to ensure that no one can make structural changes to the workbook, such as adding or deleting sheets. Which option should he use to protect the workbook?

During a team project, Anika wants to ensure that only certain cells in their shared spreadsheet can be edited by her teammates. Which feature allows her to lock specific cells before applying sheet protection?

Sanya is working on a financial report in Excel and decides to protect the worksheet to prevent accidental changes. However, she forgets to unlock certain cells that contain important data. What happens if she protects the worksheet without unlocking those cells?

Ananya is working on a sensitive financial report in Excel and wants to ensure that no one can access it without permission. Which option allows her to encrypt the Excel file with a password for maximum security?