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;
10 Cards in this Set
- Front
- Back
What are two types of sheets used in a workbook?
|
Chart sheets and Worksheets
|
|
List two ways of identifying the active cell in the worksheet.
|
The active cell is surrounded by a thick border and its cell reference appears in the Name Box
|
|
What is the cell reference for the cell located in the third column and fifth row of a worksheet?
|
C5
|
|
What keyboard shortcut moves the active cell to cell A1?
|
The Ctrl+Home keys
|
|
What is text data?
|
A combination of alphanumerical characters that form words and sentences (called a text string)
|
|
How do you enter two lines of text within a cell?
|
Enter the first line of text, press the Alt+Enter keys, and then type the second line of text.
|
|
Cell A4 contains "May 3,2010"; why doesn't Excel consider this entry a text string?
|
Because it is a date; all dates are number formatted to appear in standard date formats.
|
|
Explain the difference between clearing a row and deleting a row.
|
Clearing a row removes only the contents of the row, deleting a row removes the contents and the row.
|
|
Describe the two types of cell ranges in Excel.
|
Adjacent cell ranges contain rectangular blocks of cells; nonadjacent cell ranges contain a collection of adjacent cell ranges.
|
|
What is the range reference for the block of cells from A3 through G5 and J3 through M5?
|
A3:G5;J3:M5
|