Ms Excel — Part 2 MCQs with Explanations

The Delete key of keyboard is assigned to Clear Contents command in Excel. Clear Contents will clear only the data, will not clear any formats.

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.

Right-click the tab and choose Delete from its shortcut menu in All version of excel. In Microsoft Excel 2010 onwards Choose Home > Delete > Delete Sheet on the Ribbon, press Alt+HDS Microsoft Excel 2007 and earlier Press ‘ALT’ + ‘E’, then the ‘L’ key.

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version. In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.

In Excel we can Find and Replace within the sheet or workbook.

You can search for bold and replace with italics is the correct answer to “Which of the following is not true about Find and Replace in Excel”. This question is standard in competitive examination syllabi for Ms Excel.

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Ctrl + H shortcut key is usedto replace a data with another in sheet.

Comments can be added to cells using Review > Comment .

View > Window > Split option can be used to split windows into two.

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.

AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.

To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

The MOD function in Excel is used to find remainder after division of one number (dividend) by another (divisor). In mathematics, this operation is called the modulo operation or modulus, hence the name MOD.

Pmt is the correct answer to “Which function is not available in the Consolidate dialog box”. This question is standard in competitive examination syllabi for Ms Excel.

Delete cells is the correct answer to “Which is not the function of "Edit, Clear" command”. This question is standard in competitive examination syllabi for Ms Excel.

Microsoft Excel is Microsoft's general-purpose spreadsheet program for Windows, used for data analysis and display. It is commonly used in a business environment since it is part of the Microsoft Office package. Microsoft Excel is an extremely powerful tool, which is used by millions of people everyday. Functions tailored to a specific task can be programmed into Excel to extend its capabilities with customised analysis tools.

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. We can also sort a table to put names in alphabetical order or ascending or descending order. Or, maybe we want to sort data by Amount from smallest to largest or largest to smallest.

Excel offers the following major chart types − Column Chart Line Chart Pie Chart Doughnut Chart Bar Chart Area Chart XY (Scatter) Chart Bubble Chart Stock Chart Surface Chart Radar Chart Combo Chart

'#,##0.00' = 5436.80

DATE - returns the serial date value for a date TODAY - returns today's date NOW - returns the current date and time TIME - assemble a proper time.

DATE - returns the serial date value for a date TODAY - returns today's date NOW - returns the current date and time TIME - assemble a proper time.

Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break. On the Home tab, in the Alignment group, click Wrap Text.

COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.

Ctrl + Space Bar is the short cut key to highlight the entire column.

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

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.

First we use the name of sheet, then put an exclamation mark, at the end give the cell reference. It would be look like =Sheet3!A10

VBA (Visual Basic for Applications) is the programming language of Excel with VBA we can automate tasks in Excel by writing so called macros.

A worksheet in Excel is made up of Rows and Columns. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.

Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.