D388 Fundamentals of Spreadsheets and Data Presentations - Set 1 - Part 3

Correct Answer: Mixed reference

In the formula =A$1, the column reference (A) is relative and can change if copied, while the row reference (1) is absolute and will not change when copied.

Correct Answer: Both a and b

Both formulas will effectively calculate the value of A1 after adding a 10% tax, demonstrating different approaches to the same calculation.

Correct Answer: Line chart

Line charts are designed to display trends over time, making them the most suitable for visualizing changes in data across continuous intervals.

Correct Answer: Parentheses, Exponents, Multiplication, Division, Addition, Subtraction

PEMDAS outlines the order of operations in calculations, dictating how Excel evaluates complex formulas.

Correct Answer: It allows for data manipulation and calculation in an organized manner.

Worksheets provide a structured environment for entering, organizing, and analyzing data, enhancing user productivity and data integrity.

Correct Answer: COUNTA

The COUNTA function counts all non-empty cells in a specified range, making it useful for assessing data presence.

Correct Answer: To facilitate easy access and sharing of files

Cloud storage enables users to access their Excel files from any device with internet connectivity, making collaboration and sharing more efficient.

Correct Answer: Text to Columns

The Text to Columns feature is specifically designed to split text from one cell into multiple columns based on delimiters or fixed widths, facilitating data organization.

Correct Answer: Descriptive statistics

Descriptive statistics summarizes and describes the main features of a dataset, including qualitative data, providing insights into patterns without making predictions.

Correct Answer: The number of cells in B2:B10 whose value is greater than 50

COUNTIF counts the number of cells within a range that meet a single specified criterion. The formula =COUNTIF(B2:B10,">50") tallies how many cells in that range hold a value greater than 50, returning a count rather than a sum or average. To total qualifying values you would use SUMIF instead.