CGS 2060 Tutorial 1.1 Quick Check
What is the range reference for the block of cells B10 through C15?
B10:C15
What is the reference for the nonadjacent block of cells B10 through C15 and B20 through D25?
B10:C15;B20:D25
What is the cell reference for the cell located in the fourth column and third row of a worksheet?
D3
What keyboard shortcut changes the active cell to A1?
ctrl+Home
What is text data?
text string; combination of letters, numbers, and symbols
Cell A4 contains May 3, 2016; why doesn't excel consider this entry a text string?
it recognizes date entries as numbers
What are the two types of sheets used in a workbook?
chart sheets and worksheets
How do you resize a column or row?
using the pointer, Home>Cell group FORMAT button> Column Width, etc