Please find the Excel function that performs these tasks.  Write the function and describe the inputs to the function. 1. What function in Excel returns the current time? 2. What function in Excel rounds up a fractional number? 3. What function in Excel rounds down a fractional number? 4. What function in Excel rounds a fractional number with above .5 rounded up? 5. What function in Excel returns the month of a date? 6. What function in Excel returns the day of the month? 7. What function in Excel returns the year of a date? 8. How does Vlookup work?  Please provide a small example. 9. What function generates a random number in Excel? 10. What log math functions does Excel support? 11.  Write a function using the if statement for the price of an item.  If less than 20 items are purchased, the price is $3.  If 21 to 99 items are purchased the price is 2.80 per item.  If over 100 items are purchased, the price is 2.70.  The discount applies to all items. 12.  What are the common formats for values in Cells?

1. The function in Excel that returns the current time is the NOW function. The NOW function does not require any inputs and simply returns the current date and time as a serial number.

2. The function in Excel that rounds up a fractional number is the ROUNDUP function. The input for the ROUNDUP function is a number or a reference to a cell containing a number. It also takes an optional argument for the number of decimal places to round up to. If this argument is omitted, the function rounds up to the nearest whole number.

3. The function in Excel that rounds down a fractional number is the ROUNDDOWN function. Similar to the ROUNDUP function, the ROUNDDOWN function takes a number or reference as input and an optional argument for the number of decimal places to round down to.

4. The function in Excel that rounds a fractional number with above .5 rounded up is the ROUND function. The ROUND function works by rounding a number to a specified number of decimal places. If the decimal portion of the number is greater than or equal to 0.5, it is rounded up.

5. The function in Excel that returns the month of a date is the MONTH function. The input for the MONTH function is a date or a reference to a cell containing a date. It then returns the numerical representation of the month (1 for January, 2 for February, and so on).

6. The function in Excel that returns the day of the month is the DAY function. Similar to the MONTH function, the DAY function takes a date or reference as input and returns the numerical representation of the day of the month.

7. The function in Excel that returns the year of a date is the YEAR function. The input for the YEAR function is a date or a reference to a cell containing a date. It then returns the numerical representation of the year.

8. VLOOKUP is a Excel function used to retrieve data from a specific column in a table. It searches for a value in the leftmost column of a table and returns the value in the same row from a specified column. The syntax for the VLOOKUP function is as follows: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). The lookup_value is the value to search for, table_array is the range of cells that contains the data, col_index_num is the column number from which to retrieve the value, and range_lookup is an optional argument that determines whether an exact match is required.

For example, consider the following data:

Item Code Price
A001 $3
A002 $2
A003 $4

To retrieve the price for item code A002, you would use the VLOOKUP function as follows: =VLOOKUP(“A002”, A1:B3, 2, FALSE). This will return a value of $2.

9. The function in Excel that generates a random number is the RAND function. It returns a random decimal number between 0 and 1. No input is required for the RAND function.

10. Excel supports several logarithmic math functions, including LOG, LOG10, and LN. The LOG function returns the logarithm of a number to a specified base. The LOG10 function specifically returns the logarithm of a number to the base 10. The LN function returns the natural logarithm of a number.

11.
=IF(number_of_items < 20,3,IF(number_of_items <= 99,2.8,2.7)) In this example, the IF statement is used to determine the price of an item based on the number of items purchased. If the number of items is less than 20, the price is set to $3. If the number of items is between 20 and 99 (inclusive), the price is set to $2.80 per item. If the number of items is greater than 100, the price is set to $2.70 per item. 12. The common formats for values in Excel cells are: - Number: Used for general numeric values. - Currency: Formats numbers as currency with the appropriate symbol, decimal places, and thousand separators. - Percentage: Formats numbers as percentages, multiplying the value by 100 and appending the "%" symbol. - Date: Formats dates according to the regional settings in Excel. - Time: Formats time values, including hours, minutes, and optionally seconds. - Text: Formats values as text and preserves leading zeros and spaces. These are just a few examples of the common formats available in Excel. Users can also create custom formats to meet specific needs.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer