Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
5 Cards in this Set
- Front
- Back
|
How do you freeze a header row?
|
Choose Table > Freeze Header Rows.
|
|
|
How can you filter data automatically?
|
In the toolbar, click the Reorganize button to open the Reorganize window. In the central filter area of the window, set the filtering values.
|
|
|
How do you reference a value from one sheet to another?
|
In the destination sheet, select the cell in which you want to place the calculated value. Press the = (equal sign) key to open the Formula Editor. Create a formula based on cells in the source sheet. Press Return to calculate the value and place it in the destination sheet cell.
|
|
|
Define a function.
|
A function is a predefined, named operation that can perform a calculation.
|
|
|
In a formula, how do you insert actual data into a placeholder argument?
|
In the Function Browser, choose the desired function and click Insert Function. Click the desired argument; then click the cell in which the actual data appears. Do this for every placeholder argument in the function. Press Return to accept and calculate the formula.
|
