Creating and manipulating data

Which of these definitions describes a function in excel?

• Ready made, built in tools for manipulating data.

• A varying quantity of data.

• An activity that makes things easy to create.

• A command that creates calculations etc.

A spreadsheet _________ carries out calculations on numbers using cell addresses and mathematical operations.

• Range

• Formula

• Always

• Formulas

What is relative cell referencing?

• When changing the data inside of a cell to match another cell.

• All cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns.

• When you insert different currency symbols in order to fit a purpose.

• Deleting copied cells.

The SUMPRODUCT function is used for...

• Adding up the results of multiplying the corresponding cells.

• Dividing numbers.

• Subtracting numbers.

• Diving and subtracting numbers.

The functions: ROUND, ROUNDUP AND ROUNDDOWN are used for...

• Changing numbers to text.

• Finding the specific decimal point of numbers in cells.

• making numbers simpler while keeping each value as close as possible to the original value.

What would be the correct answer to this formula: =ROUNDUP(1123.3467,2) ?

• 1123.3

• 1132.34

• 1123.34

• 1134.24

What are the two possible results from a Logical or boolean operator?

• TRUE OR FALSE

• YES OR NO

• NOT OR AND

What is the VLOOKUP function used for?

• finding values in a table in Microsoft word

• finding values in a table that corresponds to a value in the first column

• looking for possible answers on the internet

• searching for answers in a file using excel

Match can find where a value is so that INDEX can use the result of match to find a corresponding value in a different list.

• TRUE

• FALSE

What does the INDIRECT function do?

• It allows users to create cell references that change instead of placing the actual references in formulas.

• It allows users to configure data inside of a cell that has a booleen operator.

• Deletes all data in a cell referenced cell.