F7 Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.

Headers and footers appear only in print layout view, print preview, and in printed documents.

Ctrl + C is used to copy the text or image we have selected and stores it on your virtual clipboard, until it is overwritten by the next “cut” or “copy” command.

Background color or effects applied on a document is not visible in Print Preview area.

Ctrl + R is used to right align the selected Paragraph.

If we typed a word not in the dictionary (misspelled or proper name), a wavy red line appears. Word flags a possible error and changes the Status icon to a red X.

A superscript is a character, symbol or number set slightly above the normal line of text. It is always smaller than the usual font and is typically found in mathematical or scientific formulas. it is effective on the font.

From Office Button we can access Save command in Word 2007.
From 2010 and higher versions from File we can access Save command.

The easiest way to change and remove tab stops is to work with them directly on the Ruler. We can drag a tab stop to the right or left to shift its position, or we can drag it off the Ruler entirely (up or down) to remove it. To change a tab stop’s type, double-click the tab stop on the Ruler to open the Tabs dialog box and make our changes there.

CTRL + M is used to Indent a paragraph from the left.

Center Indent is not available on the Ruler of MS Word screen.

In MS Word, Ctrl+S is used to Save the document.

Ctrl + W is used to Save and Close document.

AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
–OR–
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

There is no option to set the page border in Excel.

A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client

Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.

Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.
In earlier versions of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.
In earlier versions of Excel, you could hide the tool bar as per requirement. However, that capability was removed starting with Excel 2007 and introduced Ribbon.

When we pressing the ctrl+x in the Microsoft excel sheet it means we cut the content from that cell simply means the cells selected are marked for cutting and the user has need to move the content from one cell to another cell.

To use options from the Paste Special box, click Home > Paste > Paste Special.

Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

You can auto fit the width of column by double clicking on column right border on column header.

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.

The default value for any series is 1 in Excel.

Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose
Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Ctrl+D fills the cell beneath with the contents of the selected cell in a column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.

Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

Time series type is not valid for Fill Series dialog box in excel.
https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589642750-Examveda_8444.GIF

Paste Special allows Divide operation while you paste to new cell.
https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589643023-Examveda_8445.GIF

Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.

To remove the content of selected cells we must issue Clear Contents command. Clear Contents will clear only the data, will not clear any formats.

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.

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.

https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589644745-Examveda_8453.GIF

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 Insert > 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.

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

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.

https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589656905-Examveda_8473.GIF

https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589658005-Examveda_8474.GIF

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

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.

Click the Insert > Chart

We need to set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon.

Scatter plot (XY chart) used to show scientific XY data. Scatter plots are often used to find out if there’s a relationship between variable X and Y.
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.
Column charts are used to compare values across categories by using vertical bars.
14.
A.

Insert
B.

File
C.

Tools
D.

View
Answer & Solution Discuss in Board Save for Later
15.
A.

F3
B.

F5
C.

F7
D.

F9
Answer & Solution Discuss in Board Save for Later

1234567891011121314
Read More Section(MS Excel)
Each Section contains maximum 70 questions. To get more questions visit other sections.

MS Excel – Section 1
MS Excel – Section 3

In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > Spelling

In most Microsoft Office apps (including Word, Excel, PowerPoint and Outlook), tap F7 to begin the spellcheck process.

Macro Recorder records your mouse movements, mouse clicks and keyboard input. Just like a tape recorder for your computer.

We can save and protect the workbook by Encrypt a Workbook with a Password, Make a Workbook Read-Only, Protect a Workbook’s Structure, Protect a Worksheet from Editing, Protect Specific Cells From Editing.

The first cell in EXCEL worksheet is labeled as A1.

Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner,

In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.

Fill Color is used to add or change the background color or pattern of cells.

In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.

A worksheet in Excel is made up of Rows and Columns grids. 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.