Q&A Hero

Q: The Excel formula =MINVERSE(B1:D3) will calculate a. the inverse of each value in the range B1 through D3. b. the smallest value in the range B1 through D3. c. the inverse of the matrix in range B1 through D3. d. none of the above.

Q: An array of numbers, variables, or mathematical terms is known as a a. list. b. matrix. c. scalar. d. vector.

Q: A physical variable that possesses both magnitude and direction is known as a a. number. b. matrix. c. scalar. d. vector.

Q: A physical variable that is identifiable by either a single value or magnitude is known as a a. number. b. matrix. c. scalar. d. vector.

Q: In Excel, two sets of data with different ranges can be plotted on the same chart. a. True b. False

Q: As an engineer, most of the charts that you will create will be of which type? a. column charts b. pie charts c. line charts d. xy charts

Q: If cell A3 contains the value of 74, and if you were to type the following command in cell B3 =IF(A3>60,"PASS","FAIL"), what would be the result? a. 74 b. 60 c. PASS d. FAIL

Q: In Excel, functions that allow you to test various conditions when programming formulas to analyze data are known as a. logical functions. b. conditional functions. c. analytical functions. d. test functions.

Q: Which of the following Excel functions will automatically update the date and time the file was last used? a. =LAST_MODIFIED b. =TODAY c. =CURRENT d. none of the above

Q: The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees. a. True b. False

Q: Which of the following Excel functions will correctly calculate the cosine of the value in cell A1? a. =COSINE(A1) b. =COS(A1)

Q: Which of the following Excel functions will correctly calculate the square root of the value in cell A1? a. =SQUARE_ROOT(A1) b. =SQUAREROOT(A1) c. =SQUARE_RT(A1) d. =SQRT(A1)

Q: Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9? a. =AVG(A1:A9) b. =AVE(A1:A9) c. =AVERAGE(A1:A9) d. =MEAN(A1:A9)

Q: The Excel functions are grouped into various categories, including mathematical and trigonometric, engineering, statistical, financial, and logical functions. a. True b. False

Q: The mixed cell reference could be done in one of two ways: (1) You can keep the column as absolute (unchanged) and have a relative row, or (2) you can keep the row as absolute and have a relative column. a. True b. False

Q: Which of the following is the correct entry for a relative cell reference? a. C4 b. $C4 c. $C$4 d. *C*4

Q: Which of the following is the correct entry for an absolute cell reference? a. C4 b. *C4 c. $C$4 d. *C*4

Q: What are the three ways that you can refer to a cell address in a formula? _____________ _____________ _____________

Q: Which is the correct way to enter the following mathematical operation into Excel? a. =2+3/2+8-3/6 b. =2+(3/2)+8-3/6 c. =2+3/2+(8-3)/6 d. =2+(3/2)+(8-3/6)

Q: If you were to type the following into a cell, what would be the result in Excel? a. 25 b. 29 c. 19 d. 20

Q: If you were to type the following into a cell, what would be the result in Excel? a. 25 b. 45 c. 19 d. 20

Q: In Excel, a formula always begins with a. an equal sign (=). b. an apostrophe ("˜). c. a plus sign (+). d. an asterisk (*).

Q: A number of cells that are selected simultaneously is called a a. group b. multi-cell c. range d. cartel

Q: Visual Basic for Applications (VBA) is a programming language that allows you to use Excel more effectively. a. True b. False

Q: The intersection of a single row and a single column is called a a. data point b. data entry c. cell d. input

Q: In a spreadsheet, rows are marked with letters (A, B, C, etc.) while columns are marked with numbers (1, 2, 3, etc.) a. True b. False

Q: A worksheet is a spreadsheet file that you create and save whereas a workbook represents the rows and columns where you input information. a. True b. False

Q: Active cell refers to a specific selected cell. a. True b. False

Q: In a spreadsheet, the _________ contains the name of the current active workbook. a. title bar b. active cell c. column header d. status bar

Q: A spreadsheet is divided into a. lines and spaces. b. rows and columns. c. inputs and outputs. d. problems and solutions.

Q: Spreadsheets can be used to a. record, organize, and analyze data using formulas. b. evaluate mathematical, statistical, and logical functions. c. plot the results of engineering analysis. d. all of the above

Q: Test Bank Engineering Fundamentals, 5th ed. Chapter 14

Q: Ethanol is an alcohol-based fuel that is made from the sugars found in corn and barley. Other sources, such as rice, sugar cane, and potato skins, are also used to produce ethanol. a. True b. False

Q: Two types of wind turbines are used to extract the energy from the wind, a vertical axis turbine and a horizontal axis turbine. a. True b. False

Q: A photovoltaic system converts light energy directly into heat. a. True b. False

Q: A direct passive solar system uses large glass areas on the south wall of a building and a thermal mass to collect the solar energy. a. True b. False

Q: Solar energy starts with the sun at an average distance of 93 million miles from earth. The sun is a nuclear fusion reactor, with its surface temperature at approximately 10,000 F (5500 C). a. True b. False

Q: The U.S. natural gas transportation network consists of 1.5 million miles of mainline and secondary pipelines. a. True b. False

Q: The largest source of electric power in the U.S. is a. solar b. natural gas c. nuclear d. coal e. hydroelectric f. wind

Q: In general, efficiency is defined as a. actual output divided by required input. b. required input divided by actual output. c. actual output multiplied by required input. d. actual output minus required input.

Q: One horsepower represents the power required a. to lift an object weighing 220 lbf, a distance of 2.5 ft in 1 second. b. to lift an object weighting 100 lbf a distance of 5.5 ft in 1 second. c. to lift an object weighting 50 lbf a distance of 11 ft in 1 second. d. all of the above

Q: A common unit used in the United States in air-conditioning and refrigeration systems is ton of refrigeration or cooling. One ton of refrigeration represents the capacity of a refrigeration system to freeze a. 1000 lbm of liquid water at 32F into 32F ice in one hour. b. 2000 lbm of liquid water at 32F into 32F ice in 24 hours. c. 1000 lbm of liquid water at 32F into 32F ice in 24 hours. d. 2000 lbm of liquid water at 32F into 32F ice in one hour.

Q: A team is more powerful than an individual because a. the team can do more work than the individual in the same amount of time. b. the team can do the same amount of work as the individual, but in less time. c. the team can do more work than the individual in less time. d. All of the above.

Q: The SI unit for power is a. watts b. joules c. newtons d. horsepower

Q: Power can be described as a. how hard you push. b. how fast you push. c. how far you push. d. how long you push.

Q: The time rate of doing work is called a. energy b. power c. force d. momentum

Q: Power is found by dividing work by what other physical quantity? a. distance b. mass c. force d. time

Q: The law that simply states that energy is conserved is a. the 0th law of thermodynamics. b. the 1st law of thermodynamics. c. the 2nd law of thermodynamics. d. the 3rd law of thermodynamics.

Q: One Btu is a. nearly equal to 1000 J b. much smaller than 1000 J c. much greater than 1000 J d. none of the above

Q: What are the SI units for heat? a. Kelvins b. Celsius c. Joules d. Watts

Q: Thermal energy transfer is called a. temperature difference b. heat difference c. temperature flux d. heat

Q: Thermal energy transfer occurs whenever there exists a temperature difference within an object, or whenever there is a temperature difference between two bodies, or a temperature difference between a body and its surroundings. a. True b. False

Q: In the absence if heat transfer and no work, conservation of mechanical energy states that the total mechanical energy of a system is a. increasing b. constant c. decreasing d. none of the above

Q: In the following equation, what does the x stand for? elastic energy a. deflection of a spring from its unstretched position b. original length of an unstretched spring c. spring force d. total length of a stretched spring

Q: In the following equation, what does the k stand for? elastic energy a. kinetic energy b. spring constant c. modulus of elasticity d. momentum

Q: What is the SI unit for elastic energy? a. Newtons b. Watts c. Kelvins d. Joules

Q: Calculate the energy required to lift an elevator and its occupants with a mass of 1000 kg through a vertical distance of 5 m. a. 5000 J b. 49000 J c. 25000 J d. 2500 J

Q: A stone is dropped from a bridge and allowed to free-fall downward. As it falls a certain distance its gravitational potential energy decreases by1000 J. By how much does the stone's kinetic energy increase? (Neglect air resistance). a. 100 J b. 500 J c. 1000 J d. 2000 J

Q: The change in gravitational potential energy is found by multiplying an object's change in elevation by its a. mass b. weight c. density d. height

Q: A ping pong ball and a bowling ball are moving with the same momentum. Which has the greater kinetic energy? a. The ping pong ball b. The bowling ball

Q: Which of the following requires the most work done by the brakes of a car? a. slowing down from to b. stopping from c. equal amounts of work for both

Q: Which produces the greater change in kinetic energy (assume that all of the work goes into kinetic energy)? a. exerting a 10 N horizontal force through a distance of 5 m b. exerting a horizontal force of 20 N through a distance of 2 m c. exerting a 30 N horizontal force through a distance of 1.5 m d. exerting a horizontal force of 40 N through a distance of 1m

Q: How much kinetic energy does a 200 g soccer ball have while moving at toward your opponents' goal? a. 4 Joules b. 40 Joules c. 80 Joules d. 8 Joules

Q: What is the SI unit for gravitational potential energy? a. Newtons b. Watts c. Kelvins d. Joules

Q: If you were to push a lawn mower with a constant horizontal force of 20 N. How much work do you do while pushing the lawn mower a total distance of 100 m on level ground?

Q: In the U.S. customary system of units, the unit for kinetic energy is a. lbf.ft b. lbf.ft/s c. slugs.ft d. horsepower

Q: What is the SI unit for work? a. Newtons b. Watts c. Kelvins d. Joules

Q: Work is found by multiplying force by what other physical quantity? a. distance b. mass c. power d. time

Q: Power is a derived dimension. a. True b. False

Q: Energy is a fundamental dimension. a. True b. False

Q: An object having a mass m and moving with a speed V has a kinetic energy, which is equal to a. mV b. mV2 c. mV2 d. mV

Q: When work is done on or against an object, it changes the kinetic energy of the object a. True b. False

Q: Mechanical work is performed when a force moves an object through a distance. a. True b. False

Q: According to a light bulb manufacturer, its 75 W CFL floodlight consumes 25 W and produces 1500 lumens. What is the efficacy of the floodlight?

Q: Most indoor fluorescent light fixtures contain two or three 40-watt bulbs each. If a classroom has 15 fluorescent light fixtures, each with three 40-watt bulbs, how much does it cost to leave the lights on for a two-hour class? Assume the electric company charges approximately 10 cents per kilowatt-hour.

Q: In lighting design, a variable called CRI is often used. What does CRI stand for? a. Color Repeatability Index b. Color Rendition Index c. Capacitive-Resistive Index d. none of the above

Q: The ratio of how much light is produced by a lamp (in lumens) to how much energy is consumed by the lamp (in watts) is known as a. efficacy b. efficiency c. illumination cost d. energy cost

Q: A common unit of illumination intensity is called a footcandle and is equal to a. the amount of light one foot away from a candle. b. the amount of light from a one-foot long candle. c. one lumen distributed over an area of 1-square-foot. d. none of the above

Q: the amount of light emitted by a lamp is expressed in lumens. a. True b. False

Q: The distribution of light on a horizontal surface is known as a. luminescence b. luminosity c. illuminescence d. illumination