Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental

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

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.

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.

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.

The ampersand (&) calculation operator allow us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.

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.

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.

Think of an Excel Workbook like a notebook.

Option A: Workbooks - A Workbook can't be a collection of itself! That doesn't make sense.

Option B: Worksheets - Worksheets are like individual pages in your notebook. You can have many of them.

Option C: Charts - Charts are visual representations of your data, like graphs. They are part of what you can put in your workbook.

Option D: Worksheets and Charts - This is the best answer. A Workbook contains both the data tables (worksheets) *and* the visual representations (charts) that help you understand that data. It's like your notebook having both tables of information *and* graphs to make it easier to see the trends.

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.

MS-Excel is based on Windows. MS-Excel is a spreadsheet developed by Microsoft for Windows and few other operating systems. It is a program that stores and retrieves numerical data in rows and columns of grid format.