Flashcards in MS EXCEL Deck (65)
Loading flashcards...
1
a spreadsheet program that allow the user to apply mathematical functions (simply a predefined formula just to make the process easier) to calculate different sets of values and apply the changes in the result when the input values are changed.
MS EXCEL
2
It’s made up of Columns, Rows and cell
MS EXCEL
3
It is an environment that can make number manipulation easy
MS EXCEL
4
- a spreadsheet file.
Workbook
5
By default, each workbook in Excel contains __ pages or worksheets
3
6
–Working area IN EXCEL
It is made up of rows and columns
Worksheet
7
- a rectangular bar that intersect columns and rows.
Cell
8
- In an Excel 2007 worksheet, the cell with the black outline. l
Active Cell
9
Data is always entered into the ____
ACTIVE CELL
10
displays the data or formula stored in the active cell.
formula bar
11
is a mathematical equation used to calculate a value
A formula in a spreadsheet, such as Excel
12
In Excel formulas must begin with an ____ sign.
equal ( = )
13
- Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Column Letter
14
the last column letter
XFD
15
- run horizontally in an Excel worksheet. They are identified by a number in the row header.
Row Header
16
last row number
1048576
17
– active workbook on a worksheet.
Sheet tabs
18
Switching between worksheets in an Excel 2007 file is done
by clicking on the sheet tab at the bottom of the screen.
19
– guidelines on a worksheet
Gridlines
20
– file extension
.xlsx
21
default filename
Book1
22
– default font style and size
Calibri 11
23
keyboard command to edit cell
F2 –
24
default location of active cell
A1 -
25
Displays the name of the workbook and the program
Title Bar
26
Minimize, Restore Down/Max, and close buttons
Close button to exit excel.
Used to control the program window.
27
button to hide the window.
Minimize button
28
button to adjust the size of the windows
Restore Down/Max button
29
button to exit excel.
Close button
30