Module 1

Which special character is used to lock a particular value in excel so that it remains constant in the sumproduct function?

$

You freeze the total cell so that it doesn't change when copied by putting what symbol in front of the letter and number that represents the cell position.?

$

If you are referencing cell (C2)in Excel and want to be able to copy the formula and keep using the data in cell C2 in every place you copy it to, how do you reference the cell?

$C$2

To add up series of number, if we don't use the sum function, what symbol do you use?

+

The RAND function returns a random number that is greater than or equal to _____ and less than 1.

0

Please write 18.796512% in decimal format, rounded to 2 decimal points

0.19

34.00% can be written in decimal format as ____.

0.34

44.00% can be written in decimal format as ____.

0.44

Please round the 0.525254 to 1 decimal points

0.5

Please round the 0.729676 to 3 decimal points

0.730

I am setting up a Excel Spreadsheet to calculate my monthly expenses for a year. My rent is $650 per month. How many time should I enter the value 650 into the spread sheet. Please choose the best answer. 12 times, once for each month 1 time in the month of January and reference it the other months 1 time with a heading and then reference it for all months 0 since I don't like the apartment

1 time with a heading and then reference it for all months

What would be the result of =SUM(A1,25), if A1= 10,740.00?

10765

The probability of selling 10 donuts in a hours is .15, written in a decimal format. The value can also be written as

15%

You run a school in Florida. Fixed monthly cost is $5,362.00 for rent and utilities, $5,671.00 is spent in salaries and $1,748.00 in insurance. Also every student adds up to $104.00 per month in stationary, food etc. You charge $694.00 per month from every student now. You are considering moving the school to another neighborhood where the rent and utilities will increase to $11,374.00, salaries to $6,370.00 and insurance to $2,348.00 per month. Variable cost per student will increase up to $169.00 per month. However you can charge $1,092.00 per student. How much do you currently charge per student?

694

You want to copy a row of data to another row, which of the following do you use? You will copy the formula and want the columns to change and not the rows. =$A$1 =$A1 =A$1

=A$1

Please enter the correct syntax for the RAND function, include the = sign and the ()?

=RAND()

If you want to add the cells a10 through a20 using a function, what is the formula you would enter in Excel? Use the = and ()

=SUM(a10:a20)

What function lets you test if something is true or false and then do different things depending on which result you get? (include the = and (), but don't need to include the conditions)

=if()

When one wishes to select the largest number from a set of data, one should use which function? Include the equal sign and the ().

=max()

When one wishes to select the smallest number from a set of data, one should use which function? Include the = and()

=min()

If you are referencing cell (C2)in Excel and want to be able to copy the formula and update the column and keep the row fixed, how do you reference the cell in a formula, you don't need to include the =?

C$2

All of the following are true of calculated data except? Calculated data fields should only contain cell references. Calculated data fields should always appear before the Input Data fields. Calculated data fields can be on a different sheet than the Input data fields. Calculated data fields can be on the same sheet as the Input data fields.

Calculated data fields should always appear before the Input Data fields.

Once you have a Pivot Table you can create a Pivot ________?

Chart

What is the Key Sequence to: Move value from J5 to E5 ctrl c, ctrl v ctrl v, ctrl c Ctrl x + Ctrl v

Ctrl x + Ctrl v

The correct way to enter a cell address (for cell D3) in Excel when you want the row to always stay the same, but you want the column to change when you copy to the right or left is? You don't need to include the =.

D$3

All of the following are good spreadsheet practices for Input data except? Put all input data fields together Use some kind of formating to show that all input data fields go together. Input data fields can be on a different sheet than the calculated data fields Input data fields have to be on the same sheet as the calculated data fields

Input data fields have to be on the same sheet as the calculated data fields

To find the Pivot Table icon in Excel, first click on the _______ tab at the top.

Insert

How should you organize your spread sheet? It doesn't matter since I don't want anyone else to understand it Even numbers on one page, odd numbers on the other Isolate input data from calculated fields Even rows input data, Odd rows calculated fields

Isolate input data from calculated fields

Models are used to save _______ and time?

Money

Data to work in a Pivot Table needs to be organized as a _____?

Table

When entering information into the If Function, the second argument tell what to do if the first argument is?

True

What is the name of an Excel function that searches for values in a column of a spreadsheet list or table and return another value from the table? (don't need equal sign or ()

VLOOKUP

What is the name of an Excel function that searches for values in a column of a spreadsheet list or table and return another value from the table? (don't need equal sign or () )

VLOOKUP

RAND function: To make the value static so that they don't keep changing when we click anywhere in the Excel sheet, use copy and then paste as ______.

Values

To select the data you want to be in the body of the Pivot Table, drag the column header to the _________ box. (type out the first word, don't use the symbol).

Values

To lock the top row in excel so that it will always be visible when you scroll, you first go to which tab?

View

If you see a cell filled with ########, what does it mean Excel is taking a break You have a circular error You answer is wrong Your number is too big to fit in the cell width you have set

Your number is too big to fit in the cell width you have set

All of the following are good spreadsheet practices except: a) Only the person that created it understands it b) Organized c) Avoid embedding numbers in formulas d) Label your data

a

What is the Key Sequence to: Continue pattern counting number of students? ctrl c, ctrl v block off 1 and 2 and get + in bottom right and drag down Ctrl x + Ctrl v

block off 1 and 2 and get + in bottom right and drag down

Once you train an algorithm, it becomes a) an Excel spreadsheet b) machine learning code c) a model d) an algorithm

c

What is Not true about models a) A model helps in prediction and understanding a system b) A Model saves money c) Models are always a perfect representation of a system d) Model helps in Decision making

c

Which of these statements on Vlookup() is false? A. The Vlookup function can be used to compare a value that's between two values or for an exact value. B. When this function is used to find a value between, you must always place the smallest possible value first in the first column. C. The values of the first column must be in descending order. D. With this function, the comparison table is always read vertically.

c

A particular cell in Excel is referred to by it's cell name, such as D25. The D refers to the ______?

column

In a VLOOKUP formula, the argument column_ index_ number is the number of the __________ within the selected table_array where the lookup result is located.

column

The ______ are labeled according to the type of data being represented.

column

What is the Key Sequence to: Copy Kevin's scores to Mahmoud? ctrl c, ctrl v ctrl v, ctrl c

ctrl c, ctrl v

An algorithm is: a) a step-by-step set of instructions b) a recipe c) the exact same as a model d) A and C e) A and B d) A, B and C

e

Using good spreadsheet practices improves usability and reduces the chance of ________.

errors

What value will go in the fourth position (4 below) in a Vlookup if you want an exact match? =VLOOKUP(1,2,3,4)

false

When entering information into the If Function, the third argument is what to do if the first condition is:

false

Clicking on the button fx (found towards the top left in Excel), a box or screen pops up so you can enter values for _______.

functions

To create a chart in Excel, click on the _______ tab at the top to locate the Chart.

insert

When you want to create a Pivot Chart from your Pivot Table, you must first click on your Pivot Table, then you click on?

insert

The Average function is used to calculate the __________ of the selected data. (Another word for average)

mean

The MEDIAN returns the _________ value from a set of numbers.

middle

If you are entering how much you pay in rent into a spreadsheet, how many times should you enter this value? 12348 times Once Once per sheet Once for each month

once

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. A25 contains a value that will find a match in the table. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return, a product number or product price?

product price

What button do you click on to update the pivot table?

refresh

The labels usually are place in the first ________?

row

In a Pivot Table, the column label for the data you want in the rows is dragged to which box in the bottom half of the Pivot Table Fields?

rows

When entering information into the If Function, the second argument tell what to do if the first argument is?

true

RAND function: To make the value static so that they don't keep changing when we click anywhere in the Excel sheet, use copy and then paste as ______.

values

To lock the top row in excel so that it will always be visible when you scroll, you first go to which tab?

view