Excel 2.1

What is the General format?

The default Excel number format that displays numbers just as they are entered.

.xlsx

file extension for Excel

The range B3:B13 is merged into a single cell. What is the cell reference?

B3

How do you format text so that it is set vertically within a cell?

Click the Orientation button in the Alignment group on the Home tab, and then click Vertical Text.

How do you change the color of a worksheet tab?

Right-click the sheet tab, click Tab Color on the shortcut menu, and then select the color you want to use.

What is the difference between a serif font and a sans serif font?

Serif fonts have extra decorative strokes at the end of each characters. Sans serif fonts do not include these decorative strokes.

Describe the differences between the Accounting format and the Currency format.

The accounting format places the currency symbol on the left edge of the cell, adds a thousands separator, shows values to two decimals places,displays negative values in parentheses, and displays zero values as dashes. The Currency format places the currency symbol to the left of the first digit of the monetary value, adds a thousands separator, shows values to two decimal places, and displays negative numbers with a negative sign.

A cell containing a number displays #######. Why does this occur, and what can you do to fix it?

The number of digits could not fit within the width of the cell. To correct this problem, either increase the width of the cell column or reduce the number of digits to the right of the decimal point.

What is the difference between theme colors and standard colors?

Theme colors are a set of 12 coordinated colors that belong to a theme. Standard colors are 10 colors that are always available regardless of the workbook's theme.

f4

repeat last action