ExamVeda
Login
Home
41
You can convert existing excel worksheet data an charts to an HTML document by using
Discuss
Answer & Solution
Answer: Option B
Solution:
The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data to HTML format. It is designed for the 1997 and earlier versions of Excel.
42
A circular reference is
Discuss
Answer & Solution
Answer: Option C
Solution:
A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.
43
Which of following is Not one of Excel's what-if function?
Discuss
Answer & Solution
Answer: Option D
Solution:
Which of the following is Not one of Excel's what-if functions?

Goal seek: This is a what-if analysis tool in Excel. It allows you to find the necessary input value to achieve a desired result in a specific cell. By adjusting one input value, Excel calculates the value needed to reach the goal.

Solver: This is another what-if analysis tool in Excel. Solver is more complex than Goal Seek as it can handle multiple variables and constraints. It helps in finding an optimal value for a formula in one cell, subject to constraints on the values of other formula cells.

Scenario manager: This is also a what-if analysis tool in Excel. It allows you to create and save different groups of values, or scenarios, and then switch between them to see how the different scenarios affect your results.

Auto Outline: This is not a what-if analysis tool. Auto Outline is used for organizing data in a worksheet by creating an outline of the data. It groups data into a hierarchical structure, making it easier to summarize and analyze.

Conclusion: The Auto Outline feature is not one of Excel's what-if functions, making Option D the correct answer.
44
When you insert an excel file into a word document. The data are
Discuss
Answer & Solution
Answer: Option B
Solution:
When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked. In Embedded objects file become part of document and does not get updated when source file is updated.
45
Which of the following is not information you can specify using the solver?
Discuss
Answer & Solution
Answer: Option A
Solution:
Solver is used to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells, called decision variables or simply variable cells that are used in computing the formulas in the objective and constraint cells. Versions of Solver prior to Excel 2007 referred to the objective cell as the "target cell," and the decision variable cells as "changing cells" or "adjustable cells".
46
Each excel file is called a workbook because
Discuss
Answer & Solution
Answer: Option C
Solution:
A workbook is a collection of one or more spreadsheets and charts in a single file.
47
Excel probably considers the cell entry January 1, 2020 to be a
Discuss
Answer & Solution
Answer: Option B
Solution:
In Excel Date format is considered as value.
48
You can enter which types of data into worksheet cells?
Discuss
Answer & Solution
Answer: Option A
Solution:
We can enter Labels, values, and formulas into worksheet cells.
49
All worksheet formula
Discuss
Answer & Solution
Answer: Option C
Solution:
All worksheet formula returns a formula result.
50
Which of the following is a correct order of precedence in formula calculation?
Discuss
Answer & Solution
Answer: Option D
Solution:
None of above is correct order of precedence in formula calculation.