Prod Tools Flashcards
What is a spreadsheet?
An electronic document in which data is arranged in row and colums of a grid and can be manipulated and used in calculations.
examples of spreadsheet programs
apple numbers
zoho sheet
excel
google sheets
Describe a situation where the use of a spreadsheet is appropriate.
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.
What is a formula?
A combination of cell adresses and mathematical operations to perform some calculations.
What is a function?
A combination of cell adresses and key words to perform some calculations.
What are the 4 things you can put in a spreadsheet cell?
Values
Labels
Fucntions
formulas
What are some uses of spreadsheets?
Statistics- finding the average or calculating deviation
Financial plans- budgeting
Stock keeping in a supermarket
loan calculations
What is the title bar?
Displays the name of the program and the current workbook if it has been saved.
What are the ribbon tabs?
at the top of the worksheet with keyboards that represent a group of closely related commands.
What is the status?
displays helpful information as you use the program.
What is the name bar?
Identifies the active cell
What is the formula bar?
Displays the content of the active cell if any
What is the fill handle?
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.
What does the count function do?
It counts the number of cells that contain numbers and counts number in a list of arguments.
What does the Count A function do?
It counts cells containing any type of information including error values and empty text.
What does the average function do?
It calculates the average of supplied numbers and can hold up to 255 individual arguments.
What does the Today function do?
returns the current date continuosly when the workbook is changed or updated.
What is the relationship between absolute and relative cell address.
When used in a formula the relative address will change while thr absolute will stay the same
What is absolute referencing?
A way to fix a cell or range of cells so that they dont change when you copy the formula to another cell.
What is autofiltering?
what you do to your data when you only want to see some information according to your criteria.
How do you know when autofiltering is used?
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
Why is advanced filtering used?
Advanced filtering is normally used when you have a large amount of data or you need a more complex filter.
What are freeze panes?
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.
Why are named ranges useful?
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.
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.
What is the count if function?
A function that will tally the contents in multiple cells when the criteria is met.
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.
What is word processing?
Using computers to create, edit and print documents consisting mostly of textual information.
Word processing encompasses a range of tasks involving text manipulation.
What is required to perform word processing?
A computer processor and a printer.
These components are essential for creating and printing documents.
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.
Word processors are software applications designed specifically for document creation and editing.
What is an advantage of word processors over typewriters?
You can make changes without retyping the entire document.
This feature allows for quick corrections and modifications.
How do word processors facilitate text manipulation?
They make it easy to move sections of text within the document or between documents.
This capability enhances document organization and editing efficiency.
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
Word processors are versatile tools used in various writing and publishing tasks.
What is a feature of word processing that allows users to remove text?
Delete text
This feature enables users to eliminate unwanted characters, words, or sections from a document.
What action allows users to revert to a previous version of their document?
Undo changes
This feature is crucial for correcting mistakes or reversing recent edits.
What is the purpose of subscript in word processing?
Type very small letters just below the line of text
Commonly used in mathematical formulas and chemical symbols.
What is the purpose of superscript in word processing?
Type very small letters just above the line of text
Often used for exponents and footnotes.
Fill in the blank: Word processors also have a ruler for showing and assisting in setting _______.
margins, tabs and indents
This feature helps in formatting the document layout.
What feature distributes text evenly between the margins?
Justify
This feature enhances the appearance of the text in a document.
Name an example of a word processor.
Microsoft Word
Other examples include Goodnotes, Google Docs, Notion, and WordStar.
What does the Italics feature do in word processing?
Italicize your text
Italics are often used for emphasis or titles of works.
What action allows users to rearrange text within a document?
Move text
This feature helps in reorganizing content for better flow.
What is the function of a word processor in text editing?
Type and correct text
This is the primary function of any word processing software.
What is the purpose of line and paragraph spacing?
To choose the amount of space between lines of texts and paragraphs.
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.
What can headers and footers be used for?
To show page numbers and document names.
How can you insert a header or footer in a document?
Insert → header I footer.
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.
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.
What are footnotes used for?
To add an additional point or state the source of your information.
Where are footnotes located in a document?
At the bottom or foot of the page that the information is on.
What is an endnote?
An endnote is placed at the end or tail of the document.
References are indicated with a superscript character next to the item being spoken about.
Where can you find the option to insert a table?
Insert → table
Then select the number of rows and columns you want.
What characterizes a complex table?
A complex table is one where the number of columns is different for each line.
You would choose draw table instead of selecting the cells.
How can you convert a table back into text?
Using the convert to text option of the layout menu.
This allows for flexibility in formatting.
What menu option is used to adjust columns on the page?
Layout → column.
This allows for different text layouts.
What is the purpose of columns in document formatting?
Used to make text more organized so that other things can fit on.
Tabs are typically adjusted with the ruler.
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.
This feature is commonly used in magazines.
