ISTM 210 Exam 2 – Complete Guide to Pass

ISTM 210 EXAM 2 WITH ALL
NEEDED TO PASS




Workbook N- Ncorrect Nanswer-Excel Nfiles Nthat Nstores Ninfo, Ncalculations, N& Nanalyses

Worksheet N- Ncorrect Nanswer-Contains Nactual Ndata N& Ncalculations

File NMenu N- Ncorrect Nanswer-Performs Nfunction Non Nentire Nworkbook

How Nare Ncells Naddressed? N- Ncorrect Nanswer-Column Nthen Nrow. N(i.e. NA1)

Cell NRange NNotation N- Ncorrect Nanswer-cell:cell

Fill NFeature N- Ncorrect Nanswer-Auto-populates Ncells Nin Na Nworksheet

Freeze NPanes N- Ncorrect Nanswer-Locking Nrows N& Ncolumns Nso Nthey Ndon't Ndisappear
Nwhen Nyou Nscroll. NFreezes Nrow Nbelow Nand Ncolumn Nto Nleft Nof Nselected Ncell


How Ndo Nyou Nformat Npaint? N- Ncorrect Nanswer-Select Na Ncell, Nclick Nformat Npainter,
Nand Npaste Nit Ninto Na Nnew Ncell


T Nor NF. NData Ncan Nonly Nbe Nfiltered Nby None Ncriteria N- Ncorrect Nanswer-False. NIt
Ncan Nbe Nfiltered Nmultiple Ntimes


How Ndo Nyou Nreference Na Ncell? N- Ncorrect Nanswer-Enter Ncell Naddress Nin Na Nnew
Ncell

, How Ndo Nyou Nperform Ncalculations Nin Na Ncell? N- Ncorrect Nanswer-Type Nthe Nequation
Nin Nthe Ncurrent Ncell Nwith Nreferences Nto Ncells Nwith Nimportant Ndata


Relative NCell NReference N- Ncorrect Nanswer-Cells Nare Naddressed, Nbut Nhave Nthe
Nability Nto Nchange N(i.e. NA1)


Absolute NCell NReference N- Ncorrect Nanswer-Cell Nis Naddressed, Nbut Ndoes Nnot Nchange
N(i.e. N$A$1)


SUM NFunction N- Ncorrect Nanswer-Calculates Nsum Nof Nselected Ndata.

What Nis Nan Nargument? N- Ncorrect Nanswer-Element Nof Nan Nexcel Nfunction

Function NWizard N- Ncorrect Nanswer-(1) NAllows Nyou Nto Nenter Nor Nselect Nthe Ninputs
N(called Narguments) Nfor Nthe Nfunction, N(2) Nprovides Na Ndescription Nof Nthe Nfunction
Nand Neach Nargument, Nand N(3) Nlists Nthe Nfunction Nresult Nbased Non Nthe Ninputs Nyou
Nenter.


Functions Nmust Nalways Nbeing Nwith... N- Ncorrect Nanswer-=

COUNT NFunction N- Ncorrect Nanswer-Counts Nthe Nnumber Nof Ncells Nin Na Nrange Nof
Ncells Nthat Ncontain Nnumbers.


COUNTA NFunction N- Ncorrect Nanswer-Counts Nthe Nnumber Nof Ncells Nin Na Nrange Nof
Ncells Nthat Nare Nnot Nblank.


AVERAGE NFunction N- Ncorrect Nanswer-Calculates Nthe Nsimple Naverage Nof Na Nset Nof
Nnumbers. NWILL NNOT NWORK Nif Nyou Nput NAVG.


MAX NFunction N- Ncorrect Nanswer-Returns Nthe Nlargest Nvalue Nin Na Nset Nof Nnumbers.

MIN NFunction N- Ncorrect Nanswer-Returns Nthe Nsmallest Nvalue Nin Na Nset Nof Nnumbers.

RATE NFunction N- Ncorrect Nanswer-Calculates Nthe Ninterest Nrate Nearned Nfor Nan
Ninvestment Ngiven Nthe Nnumber Nof Npayments Nmade Nas Npart Nof Nthe Ninvestment, Nthe
Npayment Namount, Nand Nthe Ncurrent Nvalue Nof Nthe Ninvestment.


EFFECT NFunction N- Ncorrect Nanswer-Calculates Nthe Nannual Npercentage Nrate Nfor Nan
Ninterest Nrate Ngiven Nthe Nnumber Nof Ntimes Nper Nyear Nthat Ninterest Nis Ncharged.


NPER NFunction N- Ncorrect Nanswer-Calculates Nthe Nnumber Nof Npayments Nthat Nwill Nbe
Nmade Nto Npay Noff Na Nloan Ngiven Nthe Ninterest Nrate, Npayment Namount, Nand Noriginal
Nloan Namount.


PMT NFunction N- Ncorrect Nanswer-Calculates Nthe Npayment Namount Nfor Na Nloan Ngiven
Nthe Ninterest Nrate, Nnumber Nof Npayments Nto Nbe Nmade Nto Npay Noff Nthe Nloan, Nand
Nthe Noriginal Nloan Namount.