OMIS 259 Final Exam Study Guide
A colon between two cell references indicates a range of cells that includes ________. - correct answer
✔✔the two cells and all cells between
Which of the following is NOT a correct url format for your NIU student Google site if your znumber is
z123456? - correct answer ✔✔www://z123456.niu.edu/Google.Sites/z123456/
According to the eBook, what should you do if you see a column of pound signs (####) instead of values
or results of a formula? - correct answer ✔✔Increase the column width
Refer to Figure 1 (displayed on the course web site and below). For A1:K1 you want to make "Skyline
Estates" the full header of the table after applying Heading Style 1. In this situation the best option
would be? - correct answer ✔✔merge & center
Refer to Figure 1. What is the correct formula for total in cell F9 (of those listed)? - correct answer
✔✔=C9+D9+E9
Which of the following was NOT required to be on your Web Page assignment? - correct answer
✔✔page showing a corporate example of using Excel
Why are web sites, like done in your assignment, useful? - correct answer ✔✔all of these are reasons
web sites are useful
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? - correct answer ✔✔18
The best description of Excel from the following choices is... - correct answer ✔✔contains sheets of
columns and rows which can use formulas on information and repeat formulas easily
,If you want to see a preview of how a worksheet will appear on a hard copy, what do you do? - correct
answer ✔✔click the file tab, and then click print
We want to put the formula for course percentage in the cell labeled S4. S4 refers to ______. - correct
answer ✔✔column S row 4
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? - correct answer ✔✔45
What is a header? - correct answer ✔✔content appearing at the top of every printed page
Refer to Figure 3 (displayed on the course web site and below). What are the contents of cell F8? -
correct answer ✔✔0.1
Refer to Figure 3. If you wanted to enter a formula in cell J6 that calculated Education for Systems
analyst, what is correct to enter in cell J6 (in the formula bar)? Note, "Education for Systems analyst" is
Number of Education attendees, times cost per attendee, and then apply the Education discount. -
correct answer ✔✔=(1-F6)*E6*H6
Refer to Figure 3. What is the correct formula to enter in cell I7 (in the formula bar) to calculate
"Corporate" for Big Data Analytics?
Note: Corporate does not get a discount, so is calculated as Big Data Analytics Number of Corporate
attendees times Big Data Analytics Cost per attendee. - correct answer ✔✔=E7*G7
Refer to Figure 3. After entering the correct formula in cell K6, what is the fastest/easiest and correct way
to apply that same formula to cell K7? - correct answer ✔✔use mouse to get black cross in lower right of
K6, lets you auto-fill by dragging
In the formula =SUM (B5:B30), B5:B30 indicates the ________. - correct answer ✔✔range of cells
OMIS 259 is mostly about - correct answer ✔✔learning web pages, Excel and Access
, The wrap text feature in Excel: - correct answer ✔✔enables data to appear on two or more lines within a
cell
The four cells shown in figure 4 (displayed on the course web site and below), are the result of clicking
______. - correct answer ✔✔wrap text
Column width: - correct answer ✔✔is adjustable so you can display more or less characters in a column
Which of the following is the recommended order and correct weight for MyITLab Assignments (if you
elect to complete the Grader Projects)? - correct answer ✔✔ST (10%) - SE (40%) - GPHW (10%) - GPA
(40%)
If .25 is typed and Enter or Tab is pressed, Excel will automatically ___________. - correct answer
✔✔add a zero in front of the decimal point
Refer to Figure 1. What is the correct formula for Actual Increase/Decrease in cell K8?
Note: We're trying to calculate the increase from First Quarter (listed in its own column) to Second
Quarter (what this sheet represents, total listed in Total column). - correct answer ✔✔=(F8-H8)/H8
The outcome of the IF statement =IF((B10+5)>(C10+1),B10,C10) where cell B10=15 and cell C10=19 is? -
correct answer ✔✔19
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? - correct answer
✔✔=PMT(0.019/12,36,-30000)
In the =PMT function, the Nper is: - correct answer ✔✔total number of payments for the loan
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 - correct answer ✔✔=VLOOKUP function
A colon between two cell references indicates a range of cells that includes ________. - correct answer
✔✔the two cells and all cells between
Which of the following is NOT a correct url format for your NIU student Google site if your znumber is
z123456? - correct answer ✔✔www://z123456.niu.edu/Google.Sites/z123456/
According to the eBook, what should you do if you see a column of pound signs (####) instead of values
or results of a formula? - correct answer ✔✔Increase the column width
Refer to Figure 1 (displayed on the course web site and below). For A1:K1 you want to make "Skyline
Estates" the full header of the table after applying Heading Style 1. In this situation the best option
would be? - correct answer ✔✔merge & center
Refer to Figure 1. What is the correct formula for total in cell F9 (of those listed)? - correct answer
✔✔=C9+D9+E9
Which of the following was NOT required to be on your Web Page assignment? - correct answer
✔✔page showing a corporate example of using Excel
Why are web sites, like done in your assignment, useful? - correct answer ✔✔all of these are reasons
web sites are useful
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? - correct answer ✔✔18
The best description of Excel from the following choices is... - correct answer ✔✔contains sheets of
columns and rows which can use formulas on information and repeat formulas easily
,If you want to see a preview of how a worksheet will appear on a hard copy, what do you do? - correct
answer ✔✔click the file tab, and then click print
We want to put the formula for course percentage in the cell labeled S4. S4 refers to ______. - correct
answer ✔✔column S row 4
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? - correct answer ✔✔45
What is a header? - correct answer ✔✔content appearing at the top of every printed page
Refer to Figure 3 (displayed on the course web site and below). What are the contents of cell F8? -
correct answer ✔✔0.1
Refer to Figure 3. If you wanted to enter a formula in cell J6 that calculated Education for Systems
analyst, what is correct to enter in cell J6 (in the formula bar)? Note, "Education for Systems analyst" is
Number of Education attendees, times cost per attendee, and then apply the Education discount. -
correct answer ✔✔=(1-F6)*E6*H6
Refer to Figure 3. What is the correct formula to enter in cell I7 (in the formula bar) to calculate
"Corporate" for Big Data Analytics?
Note: Corporate does not get a discount, so is calculated as Big Data Analytics Number of Corporate
attendees times Big Data Analytics Cost per attendee. - correct answer ✔✔=E7*G7
Refer to Figure 3. After entering the correct formula in cell K6, what is the fastest/easiest and correct way
to apply that same formula to cell K7? - correct answer ✔✔use mouse to get black cross in lower right of
K6, lets you auto-fill by dragging
In the formula =SUM (B5:B30), B5:B30 indicates the ________. - correct answer ✔✔range of cells
OMIS 259 is mostly about - correct answer ✔✔learning web pages, Excel and Access
, The wrap text feature in Excel: - correct answer ✔✔enables data to appear on two or more lines within a
cell
The four cells shown in figure 4 (displayed on the course web site and below), are the result of clicking
______. - correct answer ✔✔wrap text
Column width: - correct answer ✔✔is adjustable so you can display more or less characters in a column
Which of the following is the recommended order and correct weight for MyITLab Assignments (if you
elect to complete the Grader Projects)? - correct answer ✔✔ST (10%) - SE (40%) - GPHW (10%) - GPA
(40%)
If .25 is typed and Enter or Tab is pressed, Excel will automatically ___________. - correct answer
✔✔add a zero in front of the decimal point
Refer to Figure 1. What is the correct formula for Actual Increase/Decrease in cell K8?
Note: We're trying to calculate the increase from First Quarter (listed in its own column) to Second
Quarter (what this sheet represents, total listed in Total column). - correct answer ✔✔=(F8-H8)/H8
The outcome of the IF statement =IF((B10+5)>(C10+1),B10,C10) where cell B10=15 and cell C10=19 is? -
correct answer ✔✔19
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? - correct answer
✔✔=PMT(0.019/12,36,-30000)
In the =PMT function, the Nper is: - correct answer ✔✔total number of payments for the loan
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 - correct answer ✔✔=VLOOKUP function
