WGU D100 (Excel Basics)2023 Tabs - Answer Eight areas of activity on the Ribbon that contain groups or collections of related commands.Why should you not duplicate column headings? - Answer Duplicate headings make it difficult to understand the data stored in the column.What is the total row used for in an Excel table? - Answer Summarize values in the table What automatically applies a formula used in one cell to the remaining cells in a column? - Answer Calculated columns What kind of calculation contains an error caused by poor input? - Answer A calculation that includes inaccurate or incomplete data What kind of calculation contains an error caused by poor logic? - Answer A calculation that includes an inaccurate or incomplete qualative data - Answer descriptive data Dynamic Function - Answer A dynamic function changes when the values in the cells it references change.Quantitive data - Answer numerical data Year - Answer =YEAR(J21) Todays Date - Answer =TODAY() Month - Answer =MONTH(J21) Years since - Answer =YEARFRAC(J27,J21) Days since last - Answer =DATEDIF(J21,J27,"D") PEDMAS - Answer parentheses, exponents, multiplication, division, addition, and subtraction. Multiplication/division and addition/subtraction go together, do whichever comes first.Active Cell - Answer The cell in the worksheet in which you can type data.Descending Order - Answer In order from the highest value to the lowest. e.g. 9-1 or Z-A.Ascending Order - Answer In order from the lowest value to the highest. e.g. 1-9 or A-Z.Ribbon - Answer A strip of icons that appears across the top of the Excel; divided into tabs, each of which contains groups of related tools.
- / 1