What is the correct formula to use

Reference no: EM133478653

Question 1:

You are using Microsoft Excel to prepare a financial forecast. You wish to format all of the numbers in a particular range to two decimal places aligned on the decimal point. They are to be blue if they are greater than zero and red if they are less than or equal to zero, with numbers less than zero in brackets and zero displayed as 0.00. In addition, you wish to format dates so that the day is displayed as a number without a leading 0 where it is a single digit, the month name is displayed in full and the year is displayed as a four-digit number. Based on this information, answer the following three questions.

Which of the following is not a correct description of the use of shortcut keys in Excel?

A) ALT+I+R Inserts a new row

B) ALT+F11 inserts the new worksheet

C) CTRL+Spacebar selects a column

D) CTRL+PgDn moves between worksheet

Question 2:

You have a Microsoft Excel spreadsheet that consists of three worksheet. On the first worksheet you have a series of values in row 1 of columns B to H and a second series of values in column A, rows 2 to 10. On the second worksheet, your model is calculating values in dollars and cell C1 contains the value 12,687,593,246. On the third worksheet you have entered the formula =IF(B1>B2,B5,IF(B3>B4,B6,B7)) into cell A1. Based on this information, answer the following three questions.

On the first worksheet you wish to enter a formula in row B2 that you will be able to copy down to row 10 and across two column H that will multiply together the respective row 1 number and column A number. What is the correct formula to use?

A) The correct formula is: =$A2*$B3

B) The correct formula is: =A$2*B$4

C) The correct formula is: =$A2*B$1

D) The correct formula is: =A$2*$B2

Question 3:

On the third worksheet, what would be displayed in cell A1 if the contents of cells B1 to B7 were 15, 10, 29, 16, 63, 11, 49 respectively?

A) The cell would display 11

B) The cell would display 16

C) The cell would display 49

D) The cell would display 63

Reference no: EM133478653

Questions Cloud

Evaluate your current web browser security settings : CMIS 111- Evaluate your current Web browser security settings. Are they sufficient? What changes would you recommend? Why?

Discuss a pharmacological treatment would you prescribe : Summarize the clinical case including the significant subjective and objective data. - Generate a primary and two differential diagnoses.

How is this method applied in a specific business situation : How is this method applied in a specific business situation? Describe a potential example and the expected use of the results

Describe cafu uae business model : Describe CAFU UAE business model using the Business Model Canvas. Iidentify its strengths and weaknesses.

What is the correct formula to use : copy down to row 10 and across two column H that will multiply together the respective row 1 number and column A number. What is the correct formula to use

What does that piece of evidence tell you about the event : What does that piece of evidence tell you about the event or issue? How does it fit into a bigger picture (what you learned in your background research)?

What is the cultural norm for sharing information about : What is the cultural norm for sharing information about students and their families? - What is Jackie's goal for sharing information about a student

What effect did the closing have on the community : Have any businesses in your area remained closed due to the pandemic? What effect did the closing have on the community?

How is the current 2023 economic environment in canada : How is the current 2023 economic environment in Canada, and how is this economic environment can or is affecting the Adastra.

User Account

All Pages