11. The active cell:
a.
b.
c.
d.

Option “D” is correct.
An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.
12. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
a. Logical
b.
c. Statistical
d. Financial

Option “D” is correct.
Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts.
A list of Excel Financial Functions in Excel are:
⇒Investment value functions including
1. FV
2. FVSCHEDULE
3. NPV
4. PV
5. RECEIVED
6. XNPV
⇒Internal rate of return functions including
1. IRR
2. MIRR
3. XIRR
⇒Asset depreciation functions including
1. AMORDEGRC
2. AMORLINC
3. DB
4. DDB
5. SLN
6. SYD
7. VDB
⇒Payment functions including
1. CUMIPMT
2. CUMPRINC
3. IPMT
4. ISPMT
5. PMT
6. PPMT
⇒Dollar conversion including
1. DOLLARDE
2. DOLLARFR
⇒Yield functions including
1. YIELD
2. YIELDDISC
3. YIELDMAT
4. ODDFYIELD
5. ODDLYIELD
6. TBILLEO
7. TBILLYIELD
⇒Price functions including
1. PRICE
2. PRICEDISC
3. PRICEMAT
4. ODDFPRICE
5. ODDLPRICE
6. TBILLPRICE
13. B7:B9 indicates:
a.
b.
c.
d.

Option “B” is correct.
B7:B9 indicates a range of cell between Cells B7 through B9.
14. The Cancel and Enter buttons appear in the:
a.
b.
c.
d.

Option “B” is correct.
Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar.
15. Which of the following methods cannot be used to enter data in a cell?
a.
b.
c.
d.

Option “C” is correct.
Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it’s original state.
16. Which of the following is not a basic step in creating a worksheet?
a.
b.
c.
d.

Option “D” is correct.
Copy the worksheet is not a basic step in creating a worksheet.
17. How do you select an entire column?
a.
b.
c.
d.

Option “B” is correct.
To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.
18. How can you print three copies of a workbook?
a.
b.
c.
d.

Option “B” is correct.
Select File > Print from the menu and type 3 in the Number of copies text box
19. To create a formula, you first:
a.
b.
c.
d.

Option “B” is correct.
A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
20. To center worksheet titles across a range of cells, you must-
a.
b.
c.
d.

Option “A” is correct.
Select the cells containing the title text plus the range over which the title text is to be centered
Pages: 1 2 3 4 5 6 7

159 thoughts on “Microsoft Excel”

  4. bij nl

    Hey! Do you know if they make any plugins to assist with Search Engine Optimization? I’m
    trying to get my website to rank for some targeted keywords but I’m not seeing very good success.
    If you know of any please share. Cheers! I saw similar text
    here: Eco bij

  5. change your life

    Hello! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my site
    to rank for some targeted keywords but I’m not seeing very good results.
    If you know of any please share. Thank you!
    I saw similar art here: Your destiny

  7. Jefferey

    I’m really inspired with your writing talents and also with the layout to your blog. Is that this a paid subject matter or did you modify it yourself? Either way stay up the nice high quality writing, it’s rare to look a great blog like this one these days. I like gkquestionsguru.com ! My is: Blaze AI

  8. Elenora

    I am really impressed together with your writing talents and also with the structure on your blog. Is this a paid topic or did you customize it yourself? Either way stay up the nice high quality writing, it’s rare to peer a nice weblog like this one these days. I like gkquestionsguru.com ! I made: Affilionaire.org

  85. RalphSmecy

    Эта публикация завернет вас в вихрь увлекательного контента, сбрасывая стереотипы и открывая двери к новым идеям. Каждый абзац станет для вас открытием, полным ярких примеров и впечатляющих достижений. Подготовьтесь быть вовлеченными и удивленными каждый раз, когда продолжите читать.
    Ознакомиться с деталями – https://medalkoblog.ru/

  125. PeterCleli

    ¡Saludos, buscadores de éxitos!
    Mejores botes progresivos en casinos extranjeros – п»їhttps://casinosextranjero.es/ casino online extranjero
    ¡Que vivas increíbles instantes inolvidables !

  128. Alfredsheni

    ¡Hola, descubridores de oportunidades!
    casinoextranjero.es – recomendaciones diarias de casino – п»їhttps://casinoextranjero.es/ п»їcasinos online extranjeros
    ¡Que vivas recompensas fascinantes !

  131. olatheofloria

    Based on the Jaeger-LeCoultre 920 which were provided as ebauches in kit-form and required link modification and extensive hand-finishing the very thin 2120 not only helped the 5402 Royal Oak maintain its svelte 7mm case profile but it was also used in rival models from both Vacheron Constantin and Patek Philippe. For the purposes of this story and in keeping with the format thus far the 2120 is just the genesis for where we are headed.

  135. CalvinGaw

    ¡Bienvenidos, buscadores de fortuna !
    Casino fuera de EspaГ±a para jugadores frecuentes – п»їhttps://casinofueraespanol.xyz/ casino por fuera
    ¡Que vivas increíbles recompensas fascinantes !

  136. Stephenset

    ?Hola, visitantes de plataformas de apuestas !
    Casinos fuera de EspaГ±a para mГіvil y escritorio – п»їhttps://casinosonlinefueradeespanol.xyz/ casinos fuera de espaГ±a
    ?Que disfrutes de asombrosas triunfos epicos !

  139. RandallBic

    Hello trailblazers of refreshing atmospheres !
    Air Purifier for Smoke Smell – Neutralize Odors – п»їhttps://bestairpurifierforcigarettesmoke.guru/ air purifier for smokers
    May you experience remarkable magnificent freshness !

  144. Sal Prasek

    Thanks a lot for sharing this with all of us you really know what you’re talking about! Bookmarked. Please also visit my web site =). We could have a link exchange contract between us!

  145. HenryWossy

    ¡Saludos, apasionados del ocio y la emoción !
    Casino online sin registro disponible en EspaГ±a – п»їemausong.es casinos sin licencia espaГ±a
    ¡Que disfrutes de increíbles victorias épicas !

  152. Marvinanevy

    Hello supporters of wholesome lifestyles !
    If odors linger after smoking, the best air purifier for smoke smell is essential. These purifiers use carbon filters to lock in odor molecules. Choosing the best air purifier for smoke smell brings instant results.
    Use a compact smoke air purifier in kitchens or laundry rooms to reduce trapped odors. These machines also combat passive smoke from open windows.air purifiers smokeA portable smoke air purifier is a smart home upgrade.
    Air purifiers smoke smell removal made easy – п»їhttps://www.youtube.com/watch?v=fJrxQEd44JM
    May you delight in extraordinary remarkable freshness !

  153. lakshyavbajnok

    The added strap is a great way to get the look of a stack link bracelets layered with watches without any fear of scratching. Nothing about this particular option in the DolceVita X YVY screams HORSES! but if you were to explain the connection to someone they could easily make the leap. And if you are in the market for a watch that screams HORSES! the black leather strap with grommets will certainly holler on your behalf.

  154. Kerryabata

    Greetings, devotees of smart humor !
    100 funny jokes for adults can supply you with entertainment for an entire year. Each one has its own flavor, tone, and style. You’ll never run out of material.
    joke for adults only is always a reliable source of laughter in every situation. [url=https://adultjokesclean.guru/]10 funniest jokes for adults[/url] They lighten even the dullest conversations. You’ll be glad you remembered it.
    text-ready funny text jokes for adults for Friends – http://adultjokesclean.guru/# joke of the day for adults
    May you enjoy incredible unforgettable chuckles !

  158. Arthurinfus

    ¿Hola visitantes del casino ?
    Muchos usuarios eligen estas casas por la posibilidad de jugar sin lГ­mites de depГіsito diarios o mensuales.apuestas fuera de espaГ±aEsto permite mayor libertad financiera.
    Las casas de apuestas fuera de EspaГ±a aceptan mГ©todos alternativos como Skrill, Neteller o criptos. Puedes mover tu dinero mГЎs rГЎpido y con menores comisiones. Y muchas veces, los retiros son instantГЎneos.
    Apuestas fuera de espaГ±a: mejores consejos para principiantes – п»їhttps://casasdeapuestasfueradeespana.guru/
    ¡Que disfrutes de enormes logros !

  159. RichardJab

    ¿Hola visitantes del casino ?
    п»їLas casas de apuestas extranjeras destacan por sus bonos de bienvenida sin condiciones difГ­ciles.[url=п»їhttps://casasdeapuestasfueradeespana.guru/]casasdeapuestasfueradeespana[/url]AdemГЎs, suelen ofrecer promociones constantes para jugadores frecuentes que buscan mГЎs valor por su dinero.
    Casas de apuestas extranjeras tienen soporte activo las 24 horas en espaГ±ol. Puedes resolver dudas en tiempo real por chat o correo. Incluso fuera del horario laboral local.
    Casasdeapuestasfueradeespana.guru: mejores ofertas del mes – http://casasdeapuestasfueradeespana.guru/
    ¡Que disfrutes de enormes ventajas !

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top