is the correct reference for 31. In Excel, to merge cells Al, B1, C1. DI and El.
ID: 3589961 • Letter: I
Question
is the correct reference for 31. In Excel, to merge cells Al, B1, C1. DI and El. the merged cell. (a) AIEI b) Al (c) El (d) Al-El 32.mm/dd/yyyy is known as (a) a text string (bl a text data fel a data format (d) a number date 33. Excel'sfunction can be used to calculate your monthly mortgage paymentif purchasing a new home. a) PMT (b) IF (c) MIN (d) TODAY 34. When calculating an average. Excel will ignore empty cells. If you want to include those cells in your average calculations, make sure they have a value of (a) s b) void (c) zero (d) null 35. The PMT function is located in which group? (a) Financial. b) Logical. (c) Math & Trig. (d) More Functions. 36. Which of the following is true about an embedded chart? (a) It can be moved elsewhere in the worksheet (b) It can be made larger or smaller (c) It can be deleted (d) All of the above 37. charts work best with data that are organized into rows and columns like a table: (a) column chart. (b) scattergram. (c) ple chart. (d) Line. 38, charts display data horizontally. (a) Pie (b) Box (c) Stacked (d) BarExplanation / Answer
Please find the answers below:
Answer for 31 is : A (A1:E1)
Explanation :
A1: E1 indicates that all cells of that Excel from A1 : E1 are merged:)
Answer for 32 is : C
Explanation:
A text string will be like normal text. For example 'Bala'
A date format can be mm/dd/yyyy ,/yyyy/dd//mm, etcc.
A number date is someting like which we mention ate in text format . for example : January 1, 1900
Answer for 33 is : A
Explanation:
PMT is excel function in that we can calculate ' PMT calculates the payment for a loan based on constant payments and a constant interest rate.'
IF function is used to check somem condiion at the Excell cell level.
MIN is the function used to find the minimum value
TODAY is a excel function that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) in Excel. As a worksheetfunction, the TODAY function can be entered as part of a formula in a cell of a worksheet.
Answer for 34 : C
Explanation:
If we keep zero in place of null average function of excel will include that cells also
Answer for 35 : A
Explanation:
PMT is one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.
Answer for 36 : D
Explanation:
All actions can be done
Answer for 37: A
Explanation:
Column chart :
Data that is arranged in columns or rows on an Excelsheet can be plotted in a column chart. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis.Column charts are useful to show how data changes over time or to show comparisons among items.
Scattergram:
This also called as scatter plot.A scatter plot is a set of points plotted on a horizontal and vertical axes. Scatter plots are important in statistics because they can show the extent of correlation, if any, between the values of observed quantities or phenomena (called variables).
Pie chart:
A graphic representation of quantitative information by means of a circle divided into sectors, in which the relative sizes of the areas (or central angles) of the sectors correspond to the relative sizes or proportions of the quantities. Expand. Also called circle graph, pie graph. Origin of pie chart.
Line chart:
Excel calls the data that you select for your chart a data series ... or, in other words, a set of data points. A data series is usually one row of data in an Excel worksheet with the associated column headings; or one column of data with the associated rowheadings.
Answer for 38 : D
Explanation:
PIe chart will be diplayed in sectors of circle.
Box chart will be displayed in boxes
Stacked charts wil be displayed in stacked on one over another of individual componenets
Bar charts will display data horizontally
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.