EXCEL CRASH COURSE EXAM 2024-2025
WITH VERIFIED QUESTIONS AND
CORECT ANSWERS GRADED A+
move back and forth between the worksheets in a workbook - ANS-*Ctrl PageUp* or *Ctrl PageDown*
open a file - ANS-*alt f o*
*ctrl o*
MIN and MAX - ANS-=MIN(number1,number2,...) returns the smallest number in a specified set of
values)
=MAX(number1,number2,...) returns the largest number in a specified set of values
COUNT - ANS-=COUNT(value1, value2,...)
counts the number of cells that contain numbers within the list of arguments
-cells with text are disregarded
,COUNTA - ANS-same as COUNT except cells with numbers and text are counted
COUNTIF - ANS-=COUNTIF(range, criteria) counts the number of items in the range that satisfy a specific
criteria
-similar to the SUMIF function
COUNTIFS - ANS-allows for multiple criteria
-similar to the SUMIFS function
PV function - ANS-returns the present value of a series of future payments
=PV(rate, nper, pmt, fv, type)
rate: interest rate per period
nper: total number of payment periods
pmt: payment made during each period (it cannot change)
fv: future value
type: indicates when payments are due (0 or omitted = end of period, 1 = beginning of period)
FV function - ANS-returns the future value of an investment based on constant payment and interest
rate
save a file - ANS-*alt f s*
*ctrl s*
print a file - ANS-*alt f p*
*ctrl p*
, navigating to the toolbars without the mouse - ANS-hit *Alt and the appropriate letter* (or use the
right/left arrow keys) to get to the desired tab
once there, use the Tab and Shift Tab keys to navigate around
accessing settings - ANS-File > Options (*Alt f t*)
*Alt t o*
Disabling the Start Screen and adding more worksheets on startup - ANS-click on 'Blank worksheet'
Hit *Alt f t* go go to Excel options (you can also get there by clicking the file tab)
Under 'General' unselect "Show the Start screen when this application starts"
password protecting files - ANS-File
Info
password protect files: "Encrypt with Password"
password protect individual worksheet (so that people can't see or edit formulas): "Protect Current
Sheet"
highlighting columns and rows - ANS-columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
widening columns and rows - ANS-highlight column by pressing *Ctrl Spacebar*
*Alt h o i* to auto-fit the column width
-if you want a column to have a certain width, press *Alt h o w* and enter the desired width
WITH VERIFIED QUESTIONS AND
CORECT ANSWERS GRADED A+
move back and forth between the worksheets in a workbook - ANS-*Ctrl PageUp* or *Ctrl PageDown*
open a file - ANS-*alt f o*
*ctrl o*
MIN and MAX - ANS-=MIN(number1,number2,...) returns the smallest number in a specified set of
values)
=MAX(number1,number2,...) returns the largest number in a specified set of values
COUNT - ANS-=COUNT(value1, value2,...)
counts the number of cells that contain numbers within the list of arguments
-cells with text are disregarded
,COUNTA - ANS-same as COUNT except cells with numbers and text are counted
COUNTIF - ANS-=COUNTIF(range, criteria) counts the number of items in the range that satisfy a specific
criteria
-similar to the SUMIF function
COUNTIFS - ANS-allows for multiple criteria
-similar to the SUMIFS function
PV function - ANS-returns the present value of a series of future payments
=PV(rate, nper, pmt, fv, type)
rate: interest rate per period
nper: total number of payment periods
pmt: payment made during each period (it cannot change)
fv: future value
type: indicates when payments are due (0 or omitted = end of period, 1 = beginning of period)
FV function - ANS-returns the future value of an investment based on constant payment and interest
rate
save a file - ANS-*alt f s*
*ctrl s*
print a file - ANS-*alt f p*
*ctrl p*
, navigating to the toolbars without the mouse - ANS-hit *Alt and the appropriate letter* (or use the
right/left arrow keys) to get to the desired tab
once there, use the Tab and Shift Tab keys to navigate around
accessing settings - ANS-File > Options (*Alt f t*)
*Alt t o*
Disabling the Start Screen and adding more worksheets on startup - ANS-click on 'Blank worksheet'
Hit *Alt f t* go go to Excel options (you can also get there by clicking the file tab)
Under 'General' unselect "Show the Start screen when this application starts"
password protecting files - ANS-File
Info
password protect files: "Encrypt with Password"
password protect individual worksheet (so that people can't see or edit formulas): "Protect Current
Sheet"
highlighting columns and rows - ANS-columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
widening columns and rows - ANS-highlight column by pressing *Ctrl Spacebar*
*Alt h o i* to auto-fit the column width
-if you want a column to have a certain width, press *Alt h o w* and enter the desired width
