BSIS2610 Chapters 1-7
Define "opt in" and "opt out" customer preferences.
"Opt out" means customers will not receive marketing messages unless they specifically request them. "Opt in" means that customers instruct companies to share their information or use it for promotional purposes.
If the VLOOKUP function cannot find the lookup value, the error value is displayed in the cell.
#N/A
What is the result of the formula =40/10-4
0
What is the result of the formula =(40+10)*4
200
What is the default column width?
8.43 characters
What is the result of the formula =40+10*4?
80
What does a green triangle in a cell indicate?
A Possible Error
What is a chart style?
A chart style is similar to a cell style or a table style in that it formats several chart elements at one time. You can change the color and appearance of the slices by selecting a different chart style from the Chart Styles gallery on the Chart Tools Design tab
What is a line chart?
A line chart compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.
What are watermarks and what are they used for? Where are they located on a worksheet?
A watermark is text or an image that appears in the background behind other content. Watermarks are inserted into the header or footer of a worksheet. Many businesses distinguish works in progress from final versions by including the word "Draft" as a watermark on each page.
______________ is the amount of money being loaned? A. Principal B. Interest C. Future value D. Payment
A. Principal
In the order of operation rules, Excel first calculates the value of any operation within parentheses, and then it applies _____. A. exponentiation B. addition C. multiplication and division D. subtraction
A. exponentiation
What is the syntax of the Average function?
AVERAGE (number1, number2, number3, ...)
If you don't want the cell reference to change when you copy the formula use the ____________reference.
Absolute
You press the ____________ key to display the Key tips, which are labels that appear over each tab and command on the ribbon.
Alt
What is an endoscope?
An endoscope is a tubular probe with a tiny camera that allows a surgeon to see images of the body's internal structures.
What symbol appears at the beginning of a function?
An equal sign =
The Themes group is found on the HOME tab. TRUE OR FALSE
Answer: FALSE, it is found on the PAGE LAYOUT tab
______ changes the column width or row height to display the longest or tallest entry within the column or row.
AutoFit
A(n) ___________ is descriptive text that appears next to the axis.
Axis Title
Which chart compares relative values of different categories to the whole? A. Column chart B. Pie chart C. Bar chart D. Line chart
B. Pie chart
The specifies the worksheet cells that contain the data on which the chart will be based. A. chart type B. chart options C. chart source data D. chart location
B. chart options
The provides a description of the chart. A. chart legend B. chart title C. data labels D. chart location
B. chart title
You create new workbooks from the New screen in ____________ view.
Backstage
A column chart turned on its side is called a(n) __________ .
Bar Chart
To see more Border options, in the Font group on the Home tab, click the ...
Borders button arrow
What is an embedded chart? What are the advantages and disadvantages of the embedded chart?
By default, a chart is inserted as an embedded chart, which means the chart is placed in a worksheet next to its data source. The advantage of an embedded chart is that you can display the chart alongside any text or figures that can plain the chart's meaning and purpose. A disadvantage is that an embedded chart covers worksheet cells, which might contain data and formulas.
What value does this function return: =AVERAGE (3, 6, 7, 8)? A. 3 B. 5 C. 6 D. 7
C. 6
The _____ function calculates how many unique items are include in a range? A. NUMBER B. SUM C. COUNT D. ITEMS
C. COUNT
The allows you to see the effects of formatting options on the workbook's appearance before you apply them. A. Form Wizard B. Theme C. Live Preview D. Print Preview
C. Live Preview
A pie slice is an ample of a ____________ . A. legend B. chart title C. data marker D. data label 9
C. data marker
Each cell is identified by a(n) _____, which is based on the cell's column and row location.
Cell Reference
Excel uses to slow down the effect of changing data source values, making it easier to see how changing one value affects the chart.
Chart Animation
A(n) _____ contains a chart that provides a visual representation of worksheet data.
Chart Sheet
What is the benefit of combination charts?
Combination charts enable you to show two sets of data using the chart type that is best for each data set. Combination charts can have data series with vastly different values.
A(n) _______ is a symbol that indicates the relationship between two values.
Comparison Operator
To toggle in and out of formula view, press the ________ keys.
Ctrl+` keys. The ` grave accent symbol is usually located above the Tab key on your keyboard.
The most efficient way for copying only formatting is to use the feature. A. Copy B. Ctrl-V (Paste) keyboard shortcut C. Merge cells D. Format Painter
D. Format Painter
Every function follows a set of rules, or _____. A. operations B. arguments C. reference D. syntax
D. syntax
A is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value.
Data Bar
To create a set of sparklines, you first select a , and then you select a location range where you want the sparklines to appear.
Data Range
Each chart must have a(n) ______________.
Data Source
How are data bars and sparklines similar or different?
Data bars differ from sparklines in that the bars are always placed in the cells containing the value they represent, and each cell represents only a single bar from the bar chart. By contrast, a column sparkline can be inserted anywhere within the workbook and can represent data from several rows or columns. However, like sparklines, data bars can be used to create compact graphs that can be easily integrated alongside the text and values stored in worksheet cells
To let Excel know you want to enter a formula, after clicking in a cell press the_____key.
Equal sign =
1. The name of the active workbook appears in the status bar of the Excel window. TRUE OR FALSE?
FALSE
A chart cannot be rotated in the chart sheet. TRUE OR FALSE
FALSE
A chart sheet takes up less space than an embedded chart. TRUE OR FALSE
FALSE
A data bar is a type of sparkline. TRUE OR FALSE
FALSE
A type style is a set of characters that employ the same typeface. TRUE OR FALSE
FALSE
A watermark is text or an image that appears in front of other content. TRUE OR FALSE
FALSE
AutoFill copies content but not formats from a cell or range into an adjacent cell or range. TRUE OR FALSE
FALSE
By default, titles appear next to the value and category axes. TRUE OR FALSE
FALSE
Combining several cells into one cell is called aligning. TRUE OR FALSE
FALSE
Flash Fill enters formulas, not text. TRUE OR FALSE
FALSE
If you change any values or labels in the data source, the chart must be manually updated to show the new content. TRUE OR FALSE
FALSE
If you leave a cell blank, the COUNTA function will include it. TRUE OR FALSE
FALSE
Internet polling reflects the reactions of a true cross-section of voters. TRUE OR FALSE
FALSE
Minor tick marks identify the main units on the chart axis. TRUE OR FALSE
FALSE
Only fonts, not colors or cell styles, are organized in theme and nontheme categories. TRUE OR FALSE
FALSE
Optional arguments are always placed first and bold type in the argument list in function argument dialog box. ____. TRUE OR FALSE
FALSE
The Format Painter copies data as well as formatting. TRUE OR FALSE
FALSE
The Format Painter will allow you to copy formatting only to adjacent cells. TRUE OR FALSE
FALSE
The width of data bars is determined based on the values in the selected range. TRUE OR FALSE
FALSE
To add a collection of numbers, use the COUNT function. TRUE OR FALSE
FALSE
Watermarks are only visible in Normal view. TRUE OR FALSE
FALSE
You cannot add text to a shape. TRUE OR FALSE
FALSE
You cannot change the background image of a worksheet. TRUE OR FALSE
FALSE
You cannot remove an axis title. TRUE OR FALSE
FALSE
An MRI is used to record the electrical activity of the heart, show any abnormal rhythms, or detect muscle damage. TRUE OR FALSE
FALSE (correct answer is EKG)
The small black square in the lower-right corner of a selected cell or range is called the AutoFill button. TRUE OR FALSE
FALSE - it is called a 'fill handle'
When you create a new blank workbook, it is named Sheet1. TRUE OR FALSE
FALSE, it is named Book1)
You can edit the data source in the Edit Data Source dialog box.
FALSE, the Select Data Source dialog box
The default font size for worksheets is 12 points. TRUE OR FALSE
FALSE, the default is 11 points.
The #NUM! error value means that a cell reference used in a formula or function is no longer valid. TRUE OR FALSE
FALSE; it means invalid numbers are used in a formula or function
One type of what-if analysis that limits the data to a subset of the original values is a process called ________.
Filtering
_____ changes a workbook's appearance so that the content of a worksheet is easier to read. (Answer: Formatting)
Formatting
A(n) _____ is a mathematical expression that calculates a value.
Formula
What are gridlines and what do they do?
Gridlines are the horizontal and vertical lines that help you compare data and category values.
The ____________ , or category, axis displays the categories associated with each data value.
Horizontal
Dates are actually measured from what date?
January 1, 1900 at 12 a.m.
A is a key that shows each color used in the worksheet and what it means.
Legend
To merge and center text in multiple cells, click the ______________ button.
Merge & Center
B$4 is an ample of a(n) ________ reference.
Mixed
Excel stores dates and times as Excel stores dates and times as ...
Numbers
_______________ is any numerical value that can be used in a mathematical calculation.
Numeric Data
An chart element floats in the chart area and is not fixed to a particular position.
Overlaid
The function can be used to calculate the payment schedule required to completely repay a mortgage or other type of loan.
PMT
The US Postal Service uses the ___ bar code.
POSTNET
The chart's controls how fast the chart appears to recede from the viewer's eye.
Perspective
A(n) ______ is a single point on a computer monitor or printout.
Pixel
You can also open the Format Cells dialog box by a cell, and then clicking Format Cells on the shortcut menu.
Right-clicking
To save a copy of a workbook with a new filename or to a different location, you need to use the ________ command.
Save As
What is the first step when adding a data series to a chart?
Select the chart to which you want to add a data series
How do you add a data series to an existing chart?
Select the chart, click the Select Data button in the Data group on the CHART TOOLS DESIGN tab to open the Select Data Source dialog box, click the Add button, and then select the range for the data series
To select more than one shape, hold down the key, then click each of the remaining shapes.
Shift
A is a mini chart that is displayed within a worksheet cell.
Sparkline
.A(n) ____________ is a collection of text and numbers laid out in a rectangular grid.
Spreadsheet
A bar chart compares values from different categories. TRUE OR FALSE
TRUE
A chart sheet can contain embedded charts. TRUE OR FALSE
TRUE
A column chart turned on its side is called a bar chart. ___________. TRUE OR FALSE
TRUE
A line chart can be used with more than one data series. TRUE OR FALSE
TRUE
A line chart is often used to show trends and changes over time. TRUE OR FALSE
TRUE
A pie chart compares relative values of different categories to the whole. TRUE OR FALSE
TRUE
A quick way to copy formatting is to use the Format Painter button. TRUE OR FALSE
TRUE
A relative reference is a cell reference that changes when it is copied and pasted in a new location. TRUE OR FALSE
TRUE
A style is a collection of formats. TRUE OR FALSE
TRUE
A worksheet can contain the following type of data: text, numeric values, dates, and calculated values. TRUE OR FALSE
TRUE
After you apply a table style, you can choose which table elements you want included in the style. TRUE OR FALSE
TRUE
An error indicator appears in the upper-left corner of the cell with the error value. TRUE OR FALSE
TRUE
An exploded pie chart moves one slice away from the pie as if someone were taking the piece out of the pie. TRUE OR FALSE
TRUE
By default, Excel does not add background color to worksheet cells. TRUE OR FALSE
TRUE
Changes to the plot area are often made in conjunction with the chart area. TRUE OR FALSE
TRUE
Charts remain linked or connected to their data sources, even if they appear in different worksheets. TRUE OR FALSE
TRUE
Conditional formatting in a worksheet is special formatting applied when certain cell values meet one or more conditions. TRUE OR FALSE
TRUE
Deleting a column or row is not the same as clearing a column or row. TRUE OR FALSE
TRUE
Dell Computer's built-to-order process is an example of just-in-time manufacturing. TRUE OR FALSE.
TRUE
Excel has built-in styles to format worksheet titles. TRUE OR FALSE
TRUE
Formatting changes only the appearance of data—it does not affect the data itself. TRUE OR FALSE
TRUE
Functions are organized in the Function Library group. TRUE OR FALSE
TRUE
Functions are used to simplify formulas. TRUE OR FALSE
TRUE
In a line chart, the data markers are the points connected by the line. TRUE OR FALSE
TRUE
Italic and bold are examples of a font style. TRUE OR FALSE
TRUE
Leader lines can be added to labels placed outside the slices to connect them to their corresponding slices. TRUE OR FALSE
TRUE
Like the COUNT function, many of Excel's statistical functions ignore cells that are blank or contain text. TRUE OR FALSE
TRUE
Text is oriented within a cell horizontally from left to right. TRUE OR FALSE
TRUE
The Office theme is the default theme. TRUE OR FALSE
TRUE
The Select Data Source dialog box lists all of the data series displayed in the chart. TRUE OR FALSE
TRUE
The TODAY function doesn't have any arguments. TRUE OR FALSE
TRUE
The color of pie slices can be changed. TRUE OR FALSE
TRUE
The precision of a smart bomb depends on how well the target has been mapped and whether the pilot has entered the proper coordinates into the weapon. TRUE OR FALSE
TRUE
The process for creating a column chart is the same as for creating a pie chart. TRUE OR FALSE
TRUE
The range of values, or scale, of an axis is based on the values in the data source. TRUE OR FALSE
TRUE
The values returned by the TODAY and NOW functions are updated automatically whenever you reopen the workbook or enter a new calculation. TRUE OR FALSE
TRUE
Theme colors are the 12 colors that belong to the workbook's theme. TRUE OR FALSE
TRUE
To make a worksheet active, click on the sheet tab. TRUE OR FALSE
TRUE
When text wraps within a cell, the row height increases. TRUE OR FALSE
TRUE
You can click the Transpose button to paste the column data into a row or to paste the row data into a column. TRUE OR FALSE
TRUE
You can format the plot area by changing its fills and borders, and by adding visual effects. TRUE OR FALSE
TRUE
You can include data labels for every data marker, or you can include data labels for individual data points. TRUE OR FALSE
TRUE
You can modify the data source to specify which ranges should be treated as category values and which ranges should be treated as data values. TRUE OR FALSE
TRUE
You can save a workbook's theme as a file that can be used in other workbooks or Office files. TRUE OR FALSE
TRUE
You can use cell styles and other formatting tools to individual cells and ranges to format Excel tables. TRUE OR FALSE
TRUE
What is the Short Date format?
The abbreviated format for dates, mm/dd/yyyy
If you forget to put an = sign at the beginning of a formula, what will appear in the cell?
The actual data you entered, not the calculation
What are the three types of sparklines ? Give an ample of when each sparkline might be used.
There are three types of sparklines - line, column, and win/loss. A line sparkline might be used to show the sales history of a department. A column sparkline could be used to present a record of monthly temperatures and a win/loss sparkline could be used to show the season results for sports teams
To retrieve the return value from a vertical lookup table, you use the function.
VLOOKUP
The __________ , or value, axis displays the values associated with the heights of each column.
Vertical
Give an example of a Web site that consumers can use to access health information.
WebMD Health, Yahoo! Health
When does Flash Fill work best?
When the pattern is clearly recognized from the values in the data.
The represents the length of the object.
X-Axis
What is the result of the expression =50+20/10*5? a. 60 b. 1 c. 25 d. 50
a. 60
If an optional argument is not included, Excel assumes a(n) ____ value for it. a. Default b. Generic c. Static d. absolute
a. Default
You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane. a. Format Data Labels b. Format Legend c. Format Chart Area d. Format Axis
a. Format Data Labels
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value. a. Numbers b. Text c. universal numbers d. Greenwich Mean Time
a. Numbers
____ is the use of advanced computer technology to help health care professionals consult with each other and work together on cases, regardless of where the patients, medical professionals, and relevant clinical data are located. a. Telemedicine b. Eidemiology c. Endoscopy d. Remote sensing
a. Telemedicine
Computer-based patient records are entered, stored, and maintained with the help of a(n) ____ system a. electronic medical record (EMR) b. computer-assisted diagnosis c. medical informatics (MI) d. patient health information (PHI)
a. electronic medical record (EMR)
The IRS allows you to do all of the following at its Web site EXCEPT ____. a. get help with TurboTax or another tax-return program b. track the status of your refund c. download tax forms d. Find tax information
a. get help with TurboTax or another tax-return program
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____. a. total number of payment periods b. total number of payments that have already been made c. number of payments per year d. number of interest payments per year
a. total number of payment periods
Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____. a. use Format Painter b. format each element using the Toolbar c. select all cells and use the Formatting dialog box d. apply a table style
a. use Format Painter
Which of the following is NOT true of Internet-based voting systems? a.They provide equal access to every citizen b.They simplify and streamline the voting process c.They improve the accuracy of election results d.They reduce the occurrence of lost or destroyed ballots
a.They provide equal access to every citizen
A(n) ____ is an organization that collects credit-authentication requests and provides retailers with a payment guarantee.
acquirer
PMT(rate, nper, pv [, fv=0] [, type=0])The possible values for the type argument in the function above are. a. 0 or null b. 0 or 1 c. 0, 1, or 2 d. 0, 1, 2, or 3
b. 0 or 1
In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell. a. A1!E1! b. A1 c. E1 d. A1-E1
b. A1
Which of the following FBI databases contains DNA profiles? a. AFIS b. CODIS c. NICS d. NCIC
b. CODIS
A(n) ____ is a test that records the electrical activity of the heart. a. CT Scan b. EKG c. MRI d. EEG
b. EKG
Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab. a. Format b. Orientation c. Sorter d. Alignment
b. Orientation
Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____. a. semi-colon b. Period c. Colon d. comma
b. Period
Which of the following is a good tip for avoiding RSI? a. Use bright font colors b. Taking break c. Use one hand to perform operations with two keys d. Do not shift body positions frequently
b. Taking break
Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value. a. relative reference b. absolute reference c. mixed reference d. fixed reference
b. absolute reference
The numbers, text, or cell references used by the function to return a value are called ____. a. expressions b. arguments c. data d. values
b. arguments
____uses computers to test product designs before the physical prototype is built. a.Computer-aided design (CAD) b.Computer aided engineering (CAE) c.Computer-aided manufacturing (CAM) d.Manufacturing Resource Planning (MRP)
b.Computer aided engineering (CAE)
A UPC bar code on a product sold at a grocery store represents data that identifies the ____. a.item number & store number b.Manufacturer and item number c.item number and price d.manufacturer and price
b.Manufacturer and item number
An Excel worksheet can have a maximum of ____ columns in a worksheet. a. 156 b. 256 c. 16,384 d. 17 million
c. 16,384
The ____ dialog box provides options for moving charts between worksheets and chart sheets. a. Insert New b. Tab c. Move Chart d. Change Chart
c. Move Chart
A LoJack device is a wireless ____. a. microchip b. emergency alert system c. Stolen vehicle recovery system d. GPS
c. Stolen vehicle recovery system
You want to have your monthly bills paid automatically. When you authorize your electricity provider to debit your checking account each month, that provider uses a/an _______to get your payment. a. bill presentment process b. bill payment service c. automated clearing house d. acquirer
c. automated clearing house
Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data? a. abbreviate all text b. change the font style c. choose Wrap text for the columns d. delete one column
c. choose Wrap text for the columns
The fill handle copies ____. a. content only b. formats only c. content and formats d. formats and cell references
c. content and formats
Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content. a. Ctrl + V b. Ctrl + G c. Ctrl + C d. Ctrl + S
d. Ctrl + S
Foreign students with visas to attend U.S. schools must provide personal information to the ____ system a. CODIS b. NICS c. AFIS d. SEVIS
d. SEVIS
The ____ identifies which data markers are associated with each data series. a. x-axis b. y-axis c. chart area d. legend
d. legend
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function. a. Complex b. Logical c. Absolute d. nested
d. nested
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, fv and type are ____. a. financial functions b. required arguments c. comparison operators d. optional arguments
d. optional arguments
Computers in red-light systems perform all of the following functions EXCEPT ____. a. taking a picture of a violating car as it enters the intersection b. adding a date, time, and location to the photo c. storing its photos for later verification by a police officer d. telling police to arrest the violator
d. telling police to arrest the violator
Which of the following is an invention of the Information Age? a. induction electric motor b. sewing machine c. transatlantic cable telephone d. transistor
d. transistor
A(n) ____ is a test that records the electrical activity of the brain. a.CT Scan b.EKG c.MRI d.EEG
d.EEG
Use the symbol to make a cell reference absolute. A. asterisk * B. number # C. dollar $ D. equal sign
dollar $
A(n) ____ system is a management software system for health care industry, which maintains patient records and assists in billing and insurance claims as well.
electronic medical record (EMR)
GPS is an acronym for ____.
global positioning system
The USPS uses a(n) ____ system to read addresses, look them up in a database, and apply a POSTNET bar code.
optical character recognition (OCR) system
What is the first step in the CIM system process?
product design with CAD (computer-aided design)
What are some of the responsibilities of a WMS?
track items received, generate pick lists, label packages for shipping, and track receipt by customer
____ are remote-controlled drones used in the military for surveillance over cities.
unmanned aerial vehicles (UAVs)
