How could you best derive a total sum for all Ryan Lowe @Saylor Spreadsheets

Question 2 / 9: How could you best derive a total sum for all the values in a Microsoft Excel spreadsheet column?

A It is not possible to perform this operation in a spreadsheet unless it has been formatted.

B You could select the range, then cut and paste it into the calculation window.

C You could select the empty cell below the last value in the column and then enter the following
formula in the formula toolbar: =SUM(A1:A5), with A1:A5 being an example of the range of all
the cells with values in the column.

D You could use a calculator and enter the total of the column manually.

<< First < Previous Flashcard Next > Last >> Quiz Home Page

https://www.jobilize.com/spreadsheets-mcq-quiz-by-ryan-lowe

Spreadsheets MCQ

Author:

Ryan Lowe

Saylor Foundation

USA

Access: Public Instant Grading

Attribution: Ryan Lowe. Spreadsheets. The Saylor Academy 2014, http://www.saylor.org/courses/prdv004/

Ask

	4 Physiotherapy Flashcards Set 4 By Rhodes Start Flashcards
	22 AP 22 Respiratory System Essay By OpenStax Start Flashcards
	2 AP 02 Chemical Level of Organization Essay By OpenStax Start Flashcards
	Are you a 5sos fan? By Rylee Minllic Start Quiz
	Engineering Communication MCQ By Steve Gibbs Start Quiz
	1 Gastrointestinal Pathophysiology By Laurence Bailen Start Exam
	American Government MCQ By Saylor Foundation Start Quiz
	23 AP Key Terms 23 The Digestive System By OpenStax Start Key Terms
©flickr:	Health Reviewer MCQ By Edgar Delgado Start Quiz
	2 Pharmacology Nervous System Essay By Rohini Ajay Start Test

Copy and paste the following HTML code into your website or blog.