Microsoft Excel
Spreadsheet
Microsoft Excel
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A detailed overview of microsoft excel, an electronic spreadsheet program. It explains the basic structure of a spreadsheet, the uses of a spreadsheet, and various components such as rows, columns, active cells, cell references, formulas, functions, ranges, worksheets, labels, and activities. It also covers how to identify cells and perform calculations using formulas and functions.
Typology: Slides
2023/2024
1 / 16
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Understanding Microsoft Excel: A Comprehensive Guide and more Slides Technology in PDF only on Docsity!
Microsoft Excel
Spreadsheet Microsoft Excel
What is a Spreadsheet?
- (^) An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
- (^) A spreadsheet is a grid of cells organized in rows and columns. Each column is given a letter, and each row is given a number.
Uses of a Spreadsheet
- (^) Record accounting information
- (^) To perform calculation
- (^) Store information
- (^) Present data
Active cell
- (^) The active cell is identified by a black or blue border or outline surrounding the cell.
- (^) The active cell is also known as the current cell or the cell that is in focus.
Cell address/ Cell reference
- (^) a cell reference identifies the location of a cell or group of cells in the worksheet.
- (^) Cell references are used in formulas, functions, charts, and other Excel commands
Function
- (^) A function is a preset formula in Excel.
- (^) Like formulas, functions begin with the equal sign ( = ) followed by the function's name and its arguments.
Range
- (^) A range is a group or block of cells in worksheet that have been selected or highlighted.
Label
- (^) A label most often refers to a text entry such as a heading used to identify a column of data.
Label
Across
- are used to perform calculations on values entered and stored in the program
- a group or block of cells in worksheet a single page in a file created with an electronic spreadsheet program
- a preset formula
- Address identifies the location of a cell or group of cell Down 1. run horizontally in an Excel worksheet
- refers to a text entry such as a heading used to identify a column of data.
- run vertically in a worksheet
- Cell identified by a black border