Excel Crash Course Exam Questions AND Correct Answers
"go to" - ✔✔*F5*
*Ctrl Shift _* - ✔✔remove all borders
*Ctrl Shift !* - ✔✔number format: 2 decimals, 000 separator
*Ctrl Shift #* - ✔✔date format with the day, month, and year
*Ctrl Shift %* - ✔✔percentage format with no decimal places
*Ctrl Shift $* - ✔✔currency format: 2 decimal places
ABS, CEILING, FLOOR - ✔✔ABS(cell)
returns the absolute value of that cell
CEILING(cell, x)
rounds input cell up to nearest x
FLOOR (cell, x)
,rounds input down to nearest x
accessing settings - ✔✔File > Options (*Alt f t*)
*Alt t o*
anchoring cells - ✔✔when you copy and paste a cell
containing a formula from one cell to another, Excel
automatically shifts the cells being referenced in the formula
sometimes this is not desirable, which is why Excel allows you
to anchor cells
Anchoring (or "Fixing") cells that are being referenced in a
formula tells Excel that even if you copy the formula to
another cell, the cells in the formula that are anchored should
not change
fix column: $ before letter
fix row: $ before number
fix entire cell: $ before letter and before number
,AND - ✔✔=AND(logical1, logical2,...) evaluates to true if all of
its arguments are true; false if one or more arguments is false
auditing cells - ✔✔go to the cel and hit F2
OR
hitting *Ctrl [* on a cell will highlight the precedent cells
-keep hitting *Ctrl [* and it will take you to the next
precedent, and on and on
hitting *Ctrl ]* on a cell will do the same thing but for
dependent cells
autofiltering - ✔✔*Alt a t*
the filtered rows get hidden but not deleted
if you copy and paste the filtered range to another area of the
worksheet or a different worksheet, id doesn't copy over the
hidden rows
, once a filter is applied, you can tell which column was filtered
via the funnel icon
to remove individual filters, click on the filter icon and "Clear
filter"
to remove all filters, hit *Alt a t* again
AVERAGEIF and AVERAGEIFs - ✔✔identical to SUMIF and
SUMIFS but instead of summing, this function averages the
data in the range
Booleans in Excel - ✔✔when Excel spits out a TRUE or FALSE,
you can convert them respectively into 1 or 0 by applying any
operator on them
multiply the TRUE/FALSE cell by 1: will convert a TRUE to 1
and FALSE to 0
multiply the TRUE/FALSE cell by TRUE: will convert a TRUE to
1 and FALSE to 0
"go to" - ✔✔*F5*
*Ctrl Shift _* - ✔✔remove all borders
*Ctrl Shift !* - ✔✔number format: 2 decimals, 000 separator
*Ctrl Shift #* - ✔✔date format with the day, month, and year
*Ctrl Shift %* - ✔✔percentage format with no decimal places
*Ctrl Shift $* - ✔✔currency format: 2 decimal places
ABS, CEILING, FLOOR - ✔✔ABS(cell)
returns the absolute value of that cell
CEILING(cell, x)
rounds input cell up to nearest x
FLOOR (cell, x)
,rounds input down to nearest x
accessing settings - ✔✔File > Options (*Alt f t*)
*Alt t o*
anchoring cells - ✔✔when you copy and paste a cell
containing a formula from one cell to another, Excel
automatically shifts the cells being referenced in the formula
sometimes this is not desirable, which is why Excel allows you
to anchor cells
Anchoring (or "Fixing") cells that are being referenced in a
formula tells Excel that even if you copy the formula to
another cell, the cells in the formula that are anchored should
not change
fix column: $ before letter
fix row: $ before number
fix entire cell: $ before letter and before number
,AND - ✔✔=AND(logical1, logical2,...) evaluates to true if all of
its arguments are true; false if one or more arguments is false
auditing cells - ✔✔go to the cel and hit F2
OR
hitting *Ctrl [* on a cell will highlight the precedent cells
-keep hitting *Ctrl [* and it will take you to the next
precedent, and on and on
hitting *Ctrl ]* on a cell will do the same thing but for
dependent cells
autofiltering - ✔✔*Alt a t*
the filtered rows get hidden but not deleted
if you copy and paste the filtered range to another area of the
worksheet or a different worksheet, id doesn't copy over the
hidden rows
, once a filter is applied, you can tell which column was filtered
via the funnel icon
to remove individual filters, click on the filter icon and "Clear
filter"
to remove all filters, hit *Alt a t* again
AVERAGEIF and AVERAGEIFs - ✔✔identical to SUMIF and
SUMIFS but instead of summing, this function averages the
data in the range
Booleans in Excel - ✔✔when Excel spits out a TRUE or FALSE,
you can convert them respectively into 1 or 0 by applying any
operator on them
multiply the TRUE/FALSE cell by 1: will convert a TRUE to 1
and FALSE to 0
multiply the TRUE/FALSE cell by TRUE: will convert a TRUE to
1 and FALSE to 0
