First look at Excel book1 and then answer the following questions: (16). Microsoft Excel Book1 File Edit View Insert Format Tools Data Window Help Nitro Pro 8 00130/74* 40 5 2 . 41 %1 L ~ 100% F4 A B D E G H Math Physics English Accounting Computer Average Percentage Grade Name 2 Zoosha 70 55 80 70 90 Kamil 40 70 45 50 60 3 90 95 85 90 90 4 Anum 5 Saba 75 55 80 60 50 Adnan 80 70 90 65 80 6 What is the formula to determine the total number of subjects? What is the formula to determine the obtained marks of Adnan? Write the address of the active cell in the above Excel sheet. Write down a formula to compute the average of Saba. Write a formula to calculate the grade of Zoosha. How to insert a cell in a worksheet? How to expand a cell in a worksheet? Write a formula to find the minimum marks in column E.
The Correct Answer and Explanation is:
Of course, here are the correct answers to the questions based on the provided Excel sheet, along with a detailed explanation.
Correct Answers
i. What is the formula to determine the total number of subjects?
=COUNTA(B1:F1)
ii. What is the formula to determine the obtained marks of Adnan?
=SUM(B6:F6)
iii. Write the address of the active cell in the above Excel sheet?
F4
iv. Write down a formula to compute the average of Saba.
=AVERAGE(B5:F5)
v. Write a formula to calculate the Grade of Zoosha.
=IF(G2>=80, “A”, IF(G2>=70, “B”, IF(G2>=60, “C”, “D”)))
(Note: This assumes a standard grading scale, as one is not provided.)
vi. How to insert a cell in a worksheet?
Right-click on a cell, select “Insert…” from the menu, and then choose whether to shift existing cells down or to the right.
vii. How to expand a cell in a worksheet?
To expand a cell’s width, move your cursor to the boundary line between the column letters at the top and drag it to the right. To expand its height, drag the boundary line between the row numbers on the left.
viii. Write a formula to find the minimum marks in column C.
=MIN(C2:C6)
Explanation
Here is a breakdown of the logic behind each answer, providing context for the Excel functions and procedures mentioned.
i. To find the total number of subjects, we count the cells containing the subject names. These are located in the range from cell B1 to F1. The COUNTA function is ideal for this because it counts all cells in a range that are not empty.
ii. To calculate the total obtained marks for a student, you must add up the scores from all subjects. Adnan’s marks are listed in row 6, from column B through column F. The SUM function in Excel adds all the numbers in a specified range of cells, making =SUM(B6:F6) the correct formula.
iii. The active cell is the currently selected cell in a worksheet, indicated by a thick black border. In the image, the cell at the intersection of column F and row 4 has this border. The cell’s address is also displayed in the Name Box, which is located to the left of the formula bar, confirming it is F4.
iv. To find the average of Saba’s marks, we use the AVERAGE function. This function calculates the arithmetic mean of its arguments. Saba’s scores are in row 5, across cells B5 to F5. The formula =AVERAGE(B5:F5) will correctly compute her average score.
v. Calculating a grade requires conditional logic, which is handled by the IF function. Since no grading scale is given, a common scale is assumed. The formula checks Zoosha’s average score in cell G2 and assigns a letter grade based on that value. It checks the highest condition first and proceeds downward.
vi. Inserting a cell is a basic worksheet modification. The most direct method is using the right-click context menu, which provides options to shift the surrounding cells to make space for the new one.
vii. “Expanding a cell” typically refers to increasing its visible size by adjusting the column width or row height. This is done by clicking and dragging the boundaries of the respective column or row headers.
viii. To find the lowest value in a set of data, you use the MIN function. The question asks for the minimum marks in column C, which contains the Physics scores. The range for these scores is C2 through C6, so the formula =MIN(C2:C6) will identify and return the lowest number in that list.
