Excel Basic Knowledge

1. If labels spill onto the column to its right & the column on the right is not empty you need to

Re size the column

Complete your calculations by hand, excel is too hard to learn

Leave it the way it is

2. Formula's always start with

=

-

+

*

3. This button allows you to incorporate the currency format to data

.

%

=

-

$

4. You can check results of your calculations by using

Auto fit

Auto replace

Auto correct

Auto calculate

5. When you key the date, excel applies a standard format that shows

2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.

Excel leaves it exactly the way I type it!

The formula to change the date

6. A__________ is a single point of color on the screen

Pixel

Cell

Border

Margin

7. A________ is a series of instructions that performs a calculation & displays an answer

Function

Formula

Range

Cell

8. What does the function Sum do?

Adds the values in the range & then divides by the number of cells in the range

Determines the largest value in a range

Multiplies the values in a range

Adds the values in the cell

9. You can use text in a formula

True

False

10. A value is always _____________ aligned in the cells & is included in calculations

Left

Centered

Justified

Right

11. To set up subtotals the data must first be formatted as a table

True

False

12. When sorting, you must highlight the entire column of the column you wish to sort by

True

False

Excel Basic Knowledge

1. If labels spill onto the column to its right & the column on the right is not empty you need to

2.

What first name or nickname would you like us to use?

2. Formula's always start with

3. This button allows you to incorporate the currency format to data

4. You can check results of your calculations by using

5. When you key the date, excel applies a standard format that shows

6. A__________ is a single point of color on the screen

7. A________ is a series of instructions that performs a calculation & displays an answer

8. What does the function Sum do?

9. You can use text in a formula

10. A value is always _____________ aligned in the cells & is included in calculations

11. To set up subtotals the data must first be formatted as a table

12. When sorting, you must highlight the entire column of the column you wish to sort by