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

8 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

Leave a Comment

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

Scroll to Top