Microsoft Excel - gkquestionsguru.com

1.	Excel displays the current cell address in the ________
a.	Formula bar
b.	Status Bar
c.	Name Box
d.	Title Bar 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.	Sheet3!A10
b.	Sheet1!A10
c.	Sheet3.A10
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.	Visual Basic
b.	C
c.	Visual 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.	none of above 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.	Media player
b.	Sound Recorder
c.	Calculator
d.	Macro Recorder 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.	Write Reservation Password
b.	Protection Password
c.	Read-only Recommended
d.	Any of the above 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.	An absolute cell address is created
b.	Cell address will change when it is copied to another cell
c.	The sheet tab is changed
d.	The status bar does not display the cell address 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.	Reference tabs
b.	Position tabs
c.	Location tabs
d.	Sheet tabs 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

Jayakrishna sahu
3 May 2024 at 14:36

Appcation is a great of humanlife
Diane.G
13 July 2024 at 08:00

Very interesting details you have noted, thank you for posting.Raise blog range
Long Herold
10 October 2024 at 19:37

Some really choice content on this site, saved to favorites.
bij nl
14 November 2024 at 09:24

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