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.

Leave a Comment

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

Scroll to Top