Technology Flashcards
(15 cards)
What can spreadsheets be used to show?
Spreadsheets can show different types of data like graphs, information, numbers, and graphics. However, they are mainly used to perform calculations on large sets of data.
What are some examples of ways spreadsheets can be used?
Examples include creating an invoice, a study timetable that calculates breaks and study time, calculating term averages and marks, and displaying data visually through graphs or charts.
What is a cell in a spreadsheet?
Every rectangle in a workbook is called a cell, formed when a row and a column meet. To select a cell, click on it.
What are spreadsheet files called?
Spreadsheet files are called workbooks, which can contain more than one worksheet.
How do you switch between sheets in a workbook?
You can switch between sheets by selecting the sheet tab in which you wish to work.
What is a column in a spreadsheet?
A column is a group of cells that run vertically from the top of the page to the bottom and are named by letters.
What is a row in a spreadsheet?
A row is a group of cells that run horizontally from the left of the page to the right and are labeled by numbers.
What is the Ribbon in a spreadsheet?
The Ribbon is a tabbed interface similar to Word, containing several tabs, each with a set of commands for performing basic tasks.
What is a cell address?
Every cell has its own address based on its row and column. For example, if a cell is in column C and row 5, its address is C5.
What is a range of cells?
When you select multiple cells at the same time, it is called a range of cells. For example, a range including C1, C2, C3, and C4 is written as C1:C4.
How do calculations start in a spreadsheet?
All calculations in a spreadsheet start with an equal sign (=) to distinguish a calculation from a value.
What is the difference between a formula and a function?
A formula is an expression that calculates the value of a cell, while a function is a predefined formula already available to use.
What is the main reason people use spreadsheets?
The main reason is that spreadsheets can perform calculations using standard operators.
What is the BODMAS rule?
The BODMAS rule stands for Brackets, Of, Division, Multiplication, Addition, and Subtraction, and it applies to formula operators in spreadsheets.
How are calculations performed in spreadsheets?
Calculations are performed from left to right, with brackets done first, followed by division and multiplication, and then addition and subtraction.