Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Information Technology Grade 10 > Prod Tools > Flashcards

Prod Tools Flashcards

(60 cards)

Start Studying
1
Q

What is a spreadsheet?

A

An electronic document in which data is arranged in row and colums of a grid and can be manipulated and used in calculations.

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

examples of spreadsheet programs

A

apple numbers
zoho sheet
excel
google sheets

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

Describe a situation where the use of a spreadsheet is appropriate.

A

A spreadsheet can be used to create a budget. This way you can manage your income and expenses, identify ways you can save money and get a more detailed view of your financial habits.

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

What is a formula?

A

A combination of cell adresses and mathematical operations to perform some calculations.

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

What is a function?

A

A combination of cell adresses and key words to perform some calculations.

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

What are the 4 things you can put in a spreadsheet cell?

A

Values
Labels
Fucntions
formulas

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

What are some uses of spreadsheets?

A

Statistics- finding the average or calculating deviation
Financial plans- budgeting
Stock keeping in a supermarket
loan calculations

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

What is the title bar?

A

Displays the name of the program and the current workbook if it has been saved.

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

What are the ribbon tabs?

A

at the top of the worksheet with keyboards that represent a group of closely related commands.

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

What is the status?

A

displays helpful information as you use the program.

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

What is the name bar?

A

Identifies the active cell

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

What is the formula bar?

A

Displays the content of the active cell if any

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

What is the fill handle?

A

A spreadsheet feature at the bottom right corner of an active cell. It allows the copying of content, continuation of sequence and updating of a formula.

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

What does the count function do?

A

It counts the number of cells that contain numbers and counts number in a list of arguments.

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

What does the Count A function do?

A

It counts cells containing any type of information including error values and empty text.

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

What does the average function do?

A

It calculates the average of supplied numbers and can hold up to 255 individual arguments.

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

What does the Today function do?

A

returns the current date continuosly when the workbook is changed or updated.

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

What is the relationship between absolute and relative cell address.

A

When used in a formula the relative address will change while thr absolute will stay the same

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

What is absolute referencing?

A

A way to fix a cell or range of cells so that they dont change when you copy the formula to another cell.

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

What is autofiltering?

A

what you do to your data when you only want to see some information according to your criteria.

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

How do you know when autofiltering is used?

A

The color of the number rows change
you can see the filter icon on what you filtered
some of the row numbers have double lines

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

Why is advanced filtering used?

A

Advanced filtering is normally used when you have a large amount of data or you need a more complex filter.

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

What are freeze panes?

A

Freeze panes allow you to lock a row or column so that when you scroll across or down your data that row or column still shows.

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

Why are named ranges useful?

A

Naming a range makes it simple to understand and maintain your data. It also makes it easy to remember if you want to reference it in another sheet or formula.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
What is the IF function?
It allows you to make a choice depending on if your condition is met or not and returns on of two values.
25
What is the count if function?
A function that will tally the contents in multiple cells when the criteria is met.
26
What is a pivot table?
A pivot table is a summary of your data packaged in a chart and allows you to report on and explore trends based on your information.
27
What is word processing?
Using computers to create, edit and print documents consisting mostly of textual information. ## Footnote Word processing encompasses a range of tasks involving text manipulation.
28
What is required to perform word processing?
A computer processor and a printer. ## Footnote These components are essential for creating and printing documents.
29
What are word processors?
Word processors enable you to create mostly text-based documents, store them electronically on a disk, display them on a screen, modify them, and print them on a printer. ## Footnote Word processors are software applications designed specifically for document creation and editing.
30
What is an advantage of word processors over typewriters?
You can make changes without retyping the entire document. ## Footnote This feature allows for quick corrections and modifications.
31
How do word processors facilitate text manipulation?
They make it easy to move sections of text within the document or between documents. ## Footnote This capability enhances document organization and editing efficiency.
32
What are some common uses of word processors?
* To create reports * To create letters * To create essays * To create memos * To produce low-grade newspapers and magazines ## Footnote Word processors are versatile tools used in various writing and publishing tasks.
33
What is a feature of word processing that allows users to remove text?
Delete text ## Footnote This feature enables users to eliminate unwanted characters, words, or sections from a document.
34
What action allows users to revert to a previous version of their document?
Undo changes ## Footnote This feature is crucial for correcting mistakes or reversing recent edits.
35
What is the purpose of subscript in word processing?
Type very small letters just below the line of text ## Footnote Commonly used in mathematical formulas and chemical symbols.
36
What is the purpose of superscript in word processing?
Type very small letters just above the line of text ## Footnote Often used for exponents and footnotes.
37
Fill in the blank: Word processors also have a ruler for showing and assisting in setting _______.
margins, tabs and indents ## Footnote This feature helps in formatting the document layout.
38
What feature distributes text evenly between the margins?
Justify ## Footnote This feature enhances the appearance of the text in a document.
39
Name an example of a word processor.
Microsoft Word ## Footnote Other examples include Goodnotes, Google Docs, Notion, and WordStar.
40
What does the Italics feature do in word processing?
Italicize your text ## Footnote Italics are often used for emphasis or titles of works.
41
What action allows users to rearrange text within a document?
Move text ## Footnote This feature helps in reorganizing content for better flow.
42
What is the function of a word processor in text editing?
Type and correct text ## Footnote This is the primary function of any word processing software.
44
45
What is the purpose of line and paragraph spacing?
To choose the amount of space between lines of texts and paragraphs.
46
Where do headers and footers appear in a document?
Headers appear at the top of every page and footers appear at the bottom of every page.
47
What can headers and footers be used for?
To show page numbers and document names.
48
How can you insert a header or footer in a document?
Insert → header I footer.
49
What is the function of page numbering in a document?
Keeps the document in order and makes it easy to refer to specific parts of the document.
50
How can page numbers be added to a document?
Insert - page number or double click the header or footer, then choosing page number from the menu option.
51
What are footnotes used for?
To add an additional point or state the source of your information.
52
Where are footnotes located in a document?
At the bottom or foot of the page that the information is on.
53
54
What is an endnote?
An endnote is placed at the end or tail of the document. ## Footnote References are indicated with a superscript character next to the item being spoken about.
55
Where can you find the option to insert a table?
Insert → table ## Footnote Then select the number of rows and columns you want.
56
What characterizes a complex table?
A complex table is one where the number of columns is different for each line. ## Footnote You would choose draw table instead of selecting the cells.
57
How can you convert a table back into text?
Using the convert to text option of the layout menu. ## Footnote This allows for flexibility in formatting.
58
What menu option is used to adjust columns on the page?
Layout → column. ## Footnote This allows for different text layouts.
59
What is the purpose of columns in document formatting?
Used to make text more organized so that other things can fit on. ## Footnote Tabs are typically adjusted with the ruler.
60
What is a drop cap?
A drop cap is used to draw the reader's attention; the first letter is bigger than all the other text. ## Footnote This feature is commonly used in magazines.

Information Technology Grade 10 (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions