Question

In: Computer Science

1. Matthew enters the value 97987 in an Excel, but instead of dispaying this value, Excel...

1. Matthew enters the value 97987 in an Excel, but instead of dispaying this value, Excel display 9.80E+04. What has happened here?

a. The cell does not accept larger values ( greater than 32768)

b. The cell has Fractional formating applied

c. The cell has scientific formating applied

d. The cell has high decimal precison formating applied

e. This is not possible in Excel. Excel will always show the values exactly as you enter them.

2. Susan was able to filter the list of names to only show unique names, by removing all duplicates. How did she do this?

a. She used conditional formatting, by applying the Hidden format on the duplicate cells

b. She selected the list of names, selected copy > paste special, and in the paste special box, checked the skip duplicate box.

c. She used advanced filter to select the list of names, then checked the unique records only checkbox and clicked ok

d. Both B and C are correct

e. This requires a VBA macro, and cannot be done through a command

3. Excel allows you to create new table styles, in addition to those that are provided. The table styles features allow you to control formatting of different elements of a table. Which of the following elements cannot be controlled through a table style?

a. Last row

b. First Column

c. Header Row

d. Footer Row

e. First Total Cell

4. What happens if you provide a negative value to the second parameter (num-digits) of the round () function?

a. A # value returns error is returned

b. A #DIV/0 error is returned

c. For the nun-digits parameter, negative values have the same effect as a 0

d. For the nun-digits parameter, negative values have the same effect as the positive values of quivalent magnitude

e. The number of places to the left decimal of the decimal is rounded up

5. A warning message about the age limit is shown in the Tooltip. The age limit is less than 30. Additionally, you can use that Excel has circled all of the entries that do not fulfill the criteria: Andrew 35, Stephanie 24, Michael 38 and Gayle 28. How can this be achieved?

a. Use the highligh cells rule under conditional formating

b. Use a VBA macro that checks the age for column for invalid entries

c. Use the Advanced filter and specify a Filter criteria

d. Use data validation and specify an input message

e. Use the protect sheet feature

Solutions

Expert Solution

Answer 1
*********
c. The cell has scientific formating applied

see screenshot

Answer 2
*********
c. She used advanced filter to select the list of names, then checked the unique records only checkbox and clicked ok

Answer 3
**********
a. Last row
d. Footer Row
e. First Total Cell

see screenshot

Answer 4
*********
d. For the nun-digits parameter, negative values have the same effect as the positive values of quivalent magnitude

if you have 10.50 and round this number with -1 then answer will be 10 but if you provide -2 then answer will be 0 but if you have the value 100.50 then again answer will be 100 even if argument is -2

Answer 5
*********
d. Use data validation and specify an input message

data validation will display the messeage beside the textbox

if you have any doubt then please ask me without any hesitation in the comment section below , if you like my answer then please thumbs up for the answer , before giving thumbs down please discuss the question it may possible that we may understand the question different way and we can edit and change the answers if you argue, thanks :)


Related Solutions

Instead of being classified as an employee, Matthew McGinnis was misclassified as an independent contractor. How...
Instead of being classified as an employee, Matthew McGinnis was misclassified as an independent contractor. How will his employer's FICA taxes be affected? What penalty will the employer face for this misclassificiation? What should a company look at in determining how to classify a worker as an employee versus an independent contractor?
Analyze the words of the Lord Jesus found in Matthew 20:1-16 and Matthew 25:14-30. How do...
Analyze the words of the Lord Jesus found in Matthew 20:1-16 and Matthew 25:14-30. How do these parables apply to economics?
Please answer in EXCEL Geoffrey decides not to buy the car mentioned earlier. Instead, he is...
Please answer in EXCEL Geoffrey decides not to buy the car mentioned earlier. Instead, he is now considering a food delivery service "You, bars, meats" that his friend Gillian has recently started. Gillian has agreed that for a single payment of $78,000 today to help her launch her business, she will provide all the delivery services that Geoffrey needs for his business for the next 5 years. Geoffrey is considering borrowing the full amount from his business account. Suppose that...
10.Present value is A. the inverse of the interest rate. B. the nominal value instead of...
10.Present value is A. the inverse of the interest rate. B. the nominal value instead of the real value of something. C. the value of a dollar received a year from​ now, expressed in terms of its future value. D. the value of a future amount expressed in​ today's dollars. 11,Suppose that you borrow​ $100,000 from the bank to purchase some land and you agree to pay 2 percent interest on the loan. If the loan must be repaid in...
Advanced Scenario 6: Matthew and Mary Donnelly Interview Notes • Matthew and Mary are married and...
Advanced Scenario 6: Matthew and Mary Donnelly Interview Notes • Matthew and Mary are married and want to file a joint return. They provided all the cost of keeping up the home and all of the support for their son Ryan. • Ryan has no income and no filing requirement. • Matthew retired and began receiving retirement income on April 1, 2018. No distributions were received prior to his retirement. Matthew selected a joint survivor annuity for these payments. •...
How would you calculate this with an excel formula on excel: •What is the future value...
How would you calculate this with an excel formula on excel: •What is the future value of the following cash flows if the discount rate is 8%? What is the future value if the discount rate is 5%? (this is asking you take the future value of the cash flows. Please find the future value at year 4. ))
Dave Matthew Inc. issues 500 shares of $10 par value common stock and 100 shares of...
Dave Matthew Inc. issues 500 shares of $10 par value common stock and 100 shares of $100 par value preferred stock for a lump sum of $100,000. (a) Prepare the journal entry for the issuance when the market price of the common shares is $165 each and market price of the preferred is $230 each. (b) Prepare the journal entry for the issuance when only the market price of the common stock is known and it is $170 per share.
Matthew Company issued 10-year, 7% bonds (paying semiannual interest) with a par value of $100,000. The...
Matthew Company issued 10-year, 7% bonds (paying semiannual interest) with a par value of $100,000. The market rate of interest when the bonds were issued was 6%. Compute the price of the bonds when they were issued. **How do i answer this NOT using a financial calculator**
~~~In Excel~~~~ Question 1. A US-Treasury bond with face value of $1,000 pays interest at an...
~~~In Excel~~~~ Question 1. A US-Treasury bond with face value of $1,000 pays interest at an annual rate of 5%. Coupons are paid twice per year. a. If this bond has 4 years to mature, what is the price of the bond if current yield to maturity is 4%? Calculate this by finding the value of coupons and principal separately. (12) b. If the coupon were instead paid once per year, what would be the price of the bond? ~~~In...
Convert the MileConversions program to an interactive application. Instead of assigning a value to the miles...
Convert the MileConversions program to an interactive application. Instead of assigning a value to the miles variable, accept it from the user as input. class MileConversionsInteractive {    public static void main(String[] args) {       // Modify the code below       final double INCHES_IN_MILE = 63360;       final double FEET_IN_MILE = 5280;       final double YARDS_IN_MILE = 1760;       double miles = 4;       double in, ft, yds;       in = miles * INCHES_IN_MILE;       ft = miles * FEET_IN_MILE;       yds = miles * YARDS_IN_MILE;       System.out.println(miles + " miles...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT