Spreadsheet

Spreadsheet

By Danur Rahmajati

Import CSV file

To import CSV files in Excel you need to access data tab, while google spreadsheet use file menu and choose import

• SUM: Adds a range of cells.

• AVERAGE: Calculates the average of a range of cells.

• MIN: Finds the smallest value in a range.

• MAX: Finds the largest value in a range.

• COUNT: Counts the number of cells containing numbers.

• POWER: Raises a number to a power.

• ROUND: Rounds a number

Function List

Multiple Choice

How to type excel round function

• =ROUNDUP(value, digits)
• =ROUND(number, num_digits)
• =ROUND(value)
• =RND(number, num_digits)

•  Logical Functions:

  • IF: Returns one value if a condition is true and another value if it's false. 

  • AND: Returns TRUE if all arguments are TRUE. 

  • OR: Returns TRUE if any argument is TRUE. 

Function List

• VLOOKUP:

  Searches for a value in the first column of a table and returns a value in the same row from another column. 

• HLOOKUP:

  Searches for a value in the first row of a table and returns a value in the same column from another row. 

• XLOOKUP ?

Function List

Multiple Choice

When we use vlookup?

• When you want to sort data in ascending order.
• When you want to delete duplicate entries in a dataset.
• When you need to look up and retrieve data from a table based on a specific value.
• When you need to create a pivot table.