Home
Browse
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Excel Tutorial 1 Key Terms
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (46)
active cell
The cell currently selected in the active worksheet. (EX 2)
active sheet
The sheet currently displayed in the workbook window. (EX 2)
arithmetic operator
An operator that performs addition, subtraction, multiplication, division, or exponentiation. (EX 32)
AutoComplete
The feature that displays text that begins with the same letters as a previous entry in the same column to help make entering repetitive text easier. (EX 20)
AutoFit
The feature that changes the column width or row height to display longest or tallest entry within the column or row. (EX 27)
AutoSum
The button that inserts functions to sum, average, or count values in a range, or find the minimum or maximum value in a range. (EX 31)
Border
A line you can add along an edge of cell that prints. (EX 30)
Cell
The intersection of a row and a column. (EX 3)
cell range (range)
A group of cells in a rectangular block. (EX 2)
cell reference
The column and row location that identifies a cell within a worksheet. (EX 9)
chart sheet
A sheet that contains only a chart that provides a visual representation of worksheet data. (EX 7)
clearing
To remove the data from a row or column but leaves the blank row or column in the worksheet. (EX 45)
column headings
The letters along the top of the worksheet window that identify the different columns in the worksheet. (EX 3)
date data
A value in a recognized date format. (EX 17)
Edit mode
The mode in which you can edit cell contents. (EX 19)
Flash Fill
The feature that enters text based on patterns it finds in the data. (EX 48)
Formula
A mathematical expression that returns a value. (EX 31)
formula bar
The bar located below the ribbon that displays the value or formula entered in the active cell. (EX 2)
function
A named operation that replaces the action of an arithmetic expression in a formula. (EX 31)
hide
To make a row, column, or worksheet not visible. (EX 48)
landscape orientation
The page orientation where the page is wider than it is tall. (EX 53)
Name box
The box located at the left side of the formula bar that displays the cell reference of the active cell. (EX 2)
nonadjacent range
A collection of separate ranges. (EX 2)
Normal view
The Excel view that shows the contents of the active sheet in the workbook window. (EX 31)
numeric data
Any number that can be used in a mathematical calculation. (EX 17)
operator
A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell. (EX 32)
order of operations
A set of predefined rules used to determine the sequence in which operators are applied in a calculation. (EX 32)
Page Break Preview
The Excel view that shows the location of page breaks in the printed sheet. (EX 31)
planning analysis sheet
A series of questions that help you think about a workbook's purpose and how to achieve your desired results. (EX 13)
range reference
The cell reference of the upper-left cell in the range and the cell reference of the lower-right cell separated by a colon that identifies the range. (EX 11)
row headings
The numbers along the left side of the workbook window that identify the different rows of the worksheet. (EX 2)
scale
To change the size of the worksheet on the printed page. (EX 54)
Sheet
A page included in a workbook; can be a worksheet or a chart sheet. (EX 2)
sheet tab
The area at the bottom of the worksheet that identifies the sheet by name. (EX 2)
spreadsheet
A grouping of text and numbers in a rectangular grid or table. (EX 4)
status bar
An area at the bottom of the Excel window that provides information about the workbook. (EX 2)
SUM
The function that adds values in a specified range. (EX 31)
Tab
The part of the ribbon that includes commands related to particular activities or tasks. (EX 2)
Template
A preformatted workbook with many design features and some content already filled in. (EX 4)
text data
Any combination of letters, numbers, and symbols. (EX 17)
time data
A value in a recognized time format. (EX 17)
Touch Mode
The mode for use with a touchscreen; changes the ribbon to make it easier to use a finger or a stylus to tap a button. (EX 6)
Unhide
To redisplay a hidden row, column, or worksheet. (EX 48)
Workbook
An Excel file that stores a spreadsheet; contains a collection of worksheets and chart sheets. (EX 2)
workbook window
The area of the Excel window that displays the contents of the workbook. (EX 3)
worksheet
A grid of rows and columns in which content is entered. (EX 3)
YOU MIGHT ALSO LIKE...
Tutorial 1: Getting Started with Excel
69 terms
Excel Tutorial 1
54 terms
Cba CHS Excel lessons 1-4 test
70 terms
Excel Key Terms (Lessons 1, 2, 3, 5)
71 terms
OTHER SETS BY THIS CREATOR
Exploring Careers - Chapter 1 Test
20 terms
Access Chapter 1 (Lessons 1-7)
22 terms
Excel Lesson 9-14
22 terms
Excel Lessons 1-8
31 terms
OTHER QUIZLET SETS
sensing memory ch2
32 terms
7 Sympathetic Drugs
76 terms
chapter two radiology
70 terms
biochem exam 3 2017
35 terms