Shared Flashcard Set

Details

CGS midterm
CGS chapters 1 through 5
101
Computer Science
Undergraduate 4
10/15/2012

Additional Computer Science Flashcards

 


 

Cards

Term
######
Definition

  - Insufficient width in cell to display numerical data, or formulas that result in negative date/time (prior to 1/1/1990)

Term
#NAME?
Definition
Unrecognized text in a formula
Term
#N/A
Definition
No answer
Term
#REF!
Definition
Invalid cell reference
Term
#NUM!
Definition
Invalid numeric values in a formula or function
Term
#DIV/0!
Definition
– Division by zero
Term

  If you enter 1,149+25 in a cell exactly as shown (without an equal ign), what value would result?

 

Definition

     1,149+25

 

Term

   If you enter =2+4*10 in a cell exactly as shown, what value would result?

Definition

  42

 

Term
List each of the following  in order of precedence, from 1 to 4 (first to last)
Definition

·        Multiplication and division -- 3

·        Parentheses ( ) --1

·        Addition and subtraction -- 4

·        Exponentiation –2

Term

 

    When writing formulas, why is it preferable to use cell references rather than typing in values?

 

Definition

      It allows the user to easily update the spreadsheet without having to know exactly which formula or formulas contain the changed value.

Term

 

  Referring to the preceding worksheet, if you wrote the formula =B1*110, what value would result (assuming the displayed value is the precise value)?

 

Definition
11
Term

 

   What formula would you write to do each of the following?

 

·Add a range of numbers in cells A2:X2.

 

Definition

                   =SUM(A2:X2)

 

Term

 

·        Find the largest value in cells C2:C8.

 

Definition

  =MAX(C2:C8)

 

Term

     Find the smallest value in cells B2 through Z12.

 

Definition

MIN(B2:Z12)

 

Term
Find the average value in cells C1 through C10, assuming blank cells will be ignored
Definition

=AVERAGE(C1:C10)

 

Term

Find the total number of values listed in cells C1 through C10, excluding any that contain text.

 

Definition

  =COUNT(C1:C10)

 

Term
Syntax
Definition

    the specific format of a function, including the function name and the order of the arguments in the function.

 

Term
Argument
Definition
A function input
Term
Algorithm
Definition
 a rule that governs how a function works. An algorithm is a systematic set of procedure hat the computer always steps through to calculate the results of a function.
Term
   If the formula =$B$4-SUM(C1:C5) is copied from cell A9 to cell C10, what is the resulting formula?
Definition

   =$B$4-SUM(E2:E6)

 

Term

 

     Refer to the following worksheet. What formula would you write in cell B2 that can be copied down the column and across the row to complete the multiplication table?

 

Definition
        =$A2*B$1
Term

 

 What formula could you use to add up cell B1 from Sheet1!, Sheet2!, and Sheet3! (Assuming the worksheets are contiguous and in the same workbook)?

 

Definition

      =SUM(Sheet1!B1,Sheet2!B1,Sheet3!B1)

Term
Cell B1 has been given the range name discount. How would you write a formula in cell C1 that multiplies discount by cell A1? What new formula results if you copy this formula into cell C2?
Definition

 

·        =discount*A1

 

·        =discount*A2

 

Term

   What formula could you write to calculate the mean of the following data set: 2,5,4,3,1,2,7? (Note that a resulting value is not required.)

 

Definition

    =(2+5+4+3+1+2+7)/7

Term

 

   What is the median of the data set given in Question 1?

 

Definition
3
Term

  What is the mode of the data set given in Question 1?

2,5,4,3,1,2,7?

Definition
2
Term

 

   The data set given in Question 1 ( 2,5,4,3,1,2,7 )has a standard deviation of 1.58 as compared with another data set that has the same mean but a standard deviation of 2.5. What general differences would you expect to find between the two sets of data?

 

Definition

 

   The second set of data has values that occur further from the mean than those in Question 1.

 

Term

 

    In the chapter, the original labor rate for inspectors was given as $35 per hour. However due to contract renegotiation, this value is now $37.50. What algebraic expression could you use to determine the percent increase in labor costs? (Note that a resulting value is not required.)

 

Definition

       =(37.50-35)/35

 

Term

 

   When using the Increase Decimal button on the toolbar, the precise value in the cell is modified. True or False?

 

Definition
True
Term

  The formula =ROUND(345.43,0) results in what precise value?

 

Definition
345
Term

   Write a formula to round up 63.34% to the nearest percent.

 

Definition

      =ROUNDUP(63.34,2)

 

Term

 

 What is the symbol for the greater than or equal to relational operator in Excel?

 

Definition

      >=

 

Term

  What is the symbol for the nor equal to relational operator in Excel?

Definition

   <> 

 

Term

 

   Review the following worksheet, nd then use the COUNTIF function to write a formula that determines the munver of GM cars in the list.

 

Definition

  =COUNTIF(A2:A10,”GM”)

 

Term

     Using the worksheet shown in Question 11, write the formula to determine the number of cars that cost less than $20,000.

 

Definition

  =COUNTIF(B2:B10,”<20000”)

Term

  Using the worksheet sown in Question 11, write a formula to determine the total value of all ford cars.

Definition
=SUMIF(A2:A10,”Ford”,B2:B10)
Term

 

   Explain the difference between a “what-if” analysis and Goal Seek by giving an example based on the worksheet in Question 11.

 

Definition

 

     For a what if analysis you could change the sum of the prices of the cars and evaluate the total and for Goal Seek you could put what you want the total to be and tell excel to change the value of a certain cell to get that total.

 

Term

 

    Using the worksheet shown in Question 11, write a formula to determine the value of the third most expensive car.

 

Definition

      =LARGE(B2:B10,2)

 

Term

    If each car shown in Question 11is marked up between $50 and $250 in dollar increments, what function could be used to randomly assign the amount to be added to the car price in this formula? =B2+______

 

Definition

 

=B2+RANDBETWEEN(50,250)

 

Term

 

   The formula =RAND() gives what result?

 

Definition
Each time you write it gives a different, random value
Term

 

1.     What formula could you write to average the values in cell A10 through A20, excluding blank cells, rounded to the nearest 10?

 

Definition

 

=ROUND(AVERAGE(A10:A20),0)

 

Term

 

 Write a formula to determine the average price of only Ford vehicles using the worksheet in Question 11.

 

Definition

 

    =AVERAGEIF(A2:A10,”Ford”, B2:B10)

 

Term

 

     Write a formula to generate a random interger between 10 and 20.

 

Definition

 

     =RANDBETWEEN(10,20)

 

Term
Above all else show the data
Definition
do not clutter the chart by adding unnecessary illustration or decoration. Everything on the chart needs to have a reason for being there.
Term
Maximize the data-ink ratio
Definition

 

a.      refers to the proportion of the ink that is devoted to displaying the data versus the portion of a graphic that can be removed without losing the data.

 

Term
Erase non-data-ink
Definition

 

 related to maximizing the data-ink ratio. Non-data-ink is part of the chart that decorates more than informs.

 

Term
Erase redundant data ink
Definition
related to maximizing data-ink ratio. Redundant data ink is ink that repeats information
Term
Revise and edit
Definition

 

 feedback on the chart’s usefulness and clarity should be sought wherever possible, and the chart should be adjusted accordingly. The intended message of the chart must be considered. A positive feature in a chart might become negative if it doesn’t support what the chart creater is tryng to illustrate.

 

Term

     How do sparklines differ from charts?

 

Definition

 

    Sparklines are small word-sized charts or graphics and are embedded within the words, numbers and images they represent. They represent the ideal of Tufte’s five data graphics principles.

 

Term

 

  What are the three steps involved in using the Insert tab to create a chart?

 

Definition

 

    First select the data you want to display in the chart, click the insert tab, and then click a button in the Charts group pr the Dialog Box Launcher in the charts group if you want to choose from all the available chart types and sub-types.

 

Term

 

  Give an example of a low data-ink ratio in a chart.

 

Definition

 

   When a chart has too much data, labels and chart effects.

 

Term

 

  How do you change the chart type of an existing chart?

 

Definition

  You select the chart or chart series you want to whose type you want to change then in the type group on the Design tab, click the change chart type button and choose the type you want to change it to.

 

Term

 

     What chart limits does Excel have in terms of data points and series?

 

Definition

 

   A chart requires at least one numeric data series and at least one label data series. The number of data series and points that excel can display in a chart is only limited by available computer memory and capacity.

 

Term

 

     How many standard chart types and sub-types are available in Excel?

 

Definition

 

  11 standard chart types and 73 sub-types

 

Term

 

 What are the differences and similarities between a line chart and an X Y (Scatter) chart?

 

Definition

 

 An X Y (Scatter) chart [plots numeric values on both the x- and y-axes based on the value of the data, where as the line chart plots numeric values on one axis and category labels equidistantly on the other axis

 

Term

 

    Explain the difference between the data points in a line and an X Y (Scatter) chart.

 

Definition

 

  The line chart plots the data points along the y-axis based in the value, but the x-axis is based on position because this axis contains categories. The X Y (Scatter) chart plots both the y- and x-axis data as numeric values.

 

Term

 

   What are the differences between a bar chart and a column chart? Give an example of when you would use each one.

 

Definition

 

   A bar chart compares values across categories in a horizontal orientation and values are indicated by the length of the bars. A column chart compares values across categories in a vertical orientation and values are indicated by the height of the columns. You could use either one to compare values across categories.

 

Term

 

     What are the differences between a column chart and an area chart? Give an example of when you would use each one.

 

Definition

 

a.      A column chart compares values across categories in a vertical orientation and values are indicated by the height of the columns. An area chart displays trends over time by category and the values are indicated by thr filled areas below the lines. You could use a column chart to compare the amount of  sales for each category and you cold use the are chart to illustrate the sales trends in different categories over  a longer time period, while emphasizing the contribution that each category made to particular year’s performance.

 

Term

 

  How do pie charts differ from doughnut charts?

 

Definition

 

   Pie charts compare the contribution of each value in a single numeric data series and makes to the whole, or 100% and values are indicated by the size of the pie slices. A doughnut chart compares the contribution value in multiple numeric data series makes to the whole and values are indicated by the size of the doughnut segments.

 

Term

 

   When should you use a stacked line, column, or area chart? How do the stacked charts differ from regular charts?

 

Definition

    You shoud use them to show the totals for each category. Staked charts illustrate the cumulative effects of data in categories.

 

Term

 

  When should you use a 100% staked line, column, or area chart? How do the 100% staked charts differ from staked charts?

 

Definition

 

   They can be used as an alternative to a pie chart and can help reduce confusion as over whether the lie line on the charts represents the individual or cumulative contribution to the whole The 100% staked charts illustrate the cumulative contribution for each category expressed as a percentage.

 

Term

 

   What chart sub-types are available for the stock chart in Excl? Explain how you interpret the data markers in each of the sub-types.

 

Definition
The sub types available for the stock chart are High-Low-Close chart, Open-High-Low-Close, Volume-High-Low-Close, and Volume-Open-High-Low-Close. On the high-low-close chart the vertical line on th marker represents the range of lwest to highest stock prices for a time period and the tip of the arrow head represents the closing pricefor the time period. On the Open-high-low-close chart the vertical line represents the range of lowest to highest stock prices, a black box indicates a decrease in stock value,  white box indicates an increase in the stock value and the top and bottom of the box indicate the opening and closing prices
Term

 

   How does a radar chart differ from other charts? Give an example of when you would consider doing a radar chart.

 

Definition

 

      A radar chart compares values across categories in a circular orientation and values are indicated by the distance from a center point. You would do a radar chart to show the numerical value that each category contributed to the whole.

 

Term

 

     Define a bubble chart and explain what type of data is suitable for plotting on a bubble chart.

 

Definition

 

     A buble chart compares sets of three values and values are indicated by the sixe of the bubbles. 3-D data is suitable for plotting on a bubble chart. For example it can be used to display the relationship between the number of styles of shoes offered, sales, and market share.

 

Term

 

    When should you use a dashboard chart?

 

Definition

 

     A dashboard chart can be used to provide a quick, visual summary of  performance indicators.

 

 

 

Term
AND(FALSE,TRUE,TRUE)--
Definition

 

    False

 

Term
=OR(3>5,TRUE)—
Definition
True
Term
=NOT(OR(FLASE,FALSE,FALSE))—
Definition
True
Term
=AND(A2>6,NOT(FALSE))where A2 contains the value 25--
Definition
False
Term

 

 Describe how you would format a cell so that is the value Is greater than 50 it would be automatically bolded.

 

Definition

 

      You select the cells you want to apply the conditional formatting to then click the conditional formatting button in the styles group in the home tab and then point to the highlight sells rule to display its options. Then select greater than and type in 50 and then use the format cell dialog box and select bold then click OK.

 

Term

 

     What formula is used in cell E3, which can be copied down the column to determine (TRUE or FALSE) if the item is within budget?

 

Definition

 

     =OR(D3<C3,FALSE)

 

Term

     Write a formula to determine if all the items are in budget.

 

Definition

 

     =AND(E3:E8,TRUE)

 

Term

    Write a formula to determine if at least one item is within budget.

 

Definition

 

    =OR(E3:E8,TRUE)

 

Term

 

     Write a formula in cell F3 that can be copied down the column to determine if this food item is not within budget.

 

Definition

 

    =NOT(E3,FALSE)

 

Term

 

  Write a formula to determine if none of the values are within budget.

 

Definition

     =AND(E3:E8,FALSE)

 

Term

 

     Write a formula to determine if (TRUE or FALSE) only the required items (R) are within budget. Note that this formula does not have to work if the optional/required categories are later modified.

 

Definition

 

     =IF(B7="r",AND(E7,TRUE),FALSE)

 

Term

        Are the following two Boolean expressions equivalent? Why or why not?

·        =NOT(OR(E3:E8))

 

·        =AND(NOT(E3),NOT(E4),NOT(E5),NOT(E6),NOT(E7),NOT(E8))

 

Definition

 

     These expressions are equivalent because they both give you the same answer

 

Term

 

    Is the following formula valid? Why or why not?

 

·        =NOT(E3:E8)

 

Definition

 

                                                                    The formula is not valid because for a NOT function you are only supposed to put one argument and it changes it to the opposite of what the argument says.

 

Term

     What value would the following formula return?

 

Definition

 

       =IF(D4<=C4,”within budget” ,”over budget”)

 

                                                              i.      it returns “over budget”

 

Term

 

    What value would the following formula return?

 

Definition

 

     =IF(SUM(D6,D8)<200, “go to both”, IF(SUM(D6,D8)>450,”go to neither”,”choose one”))

 

                                                              i.      it returns “go to both”

 

Term

 

     Write a formula in cell G3 that can be copied down the column to return the following:

 

·        If this item has an actual cost of less that $100,then return the text “Minor Component Cost”.

 

·        If this item has an actual cost of $100 or more, then return the text “Major Component Cost”.

 

Definition

 

                                                                    =IF(D3<100,”Minor Component Cost”,IF(D3>=100,”Major Component Cost”,” “))

 

Term

 

     Write an excel formula in cell H3 that can be copied down the column to calculate the cost of this component for a larger sales meeting based on the following:

 

·        If this item is optional as indicated in column B, then the cost will be equal to the original budgeted amount.

 

·        If this item is required as indicated in column B, then the cost will  be three times the original budgeted amount.

 

Definition

 

                                                                   =IF(B3=”O”,C3,IF(B3=”R”,3*C3,C3)

 

Term

 

1.     The lookup_value of a VLOOKUP function can be a contiguous cell range.

 

Definition
True
Term

 

    In a VLOOKUP formula with a TRUE lookup type, the first column of the lookup table referenced must be in ascending order to retrieve the correct value.

 

Definition
True
Term

 

     The result_vector of a LOOKUP function must be sorted in ascending order.

 

Definition
False
Term

 

     Reference and Lookup functions may not contain nested functions as arguments.

 

Definition
False
Term

 

     The default range_lookup type for the VLOOKUP and HLOOKUP functions is FALSE.

 

Definition
False
Term
Excel matches the lookup_value “tom” with the entry “TOM” in a lookup table.
Definition
True
Term

 

  The row and column arguments in the INDEX function can be numeric values, Boolean values, or text.

 

Definition
True
Term
The formula =returns the value in cell D13.
Definition
True
Term
The formula =AVERAGE(CHOOSE(1,B12:D17,B22:D17)) averages the value 1 with the values in cells B12 to D17 and B22 to D17.
Definition
False
Term

 

     The Formula =MATCH(40, {10,40,50,90},0) returns the value 2.

 

Definition
True
Term

 

What happens  when Excel is solving a VLOOKUP formula with a FALSE range_lookup type and does not find an exact match in the lookup table?

 

Definition
The text #N/A is displayed in the cell.
Term

 

    What happens  when Excel is solving a VLOOKUP formula with a FALSE range_lookup type and does not find an exact match in the lookup table?

 

Definition

 

    The text #N/A is displayed in the cell.

 

Term

 

    What is the difference between the LOOKUP function and the VLOOKUP or HLOOKUP function?

 

Definition

 

        The LOOKUP function looks up values anywhere in a table or range and VLOOKUP can only retrieve data from a table with a vertical orientation and an HOOKUP from a table with a horizontal orientation.

 

Term

 

     Which Excel function should you use when you want to look up a value from a two dimensional table, where both the columns and rows can be varied?

 

Definition

        The INDEX function

 

Term

 

    Write a formula to choose the name of the fifth day of the week from the list starting with Sunday, Monday, Tuesday…Saturday.

 

Definition

        =CHOOSE(5,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

 

Term

 

     What is the difference between the LOOKUP function and the MATCH function?

 

Definition
A LOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range and a MATCH function returns the relative position of a matched value in a list.
Term
Florida State Fight Song
Definition

 

You got to fight, fight, fight for FSU! You got to scalp ‘em Seminoles! You got to win, win, win, win this game and Roll on down to make those goals! For FSU is on the warpath now, and at the battle’s end she’s great.  So fight, fight, fight for victory, the Seminoles of Florida State! F-L-O-R-I-D-A…. S-T-A-T-E FLORIDA STATE !! FLORIDA STATE!! FLORIDA STATE!! Woooooooooooo!!

 

Supporting users have an ad free experience!