Avatar of Dier02
Dier02Flag for Australia

asked on 

link different cells in a worksheet to a table in excel

I want to link a range of cells to a table in excel.  For example the first columns data may come from the sum of cells A1, C36, D16.  Column two could be the sum of A36, B92,C18 and so on.  How do I do this?
Microsoft Excel

Avatar of undefined
Last Comment
Dier02
Avatar of redmondb
redmondb
Flag of Afghanistan image

Hi, Dier02.

Could you post a sample file, please?

Thanks,
Brian.
Avatar of Dier02
Dier02
Flag of Australia image

ASKER

Avatar of Dier02
Dier02
Flag of Australia image

ASKER

There a range of scores and answers that have to be linked to a final sum then represented as a column graph.  If you look at A 100 you will see the questions that are grouped to give a result for that column.
Avatar of redmondb
redmondb
Flag of Afghanistan image

Dier02,

Thanks. I'm finding it very slow to get my head around the sheet. A few question, please.

(1) Checking for understanding, are the following correct?
 - You are reporting under 4 Categories  - Knowledge and Understanding, Investigating, Communicating, Reflecting
 - There is a single Grade for each Category - A, B, C, D, E
 - The combined scores of a no. of Questions are used to assess each Category  -  Knowledge and Understanding  (Q2,4,6b,7), Investigating (Q1,3,5,6,8,9a), Communicating (Q2,4,6,7), Reflecting (Q6c,7,9)

(2) Row B26...
 - Is this Question 2?
 - Which cells are answers and which scores?
 - How much is the marker manually entering and how much will be automatically scored from the answers? (I'm assuming the tables in row 230 (?) and following will be used for this?)

(3) Having totaled up all a Category's points how is this converted to a Grade?

(4) Where a result has multiple grades (e.g. "Refines procedure by applying learning from investigation. (B/C)") how is it decided which Grade applies?

That's it ... for now!
Thanks,
Brian.

Thanks,
Brian.
Avatar of redmondb
redmondb
Flag of Afghanistan image

Dier02,

(5) Am I correct that where an answer is entered on the sheet, this is done by the marker, not the student? So, e.g., G51 is not strictly the answer, but rather an assessment of the answer?

Thanks,
Brian.
ASKER CERTIFIED SOLUTION
Avatar of cben
cben
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Dier02
Dier02
Flag of Australia image

ASKER

Great work, thanks.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo