spreadsheets

Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.

borders

You are working with spreadsheet data about a cross-country relay race. Each runner's times are located in cells H2 through H28. To find the runner with the slowest time, what is the correct function?

=MAX(H2:H28)

What are some strategies to ensure your data is accurate and fair? Select all that apply.

Collect the data in an objective way Make sure you start with an accurate representation of the population in the sample Think through the "who, what, where, when, how, and why" of your data

What is the term for a preset command in a spreadsheet?

Function

Within a spreadsheet, data analysts use which tools to save time and effort by automating commands? Select all that apply.

Functions Formulas

What are the key elements of structured thinking? Select all that apply.

Recognizing the current problem or situation Organizing available information Revealing gaps and opportunities in order to identify the options

Data analysts use which of the following functions to quickly perform calculations in a spreadsheet? Select all that apply.

SUM AVERAGE MIN

When giving a spreadsheet a title, what are some best practices to follow? Select all that apply.

Titles should state what the data in the spreadsheet is about * Titles should be short Titles should be clear

A scope of work is an agreed-upon _____ of the work you're going to perform on a project.

outline