21.
Comments put in cells are called-
a.
b.
c.
d.

Option “B” is correct.
Comments put in cells are called Cell Tip
22. Which is used to perform what if analysis?
a. Solver
b.
c.
d.

Option “D” is correct.
Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.
23. You can use the horizontal and vertical scroll bars to-
a. Split a worksheet into two panes
b.
c.
d.

Option “B” is correct.
You can use the horizontal and vertical scroll bars to view different rows and columns edit the contents of a cell.
24. Multiple calculations can be made in a single formula using-
a.
b.
c.
d.

Option “B” is correct.
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.
25. Hyperlinks can be-
a. Text
b.
c. Pictures
d.

Option “D” is correct.
Hyperlinks can be a text or drawing objects or pictures. A hyperlink is a word, phrase, or image that we can click on to jump to a new file or a new section within the current file.
26. When you link data maintained in an excel workbook to a word document-
a.
b.
c.
d.

Option “B” is correct.
When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.
27. Which area in an excel window allows entering values and formulas-
a.
b.
c.
d.

Option “C” is correct.
Formula Bar is where data or formulas we enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell.
28. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
a.
b.
c.
d.

Option “B” is correct.
When we want to scroll down the worksheet, and lock the heading rows in place, so it is always visible, we can use one of the Freeze Panes commands.
29. To edit in an embedded excel worksheet object in a word document
a.
b.
c.
d.

Option “A” is correct.
Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.
30. To create a formula, you can use:
a.
b.
c.
d.

Option “D” is correct.
To create a formula, we can use value and cell references both.
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