INDIRECT SECONDARY SOURCE CITATION APA GENERAL FORMAT LibGuides at Clover Park Technical College

Literature is a vast repository of stories, characters, and narratives that echo historical events. A historical allusion is a brief and indirect reference to a person, place, event, or idea of historical significance that is not elaborated on. Writers use it to let readers make connections without explicitly stating those connections. Essentially, it’s a shorthand reference that evokes a broader world of experience and emotions without having to describe that world in detail.

For example, the TV series Stranger Things (2016–) includes numerous references to 1980s pop culture, from films like E.T. The references help create a nostalgic atmosphere while adding layers of meaning. The usefulness of the Excel INDIRECT function is not limited to building “dynamic” cell references. You can also utilize it to refer to cells in other worksheets “on the fly”, and here’s how. Apart from making references from cell and text values, you can get the Excel INDIRECT function to refer to named ranges. This third type of intertextuality happens when a reader makes a connection that the author or poet did not intend to make.

Ultimate Suite for Excel

The word intertextual was coined in the 1960s by Julia Kristeva in her analysis of Bakhtin’s concepts of Dialogism and Carnival. The INDIRECT function allows you to give a text string and have the computer interpret that string as an actual reference. This can be used to reference a range on the same sheet, a different sheet, or even a different workbook. Circular references can cause incorrect calculations, slow down the performance of the workbook, and even crash Excel.

• Direct Addressing Mode is a way for a computer to find data in memory using a specific memory address included in the instruction.
• The meaning of one text is shaped or influenced by its relationship with other texts.
• To prevent this from happening, you can use the INDIRECT function to work with cell references that should remain intact in any case.

Example 3 – Using the ROW Function inside the INDIRECT Function to Define a Cell Reference

Knowing how circular references work can help you troubleshoot formula errors and other issues in your Excel workbooks. “Fahrenheit 451” by Ray Bradbury is a dystopian novel that centers on the theme of censorship and the dangers of a society that shuns intellectualism. Throughout the novel, Bradbury employs various allusions, including historical ones, to reinforce his themes and provide deeper insights into the world he has created.

Example 4 – Calculations with Cell References Defined by the INDIRECT Function

The hypotext is the text that is being referenced, so in this example it would be William Shakespeare’s Hamlet. In intertextuality, there are two main types of text, the hypertextual and the hypotextual. Contrast the Moby Dick example with John Steinbeck’s East of Eden (1952) which is a clear and direct obligatory reference to the biblical story of Cain and Abel. In Steinbeck’s case, the link was deliberate and also necessary to fully understand his novel. A writer could also use a reference to create humour, highlight an inspiration or even create a reinterpretation of an existing work. The reasons and ways to use intertextuality are so varied that it is worth looking at each example to establish why and how the method was used.

INDIRECT in Google Sheets

Effective subtlety requires skill and understanding — but it’s a very important part of communication, no matter if the context is formal or casual. “Subtle” is an adjective that means “indirect or not obvious” — and there are plenty of situations when being subtle is the safest thing to do. You can use Excel INDIRECT together with the ADDRESS function to get a value in a certain cell on the fly. Apart from SUM, INDIRECT is frequently used with other Excel functions such as ROW, COLUMN, ADDRESS, VLOOKUP, SUMIF, to name a few. To get into the function’s insight, let’s write a simple formula that demonstrates how you use INDIRECT in Excel. ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc.

• Data Tables allow you to explore the effects of changing one or two variables in a formula.
• Below is a rundown of intertextuality’s functions and why authors and screenwriters might choose to reference another cultural work.
• Direct addressing gives the exact location of the data, making it quick and easy to access.
• Intertextuality adds layers to a text, enriching its meaning and providing intellectual depth.
• Another phrase often alluded to is one from John F. Kennedy’s inaugural address, “ask not what your country can do for you—ask what you can do for your country.”

In literature, intertextuality enriches the depth of the narrative by weaving familiar themes or elements from other works. Techniques include allusion, pastiche, and parody, each employing varying degrees of explicit reference to another text. Through direct quotes, thematic reflections, or stylistic mimicry (fx, through parody), intertextuality is a great way to add more layers of meaning to your script. It involves indirect references, such as thematic echoes, stylistic similarities, or shared motifs. These connections may not be immediately obvious but become apparent upon closer analysis.

They can show up in literature, movies, television, comic books, video games, and ordinary conversations. In computer programming, addressing modes help the CPU find data in memory. Direct addressing gives the exact location of the data, making it quick and easy to access. Indirect addressing, on the other hand, uses a pointer to find the data, offering more flexibility but requiring an extra step. In this article we are going to discuss difference between direct and indirect addressing modes in detail. Movies often use historical allusions to provide depth, add layers of meaning, and to connect the film’s narrative with real-world events.

Intertextuality adds layers to a text, enriching its meaning and providing intellectual depth. By referencing other works, a text can trigger a broader range of emotions and ideas that challenge us as audience. I often say that there’s a fine line between intertextuality and intellectualism. Intertextuality, first and foremost, speaks to our intellect, and the more we understand the references, the deeper the meaning of the text (movie).

Philosopher and literary critic Julia Kristeva coined the term in the 1960s and argued that texts are not isolated creations but are shaped by a network of other texts. This suggests that understanding a text requires recognizing its connections to other works through direct citations, allusions, or more subtle references. Since you don’t want the cells containing the book’s and sheet’s names to change when copying the formula to other cells, you lock them by using absolute cell references, $A$2 and $B$2, respectively.

Example 2. INDIRECT and ADDRESS functions

You just have to specify the workbook’s name is addition to the sheet name and cell address. Also, please pay attention that if you are copying Indirect Reference Definition the formula into multiple cells, you have to lock the reference to the sheet’s name using the absolute cell references like $A$1. Most of the cases, when you face this type of problem, you should enable iterative calculations to continue with the formula.