CYB 405 Kennedy King College PCI Compliance Problem Solving Questions

User Generated

Fcvevgyvsr

Business Finance

CYB 405

Kennedy King College

CYB

Description

Your answer to each of these questions should not exceed 50 words.

And respond with 2-3 sentence to two classmates, I will post when the classmates post

Question 1: What is the difference between using a relative cell reference, an absolute cell reference, and a mixed cell reference?

Question 2: What is a circular reference and why would you need to avoid it?

Question 3: What information is required to use a PMT function?

Question 4: what are the strengths of line charts and column charts, and discuss how each chart compares different features of the same data.

Question 5: When you should use a dashboard chart?

Question 6: Critical Thinking: We are becoming an increasingly visual society, and we respond to the graphic features in a chart more than those in a worksheet. Therefore, shouldn’t every Excel worksheet you create have an accompanying chart? Why or why not?

Question 7: List three types of conditional formatting and the steps you would take to apply them to your worksheet?

Question 8: Briefly describe each of the arguments in an IF function IF (logical_test,value_if_true,value_if_false).

Question 9: Write the correct syntax for the VLOOKUP function. Give a brief explanation of each of the four arguments that are included in VLOOKUP?

Question 10: Write the correct syntax for the LOOKUP function. Give a brief explanation of each of the three arguments that are included in LOOKUP?

Question 11: Briefly describe five of the nine IS functions. The options are: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.

Question 12: What is the correct syntax of the PMT function? Briefly describe each of the arguments associated with this function.

Question 13: Briefly describe each of the following depreciation methods: straight line depreciation, double-declining balance, sum of the years digits, and fixed-declining balance.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Question 1: What is the difference between using a relative cell reference, an absolute cell
reference, and a mixed cell reference?
The difference between using a relative cell reference, an absolute reference and mixed cell
reference are:
(i) Relative cell reference changes when a formula is copied from one cell to another cell. By
default, all the references are relative cell references.
(ii) Absolute cell references remains constant no matter where they are copied. Generally used to
keep a row or column constant.
(iii) Mixed cell reference is either an absolute column & relative row or vice versa.
Question 2: What is a circular reference and why would you need to avoid it?
A formula in a cell that indirectly or directly refers to its own cell is called a circular reference. It
should be avoided because sometimes it gives somewhat unpredictable results and makes excel
go crazy.
Question 3: What information is required to use a PMT function?
The information required to use a PMT function is:






Nper Required. The total number of payments for the loan.
Type Optional.
Fv Optional. ...
Rate Required. The interest rate for the loan.
Pv Required. The present value, or the total amount that a series of future payments is
worth now; also known as the principal.

Question 4: what are the strengths of line charts and column charts, and discuss how each
chart compares different features of the same data.
Line charts are very simple to visualize and they can depict the data in a very effective way. The
line charts are best to depict the time series data where we can easily identify the trend over the
period of time. Line charts are very simple yet intuitive and hence line charts are used widely
across in domains where time-series data is important. For example stock exchange data, sales
data, trends data, etc.
Column Charts are very useful when we have 2 or more variables that are to be compared with
each other for every mentioned time period. It helps us in analyzing the period for each variable
and hence gives us an indication of how each variable performed during each particular year.
This type of chart is useful when we compare the trend of a particular variable over the years. It

GOOD NEWS FOR THE POOR

2

helps us in understanding the growth or decline of the variable and we can have a rough estimate
of the same through column charts.
Question 5: When you should use a dashboard chart?
Dashboard charts are useful when we are monitoring more than one metric at a time. These kinds
of charts are useful when we are tracking real-life information. This real-life information can be
about anything and depending on the intent, the information in the dashboard chart will change.
The dashboard charts are used for large projects where it is essential to track multiple metrics ...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags