IT Flashcards
study
What is a file?
it is a container use to store stuff
what is a folder?
it is a collection of files
Differentiate between webpage and website
a webpage is A single page on the internet
a website is A collection of related webpages under a single domain.
what is file organisation?
it is when data has been input verified and validated
what is file access method?
it is how data is stored in a file
what is HDD and SSD
hard disk drive
solid state drive
what is serial?
it mean to start at the beginning and read to the end in one go.
what is sequential
it refers to a method where data or files are processed in a specific, linear order, one after another.
what is random and direct?
these are the final method of access
what is the purpose of spreadsheet
it allows users to organize data in rows and columns and perform calculations on the data.
what is a spreadsheet?
it is a table consisting of cells (columns, row locations) that hold accounting or financial data and simulates the traditional spreadsheet
what is a workbook
it is a spreadsheet file. It contains at least one work sheet, and may contain several worksheets
what is another name for workbook
it is spreadsheet
what is cell address
A cell address identifies a single cell in a worksheet.
what is worksheet?
A worksheet is a single page in a spreadsheet file/workbook.
what is a cell?
A cell is an individual location in a spreadsheet. It is referenced by its column letter and row number.
what is a range?
A range identifies a rectangular block of cells on a worksheet.
what is a label?
These are non-numeric data that will not be used in calculations, example a person’s name. In a spreadsheet, a label is text entered to explain contents of other cells.
what is a value
The data entered into a cell in a spreadsheet
what is function
A function is used within a formula to carryout complex calculations.
