Week 3 – More spreadsheet basics Post author:Devendra Kumar Post published: Post comments:0 Comments ask questions to make data-driven decisions weekly challenge 3 answers 1. Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=). Answers cellsnumbersformulascharts 2. Fill in the blank: The labels that describe the type of data contained in each column of a spreadsheet are called _____. Answers assignmentsattributesallowancesaspects 3. Which of the following tasks might be performed using spreadsheets? Answers Maintain information about accounts Write a sales pitchDevelop communication skillsLand a new client 4. Formulas are created by the user, whereas functions are preset commands in spreadsheets. Answers TrueFalse 5. In the function =MAX(B5:B15), what does B5:B15 represent? Answers ObservationColumnAttributeRange 6. What is the correct spreadsheet formula for multiplying cell H2 times cell H5? Answers =H2/H5=H2^H5=H2*H5=H2xH5 7. To avoid bias when collecting data, a data analyst should keep what in mind? Answers ContextOpinionStakeholdersGraphs 8. A data analyst might use descriptive column headers in order to achieve what goal? Answers Add context to their dataProtect the spreadsheetAlphabetize the spreadsheet dataFilter the data Shuffle Q/A 1 9. To determine an organization’s annual budget, a data analyst might use a slideshow. Answer TrueFalse 10. Which of the following are ways that data analysts can add context to their data? Select all that apply. Answer Use descriptive column headersConsider where the data came fromCreate reports for stakeholdersAsk questions about the data Next Please Share This Share this content Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Devendra Kumar Project Management Apprentice at Google You Might Also Like Week 3 – Data-informed decision-making – Shuffle Q/A 3 Project Management and Its Importance Leave a Reply Cancel replyCommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional) Save my name, email, and website in this browser for the next time I comment.