Bcms Class Mid-term Exam Review Part I

In MS Excel, each formula starts with the "=" sign. This is because the "=" sign is used to indicate that the following characters or expression is a formula and should be calculated by Excel. By starting a formula with "=", Excel understands that it needs to perform a calculation rather than treating it as plain text.

In MS Word, the Tools menu is used to start the spell check. This menu contains various options and features related to editing and proofreading, including the spell check functionality. By selecting the Tools menu, users can access the spell check tool and review and correct any spelling errors in their document.

To multiply a number in cell A7 by a number in C7 in MS Excel, we use the formula "=A7*C7". This formula multiplies the value in cell A7 with the value in cell C7 and displays the result in cell B7.

To insert WordArt in MS Word, we need to go to the "Insert" tab and select "Picture". This option allows us to insert various types of images, including WordArt, into our document.

A single field on an MS Excel spreadsheet is called a cell. In Excel, a cell is the smallest unit of data storage and can contain various types of information such as text, numbers, formulas, or functions. Cells are organized in rows and columns, allowing users to input and manipulate data efficiently. Cells can be formatted, merged, or referenced in formulas to perform calculations or create relationships between different cells. Overall, a cell is a fundamental component of an Excel spreadsheet that enables users to organize and analyze data effectively.

The currency number format would be used in MS Excel to format money. This format is specifically designed for displaying monetary values and includes symbols such as the dollar sign ($) or the euro sign (€) depending on the currency being used. It also adds appropriate decimal places and thousand separators to make the values more readable and consistent.

To change the height of a row in MS Excel, we need to highlight the row first. This can be done by clicking on any cell within the row and then dragging the cursor to select the entire row. Once the row is highlighted, we can right-click on the selected row and choose the "Row Height" option to change the height of the row.

To view the document's header in MS Word, we need to go to "File - Print Preview". This option allows us to see a preview of how the document will look when printed, including the header section. This is useful for checking the placement and formatting of the header before printing the document.

To spread a formula along a column in MS Excel, we use AutoFill. AutoFill allows us to quickly fill a series or pattern of data, including formulas, by dragging the fill handle. This feature is useful when we want to apply the same formula to multiple cells in a column without manually entering it in each cell. AutoSum, AutoFix, and AutoSpread are not relevant options for this action in MS Excel.

To insert a footer in an MS Word document, you need to go to the "View" tab. This tab contains various options for viewing and editing the document, including the option to insert headers and footers. By selecting the "View" tab, you can access the necessary tools to insert a footer into your document.