Mastering Excel Basics

Naira is trying to calculate the total amount of money she has saved in her piggy bank. She has saved the amount in cell A1 and the amount in cell A2. What formula would she use to add the values in cells A1 and A2?

• =A1 - A2

• =A1 * A2

• =A1 + A2

• =SUM(A1,A2)

Aditi is trying to find out the average score of her last 10 math tests in Excel. How does she calculate the average of a range of cells in Excel?

• Count the cells with =COUNT(A1:A10).

• Use the SUM function, e.g., =SUM(A1:A10).

• Calculate the median with =MEDIAN(A1:A10).

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10).

Vanya is analyzing the scores of her classmates in a recent math test. She wants to find out which student scored the highest. Which function would she use to find the maximum value in the range of scores?

• MIN

• SUM

• MAX

• AVERAGE

Neha is trying to determine if she has passed her math exam. She wants to use the IF function in Excel to evaluate her score and return different messages based on whether her score is above or below the passing mark.

• To evaluate a condition and return different values based on whether the condition is true or false.

• To calculate the sum of a range of cells.

• To create a chart from data in a worksheet.

• To format cells based on their values.

Krish is trying to reference a cell in another worksheet for his project. How does he do it?

• Use 'SheetName.CellReference' format.

• Reference cells by 'CellReference@SheetName' syntax.

• Use 'SheetName!CellReference' format.

• Use 'CellReference:SheetName' format.

Sanya is working on a project in a spreadsheet and wants to add a new line within a cell to separate her notes. What keyboard shortcut should she use?

• Ctrl + Enter (Windows) / Command + Enter (Mac)

• Shift + Enter (Windows) / Shift + Return (Mac)

• Alt + Enter (Windows) / Option + Enter (Mac)

• Alt + Shift + Enter (Windows) / Option + Shift + Enter (Mac)

Eesha is analyzing her monthly expenses and wants to highlight any amounts greater than 100. How can she apply conditional formatting to highlight those cells?

• Select cells, go to Data > Sort > Sort Largest to Smallest.

• Select cells, go to Home > Conditional Formatting > New Rule > Format cells that contain > greater than > 100 > choose format > OK.

• Right-click on the cells and choose Format Cells > Number > Custom > OK.

• Select cells, go to Home > Conditional Formatting > Clear Rules > All Rules > OK.

Avyaan is analyzing the scores of his classmates in a math test. He wants to count how many students scored a number greater than zero. What is the formula to count the number of cells that contain numbers in the range of scores?

• SUM(range)

• AVERAGE(range)

• COUNT(range)

• MAX(range)

Akhil is trying to calculate the total cost of items he wants to buy. If the price of item B is in cell B1 and the quantity he wants to buy is in cell C1, how does he create a formula that multiplies the values in cells B1 and C1?

• =B1-C1

• =B1*C1

• =B1/C1

• =B1+C1

Ananya is working on a project where she needs to combine the names of her team members from different cells in a spreadsheet. What is the function she should use to concatenate text from multiple cells?

• CONCATENATE or &

• APPEND

• MERGE

• JOIN