Microsoft Excel 2013 Cell Formatting Quiz

Search Operators

• The related: operator is used to search for related sites.
• The site: operator is used to search for a specific website.

Search Operators and File Licenses

• The cached: operator displays the cached version of a webpage.
• Creative Commons licenses determine usage rights for multimedia files.

Microsoft Excel 2013

Cell Alignment and Formatting

• Text alignment within a cell can be modified using the Alignment group in the Home tab.
• The Right feature allows aligning cell values with the right bottom borders.
• Indenting cell text helps to improve readability.
• Adding borders of different styles and colors to individual cells or ranges enhances visual appeal.

Functions and Formulas

• Using cell references in Excel functions provides flexibility and accuracy.
• The TRIMMEAN function is recommended for data with extremely large or small values.
• There are three methods for inserting a function: typing it manually, using the Insert Function Dialog Box, or using the AutoSum feature.
• The Insert Function Dialog Box helps locate specific functions.
• Relative cell references change when the formula is copied to another group of cells.
• Absolute cell references are denoted by a $ symbol and do not change when the formula is copied.
• Mixed references contain both relative and absolute components.
• Absolute references are recommended when the referenced cells should not change.
• The F4 key toggles between relative and absolute references.
• AutoFill's default behavior is to copy formulas and adjust references.
• The Auto Fill Options button provides additional options for filling data.

Date and Time Functions

• The TODAY function returns the current date.
• The background image option is located in the Page Layout tab.

Functions and Formulas Purpose

• The primary purpose of using functions and formulas is to perform calculations and analyze data.
• In Tutorial 2 of New Perspectives on Microsoft Excel 2013, the 'Net Profit/Loss' formula calculates profit or loss.

Number Formatting

• The primary purpose of formatting numbers is to improve readability and understanding.
• The Currency number format lines up currency values within a column by currency symbol and decimal point.
• Dates and times are stored as numerical values in Microsoft Excel.
• Date and time formats can be selected in the Number group of the Home tab.
• Applying number formats helps to improve readability.
• Different formats affect dates and times in Microsoft Excel.
• The Number tab is the preferred tab for selecting number formats for dates and times.

Purpose of Functions and Formulas

• The purpose of using functions in Microsoft Excel is to perform calculations and analyze data.
• The 'Cost of Sales' formula calculates the cost of goods sold.
• Applying number formats helps to improve readability.