Explanation

A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations

the columns are normally represented by letters, "A," "B," "C," etc.,

while

rows are normally represented by numbers, 1, 2, 3, etc.

SH31-07-2023

Explanation

When you type a zero (0) before a fraction, Excel will treat it as a numerical value rather than a date.

This is a quick way to ensure that your fractions are displayed correctly in your spreadsheet.

Example: 0 1/2 (Displays as a fraction)

Explanation

Cells are the basic building blocks of a worksheet.

Explanation

To use a keyboard shortcut to change between lowercase, UPPERCASE, and Capitalize Each Word, select the text and press SHIFT + F3 until the case you want is applied.

**** 

RY19012023

Explanation

Explanation

To duplicate values in a cell range in Excel 2016, follow these steps:

• Select the range of cells that you want to duplicate.
• Go to the Home tab in the ribbon.
• Click on the "Fill" handle (the small square at the bottom-right corner of the selection) and drag it down to the range where you want to duplicate the values.
• Alternatively, you can right-click on the selection and choose "Copy" (or press Ctrl+C), then select the range where you want to duplicate the values and right-click and choose "Paste" (or press Ctrl+V).

Explanation

Color and pattern used to fill a closed shape is called Fill Style

Explanation

In MS Excel, a function is a pre-defined formula that performs a specific calculation or operation.

Examples of functions in Excel include SUM, AVERAGE, COUNT, IF, and many others.

Functions are used to manipulate data, perform calculations, and analyze information in a spreadsheet.

Explanation

Freeze columns and rows in Excel

• Select the row below the row(s) you want to freeze (select row 6 if you want to freeze rows 1 to 5).
• On the View tab, click Freeze Panes > Freeze Panes.

Explanation

Split data into multiple columns

1. Select the "Sales Rep" column, and then select Home > Transform > Split Column.
2. Select Choose the By Delimiter.
3. Select the default Each occurrence of the delimiter option, and then select OK. ...
4. To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".