OMIS259

If cell b5 contains the number 3, and cell c5 contains the number 6, what does the formula "= B5 * C5", placed in cell d5, give as a result? A. #### B. #N/A C. 9 D. 18 E. 36

A. ####

The outcome of the IF statement =IF((B10+5)>(C10+1),B10,C10) where cell B10=15 and cell C10=19 is? A. 19 B. 14 C. #NULL D. 15 E. None of the above

A. 19

Given the formula =B1^2+B3/4*B2+B4 where B1 contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result? A. 45 B. 15 C. 73 D. 14

A. 45

I just purchased a new car for $30,000 at a very nice 1.9% annual interest rate. I want to pay the car off in 3 years. Which of the following formulas would give me my monthly car payment? A. =PMT(0.019/12,36,-30000) B. =PMT(1.9,3,3000) C. =PMT(1.9/12,36,-30000) D. =PMT(1.9/12,12,-30000)

A. =PMT(0.019/12,36,-30000)

A calculated field is simply A. A choice which appears when your mouse is in the PivotTable which allows a user to create extra fields (columns) using formulas. B. Just like a regular chart, only done using a PivotTable for the chart information. C. An automatically created PivotTable calculation D. None of these.

A. A choice which appears when your mouse is in the PivotTable which allows a user to create extra fields (columns) using formulas.

What is a primary key? A. A field (or group of fields) that uniquely identifies a given record or entity in a table B. A primary key of one table that does not appear as an attribute in another table C. Characteristics or properties of an entity class D. A field (or group of fields) that uniquely identifies a given attribute in a table E. A key that is made in USA

A. A field (or group of fields) that uniquely identifies a given record or entity in a table

When designing expression for calculated fields in Access Expression Builder, field names are surrounded by ________. A. Brackets B. Parentheses C. semicolon D. period

A. Brackets

Which of the following is an example of a relative cell reference? A. C4 B. $C$4 C. C$4 D. $C4

A. C4

A ________ is a collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported. A. Database B. File C. Relationship D. None of the above

A. Database

When you are working on or building a query in Access, you are in _______ view and after you run a query in Access you are in __________ view. A. Design; Datasheet B. SQL; Datasheet C. Home; Datasheet D. Datasheet; Design E. Datasheet; Home

A. Design; Datasheet

If data from an Excel worksheet is imported into Access and no column headings exist, the data will import using: A. Field1, Field2, Field3, etc. B. Import1, Import2, Import3, etc. C. Access1, Access2, Access3, etc. D. FieldA, FieldB, FieldC, etc.

A. Field1, Field2, Field3, etc.

Why/when should you use a relational database (like Access)? A. If I have information in more than one spreadsheet or source and I need to tie them together to get business answers. B. If the file is too big for Excel. C. If I need to perform sophisticated mathematical calculations on the data. D. If I have a large amount of information on a spreadsheet and need to "slice and dice" it.

A. If I have information in more than one spreadsheet or source and I need to tie them together to get business answers.

Which of the following is NOT one of most commonly used chart types? A. Inverse Logarithmic chart B. Bar chart C. Line chart D. Pie chart E. All of the above are commonly used chart types

A. Inverse Logarithmic chart

If I had a Pivot Table with Sales Rep, Sales, and Magazine as fields, and wanted to see the sales for each Sales Rep for each Magazine in the Pivot Table (best complete view), if I already had Sales Rep in the Rows area and Sales in the Values area, I would A. Magazine; Columns area B. Magazine; Rows area C. Magazine; Totals area D. Sales Rep; Columns area E. Sales Rep; Rows area

A. Magazine; Columns area

In order to break even you must have: A. Positive profit per period B. Good employees C. Low fixed costs D. Negative investment per period

A. Positive profit per period

According to the e-book. A _____ is a question that you ask about the data in your database A. Query B. Form C. Report D. All of the above

A. Query

For one fast way to create a chart in Excel 2016, select the data and click the ________. A. Quick Analysis button B. Chart tab C. Chart Elements button D. Chart Styles button

A. Quick Analysis button

How do you get (easiest way) the menu to change chart type, format data labels, change tab colors, etc.? A. Right-click with your mouse in the correct area. B. Left-click with your mouse in the correct area. C. Search through all tabs to find the method. D. Search through all menu items to find the method.

A. Right-click with your mouse in the correct area.

What is the missing argument in the following formula: =PMT(rate,_______, pv, [fv], [type]) A. Total number of payments for the loan B. Value if true C. Interest rate D. Payment

A. Total number of payments for the loan

What if your boss has told you to make a chart using some spreadsheet data, but you have no idea which type of chart to use? A. Use "Recommended Charts" in the Insert tab of Excel. B. With chart selected, chose Design tab, Chart. C. Tell your boss to do the chart herself. D. Chose Home tab, Insert, Charts.

A. Use "Recommended Charts" in the Insert tab of Excel.

When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT: A. You need to create complex charts or graphs B. You require multiple tables to manage data C. You are managing a large quantity of data coming from multiple sources D. Multiple users need to work with data simultaneously

A. You need to create complex charts or graphs

Expression builder represents fields you choose from tables as... A. [Table]![Field] B. [Field]![Table] C. (Table)!(Field) D. (Field)!(Table)

A. [Table]![Field]

To create a table from an existing range of data: A. click the Insert tab and then click Table in the Tables group. B. click within the range, click the Table Tools Design tab, and then select Convert to Table. C. select any cell in the worksheet then click Existing Range in the Tools group. D. click in a cell and on the Home tab, click the Insert arrow in the Cells group.

A. click the Insert tab and then click Table in the Tables group.

In the formula =SUM (B5:B30), B5:B30 indicates the ________. A. range of cells B. type of calculation C. variable D. cells excluded from the calculation

A. range of cells

If researchers wanted to display the relationship between variables in a scientific experiment, they could use a ________ chart. A. scatter B. bar C. pie D. doughnut

A. scatter

Which of the following is NOT a correct url format for your NIU student Google site if your znumber is z123456? A.www://z123456.niu.edu/Google.Sites/z123456/ B.https://sites.google.com/sites/z123456 C.https://sites.google.com/ sites/NIUz123456 D.https://sites.google.com/sites/YourName/z123456

A. www://z123456.niu.edu/Google.Sites/z123456/

Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force? A. % of Values Total B. % of Grand Total C. % of Row Total D. Running Total

B. % of Grand Total

A formula containing the entry =B$3 is copied to a cell five columns to the right and three rows down. How will the entry appear in its new location? A. =$F6 B. =G$3 C. =E$6 D. =E$3

B. =G$3

What is a good description of a Sparkline? A. A fancy formula B. A trendline in a cell C. A chart or graph in a new sheet D. A graph of a line that shows a clear high, or spark, point

B. A trendline in a cell

If cell D15 contains the formula =$C$5*D15, what is the $C$5 in the formula? A. Mixed Reference B. Absolute Reference C. Circular Reference D. Range name E. None of the above

B. Absolute Reference

The best description of Excel from the following choices is... A. A database management system. B. Contains sheets of columns and rows which can use formulas on information and repeat formulas easily. C. A file which resides on a web server and can be seen by anyone with an internet connection. D. A device to train and simulate students in a psuedo-environment.

B. Contains sheets of columns and rows which can use formulas on information and repeat formulas easily.

What is a header? A. Content appearing at the bottom of every printed page B. Content appearing at the top of every printed page C. Content appearing at the right margins of every printed page D. Content appearing at the left margins of every printed page

B. Content appearing at the top of every printed page

What does the Values Area of a PivotTable do? A. Subdivides data into one or more additional categories B. Displays summary statistics, such as totals or averages C. Filters the data to display results based on particular conditions you set D. Organizes and groups data into categories on the left side. Each group name occupies a single row

B. Displays summary statistics, such as totals or averages

The wrap text feature in Excel: A. Enables long formulas to wrap to two or more lines within a single cell. B. Enables data to appear on two or more lines within a cell. C. Is most useful with very short titles or column headings. D. Can be downloaded as an add-on to Excel 2013.

B. Enables data to appear on two or more lines within a cell.

According to the eBook, which of the following is not true of an Access database? A. Every record in a table has the same fields as every other record B. Every table in a database contains the same number of records as every other table C. Text (long or short), number, autonumber, and currency are valid data types D. Each table should contain a primary key; however, a primary key is not required E. All of these are true, according to the eBook.

B. Every table in a database contains the same number of records as every other table

Which of the following is the correct mathematical sequence for the order of operations? A. Multiplication, Division, Exponentiation, Addition, Subtraction B. Exponentiation, Multiplication, Division, Addition, Subtraction C. Multiplication, Exponentiation, Division, Addition, Subtraction D. Addition, Subtraction, Multiplication, Exponentiation, Division

B. Exponentiation, Multiplication, Division, Addition, Subtraction

All of the following are true in reference to Expression Builder EXCEPT: A. Expression Builder inserts placeholders that tell you where each argument belongs when you insert functions. B. Expression Builder can only be used with user-designed functions and not with built-in functions. C. Expression Builder gives you lists of fields, operators, and functions you need to create expressions. D. Expression Builder can be used when working with queries.

B. Expression Builder can only be used with user-designed functions and not with built-in functions.

What is the best tool to determine the required downpayment to reach a $700 car payment? A. Solver B. Goal Seek C. Scenario Manager D. One-variable data table E. None of the Above

B. Goal Seek

Which of the following tools is best suited for maximum control when creating an outline? A. Subtotals B. Grouping C. Slicers D. PivotTable

B. Grouping

Column width: A. Always switches back to default. B. Is adjustable so you can display more or less characters in a column. C. Is best left unchanged unless you absolutely have to. D. Is not adjustable so keep the formulas as short as possible.

B. Is adjustable so you can display more or less characters in a column.

A pie chart: A. Shows a relationship between two variables. B. Is great for showing proportional or percentage data. C. Emphasizes magnitude of changes over time by filling in the space between lines with a color. D. Both A and B E. None of the above

B. Is great for showing proportional or percentage data.

Which of the following charts displays lines connecting data points to show trends over equal time periods? A. X Y chart B. Line chart C. Bar chart D. Column chart E. Area chart

B. Line chart

A stacked column chart: A. Places (stacks) data in one column per category, with each column having the same height of 100%. B. Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. C. Adds a third dimension to each data series, creating a distorted perspective of the data. D. Compares values across categories using horizontal bars.

B. Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.

After creating a calculated field, you run the query and a parameter dialog box unexpectedly appears on your screen. How do you respond to the parameter dialog box? A. Click OK to make the parameter box go away. B. Read the field name specified in the parameter box, and then look for a possible typing error in the calculated expression. C. Type numbers in the parameter box, and then click OK. D. None of the above.

B. Read the field name specified in the parameter box, and then look for a possible typing error in the calculated expression.

What is an Excel Row in Access? A. Field B. Record C. Table D. Character

B. Record

If this is supposed to be Dr. Downing's office phone number, what data type is this information: "(815) 753-6381" A. Currency B. Text C. Number D. Hyperlink E. Integer

B. Text

When using Datasheet view, what determines sort order when sorting more than one field? A. The order is determined by the first selected field to the last selected field B. The order is determined from left to right. C. The order is determined by the last selected field to the first selected field. D. The order is determined from right to left.

B. The order is determined from left to right.

In the =PMT function, the Nper is: A. Is a word or a string of characters that represent one or more cells. B. Total number of payments for the loan. C. A set of range names. D. Why you do not have to make the cell reference absolute in the formula.

B. Total number of payments for the loan.

If .25 is typed and Enter or Tab is pressed, Excel will automatically ___________. A. add a zero in front of the decimal point B. insert a formula C. delete the number D. add a percent sign after the number

B. insert a formula

When using Design view to enter text in the Criteria row, Access will place ________ around the text. A. brackets [ ] B. quotation marks " " C. braces { } D. parentheses ( ) E. None of the above

B. quotation marks " "

You want to create a single chart that shows each of five divisions' proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs? A. Pie chart B. Surface Chart C. 100% stacked column chart D. Clustered bar chart E. None of the above

C. 100% stacked column chart

In the following function, the value_if_false will place ________ in the cell: =IF(SUM(D21:D27)<=40,SUM(D21:D27),40) A. SUM(D21:D27)<=40 B. SUM(D21:D27) C. 40 D. The formula is invalid and will give an error

C. 40

While using formulas, ___________ error is displayed in the formula bar when a cell reference is not valid. A. =#INVALIDREF! B. =INVALIDREF! C. =#REF! D. ######

C. =#REF!

If a company has a set of rules, which can be listed but can't be calculated by a formula, like a commission structure for dollars sold or something, and they need to apply these rules to many cells (like a large number of employees), then the best way to get this to work in Excel is A. =IF function B. =PMT function C. =VLOOKUP function D. simply by using appropriate formulas like "=C2 * 5" or whatever is necessary E. None of the above.

C. =VLOOKUP function

What is a good description of a Sparkline? A. A fancy formula B. A chart of a graph in a new sheet C. A trendline in a cell D. A graph of line that shows a clear high, or spark point

C. A trendline in a cell

The ______ data type is incremented when a new record is added. A. Number B. Integer C. AutoNumber D. None of the above

C. AutoNumber

In your Query you want to create a calculated field, DaysOnMarket, that calculates the number of days prior to 12/1/2011 that the house has been on the market ("DateListed" is when the house first went on the market, and all houses went on prior to 12/1/2 A. DaysOnMarket= [DateListed]-#12/1/2011# B. DaysOnMarket: [DateListed]-12/1/2011 C. DaysOnMarket: #12/1/2011#-[DateListed] D. DaysOnMarket: [DateListed]-#12/1/2011#

C. DaysOnMarket: #12/1/2011#-[DateListed]

In an Access table, the _________ view is used to 1.) Add, remove or rearrange fields 2.) Define the name, the data type and other properties of each field 3.) Designate a primary key for the table. A. Report View B. Form View C. Design View D. Sectional View E. Datasheet View

C. Design View

Which of the following options is the best tool when using a PivotTable that contains more data than you currently need? A. Sorting B. Removing a value field C. Filtering D. Refreshing the data

C. Filtering

To change the dollar totals into percentages in a pie chart, we have to find the ____________ option. A. Format data labels, and use "Value" B. Format data series, and use "Value" C. Format data labels, and use "Percentage" D. Format data series, and use "Percentage"

C. Format data labels, and use "Percentage"

OMIS 259 is mostly about... A. Making my life difficult with computers. B. Making me into a tech specialist. C. Learning web pages, Excel and Access. D. Excel.

C. Learning web pages, Excel and Access.

Which statement is not a recommended guideline for planning a table in Excel? A. Avoid naming two fields with the same name B. Ensure no blank columns separate data columns within the table C. Leave one blank row between records in the table D. Include field names on the first row of the table

C. Leave one blank row between records in the table

Which would be the best chart to use to be able to show Sales increasing over time, with a prediction of future sales (like shown in class)? A. Pie chart. B. Scatter chart. C. Linear forecast trendline. D. Bar chart. E. Column chart.

C. Linear forecast trendline.

What is the typical sequence for creating a chart? A. Select chart type, select the data source and then size and position the chart B. Select the data source, size the chart, select the chart type, and then position the chart C. Select the data source, select the chart type, and then size and position the chart D. Click the cell to contain the chart, select the chart type, and then select the data source E. All of the above

C. Select the data source, select the chart type, and then size and position the chart

How can you identify sizing handles when you click a chart? A. A Sizing Handles button displays on the Design tab. B. A Sizing Handles button displays next to the chart. C. They display as small, black triangles located on the corners of a selected chart. D. They display as small, white-filled squares.

C. They display as small, black triangles located on the corners of a selected chart.

Which of the following is NOT a specific way to more easily work with or view large amounts of data on a spreadsheet? A. Freeze Panes B. Use the Sheet tab in Page Setup to repeat rows and/or columns when printing C. Use the Insert / Function feature D. Filtering E. ALL of these are ways to more easily work with or view large amounts of data on a spreadsheet.

C. Use the Insert / Function feature

You suspect a customer name table has several identical records and you only need one of these records. What should you do? A. Do nothing; a logical reason probably exists to keep identical records B. Find the duplicate records and change some of the data to be different C. Use the Remove Duplicates command D. Look at each row yourself, manually deleting records

C. Use the Remove Duplicates command

To reverse the data series of a chart: A. use the Select Data Source dialog box from the Selected Switch Data button B. change the numbers in the spreadsheet C. click Switch Row/Column in the Data Group D. Both A and C are correct E. all of the above

C. click Switch Row/Column in the Data Group

A _______ is the smallest database object listed below that contains all the data concerning one person, place, thing, or event. A. table B. query C. record D. report

C. record

In Access, tables and queries for the same data set are.... A. stored using different file names, so on your flash drive, for example, you would see more than one file. B. stored using the same file name, so on your flash drive, for example, you would see one file. C. stored using different names but are contained in the same file, so on your flash drive, for example, you would see one file. D. stored using the same name but are contained in the same file, so on your flash drive, for example, you would see one file. E. None of these are correct

C. stored using different names but are contained in the same file, so on your flash drive, for example, you would see one file.

Given that cells A1,A2, and A3 contain values 2,3, and 4, respectively, and B6, C6, and D6 contain values 10,21, and 30 respectively, what value will be returned by the function =IF(B6>C6,B6*A2,C6*A1)? A. 10 B. 50 C. 30 D. 42 E. 60

D. 42

If you wanted to show customers who placed an order after November 1, 2017, what would go in the "criteria" row under "OrderDate" in your query? A. < 11/1/2017 B. > 11/1/2017 C. < #11/1/2017# D. > #11/1/2017#

D. > #11/1/2017#

Charts and graphs are useful in Excel for... A. Making a visual impact B. Summarzing data into an attractive display C. Enhancing Business presentations. D. All of the above.

D. All of the above.

Which of the following is NOT a reason to use tables in a worksheet? A. Automatic filtering options B. Predefined table styles C. Availability of Total Row D. Automatic conditional formatting E. Use of structured references and automatic copying down for formulas

D. Automatic conditional formatting

If I modify a field in a table that is related to a field in another table, what must I have enabled so that it changes the field in BOTH tables? A. Cascade Delete Relate Fields B. Enforce Referential Integrity C. Export Data D. Cascade Update Related Fields

D. Cascade Update Related Fields

What is the correct ordering of these database elements from SMALLEST to LARGEST? A. Character, table, field, record, database B. Character, record, table, field, database C. Character, field, table, record, database D. Character, field, record, table, database

D. Character, field, record, table, database

If you want to see a preview of how a worksheet will appear on a hard copy, what do you do? A. Click the Page Layout tab, and then click the Print check box in the Sheet Options group. B. Change the Zoom to 100%. C. Click the Page Setup Dialog Box Launcher. D. Click the File tab, and then click Print

D. Click the File tab, and then click Print

According to the eBook, if you want to show exact values for a data series in a bar chart, what chart element should you display? A. Chart Title B. Legend C. Value Axis Title D. Data Labels

D. Data Labels

A _________ is a field in one table that is also a primary key of another table. A. Master key B. Primary key C. Alternate key D. Foreign key

D. Foreign key

Referential integrity should be enforced in a database with related tables because it A. Creates a primary key in every table of a database. B. Makes the database easier to repair. C. Helps ensure data is automatically updated. D. Helps ensure invalid data is not entered into a table. E. None of the above

D. Helps ensure invalid data is not entered into a table.

Gridlines on a chart in Excel 2016 are: A. Numeric values that describe a single value on a chart. B. Lines used to depict trends and forecast future data. C. A visual representation of numerical data. D. Horizontal or vertical lines that span across the chart.

D. Horizontal or vertical lines that span across the chart.

According to the eBook, what should you do if you see a column of pound signs (####) instead of values or results of a formula? A. Increase the zoom percentage B. Delete the column C. Adjust the row height D. Increase the column width

D. Increase the column width

Which of the following is not a calculation that can be completed with the SUBTOTAL function? A. Average B. Count C. Min D. Index

D. Index

In a VLOOKUP function, the lookup value: A. Is the argument in a function that identifies which lookup table column from which to return a value. B. Looks in a horizontal table where the first row contains the values. C. Is a range containing a lookup table. D. Is a reference to a cell containing a value to look up. E. None of the above

D. Is a reference to a cell containing a value to look up.

The column index number in a VLOOKUP function: A. Is the periodic interest rate, such as the monthly interest rate. B. Looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value. C. Calculates the periodic payment for a loan with a fixed interest rate and fixed term. D. Is the argument that identifies from which column to return a value.

D. Is the argument that identifies from which column to return a value.

You open an Access form and use it to update an address for customer Lee Fong. After closing the form, you later open a report that generates mailing labels. What will the address label for Lee Fong show? A. The old address until you remember to update it in the report B. The old address C. The new address if you remembered to save the changes made to the form D. The new address

D. The new address

If a course percentage is in cell S4, a table with percentages in the first column and letter grades in the second column is in the range V13:W17, and we want to display the first student's letter grade for the course in cell T4, what's wrong with this VLOOKUP statement for cell T4 if I want to copy it for all students? =VLOOKUP(S4,V13:W17,2) A. The order of the arguments (things in the parentheses) is wrong. B. The cell references of the arguments is wrong. C. There are no absolute references for S4. D. There are no absolute references for V13:W17.

D. There are no absolute references for V13:W17.

Which row in the Access Query Design view do you have to add if you want it to appear? A. Field B. Criteria C. Sort D. Totals

D. Totals

You created an outline for a dataset. What does the "+" button indicate to the left of a row heading? A. You can add a new row at that location only. B. One or more columns are hidden. C. You can click it to collapse the details of that category. D. You can click it to expand the details of that category.

D. You can click it to expand the details of that category.

The Freeze Panes option, chosen as "View / Freeze Panes", keeps: A. only the first column visible as you scroll through a worksheet. B. only the designated rows visible as you scroll through a worksheet. C. all row names and column headings on the screen for preparation in printing. D. both rows and columns above and to the left of the active cell visible as you scroll.

D. both rows and columns above and to the left of the active cell visible as you scroll.

We want to put the formula for course percentage in the cell labeled S4. S4 refers to ______. A. row S column 4 B. the function available in that cell C. function #4 D. column S row 4

D. column S row 4

Instead of using an "=IF" statement, an easier way to highlight specific values for someone viewing a spreadsheet is to use... A. a chart B. a pie chart C. a conditional chart D. conditional formatting

D. conditional formatting

You'll never break even if you have... A. bad employees B. poor machines C. negative investment per period D. negative profit per period

D. negative profit per period

A colon between two cell references indicates a range of cells that includes ________. A. the entire worksheet B. all cells in the worksheet except the two cells C. the two cells D. the two cells and all cells between E. None of the above

D. the two cells and all cells between

What should you always do after you've made a chart in Excel? A. Check to see if it makes sense given what you're trying to do B. Check to see that the data included is what you wanted C. Check to see that the colors and styles are visually appealing and clear D. Check to see that the chart sizing and number and text fonts are appropriate E. All of the above

E. All of the above

According to the E-book. All of the following may be used in an expression EXCEPT: A. Fields B. Arithmetic operators C. Functions D. Constants E. All of the above can be used

E. All of the above can be used

The best way to format the axis or gridlines of a chart is to ____________ A. Review that function in MyITLab and the ebook B. Email the TA C. Visit the professor D. Choose "Formulas" / "Insert Function" and review how the function works and what it needs to work. E. Click on the axis or gridline you want to work with, then Right-click and choose "Format <what you want to work with>".

E. Click on the axis or gridline you want to work with, then Right-click and choose "Format <what you want to work with>".

A (n) ________ is a key that identifies the color, gradient, picture, texture, or pattern of each data series in a chart. A. Label B. Sparkline C. Trendline D. Axis E. Legend

E. Legend

Which of the following is the recommended order and correct weight for MyITLab Assignments? A. ST (10%) - GPA (10%) - GPHW (40%) - SE (40%) B. ST (10%) - GPHW (40%) - GPA (10%) -- SE (40%) C. GPHW (10%) - ST (10%) - GPA (40%) -- SE (40%) D. ST (10%) - SE (10%) - GPHW (40%) - GPA (40%) E. ST (10%) - SE (40%) - GPHW (10%) - GPA (40%)

E. ST (10%) - SE (40%) - GPHW (10%) - GPA (40%)

Which of the following is TRUE about the print area feature? A. In Page Break Preview, the area of the worksheet that won't be printed has a dark blue background. B. In Page Break Preview, the print area has a white background and dashed red border. C. The print area can be cleared from the Home tab. D. In the print option, the print area prints the entire document. E. The print area defines the range of data to print.

E. The print area defines the range of data to print.