150 very important Excel MCQs for test and interview

41. 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,

42. You can convert, existing “excel worksheet” data an charts, to an HTML document, by using

a. FTP wizard,

b. Internet assistant, wizard

C. Intranet wizard,

d. Import wizard,

43. A c”ircular reference is:,

a. Geometric modeling, tool

b. A cell that, points to a drawing, object

C. A formula that, either directly or, indirectly depends, on itself

d. Always erroneous,

44. Which of following, is not one or Excel’s what-if, function?

a. Goal seek,

b. Solver,

C. Scenario manager,

d. Auto Outline,

45. When you, insert an excel file ,into a word document. The data, are:

a. Hyperlinked, placed in a word table,

b. Linked,

C. Embedded,

d. Use the word, menu bar and toolbars,

46. Which of the, following is not information, you can specify using, the solver?

a. Input cells,

b. Constraints,

C. Target cell,

d. Changing cells,

47. Each excel file, is called a workbook, because:

a. It can contain text, and data

b. It can be modified,

C. It can contain, many sheets including worksheets, and chart sheets

d. You have, to work hard to, create it

48. Excel probably, considers the cell, entry January 1, 2000, to be a

a. Label,

b. Value,

c. Formula,

d. Text string,

49. You can enter, which types of, data into “worksheet cells”?

a. Labels, values, and formulas

b. Labels and values, but not formulas,

C. Values and, formulas but not labels,

d. Formulas only,

50. All “worksheet formula”:

a. Manipulate values,

b. Manipulate labels,

c. Return a formula, result

d. Use the addition operator,