41. Which would you choose to create a bar diagram?
a.
b.
c.
d.

Option “B” is correct.
Click the Insert > Chart
42. Which setting you must modify to print a worksheet using letterhead?
a. Paper
b. Margin
c. Layout
d. Orientation

Option “B” is correct.
We need to set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon.
43. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
a.
b.
c.
d.

Option “C” is correct.
Scatter plot (XY chart) used to show scientific XY data. Scatter plots are often used to find out if there’s a relationship between variable X and Y.
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.
Column charts are used to compare values across categories by using vertical bars.
44. The spelling dialog box can be involved by choosing spelling from ________ menu.
a. Insert
b. File
c. Tools
d. View

Option “C” is correct.
In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > Spelling
45. Which key do you press to check spelling?
a. F3
b. F5
c. F7
d. F9

Option “C” is correct.
In most Microsoft Office apps (including Word, Excel, PowerPoint and Outlook), tap F7 to begin the spellcheck process.
46. What is represented by the small, black square in the lower-right corner of an active cell or range?
a.
b.
c.
d. Border

Option “B” is correct.
Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.
47. In Excel, a Data Series is defined as what?
a.
b.
c.
d.

Option “C” is correct.
In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.
48. In Excel, the Fill Color button on the Formatting toolbar is used for what?
a.
b.
c.
d.

Option “D” is correct.
Fill Color is used to add or change the background color or pattern of cells.
49. In help menu of Excel, which of the following tabs are found?
a.
b.
c.
d.

Option “D” is correct.
In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.
50. A ________ is a grid with labeled columns and rows.
a.
b. Worksheet
c. Clipboard
d. Toolbar

Option “B” is correct.
A worksheet in Excel is made up of Rows and Columns grids. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
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