Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
Excel 365 exam
Study online at https://quizlet.com/_fyp4uk
1. Relative reference cell reference is a relative reference, which means
that the reference is relative to the location of the
cell. If, for example, you refer to cell A2 from cell
C2, you are actually referring to a cell that is two
columns to the left (C minus A)—in the same row
(2).
2. Absolute reference If you want to maintain the original cell reference in
this example when you copy it, you make the cell
reference absolute by preceding the columns (B and
C) and row (2) with a dollar sign ($). Then, when you
copy the formula =$B$4*$C$4 from D4 to D5, the
formula stays exactly the same.
3. Mixed reference Less often, you may want to mixed absolute and
relative cell references by preceding either the col-
umn or the row value with a dollar sign—which fixes
either the column or the row (for example, $B4 or
C$4).
To change the type of cell reference:
Select the cell that contains the formula.
In the formula bar , select the reference that you
want to change.
Press F4 to switch between the reference types.
The table below summarizes how a reference type
updates if a formula containing the reference is
copied two cells down and two cells to the right.
4. Structured references Excel assigns a name to the table, and to each
in formulas column header in the table. When you add formulas
to an Excel table, those names can appear auto-
1/8
Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
, Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
Excel 365 exam
Study online at https://quizlet.com/_fyp4uk
matically as you enter the formula and select the
cell references in the table instead of manually en-
tering them. That combination of table and column
names is called a structured reference. The names
in structured references adjust whenever you add or
remove data from the table.
Structured references also appear when you create
a formula outside of an Excel table that references
table data. The references can make it easier to
locate tables in a large workbook.
5. AVERAGE function Returns the average (arithmetic mean) of the argu-
ments. For example, if the range A1:A20 contains
numbers, the formula =AVERAGE(A1:A20) returns
the average of those numbers.
Number1 Required. The first number, cell reference,
or range for which you want the average.
Number2, ... Optional. Additional numbers, cell ref-
erences or ranges for which you want the average,
up to a maximum of 255.
6. MAX function Returns the largest value in a set of values.
MAX(number1, [number2], ...)
The MAX function syntax has the following argu-
ments:
Number1, number2, ... Number1 is required, subse-
quent numbers are optional. 1 to 255 numbers for
which you want to find the maximum value.
7. MIN function MIN(number1, [number2], ...)
The MIN function syntax has the following argu-
ments:
Number1, number2, ... Number1 is optional, subse-
2/8
Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
Excel 365 exam
Study online at https://quizlet.com/_fyp4uk
1. Relative reference cell reference is a relative reference, which means
that the reference is relative to the location of the
cell. If, for example, you refer to cell A2 from cell
C2, you are actually referring to a cell that is two
columns to the left (C minus A)—in the same row
(2).
2. Absolute reference If you want to maintain the original cell reference in
this example when you copy it, you make the cell
reference absolute by preceding the columns (B and
C) and row (2) with a dollar sign ($). Then, when you
copy the formula =$B$4*$C$4 from D4 to D5, the
formula stays exactly the same.
3. Mixed reference Less often, you may want to mixed absolute and
relative cell references by preceding either the col-
umn or the row value with a dollar sign—which fixes
either the column or the row (for example, $B4 or
C$4).
To change the type of cell reference:
Select the cell that contains the formula.
In the formula bar , select the reference that you
want to change.
Press F4 to switch between the reference types.
The table below summarizes how a reference type
updates if a formula containing the reference is
copied two cells down and two cells to the right.
4. Structured references Excel assigns a name to the table, and to each
in formulas column header in the table. When you add formulas
to an Excel table, those names can appear auto-
1/8
Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
, Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
Excel 365 exam
Study online at https://quizlet.com/_fyp4uk
matically as you enter the formula and select the
cell references in the table instead of manually en-
tering them. That combination of table and column
names is called a structured reference. The names
in structured references adjust whenever you add or
remove data from the table.
Structured references also appear when you create
a formula outside of an Excel table that references
table data. The references can make it easier to
locate tables in a large workbook.
5. AVERAGE function Returns the average (arithmetic mean) of the argu-
ments. For example, if the range A1:A20 contains
numbers, the formula =AVERAGE(A1:A20) returns
the average of those numbers.
Number1 Required. The first number, cell reference,
or range for which you want the average.
Number2, ... Optional. Additional numbers, cell ref-
erences or ranges for which you want the average,
up to a maximum of 255.
6. MAX function Returns the largest value in a set of values.
MAX(number1, [number2], ...)
The MAX function syntax has the following argu-
ments:
Number1, number2, ... Number1 is required, subse-
quent numbers are optional. 1 to 255 numbers for
which you want to find the maximum value.
7. MIN function MIN(number1, [number2], ...)
The MIN function syntax has the following argu-
ments:
Number1, number2, ... Number1 is optional, subse-
2/8
Excel 365 exam.pdf Excel 365 exam.pdf Excel 365 exam.pdf
