Thủ Thuật về Which of the following is not one of the categories of functions offered by excel? 2022
Lê Minh Sơn đang tìm kiếm từ khóa Which of the following is not one of the categories of functions offered by excel? được Cập Nhật vào lúc : 2022-11-26 15:16:07 . Với phương châm chia sẻ Bí kíp Hướng dẫn trong nội dung bài viết một cách Chi Tiết Mới Nhất. Nếu sau khi Read tài liệu vẫn ko hiểu thì hoàn toàn có thể lại phản hồi ở cuối bài để Tác giả lý giải và hướng dẫn lại nha.To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math & Trigonometry categories. To create a pricing spreadsheet, you might use functions in the Database or Lookup & Reference categories. Because there are hundreds of functions to choose from, Excel groups functions into categories to make it easier to find the right function for a particular calculation. A category, however, is simply for convenience and does not determine how or when functions of different categories in Excel can be used together.
Nội dung chính Show- Compound ExpressionsMultiple Solutions [ 1 ] Paste Special (10 minutes to learn) [ 2 ] Add Multiple Rows (2 minutes to learn) [ 3 ] Flash Fill (30 minutes to learn) [ 4 ] INDEX/MATCH (45 minutes to learn) [ 5 ]
SUM (2 minutes to learn) [ 6 ] Ctrl+Z and Ctrl+Y (1 minute
to learn)
[ 7 ] Remove Duplicates (10 minutes to learn) [ 8 ] Freeze Panes (15 minutes to learn) [ 9 ] F4 (10 minutes to learn) [ 10 ] Ctrl+Arrows (5 minutes to learn) Which of the following is not one of the Excel functions?Which of the following is not a category of function?What are the 5 functions in Excel?What are the 10 functions in Excel?
Categories
Excel groups functions into 12 categories: Compatibility, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup & Reference, Math & Trigonometry, Statistical and Text. There is an additional category for user-defined functions installed with add-ins.
Data Types
Functions in all categories share a common set of data types such as number, text, date and Boolean. Each function accepts one or more parameters of a given type and returns a value of a given type. For example, the SUM function accepts two numbers and returns a number. Functions of different categories in Excel often return the same data type. For example, the DATEVALUE function in the Date & Time category also returns a numeric value, which is the serial representation of a character string.
Compound Expressions
You can create a compound expression using functions in different categories as long as the data types match. Match the data type of the output from one function to the input data type required by another function when you use them together. For example, combine functions from Math & Trigonometry with a function from the Logical category to avoid a possible "divide-by-zero" error in a calculation, as in the example below. The formula uses the IF function to test if the divisor is greater than zero before it performs the division; otherwise it returns zero. Both the logical test and the division use the SUM formula from the Math & Trigonometry category.
=IF(SUM(C1:C4)>0, SUM(A1:A4)/SUM(C1:C4), 0)
Multiple Solutions
There is often more than one way to arrive a calculated result using functions of different categories in Excel. For example, you can find the sign of a number using the SIGN function in the Math & Trigonometry category, as in:
=SIGN(A1).
You can calculate the same result with the IF function in the Logical category, using:
=IF(A1>0,"+1", IF(A1<0,"-1",0)).
The past 10 years have seen a wave of innovative big data software designed to analyze, manipulate, and visualize data. Yet for the regular knowledge worker, Microsoft Excel, 30 years on, remains the go-to product for people looking to make sense of data. Satya Nadella, Microsoft’s CEO, maintains that Excel is still the one Microsoft product that stands above the rest — and 750 million knowledge workers worldwide support that claim every day.
We’ve been teaching and testing Microsoft Excel for a decade, and a survey of several hundred office staff we ran suggests we spend more than 10% of our working lives spreadsheeting; for those working in research and development or finance, it’s more like 30%, or 2.5 hours a day.
Imagine, then, if this substantial proportion of the global workforce were a little better using the application. Time would be saved, and productivity would improve.
Last year we put together “The Definitive 100 Most Useful Excel Tips,” for which we consulted Excel experts and looked tens of thousands of test results and course usage data. Though every Excel feature has a use case, no single person uses every Excel feature. Cut through the 500+ functions, and you’re left with 100 or so truly useful functions and features for the majority of modern knowledge workers. We’ve selected 10 from that list that are especially easy to learn (approximately two hours total) and can make a material difference to productivity. These 10 are listed in decreasing order of utility from our top 100 list. If, like many, you’re stuck on what to learn next in Excel, you might want to look this 2×2 matrix, which factors in usefulness and time needed to learn a skill.
[ 1 ] Paste Special (10 minutes to learn)
Copy and paste is one of the simplest and most used functions in Excel. But we often carry over a format we don’t want, or we copy a formula over when instead we just want a value.
These little frustrations can take time to fix, which is why Paste Special is so…special. Paste Special enables you to pick which elements of the copied cell you bring over. After you’ve copied your cell (Ctrl+C), hit Ctrl+Alt+V (or go to the Clipboard section of the trang chủ ribbon, or Edit > Paste Special) to bring up Paste Special and make your selection. Alt+E+S+V is the shortcut to just paste values — probably the most common use of Paste Special.
[ 2 ] Add Multiple Rows (2 minutes to learn)
We often need to add new rows between existing rows. The shortcut (Ctrl+Shift++ [plus sign]) is pretty handy, especially as you can toggle the + to add multiple rows. Often, just highlighting the number of rows you want to add (say five) and using right click+insert is quicker when adding in bulk as it will add the number of rows you’ve highlighted.
[ 3 ] Flash Fill (30 minutes to learn)
Excel developed a mind of its own in 2013 with this feature. Flash Fill automatically fills your data when it senses a pattern.
Suppose you have a list of product numbers in the first 10 cells of column A, for example “ABC-00001” to “ABC-00010” and you only need the numbers after the “-”. You can easily discard the “ABC” using Flash Fill. Pre-2013 this was possible but relied on a combination of functions (FIND, LEFT, &, and so forth). Now, this is much faster and will impress people.
Establish the pattern by typing “00001” into the first blank cell. If Flash Fill is turned on (File Options, Advanced), just start to type the next product number in the cell below and Flash Fill will recognize the pattern and fill down the remaining product numbers for you. Just hit the Enter key to accept. Or get it going manually by clicking Data > Flash Fill, or Ctrl+E.
Flash Fill is like magic, and can be used in many different scenarios. It’s a fantastic time-saver when you need to input or change a lot of data quickly and accurately.
[ 4 ] INDEX/MATCH (45 minutes to learn)
Aside from VLOOKUP (which looks up the value in one column and returns a corresponding value from another column), INDEX and MATCH are the most widely used and most powerful tools in Excel for performing lookups. Used separately, these functions are invaluable, but when you combine them, their true power is unleashed. INDEX and MATCH used in combination helps you extract the data you need from a large data set efficiently and precisely. Mastering these functions will not only make you look like an Excel whiz to your colleagues and manager — it will also make tedious, mundane tasks quick and simple. Here’s how these functions work:
VLOOKUP is a great function, but it has its limitations. It can look up values only from left to right. The lookup value must be on the left in the lookup table. INDEX and MATCH allows you to look up a value anywhere in the lookup table regardless of its position.
Let’s say you have a spreadsheet with a list of products. You have columns titled “Product Number,” “Profit,” “Product Name,” and “Revenue.” On another spreadsheet, you have a list of the product names, and you want to look up how much profit each product has generated. In this scenario, we are using the product name (our lookup value) to look up the profit. The product name sits to the right of the profit, so VLOOKUP would not work. This is the perfect scenario for INDEX and MATCH.
The syntax would be:
=INDEX(Profit column),MATCH(Lookup Value,Product Name column),0
Here’s a good way to remember how it works:
=INDEX (column I want a return value from), MATCH (my lookup value, column I want to look up against), Enter “0” (Zero gives you an exact match; you can match against less than [-1] or greater than [1] as well.)
At first and even second glance, INDEX and MATCH looks complex. It certainly needs some practice, but it’s worth getting your head around as it is more flexible and more powerful than a VLOOKUP. It’s one of the most important uses of Excel, period.
[ 5 ] SUM (2 minutes to learn)
This is one of the first functions you’re likely to learn in Excel — how to sum a row or column. But did you know you can select the cell the end of a row or column and press Alt++ [plus sign] to do this function in seconds?
[ 6 ] Ctrl+Z and Ctrl+Y (1 minute to learn)
This is your Excel get-out-of-jail-không lấy phí card. If you aren’t using Ctrl+Z to undo mistakes in Excel, then you should be. What many people don’t know is that Ctrl+Y does the opposite — redo. The two work in tandem very nicely, and you can cycle through iterations of your work until you find the right one.
[ 7 ] Remove Duplicates (10 minutes to learn)
This is so simple and quick to use. Remove Duplicates does exactly what you’d expect — it removes the duplicates in any given range of data. Our advice is to remove the values you want to dedupe and place them in another sheet. It’s found on the Data tab in the Data Tools section of the ribbon.
If you just want to highlight duplicates, you can do this using Conditional Formatting. The shortcut to get you there is Alt+H+L (or find it on the trang chủ ribbon under Styles).
[ 8 ] Freeze Panes (15 minutes to learn)
Ever scroll down a large table of data only to forget which columns are which? Freeze Panes is the answer here. You can freeze just the top row, first column, or any number of either. Identify the columns and rows of the area you want to freeze. Then select the cell immediately to the right of those columns and beneath those rows. Go to the View tab and Freeze Panes in the Window section. Alt+W+F is the shortcut.
[ 9 ] F4 (10 minutes to learn)
There are two especially satisfying ways to use F4 in Excel. The first is when creating an Absolute Reference: F4 toggles you through the various options. The second is one that few people know about, but could seriously improve your Excel productivity. F4 repeats your last action, where available. For example, if you’ve just applied a border to one cell, use F4 to apply it to others.
[ 10 ] Ctrl+Arrows (5 minutes to learn)
If you’ve found yourself scrolling through a data set to reach the bottom of it, stop right now and start using Ctrl+the arrow keys! This simple shortcut takes you straight to the end of the data in a column or row you are using. Combine it with Ctrl+Shift to highlight/select large areas of data in seconds.
Warning: If you have gaps in your data this will just take you down to the first gap. So if you want to get to the bottom fast, choose a column of data that has no gaps.
Technology & Innovation
Digital transformation isn’t slowing down. Make sure your organization doesn’t either.
. . .
Harness just a few of these 10 items, and you can transform your typical workday. Whether you want to help justify data-driven business decisions a high level or simply get home to your family earlier, mastering the right Excel functions is a quick and easy way to maximize your productivity.
Which of the following is not one of the Excel functions?
Detailed Solution. The correct answer is "ALT".Which of the following is not a category of function?
The correct answer is Series.What are the 5 functions in Excel?
The most frequently used functions in Excel are:. AutoSum;. IF function;. LOOKUP function;. VLOOKUP function;. HLOOKUP function;. MATCH function;. CHOOSE function;. DATE function;.What are the 10 functions in Excel?
Read on below for a full overview of each function of MS Excel.. Table formatting. What it does: transforms your data into an interactive database. ... . Pivot tables. What it does: summarizes data and finds unique values. ... . Charting. ... . COUNTIFS. ... . SUMIFS. ... . IF Statements. ... . CONCATENATE. ... . VLOOKUP.. Tải thêm tài liệu liên quan đến nội dung bài viết Which of the following is not one of the categories of functions offered by excel?