Microsoft Excel Questions

MCQ bookmark_border

51.

Getting data from a cell located in a different sheet is called ________

A

Accessing

B

Referencing

C

Updating

D

Functioning

Correct Answer: B

Getting data from a cell located in a different sheet is called Cell reference.
There are Three types of Cell reference in Excel
Relative
Absolute
Mixed

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

52.

Which of the following is not a valid data type in Excel?

A

Number

B

Character

C

Label

D

Date/Time

Correct Answer: B

There are Three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates. Formulas are instructions for Excel to perform calculations.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

53.

Which elements of a worksheet can be protected from accidental modification?

A

Contents

B

Objects

C

Scenarios

D

All of the above

Correct Answer: D

All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

54.

A numeric value can be treated as label value if ________ precedes it.

A

Apostrophe (

B

Exclamation ( ! )

C

Hash ( # )

D

Tilde ( ~ )

Correct Answer: A

An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

55.

A numeric value can be treated as label value if ________ precedes it.

A

Apostrophe (

B

Exclamation ( ! )

C

Hash ( # )

D

Tilde ( ~ )

Correct Answer: A

An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

56.

Which area in an Excel window allows entering values and formulas?

A

Title Bar

B

Menu Bar

C

Formula Bar

D

Standard Tool Bar

Correct Answer: C

Formula Bar area in an Excel window allows entering values and formulas. Formula Bar is a toolbar at the top of the Microsoft Excel spreadsheet window that we can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

57.

Multiple calculations can be made in a single formula using ________

A

Standard Formulas

B

Array Formula

C

Complex Formulas

D

Smart Formula

Correct Answer: B

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.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

58.

An Excel Workbook is a collection of ________

A

Workbooks

B

Worksheets

C

Charts

D

Worksheets and Charts

Correct Answer: D

A workbook is a collection of one or more spreadsheets and charts in a single file.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

59.

What do you mean by a Workspace?

A

Group of Columns

B

Group of Worksheets

C

Group of Rows

D

Group of Workbooks

Correct Answer: D

The term workspace refers to all the open workbooks and their exact screen position and window sizes.
A workspace contains pointers to your other Excel files that you had open during your session.
When you open an Excel workspace all the other files are opened as well
Workspaces are particularly useful if you frequently work with the same set of files and need to have them all open at once.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

60.

What do you mean by a Workspace?

A

Group of Columns

B

Group of Worksheets

C

Group of Rows

D

Group of Workbooks

Correct Answer: D

The term workspace refers to all the open workbooks and their exact screen position and window sizes.
A workspace contains pointers to your other Excel files that you had open during your session.
When you open an Excel workspace all the other files are opened as well
Workspaces are particularly useful if you frequently work with the same set of files and need to have them all open at once.

Check Answer report_problem Report forum Discussion