Microsoft Excel

31.Which of the following is a popular DOS based spreadsheet package?
a.Word
b.
c.Excel
d.

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.

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.
b.
c.
d.

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.
b.
c.
d.

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.
b.
c.
d.

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.
b.
c.
d.

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.
b.
c.
d.

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.
b.
c.
d.

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