31. Which of the following is a popular DOS based spreadsheet package?
a. Word
b.
c. Excel
d.

Option “D” is correct.
Lotus 1-2-3 spreadsheet was the first MS-DOS based spreadsheet package which was released on January 26, 1983. It was the IBM PC’s first killer application, was hugely popular in the 1980s, displacing the former leader VisiCalc and contributed significantly to the success of the IBM PC. Lotus had difficulties adapting 1-2-3 to the Windows environment, and was overtaken by Microsoft Excel.
32. An excel workbook is a collection of-
a. Workbooks
b. Worksheets
c. Charts
d.

Option “D” is correct.
A workbook is a collection of one or more spreadsheets and charts in a single file.
33. Excel files have a default extension of in Excel-2003-
a. Xls
b. Xlw
c. Wk1
d. 123

Option “A” is correct.
Excel files have a default extension of xls in 2003 and earlier version of MS-office and xlxs in 2007 and higher version of MS-office.
34. You can use the format painter multiple times before you turn it off by-
a.
b.
c.
d.

Option “B” is correct.
We can use the format painter multiple times before we turn it off by double clicking the format painter button.
35. You can use the formula palette to-
a.
b.
c.
d.

Option “B” is correct.
Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.
36. How do you display current date only in MS Excel?
a.
b.
c.
d.

Option “B” is correct.
DATE – returns the serial date value for a date
TODAY – returns today’s date
NOW – returns the current date and time
TIME – assemble a proper time.
37. How do you wrap the text in a cell?
a.
b.
c.
d.

Option “D” is correct.
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.
38. What does COUNTA () function do?
a.
b.
c.
d.

Option “D” is correct.
COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.
39. What is the short cut key to highlight the entire column?
a.
b.
c.
d.

Option “D” is correct.
Ctrl + Space Bar is the short cut key to highlight the entire column.
40. In the formula, which symbol specifies the fixed columns or rows?
a. $
b.
c.
d. &

Option “A” is correct.
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or 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