ExamVeda
Login
Home
31
Status indicators are located on the
Discuss
Answer & Solution
Answer: Option C
Solution:
Status indicators are located on the formula bar.
32
Which of the following is the oldest spreadsheet package?
Discuss
Answer & Solution
Answer: Option A
Solution:
VisiCalc was the first computer spreadsheet program. It was released to the public in 1979, running on an Apple II computer. While most early microprocessor computers had been quickly supported by BASIC and a few games, VisiCalc introduced a new level in application software. It was considered a fourth generation software program.
33
Rounding errors can occur
Discuss
Answer & Solution
Answer: Option A
Solution:
When we use multiplication, division, or exponentiation in a formula, rounding errors can occur.
34
You can copy data or formulas
Discuss
Answer & Solution
Answer: Option D
Solution:
We can copy data or formulas with the copy, paste and cut commands on the edit menu or with commands on the shortcut menu or with buttons on the standard toolbars in Excel 2003 or earlier version.
35
You cannot link excel worksheet data to a word document
Discuss
Answer & Solution
Answer: Option D
Solution:
We cannot link excel worksheet data to a word document with the copy and paste buttons on the standard toolbar.
36
Which of the following is a popular DOS based spreadsheet package?
Discuss
Answer & Solution
Answer: Option D
Solution:
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.
37
An excel workbook is a collection of
Discuss
Answer & Solution
Answer: Option D
Solution:
The correct answer is D: Worksheets and charts.
Let's break it down:

Imagine an Excel workbook like a notebook.

* Option A: Workbooks - A workbook is the whole notebook itself, so a notebook isn't made of other notebooks.
* Option B: Worksheets - Think of worksheets as the individual pages inside the notebook where you write your data.
* Option C: Charts - Charts are like pictures or graphs you might draw in your notebook to visually represent your data.
* Option D: Worksheets and charts - This is the most accurate. An Excel workbook contains both the data tables (worksheets) and the visual representations (charts) of that data.
Therefore, an Excel workbook holds multiple worksheets (pages) and charts (graphs).
38
Excel files have a default extension of in Excel-2003
Discuss
Answer & Solution
Answer: Option A
Solution:
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.
39
You can use the format painter multiple times before you turn it off by
Discuss
Answer & Solution
Answer: Option B
Solution:
We can use the format painter multiple times before we turn it off by double clicking the format painter button.
40
You can use the formula palette to
Discuss
Answer & Solution
Answer: Option B
Solution:
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.