Name: Excel 2010:基本功能 (Excel 2010: Basic Functions)
Uploaded: 2021-01-14T07:20:28.000Z
Duration: 5 min 37 s
Description: 【看影片學英語】數萬部 YouTube 影片，搭配英漢字典即點即查，輕鬆掌握單字發音與用法，長久累積看電影不必再看字幕。

Excel has a really powerful and convenient
feature

A function is a pre-defined formula, and it's
used

would be too complicated, or just
too long.

You can access them from the Formulas tab.

There are hundreds of functions that you can
choose from,

and they are organized by category in
the function library.

For example, the Financial category contains
functions that

deal with things like interest and
monthly payments.

The Text category allows you to convert text
to

replace text, and do other
types of text manipulation.

Date & Time includes functions that return
the

current date, time, day of the week, and others.

Much of the time, you'll just need to use
common

functions such as SUM and AVERAGE, and you
can

access these by clicking the AutoSum drop-down
arrow.

In this example, I'd like to add all of these
cells.

If I tried to create a formula for this, I
would

That would get pretty long, and if I had to
add

then it would really not be
manageable at all.

So I'm just going to add them all by using
a

Click on the cell where you want the function
to

click on the AutoSum drop-down arrow
and select Sum.

Now this has inserted the function, and it's
also

If it selects the wrong cells, then we can
always

change that by dragging these corner handles.

But this looks right, so I'll press enter
to get

Let's look at this function in a little bit
more

Just like formulas, functions always start
with

But you might notice that there are no
mathematical operators such as addition or

subtraction, like you would normally see in
a

Instead, functions have a specific syntax
that

followed by one
or more arguments in parentheses.

The arguments tell the function which cells
or

In this example, we actually only have one
argument,

even though there are two different cell
references.

A range of cells is indicated by two cell
references separated by a colon.

In this case, the range consists of all of
the

If you want to use more than one argument,
you'll

In this example, we have a column for the
date

and the date that it was received,
and I'd like to know how many

business days it took to receive the item
after it

First, select the cell where you want the
function

If you know which category your function is
in,

you can select it from there, or you can just

search for the function by clicking the Insert
Function command.

Just type in a description of what you're
looking

I'm looking for a function that can count
the

so I'll type "count days"
and press Enter.

We've gotten a lot of different results here.

You can click on a function and read a description
of it below.

NETWORKDAYS returns the number of workdays
between

This function has up to three arguments:
Start_date, End_date, and Holidays.

When you click in each field, you can see
a

If you need more help on a particular function,
you can click "Help on this function".

I'll select G6 for the Start date, H6 for
the end

Holidays argument is optional, so
I'll just leave it blank.

Click OK, and the function will be added to
the

Just like with formulas, we can drag the fill
handle to copy it.

And now we can see how long it took each of
these

If you've never used functions before, the
syntax

but with some practice you'll start to
get the hang of it,

and over time you'll probably find your favorite
functions that you'll use over and over again.