Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following (2 marks each 10 marks) If A1 15, B1 100, C1 200 Formula Calculate the product of 15 and 100 2 marks Calculate the average of 15, 100, 200 2 marks Calculate the highest number of 15,100, 200 2 marks Calculate the difference of 200 and 100 2 marks Calculate the lowest number of 15, 100, 200 2 marks

The Answer is in the image, click to view ...

Question: Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following: (2 marks

Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following: (2 marks each = 10 marks)

If A1=15, B1=100, C1=200

	Formula
Calculate the product of 15 and 100		2 marks
Calculate the average of 15, 100, 200		2 marks
Calculate the highest number of 15,100, 200		2 marks
Calculate the difference of 200 and 100		2 marks
Calculate the lowest number of 15, 100, 200		2 marks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Calculate Z. HR. and SR by the Redlich / Kwong equation for one of the following, and compare results with values found from suitable generalized correlations: (a) Acetylene at 300 K and 40 bar. (b)...

1 . Describe the two major kinds of software ( Chapter 1 ) . ( 4 marks ) 2 . Describe two types of system software programs ( Chapter 1 ) . ( 4 marks ) 3 . Define and compare general - purpose...

. Create a hierarchical table identifying the three main categories of software and their subcategories. (17 marks) 3. List and describe the four pricing models commonly used in the software...

Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following: (2 marks each = 10 marks) If A1=5, B1=10, C1=20...

Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Give the typing rules for Peano natural numbers and their eliminator.(ii) Using the rules given above, define the addition function.] (iii) Let a binary tree be either a leaf Leaf or a node...

Microkernel operating systems aim to address perceived modularity and reliability issues in traditional "monolithic" operating systems. (i) Describe the typical architecture of a microkernel...

Hello, I really need some help here. The instructions are on the bottom page. Please start reading from top to bottom. I have 24 hours to submitted. AutoSave . OFF 1 Flexible budget project_Student...

Giving a suitable example, explain the effect in C++ of qualifying a member function (method) with virtual. [3 marks] (e) Recode the following Java code in C++. Minor syntactic errors will not be...

123 Compare the purely graphical properties of these two notations, and the ways in which the graphical properties of each display correspond to the information structure being defined. Describe...

2. Consider the following linear programming problem: Maximise subject to Z = 3x1 + x2 X1 X2 1 -x1-x-3 2x1 + x 4 x1 0, X 0. (a) Solve the problem using two-phase simplex method. (b) Solve the...

Journal Instructions A Chapter 10 describes how liberal ideology justifies the wealth and income inequality embedded in our economic system. Ideology is defined by your textbook as: "A body of...

A company finances its operations with 4 0 % debt and 6 0 % equity. It s net income is I = R 1 6 0 0 0 0 0 0 and it has a dividend payout ratio of ( x = 2 5 % ) . It s capital budget is ( B = R 1 5 0...

The table below shows actual and forecasted numbers of accounts serviced by a company. Compute MAD, MSE, and MAPE for the following data, showing actual and forecasted numbers of accounts serviced. (...

understand the issues relating to equality of opportunity in the workplace

explain the practical implications of the equality legislation with regard to recruitment and selection.

4. What are the pros and cons for zero hours contracts for employees? Do you agree with certain commentators who believe they should be made illegal?