ExamVeda
Login
Home
11
How do you delete a column?
Discuss
Answer & Solution
Answer: Option D
Solution:
Right click the column heading you want to delete and select delete from the shortcut menu in Excel 2003.
From 2007 and Higher version Home > Delete > Delete Sheet Columns.
12
How can you find specific information in a list?
Discuss
Answer & Solution
Answer: Option D
Solution:
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
13
When integrating word and excel, word is usually the
Discuss
Answer & Solution
Answer: Option D
Solution:
When integrating ms-word and excel, word is usually the Destination and Client .
14
When a label is too long to fit within a worksheet cell, you typically must
Discuss
Answer & Solution
Answer: Option B
Solution:
When a label is too long to fit within a worksheet cell, we must increase the column width.
15
The name box
Discuss
Answer & Solution
Answer: Option B
Solution:
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.
16
Comments put in cells are called
Discuss
Answer & Solution
Answer: Option B
Solution:
Comments put in cells are called Cell Tip
17
Which is used to perform what if analysis?
Discuss
Answer & Solution
Answer: Option D
Solution:
Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.
18
You can use the horizontal and vertical scroll bars to
Discuss
Answer & Solution
Answer: Option B
Solution:
You can use the horizontal and vertical scroll bars to view different rows and columns edit the contents of a cell.
19
Multiple calculations can be made in a single formula using
Discuss
Answer & Solution
Answer: Option B
Solution:
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.
20
Hyperlinks can be
Discuss
Answer & Solution
Answer: Option D
Solution:
Hyperlinks can be a text or drawing objects or pictures. A hyperlink is a word, phrase, or image that we can click on to jump to a new file or a new section within the current file.