Prod Tools

Question 1

What is a spreadsheet?

Answer 1

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

Question 2

examples of spreadsheet programs

Answer 2

apple numbers
zoho sheet
excel
google sheets

Question 3

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

Answer 3

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.

Question 4

What is a formula?

Answer 4

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

Question 5

What is a function?

Answer 5

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

Question 6

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

Answer 6

Values
Labels
Fucntions
formulas

Question 7

What are some uses of spreadsheets?

Answer 7

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

Question 8

What is the title bar?

Answer 8

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

Question 9

What are the ribbon tabs?

Answer 9

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

Question 10

What is the status?

Answer 10

displays helpful information as you use the program.

Question 11

What is the name bar?

Answer 11

Identifies the active cell

Question 12

What is the formula bar?

Answer 12

Displays the content of the active cell if any

Question 12

What is the fill handle?

Answer 12

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.

Question 13

What does the count function do?

Answer 13

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

Question 14

What does the Count A function do?

Answer 14

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

Question 15

What does the average function do?

Answer 15

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

Question 16

What does the Today function do?

Answer 16

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

Question 17

What is the relationship between absolute and relative cell address.

Answer 17

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

Question 18

What is absolute referencing?

Answer 18

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

Question 19

What is autofiltering?

Answer 19

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

Question 20

How do you know when autofiltering is used?

Answer 20

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

Question 21

Why is advanced filtering used?

Answer 21

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

Question 22

What are freeze panes?

Answer 22

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.

Question 23

Why are named ranges useful?

Answer 23

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.

Question 24

What is the IF function?

Answer 24

It allows you to make a choice depending on if your condition is met or not and returns on of two values.

Question 25

What is the count if function?

Answer 25

A function that will tally the contents in multiple cells when the criteria is met.

Question 26

What is a pivot table?

Answer 26

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.