You are given an Excel 2007 spreadsheet with two columns of data. Cells A1:A1000 have dates and cells B1:B1000 have counts corresponding to those dates. You are asked to find the sum of all of the counts for dates between 01-Jul-2012 and 31-Dec-2012 (inclusive)

🎲 Try a Random Question  |  Total Questions in Quiz: 719  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Excel Fundamentals Test (Upwork) — practice the complete quiz, review flashcards, or try a random question.

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.


You are given an Excel 2007 spreadsheet with two columns of data. Cells A1:A1000 have dates and cells B1:B1000 have counts corresponding to those dates. You are asked to find the sum of all of the counts for dates between 01-Jul-2012 and 31-Dec-2012 (inclusive)