Unit 4 Lesson 1: Familiarizing with Spreadsheet Application Flashcards
-a spreadsheet software used to input and analyze data
-contains grids where you
can place values
-although it is commonly used for computations, you can also place
images, graphs, and charts to represent various data in a document for easier understanding and presentation
Excel
-document itself when you open your Excel
-can contain many spreadsheets
Workbook
one portion of your document
Spreadsheet
- works as your normal arithmetic operation
-you need to place an
equal sign (=) before performing any operation between two or more values
Formulas
specialized operations with assigned names that use predefined
formulas and return a value
Functions
Parts of an Excel Document:
-is a rectangular box where you can input your values
-each one can contain texts, numbers, images, or formulas
Cell
Parts of an Excel Document:
- shows the number in a row of the currently selected cell
-these numbers are
arranged in numeric order
Row Number
Parts of an Excel Document:
-shows the letter in a column of the currently selected cell
- are in alphabetical order from A-Z, and will have a combination afterwards such as AA, AB, AC,
and so on
Column Letter
Parts of an Excel Document:
-shows the cell currently selected if you are selecting only one cell
Name Box
Parts of an Excel Document:
- also shows the number of rows and columns if you are trying to select a big portion of your document which contains several cells
Parts of an Excel Document:
-is the long rectangle beside the name box where you can input your formulas for your data
-can also use this to input a value in a cell
Formula Bar
Parts of an Excel Document:
-is found on the top of the grid in Excel
Ribbon
Parts of an Excel Document:
-allows you to access frequently used tools such as save, undo, and
redo
Quick Access Toolbar
Parts of an Excel Document:
-also known as sheets, is where you can select a different sheet to look at its contents
Spreadsheet Tab
Parts of an Excel Document:
-shows different information about the document
Status Bar