Question
a) Write an Excel formula, in the specific order that follows, to multiply the following: The sum of 5, 8 & B3 The mean of
a) Write an Excel formula, in the specific order that follows, to multiply the following:
The sum of 5, 8 & B3
The mean of 6, 9 & 12
35
Do not include spaces in your answer.
Ensure that if this formula were to be copy and pasted into a working spreadsheet that the correct value would be produced.
b) Write the Excel formula, in the specific order that follows, for the average of:
4
The sum of 6 and B7
A3 Do not include spaces in your answer.
Ensure that if this formula were to be copy and pasted into a working spreadsheet that the correct value would be produced.
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