Microsoft Excel - gkquestionsguru.com

31.	Which of the following is a popular DOS based spreadsheet package?
a.	Word
b.	Smart cell
c.	Excel
d.	Lotus 1-2-3 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.	Worksheets and charts 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.	You can use the format painter button on ly one time when you click it
b.	Double clicking the format painter button
c.	Pressing the Ctrl key and clicking the format painter button
d.	Pressing the Alt key and clicking the format painter button 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.	Format cells containing numbers
b.	Create and edit formulas containing functions
c.	Enter assumptions data
d.	Copy a range of cells 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.	Date ()
b.	Today ()
c.	Now ()
d.	Time () 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.	Format, cells, font
b.	Format, cells, protection
c.	Format, cells, number
d.	Format, cells, alignment 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.	Counts cells having alphabets
b.	Counts empty cells
c.	Counts cells having number
d.	Counts non-empty cells 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.	Ctrl + C
b.	Ctrl + Enter
c.	Ctrl + Page Up
d.	Ctrl + Space Bar 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

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