COMPUTER Flashcards
REVIEWER
A computerized worksheet.
- It has the standard feature of an electronic spreadsheet.
- It can also organize information such as inventory, work schedules, projects, invoices, and address lists
Ms Excel
- A single sheet within a workbook or onscreen spreadsheet.
Work Sheet
- It is a file that contains one or more worksheets.
Workbook
– are horizontal lines in the worksheet. Represents a number (“1 to 1048576”)
Rows
are vertical lines in the worksheet. Represents a letter. (“A to XFD”)
Columns
the basic unit of a worksheet into which you enter data in Excel.
Cell
– shows the cell reference of the active cell and can also be used to assign names to cells or ranges of cells.
Name Box
is the area where you can enter or edit text or formulas.
FORMULA BAR
it contains the commands organized in three components:
Ribbon
allows you to easily go to the top and bottom, left or right of the worksheet.
Scroll Bar
provides access to the most common Excel commands including SAVE, UNDO, REPEAT, and COPY.
Quick Access Toolbar
provides access to the only menu in MS Office 2016.
FILE MENU
Workbook
is a file that contains one or more worksheets.
displays different views of the worksheet.
View Buttons
– it indicates the name of the file and name of the program.
FILE NAME
- THREE BUTTONS IN WINDOWS CONTROL BUTTON
- Minimize
- Maximize
- Close
- THREE BASIC COMPONENTS OF RIBBON
- Tabs
- Groups
- Commands
it contains the commands organized in three components:
RIBBON
- FONT GROUP COMMANDS
- Font name
- Font size
- Bold
- Italic
- Underline
- Increase font size
- Decrease font size
- Border
- Fill color
- Font color
The process of arranging the items of a column in some sequence or order .xlsx- a default extension of Excel Files
- Sorting
feature of MS Excel quickly completes a series of data
- Auto Fill
This will automatically copy the formula down to the end of your data, matching the rows in adjacent columns.
- Fill Handle
- You can complete a cell entry by:
- Pressing enter
- Pressing any arrow key on the keyboard
- Clicking the Enter button on the Formula bar
- You can activate a cell by:
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- are letters, symbols, numbers and spaces or any combination that you enter into cell.
Labels
- is a number that you enter into a cell, you may include symbols such as decimal point, comma and currency.
Value
- is used to calculate values You may use an equal sign or the Auto sum function to build a formula.
FORMULA
