Use the image below to answer the questions that follow. Flag question: Question 6Question 6Tips1 pts6.1Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA Flag question: Question 7Question 7Tips2 pts6.2In column D certain cells have been shaded and the text has been changed by the use of conditional formatting, you can specify certain through the use of to apply this formatting.(2) Flag question: Question 8Question 8Tips1 pts6.3Which function can be used in cell C16 to determine the lowest price value?(1)Group of answer choices=MINIMAL=LOWEST=MIN=LOW Flag question: Question 9Question 9Tips1 pts6.4Looking at cell D2 in our image we can see that the heading text for for this particular cell is displayed on 2 lines one below the other. Which formatting option of Microsoft Excel was used for this?(1)Group of answer choicesText RotationMerge and CenterText GroupingText Wrapping Flag question: Question 10Question 10Tips1 pts6.5Which of the following functions can be used to calculate the total income received by all of the AI companies as displayed in cell C15?(1)Group of answer choices=SUM=COUNT=AVERAGE=TOTAL Flag question: Question 11Question 11Tips1 pts6.6The cell range A1:E12 has only outside borders applied to it.(1)Group of answer choicesTrueFalse

Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA

II - Directions: Choose the correct answer.11.    256.11      +    89.4   Group of answer choices535.51345.51435.51 Flag question: Question 12Question 12Tips1 pts12.    6090.2       -    370.8 Group of answer choices5891.65719.45917.2 Flag question: Question 13Question 13Tips1 pts13.    71.303      x        5.5 Group of answer choices392.1665239.66511665.392 Flag question: Question 14Question 14Tips1 pts14.    0.25 ÷ 1.5 =Group of answer choices0.1880.1660.177

Goal Seek changes the value of on cell by modifying:Group of answer choicesOnly one other cellMultiple cellsA Scenario SummaryA Pivot Table

17. If there are only addition and subtraction, work from left to right.Group of answer choicesTrueFalse Flag question: Question 18Question 181 pts18. Any whole number has a denominator of 1.Group of answer choicesTrueFalse Flag question: Question 19Question 191 pts19. The sum of 4 ¾ and ½ is 4 ¼.Group of answer choicesTrueFalse Flag question: Question 20Question 201 pts20. 5/6 – 1/6 = 4/6 or 2/3Group of answer choicesTrueFalse

Question 1Tips1 ptsI - Directions: Read the statements carefully. Choose True if the statement is correct and False if not.1. When adding decimals, it's important to align horizontally according to the decimal points.Group of answer choicesTrueFalse Flag question: Question 2Question 2Tips1 pts2. Just like with whole numbers, each digit in a decimal number has a specific place value determined by its position relative to the decimal point.Group of answer choicesTrueFalse Flag question: Question 3Question 3Tips1 pts3. Remember to carry over any values greater than nine to the next column, just like in regular addition.Group of answer choicesTrueFalse Flag question: Question 4Question 4Tips1 pts4. When subtracting decimals, it's essential to line up the decimal points vertically. This makes it easier to perform the subtraction accurately.Group of answer choicesTrueFalse Flag question: Question 5Question 5Tips1 pts5. Addition of decimals is commonly cannot used in real-world scenarios involving measurements, money, and other quantities that are not whole numbers.Group of answer choicesTrueFalse Flag question: Question 6Question 6Tips1 pts6. When subtracting decimals, borrowing (also known as regrouping) may be necessary, similar to whole number subtraction. This involves borrowing from the next higher place value if necessary.Group of answer choicesTrueFalse Flag question: Question 7Question 7Tips1 pts7. When multiplying decimals, it's important to consider the place value of each digit.Group of answer choicesTrueFalse Flag question: Question 8Question 8Tips1 pts8. In decimal numbers, the decimal point is not important.Group of answer choicesTrueFalse Flag question: Question 9Question 9Tips1 pts9. When dividing decimals, whatever you do in the divisor (outside number), you will also do it in the dividend (inside number).Group of answer choicesTrueFalse Flag question: Question 10Question 10Tips1 pts10.  The placement of the decimal point in the product is determined by the total number of decimal places in the factors being multiplied.Group of answer choicesTrueFalse