Test: Excel Formulas- 2 - Primary 6 MCQ

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

Auto Format 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.

Worksheet in MS Excel
Definition:
A worksheet in MS Excel is a table or grid-like structure where you can enter and organize data.
Key Points:
- A worksheet is also known as a spreadsheet in MS Excel.
- It is the primary workspace where you can perform calculations, analyze data, and create charts.
- Worksheets are organized into rows and columns, forming cells where you can input data.
- Each cell can contain text, numbers, formulas, and functions.
- Worksheets can be customized by adjusting column widths, applying formatting, and adding headers and footers.
- Multiple worksheets can be created within a single Excel file, allowing you to work on different sets of data or scenarios.
- Worksheets can be renamed, rearranged, and copied within the same file or across different files.
- They can also be protected with passwords to prevent unauthorized changes.
- Excel provides various tools and features to manipulate and analyze data within a worksheet, including sorting, filtering, and conditional formatting.
Answer:
In MS Excel, a worksheet, also known as a spreadsheet, is a table into which you enter data and data labels.

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.

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.

Pivot Table: 

• We can use pivot tables to sort, reorganize, group, count, total or average data stored in a database.
• They are the perfect solution when you need to summarize and analyze large amounts of information.
• The Pivot Table feature allows the user to create a cross-tabulation summary of data in which heading can subsequently move to give different views of the data.
• Pivot tables are useful with large amounts of data that would be time-consuming to calculate by hand. 
• It flips and sums data in seconds and allows us to perform data analysis and generating reports like periodic financial statements, statistical reports, etc.

Use a Custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but we can also create your own custom list.
For Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.
For Excel 2007, click the Microsoft Office Button Office button > Excel Options > Popular >Top options for working with Excel > Edit Custom Lists.

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.

Key Points

• When you select a cell in MS Excel and type  "=B25"  then the selected cell will show the value that is contained in cell B25.
• In MS-Excel Equal (=) sign means that you enter either a calculation or function for the selected cell.
• Therefore, when the equal sign is entered after any cell it takes its value. 

When you press F9 or click Calc Sheet on the Calculation tab on the Tools/Options menu. Calculation also occurs every time that you save the file if you have the checkbox "Recalculate workbook before saving" checked under File > Options > Formulas.

There is no option to set page border in Excel.

Key Points

• Ctrl + C — activates the copy command 
• Ctrl + V — activates the paste command
• Ctrl + X — activates the cut command
• Ctrl+A = Select All
• Ctrl+B =Bold
• Ctrl+C =Copy
• Ctrl+D =Fill Down
• Ctrl+F =Find
• Ctrl+G =Go to Edit
• Ctrl+H =Replace
• Ctrl+I=Italic

In Excel 2016, 2013, 2010, 2007, click on View > Show > Gridlines
For Excel 2003 and Earlier: Navigate to Tools > Options or Click Gridline tool on Forms toolbar.

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.

Key Points

• The Formula Bar is where data or formulas are entered into a worksheet that appears for the active cell.
• The Formula Bar can also be used to edit data or formula in the active cell.
• The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
• The Insert Function dialog box shows what functions are available, what they do, and how to use them.