Spreadsheet Basics and Functions

An individual entity on a spreadsheet where data can be entered.

A vertical line of characters extending from the top to the bottom of the screen.

A horizontal series of data in a table or spreadsheet.

An equation that makes calculations based on the data in your spreadsheet.

A number entered into a spreadsheet cell. If a formula or function returns a number into a cell, this data is also a value.

The grid of columns and rows that information is inputted into. In many spreadsheet applications (such as Microsoft Excel) one file - called a workbook - can contain several worksheets.

If we divide 8 by 2, we get 4. 8 divided by 2 equals/is 4. (8/2= 4)

If we subtract 2 from 8, we get 6. 8 minus 2 is 6. (8-2=6)

A field in a database that uniquely identifies each record. It ensures that no two records have the same value in this field.

A data entry tool used to input data into tables in a database.

A database object used for displaying data from one or more tables in a user-friendly format. It's designed to look good and is suitable for printing.

The process of retrieving specific data from a database. It helps find specific information.

A process of combining data from different tables in a database to achieve a specific outcome. It helps analyze and combine information.

A type of system administrator responsible for managing computer systems and networks.

The act of deploying software updates or upgrades to multiple computers simultaneously.

Ensuring that a website is secure, accessible and performs consistently.

To make something in the past, for example, writing a document, reading a book, or playing a game.

A word that changes its form according to the tense, for example, 'walk', 'walked', 'walking'.

A word that doesn't change its past tense by adding '-ed' and instead has a unique past form, for example, 'go', 'went', 'gone'.

A collection of related data organized in a way to make data accessible and easy to use.

A column in a database table, representing a specific characteristic or attribute.

A structured request to extract specific data from a database.

The process of making a program ready to use on many computers at once.

Settings that control who can access a file, folder, or device.

Data that a computer or program records while running, used to track its performance and troubleshoot problems.

A network-connected storage device that lets multiple computers access data easily.

A flat surface that responds to touch, letting users interact with a device without a mouse or stylus.

A type of pen designed to be used with touchscreens or graphics tablets for precise drawing or writing.

A device that shows the computer's screen on a larger surface, often used for presentations.

A phrase used to describe a program or system that is working well without any errors.

A device worn on the head with a microphone and headphones.

A printer that can also scan, copy, and fax documents.

The past continuous tense describes an action happening over a period in the past. It uses "was/were + verb + -ing".

The past simple tense describes a completed action in the past. It uses the base form of the verb (or the past tense form for irregular verbs).

A comparison between two things, using "as...as" or "more...than".

A comparison that identifies the most extreme or highest level.

A suggestion or guidance for an action or course of action.

A recommendation structure using the infinitive form of a verb. "I recommend + verb + -ing".