Lesson 14

Question 1

Calculated column

Answer 1

A column created in Excel table that holds the values entered for calculation for each row in that column number that are to be added using auto sum

Question 2

Enter button

Answer 2

A button that appears want to use the formula in a cell and allows you to enter that formula is shown as a checkmark on the tool table

Question 3

Formula

Answer 3

An equation used to calculate numbers

Question 4

Grid lines

Answer 4

Evenly spaced horizontal and or vertical lines used in a worksheet or chart to make it easier to read

Question 5

Navigate

Answer 5

To move around a worksheet navigation can be accomplished by using the arrow keys or that page up or page down keys on the keyboard

Question 6

Range

Answer 6

Specific set for items were cells in a spreadsheet designated with beginning and ending point usually ranges can be selected by dragging or typed in the formula bar

Question 7

Sum button

Answer 7

The Excel formula function as the numbers and selected cells and updates that total according to the numbers placed in those cells

Question 8

Sum

Answer 8

The total of added numbers

Question 9

Value

Answer 9

The content in a cell such as a text, a number etc that meets criteria within Microsoft Excel

Question 10

Auto sum tool

Answer 10

Tool in Microsoft Excel that allows you to choose from several formula options including sum