Recap Spreadsheet EP1

What is a spreadsheet?

• A document filled with row and column in which you can safely store data

• A special type of word document that is used to calculate and print values

• A specific document used to store, modify, update and calculate a data.

• A table consisting of cells that hold accounting or financial data and simulates the tradition spreadsheet

Which of the following is not a formatting type in spreadsheet?

• Accounting

• Font

• Currency

• Date and time

• Percentage

I am used to tell the location of a specifc cell in a spreadsheet. What am I?

• Cell Name

• Cell range

• Cell location

• Cell address

i have a name, an equal sign and also I use cell ranges. What am I?

• Functions

• Cell ranges

• Cell function

• Cell places

Select all functions from the lost below.

SELECT ALL THAT APPLY

• SUM

• IF

• PRODUCT

• MATHS

• DATE

The max function is used to ...

The VLOOKUP Function is used for

• Finding a value and using any values that is from that row (running horizontal)

• horizontally finding a value and using an vertical value that matches that column

• Used to sums all values listed

• None of the above

If you are wishing to insert a row or column. it is important to bear that rows are added to the ___________ of the spreadsheet.

• Left

• Right

• No specific direction

_____________________ is used to anchor a cell address that will be used as a range or that should be continuously used.

• Relative Addressing

• Absolute Addressing

• Anchoring Range

• None of the above

If a function/formula is copied without ____________, this will produce zero or incorrect values. This type of addressing is known as _______________

• Relative cell addressing , absolute cell addressing

• Absolute cell addressing , relative cell addressing

• Cell ranges, relative cell addressing

• None of the above