Fundamentals of Spreadsheets and Data Presentations - D388
Studied by 2 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/19
Earn XP
Description and Tags
stopped @ lesson 3.1
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
20 Terms
Workbook
An Excel file that stores all the information, previous calculations, and analyses that you may have already completed; must contain at least one worksheet.
Worksheet
A collection of cells arranged in the form of a table that contains the actual data and calculations.
Pane
The area of a worksheet that is visible on the screen.
Value
The content within the cell.
Function
A built-in method for performing a calculation in Excel.
File menu
A group of menu items used to manipulate workbooks.
Home menu
A group of menu items used to format the appearance of data in cells.
Insert menu
A group of menu items that includes features for specializing elements into workbooks, such as charts, pictures, and shapes.
Draw menu
A group of menu items used to insert freehand sketches into worksheets.
Page layout menu
A group of menu items used to format the appearance of worksheets when they are printed.
Formulas menu
A group of menu items used to perform calculations using Excel’s built-in functions.
Data menu
A group of menu items used to aid in importing and working with data.
Review menu
A group of menu items that help in sharing an Excel workbook with colleagues.
View menu
A group of menu items that are used to change how a worksheet is displayed on the screen.
Help menu
A group of menu items that are used to obtain assistance on spreadsheet features.
Toolbar
The bar located below the title bar. Provides access to tools commonly associated with tasks performed in an Excel workbook.
Formula bar
A bar located to the right of the Insert Function icon (fx) in an Excel worksheet where the user can add or edit the contents of a cell.
Range
A consecutive block of cells arranged in a row, a column, or a combination of both.
E.g., A1:B3 contains cells A1, A2, A3, B1, B2, and B3.
Where the column and row width and height options are
Home tab > cells section > format
Where the “Sort Ascending” and “Sort Descending” icons are
Data tab
Note 
Flashcards (161)