Bst terms part 1, 2 and 3

45 terms by Tavernari_Arielle 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

Excel 2007

a spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, and develop professional looking reports

Worksheet

a page in an Excel workbook organized in vertical columns and horizontal rows

Spreadsheet

another name for worksheet

Workbook

a collection of worksheets

Tables

used to organize and store data within worksheets

Column

a vertical line of cells identified by an alphabetic label at the top of the column

Row

a horizontal line of cells identified by a row number at the left end of the row

Column headings

a column letter above the grid that identifies each column

Row headings

a row number on the left side of the grid that identifies each row

Cell

the intersection of a row and a column

Active cell

the cell that is currently selected or being used

Cell reference

the coordinates of the intersection of a column and row, with the column letter first and the row number last

Gridlines

the horizontal and vertical on the actual worksheet

Worksheet size

each worksheet can have over 16 thousand (16,384) columns and over 1 million (1,048,576) rows for a total of over 17 billion (17,179,869,180) cells

Block plus sign

the shape of the mouse pointer whenever the mouse pointer is located in a cell

Block arrow

the shape of the mouse pointer whenever the mouse pointer is moved outside the worksheet or when you drag cell contents between rows or columns

Worksheet window

the portion of the worksheet displayed on the screen

Normal view

the default (preset) view in Excel

Status bar

presents info about the worksheet and is located immediately above the Windows taskbar at the bottom of the screen

Mode indicators

on the status bar, this specifies the current mode of Excel, such as Enter or Ready

Ready Mode indicator

indicates that Excel is ready to accept the next command or data entry

Enter Mode indicator

indicates that Excel is in the process of accepting data through the keyboard into the active cell

Keyboard indicators

appear to the right of the mode indicator and shows which toggle keys are engaged (for example: Scroll lock)

Ribbon

consisting of tabs, groups, and commands, and is located near the top of the Excel window

Top level tab

located on the ribbon, each tab surrounds a collection of groups

Group

found on the ribbon, this is a collection of related commands

Home tab

also known as the primary tab, contains the more frequently used commands

Active tab

the tab that is currently displayed

Contextual tabs

tabs that are only displayed when you work with certain tasks or object such as charts or tables

Gallery

a set of choices, often graphical, arranged in a grid or list

in ribbon gallery

Shows common gallery choices on the ribbon rather than in a drop down list

Task pane

Similar to a dialog box. this is a window than can remain open and visible while you work in the worksheet instead f having to be closed before you return to the worksheet

formula bar

A bar that appears below the Ribbon and displays your cell entry(s) as you type

name box

located on the left side of the formula bar, this displays the active cell reference (the cell which you are currently using)

Select a cell

to make the cell active

text

consists of any set of characters containing a letter, hyphen, or a space

Row content

rows typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet

Characters

Letters, numbers, punctuation marks, and symbols

Label

a text entry in an Excel worksheet

value

a numeric entry in an Excel worksheet

formula

a cell entry that performs calculations

Range

a series of two or more adjacent cells in a column or row or a rectangle group of cells

SUM function

adds all of the numbers in a range of cells

Marquee

the flashing border that appears around a group of cells that have been selected to be summed(added)

Column content

columns typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set