write algorthim for ms excel 2077
Answers
Explanation:
Enter a formula that contains a built-in function
Select an empty cell.
Type an equal sign = and then type a function. For example, =SUM for getting the total sales.
Type an opening parenthesis (.
Select the range of cells, and then type a closing parenthesis).
Press Enter to get the result.
You create an algorithm by scribbling the ideas in paper.
Two ways to implement it
You design a model with one or more formulae to process the data, so you need to plan what order to do the calculations.
Or
Write a program in VBA to process the data in the cells.
You can do a lot with the first method but you may end up with a house of cards they lets you down with the slightest of errors.
The second method lets you think like a programmer, but also depends on no one messing with the data.
And you can combine both approaches
I don't know how to write but the following are steps to create algorithm for Ms Excel :-
Problem Definition Phase: Know all the phases of the problem, as far as you can, to do this, you need to search what is X, learn about it, learn more and more about your enemy (the problem).
Last Solutions Phase: In the last phase you searched for “what is X”, now we will search for “what are the possible solutions for X”, we will search for that in order to know, what did great people do so far, search alot, read papers, search for conferences, collect as many solutions and as newest solutions as you can, study them will, compare them, understand them.
The Fork Phase: Now, you had learnt about the problem and its most recently solutions, ask your self, do you think “I need” or “I can” make better ? if you can be satisfied with one of the most recently developed solutions, then we are done, if not continue.
Archimedes Eureka Phase: This is the last and longest phase, here, you need to start thinking about a solution wich is faster than or better than the others, you may use one of them also and complete it, or you may use it as a reference, but this phase really don’t have a typical way to go through it, as you know, Archimedes had discovered the floating principle just by chance, the same lot of inventions and discoveries, you just have you, yourself, your mind, the nature and the luck to invent the algorithm wich is the last phase in the algorithm of creating your algorithm.