1. Excel displays the current cell address in the ________
a.
b.
c.
d.

Option “C” is correct.
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the “active cell” on the worksheet. You can also use the name box to quickly create a named range.
2. What is the correct way to refer the cell A10 on sheet3 from sheet1?
a.
b.
c.
d. A10

Option “A” is correct.
First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.
It would be look like =Sheet3!A10
3. Which language is used to create macros in Excel?
a.
b. C
c.
d. Java

Option “A” is correct.
VBA (Visual Basic for Applications) is the programming language of Excel with VBA we can automate tasks in Excel by writing so called macros.
4. Which of the following is not a term of MS-Excel?
a. Cells
b. Rows
c. Columns
d. Document

Option “D” is correct.
A worksheet in Excel is made up of Rows and Columns. 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.
5. How many worksheets can a workbook have?
a. 3
b. 8
c. 255
d.

Option “D” is correct.
Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.
6.
To record a sequence of keystrokes and mouse actions to play back later we use:
a.
b.
c. Calculator
d.

Option “D” is correct.
Macro Recorder records your mouse movements, mouse clicks and keyboard input. Just like a tape recorder for your computer.
7. We can save and protect the workbook by-
a.
b.
c.
d.

Option “D” is correct.
We can save and protect the workbook by Encrypt a Workbook with a Password, Make a Workbook Read-Only, Protect a Workbook’s Structure, Protect a Worksheet from Editing, Protect Specific Cells From Editing.
8. The first cell in EXCEL worksheet is labeled as-
a. AA
b. A1
c. Aa
d. A0

Option “B” is correct.
The first cell in EXCEL worksheet is labeled as A1.
9. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
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.
10. What are the tabs that appear at the bottom of each workbook called?
a.
b.
c.
d.

Option “D” is correct.
In Excel, a sheet, sheet tab, or worksheet tab is used to display the worksheet that a user is currently editing. By clicking a worksheet tab (located at the bottom of the workbook), users may move between the various worksheets.
Pages: 1 2 3 4 5 6 7

147 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 !

Leave a Comment

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

Scroll to Top