Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A3.1 Write appropriate formulae for each question in the correct format based on the Excel table given. Use appropriate cell referencing where applicable. Sl. No.
A3.1 Write appropriate formulae for each question in the correct format based on the Excel table given. Use appropriate cell referencing where applicable. Sl. No. Name Do Our Mid Final A nt Test Mark Resul mahmood ELC 4 ahmed ELC 10 11 3812 17 19 Write the formula to display the Average Mid. Use appropriate cell referencing. A3.2 Write the formula to 2 calculate Total Marks Marks in cell H3 Total Marks= (Quiz + Mid + Final+ Assmnt) A3.3 Write the formula to 3 display Result in cell Marks 13 \f Total Marks is more than 60, display Result as "PASS" otherwise display "FAIL". 1 Mark A3.4 Write the formula to calculate the Factorial of 10. 1 Mark A3.5 Write the formula to display the Highest mark in Final. Use appropriate cell referencing. 1 Mark A3.6 Write the formula to find the sign of the number -47.891 1 Mark A3.7 Write the formula to display current date. B2.1 Write appropriate formulae for each question in the correct format based on the Excel table given. Use appropriate cell referencing where applicable. Internet C afe Duration D o m 20-04-18 304 0419334 20-04-13 323 20-04-28 379 2 ARNOLD ANTHONY DENZEL UA 15 34 13 20200422399 ROBERTS Write the formula to find the total duration in hours of "computer no. 15". Use appropriate cell referencing. B2.2 Write the formula to 2 count the no of entries Marks with the amount">600". Use appropriate cell referencing. B2.3 Write the formula to display the second (2nd) Marks smallest amount. Use appropriate cell referencing. B2.4 Write the formula to find 2 Marks 97. B2.5 Write the formula to 1 round the number in cell Mark D7 to the nearest EVEN integer. Use appropriate cell referencing. B2.6 Write the steps to rename sheet2. Mark
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started