-
Home
- Professional Development
- Career
- Spreadsheets MCQ
- Unit 03: Spreadsheet Design and
- How could you best derive a
-
Card 3 / 13: 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.
Answer:
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.
-
Keyboard Shortcuts
| Previous Card |
← Previous Card Button |
| Next Card |
→ Next Card Button |
| Flip Card |
Space-Bar |
<< First
< Previous
Flip
Next >
Last >>
Hide Choices
Interactive Question
Quiz Home Page
|
|
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/
Flash Cards plugin by Curtis Blackwell github.com/curtisblackwell/flash_cards
Google Play and the Google Play logo are trademarks of Google Inc.
