Technology Flashcards

(15 cards)

1
Q

What can spreadsheets be used to show?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are some examples of ways spreadsheets can be used?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a cell in a spreadsheet?

A

Every rectangle in a workbook is called a cell, formed when a row and a column meet. To select a cell, click on it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are spreadsheet files called?

A

Spreadsheet files are called workbooks, which can contain more than one worksheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do you switch between sheets in a workbook?

A

You can switch between sheets by selecting the sheet tab in which you wish to work.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a column in a spreadsheet?

A

A column is a group of cells that run vertically from the top of the page to the bottom and are named by letters.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a row in a spreadsheet?

A

A row is a group of cells that run horizontally from the left of the page to the right and are labeled by numbers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the Ribbon in a spreadsheet?

A

The Ribbon is a tabbed interface similar to Word, containing several tabs, each with a set of commands for performing basic tasks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a cell address?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a range of cells?

A

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 well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How do calculations start in a spreadsheet?

A

All calculations in a spreadsheet start with an equal sign (=) to distinguish a calculation from a value.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the difference between a formula and a function?

A

A formula is an expression that calculates the value of a cell, while a function is a predefined formula already available to use.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the main reason people use spreadsheets?

A

The main reason is that spreadsheets can perform calculations using standard operators.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the BODMAS rule?

A

The BODMAS rule stands for Brackets, Of, Division, Multiplication, Addition, and Subtraction, and it applies to formula operators in spreadsheets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How are calculations performed in spreadsheets?

A

Calculations are performed from left to right, with brackets done first, followed by division and multiplication, and then addition and subtraction.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly