Spreadsheet

Vocabulary Words

100

What is a value in Spreadsheet?

A number entered into a spreadsheet cell that will be used for calculations.

200

Intersection of row and a column and identified by a cell reference

Cell

300

What is a formula?

Equations with symbols for mathematical operations, usually begins with equal signs. Ex =B6+B7

400

Chart that only shows one data series and is used to compare sizes of each part of the whole or percentage.

Pie Chart

500

What is range and union in spredsheet?

Range is a selection of more than one cell next to each other (adjacent to each other). Union is to combine one or more than two ranges to perform different sets of operations on them.

True or False

100

Horizontal or vertical line that extends across the plot area of the chart to make it easier to read or understand

True

200

When you create a formula that contains a function, the Insert Function dialog box helps you enter worksheet functions.

True

300

The data to be drawn as a chart cannot be selected after the chart wizard is started.

False

400

In Excel, pressing [Ctrl] + [Spacebar] select the entire row.

False

Note: [Ctrl]+[Spacebar] Select entire column. [Shift]+[Spacebar] Select entire row.

500

If the Bold and Underline buttons are appearing lighter than before, it means that they are currently in use. 

False

Functions and Formulas

100

Differentiate between Formulas and Functions.

Formula needs to start with an “=“ sign to tell MS Excel to expect a calculation. Otherwise, you will just see Labels (text) and Values (numbers) in the cell but Functions are prewritten formula already in Excel, (eg- =sum, =average.)

200

What are the formulas or the mathematical operators (symbols) use in Excel?

* is to multiply

- is to subtract

+ is to add

/ is to divide

300

Give the definition of MIN and give an example.

*MIN is the function for finding the smallest number in a set of numbers.

-For example, if you have the numbers 1, 5, 20 and 40, the smallest number is 1.

400

State at least 4 functions in excel and their meanings.

Sum: The Sum Function returns the total of the range values.

Average: It returns the average of the range values.

Max: It is used to find the largest value in given range.

Min: It is used to find the lowest value given range.

500

What are the 3 types of cell references?

-Relative Reference

-Absolute Reference

-Mixed Reference

Extra

100

Unscrambled these words:

FI ONCUITNF

LORMFUA ABR

TASEDERPSEH

IF function

Formula Bar

Spreadsheet

200

When you see this ########## on your spreadsheet, describe what it means and what you will do to resolve this.

In Excel, it means that the cell is too narrow to display the value or formula. You can fix this by adjusting the column width or changing the number format.

300

State at least 4 advantages of MS Excel

Advantages:

-makes numeric calculation fast and accurate.

-create charts or graphs.

-formulas can be updated and recalculated quickly.

-data is easily retrieved, edited, printed and stored.

400

What does it mean when you see these signs on your excel calculations?

#VALUE

#DIV.0!

#NUM!

#VALUE: means you type the wrong argument or operand

#DIV.0!: means a formula divides by 0 (zero) was used

#NUM!: means when a problem occurs with a number in a formula or function.

500

Fill in the blanks with the correct words from the list.

Cost, calculations, formula, training, graphs

Spreadsheet is now very common in offices. It is very useful as one can perform ________________ and therefore does not need a calculator anymore. One can also create _____________________ to display information such as results. As one needs to have good knowledge of spreadsheets, one needs to go through proper ____________________, and this can ________________ one up to a few hundreds of tala.

Spreadsheet is now very common in offices. It is very useful as one can perform calculations and therefore does not need a calculator anymore. One can also create graphs to display information such as results. As one needs to have good knowledge of spreadsheets, one needs to go through proper training, and this can cost one up to a few hundreds of tala.