6 hours 3 minutes
except for standard text that you can type in a cell.
There are some things that you might want to put in in your Excel sheet, especially if you're doing some math calculation to explain better
the formulas using.
And you want them displayed in
typical math four month. Or you just want to add some symbols into your
ah cells or
somewhere on your Excel sheet, which are not typical characters that you can just type in a cell.
So in that case, you could insert symbols and equations, and if we go again to the insert tab
and go to the symbols, you get all these symbols that you can insert. So why would you want to do that? Typical thing is
that here you do the some offer revenue for a week,
and for some reason you don't want to put
in a cell a nine, the total
or total revenue.
You just want to put the Greek symbol for some sigma,
and you just wanted there.
So you want to insert symbol. You click on symbol
if you can insert
and is there. So some people preferred this type of four months. Then, too right total something
or you have a situation in which you want to add something like
he won't insert toe insert. Ah, symbol here.
Ah, that represents the currency.
So, for example,
found British pound.
So this will tell you that this is some off revenue and it's in British pounds,
so all these symbols can be found here. Ondas, You see some of a ll. These symbols can be placed within that cell so they don't need a special object to be placed there.
Now, for example,
you want to put the equation in your table that will explain
something about what you're doing here. So, for example, let's take a typical,
physics. Like kinetic energy is equal mass times the speed squared, divided by two.
So you go to these equations
and you have the option to insert the equation
and you will say e
And then you can add
things like uh,
X Y fraction,
for example, something like
And then you can edit this so you can say M
divided by two
and then you can make it bigger,
You can, uh,
increased the front
and then here you can select these and say OK, I wanted to be a sub script because that's the way to write it.
And I want to this one to be
And now we have
the regular formula like it is supposed to be written
and it can be placed when there were you
want. And you can
do it to be moved with cells or not moved, and it can be locked. You can lock, text or unlock it
and everything you would like to do
with the formula
in order to make it sit where you want it.
So if you go again to the insert Anglican,
this arrow here
you have quite a nice collection off predefined formulas
that you can
and you can modify them in the way that you like.
So we're just going to do one undo and another one
because we inserted that formula inside this one because we were editing it.
again, like with any object that is inserted in excel, you can change size. You can train properties,
you can add Ah,
some things. In this case with formulas, you don't shadows or reflection or soft edges.
But essentially, this is
the other things you can do. Like, for example,
you can resize it.
but not with the properties function. You have to do it like this.
And then the funds, you can change the size, so it's pretty much like a text.
So this is all about
in certain formulas. Again, you can play with it on again if we goto edit.
Ah, you can. So if we had another formula, for example,
this one here, you get all these types.
Ah, for example Ah,
we can say that
speed is equal.
do I have to make time
and then you can resize it.
Let's do it again. So
Asian, Okay, See
we can do it in a linear fashion or we can make it in a professional fashion, which means
it looks a little bit like this or we can change it into normal text. We can use the ink in creation in which we will draw it. But we need some kind of
drawing instrument like pen to make it nice. And you have all these structures that you can use to change alter the appearance of formula. You can also add symbols through your formula, like Greek letters, which are usually used.
And once you finish designing your formula, you can resize it. You can change the text size
and so on and so on. So
quite a lot of functionality again, I recommend that you
practice these things according to your preferences. If you need formulas, it all.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered