excel ka assignment

Ablebits blog
Excel formulas

Basic Excel formulas & functions with examples

The tutorial provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials.

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. It enables you to total or average a column of numbers in the blink of an eye. Apart from that, you can compute a compound interest and weighted average, get the optimal budget for your advertising campaign, minimize the shipment costs or make the optimal work schedule for your employees. All this is done by entering formulas in cells.

This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel.

The basics of Excel formulas

Before providing the basic Excel formulas list, let's define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?

Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

For example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4)

Clicking the function's name will turn it into a blue hyperlink, which will open the Help topic for that function.

Tip. You don't necessarily have to type a function name in all caps, Microsoft Excel will automatically capitalize it once you finish typing the formula and press the Enter key to complete it.

10 Excel basic functions you should definitely know

What follows below is a list of 10 simple yet really helpful functions that are a necessary skill for everyone who wishes to turn from an Excel novice to an Excel professional.

The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition:

In the syntax of all Excel functions, an argument enclosed in [square brackets] is optional, other arguments are required. Meaning, your Sum formula should include at least 1 number, reference to a cell or a range of cells. For example:

=SUM(B2:B6) - adds up values in cells B2 through B6.

=SUM(B2, B6) - adds up values in cells B2 and B6.

If necessary, you can perform other calculations within a single formula, for example, add up values in cells B2 through B6, and then divide the sum by 5:

=SUM(B2:B6)/5

To sum with conditions, use the SUMIF function: in the 1st argument, you enter the range of cells to be tested against the criteria (A2:A6), in the 2nd argument - the criteria itself (D2), and in the last argument - the cells to sum (B2:B6):

=SUMIF(A2:A6, D2, B2:B6)

Useful resources:

Excel Sum formula examples - formulas to total a column, rows, only filtered (visible) cells, or sum across sheets.
Excel AutoSum - the fastest way to sum a column or row of numbers.
SUMIF in Excel - formula examples to conditionally sum cells.
SUMIFS in Excel - formula examples to sum cells based on multiple criteria.

The Excel AVERAGE function does exactly what its name suggests, i.e. finds an average, or arithmetic mean, of numbers. Its syntax is similar to SUM's:

Having a closer look at the formula from the previous section ( =SUM(B2:B6)/5 ), what does it actually do? Sums values in cells B2 through B6, and then divides the result by 5. And what do you call adding up a group of numbers and then dividing the sum by the count of those numbers? Yep, an average!

The Excel AVERAGE function performs these calculations behind the scenes. So, instead of dividing sum by count, you can simply put this formula in a cell:

=AVERAGE(B2:B6)

To average cells based on condition, use the following AVERAGEIF formula, where A2:A6 is the criteria range, D3 is he criteria, and B2:B6 are the cells to average:

Excel AVERAGE - average cells with numbers.
Excel AVERAGEA - find an average of cells with any data (numbers, Boolean and text values).
Excel AVERAGEIF - average cells based on one criterion.
Excel AVERAGEIFS - average cells based on multiple criteria.
How to calculate weighted average in Excel
How to find moving average in Excel

MAX & MIN

The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as:

=MAX(B2:B6)

MAX function - find the highest value.
MAX IF formula - get the highest number with conditions.
MAXIFS function - get the largest value based on multiple criteria.
MIN function - return the smallest value in a data set.
MINIFS function - find the smallest number based on one or several conditions.

COUNT & COUNTA

If you are curious to know how many cells in a given range contain numeric values (numbers or dates), don't waste your time counting them by hand. The Excel COUNT function will bring you the count in a heartbeat:

While the COUNT function deals only with those cells that contain numbers, the COUNTA function counts all cells that are not blank , whether they contain numbers, dates, times, text, logical values of TRUE and FALSE, errors or empty text strings (""):

For example, to find out how many cells in column B contain numbers, use this formula:

=COUNT(B:B)

To count all non-empty cells in column B, go with this one:

=COUNTA(B:B)

In both formulas, you use the so-called "whole column reference" (B:B) that refers to all the cells within column B.

Excel COUNT function - a quick way to count cells with numbers.
Excel COUNTA function - count cells with any values (non-empty cells).
Excel COUNTIF function - count cells that meet one condition.
Excel COUNTIFS function - count cells with several criteria.

Judging by the number of IF-related comments on our blog, it's the most popular function in Excel. In simple terms, you use an IF formula to ask Excel to test a certain condition and return one value or perform one calculation if the condition is met, and another value or calculation if the condition is not met:

For example, the following IF statement checks if the order is completed (i.e. there is a value in column C) or not. To test if a cell is not blank, you use the "not equal to" operator ( <>) in combination with an empty string (""). As the result, if cell C2 is not empty, the formula returns "Yes", otherwise "No":

IF function in Excel with formula examples
How to use nested IFs in Excel
IF formulas with multiple AND/OR conditions

If your obviously correct Excel formulas return just a bunch of errors, one of the first things to check is extra spaces in the referenced cells (You may be surprised to know how many leading, trailing and in-between spaces lurk unnoticed in your sheets just until something goes wrong!).

There are several ways to remove unwanted spaces in Excel, with the TRIM function being the easiest one:

For example, to trim extra spaces in column A, enter the following formula in cell A1, and then copy it down the column:

Excel TRIM function with formula examples
How to delete line breaks and non-printing characters
How to remove non-breaking spaces ( )
How to delete a specific non-printing character

Whenever you want to know the number of characters in a certain cell, LEN is the function to use:

Wish to find out how many characters are in cell A2? Just type the below formula into another cell:

Want to get the total count of characters in a range or cells or count only specific characters? Please check out the following resources.

Excel LEN formulas to count characters in a cell
Count the number of characters in cells and ranges

AND & OR

These are the two most popular logical functions to check multiple criteria. The difference is how they do this:

AND returns TRUE if all conditions are met, FALSE otherwise.
OR returns TRUE if any condition is met, FALSE otherwise.

While rarely used on their own, these functions come in very handy as part of bigger formulas.

For example, to check the test results in columns B and C and return "Pass" if both are greater than 60, "Fail" otherwise, use the following IF formula with an embedded AND statement:

=IF(AND(B2>60, B2>60), "Pass", "Fail")

If it's sufficient to have just one test score greater than 60 (either test 1 or test 2), embed the OR statement:

IF formulas with embedded AND/OR statements

Excel AND function with formula examples
Excel OR function with formula examples

CONCATENATE

In case you want to take values from two or more cells and combine them into one cell, use the concatenate operator (&) or the CONCATENATE function:

For example, to combine the values from cells A2 and B2, just enter the following formula in a different cell:

=CONCATENATE(A2, B2)

To separate the combined values with a space, type the space character (" ") in the arguments list:

How to concatenate in Excel - formula examples to combine text strings, cells and columns.
CONCAT function - newer and improved function to combine the contents of multiple cells into one cell.

TODAY & NOW

To see the current date and time whenever you open your worksheet without having to manually update it on a daily basis, use either:

=TODAY() to insert the today's date in a cell.

=NOW() to insert the current date and time in a cell.

How to insert today's date in Excel - different ways to enter the current date in Excel: as an unchangeable time stamp or automatically updatable date and time.
Excel date functions with formula examples - formulas to convert date to text and vice versa, extract a day, month or year from a date, calculate the difference between two dates, and a lot more.

Best practices for writing Excel formulas

Now that you are familiar with the basic Excel formulas, these tips will give you some guidance on how to use them most effectively and avoid common formula errors.

Do not enclose numbers in double quotes

Any text included in your Excel formulas should be enclosed in "quotation marks". However, you should never do that to numbers, unless you want Excel to treat them as text values.

For example, to check the value in cell B2 and return 1 for "Passed", 0 otherwise, you put the following formula, say, in C2:

=IF(B2="pass", 1, 0)

Copy the formula down to other cells and you will have a column of 1's and 0's that can be calculated without a hitch.

Now, see what happens if you double quote the numbers:

=IF(B2="pass", "1", "0")

Enclose text values in double quotes, but not numbers

Don't format numbers in Excel formulas

Match all opening and closing parentheses, copy the same formula to other cells instead of re-typing it.

Note. After copying the formula, make sure that all cell references are correct. Cell references may change depending on whether they are absolute (do not change) or relative (change).

How to delete formula, but keep calculated value

When you remove a formula by pressing the Delete key, a calculated value is also deleted. However, you can delete only the formula and keep the resulting value in the cell. Here's how:

Select all cells with your formulas.
Press Ctrl + C to copy the selected cells.
Right-click the selection, and then click Paste Values > Values to paste the calculated values back to the selected cells. Or, press the Paste Special shortcut: Shift+F10 and then V .

Make sure Calculation Options are set to Automatic

If all of a sudden your Excel formulas have stopped recalculating automatically, most likely the Calculation Options somehow switched to Manual . To fix this, go to the Formulas tab > Calculation group, click the Calculation Options button, and select Automatic .

This is how you make and manage basic formulas in Excel. I how you will find this information helpful. Anyway, I thank you for reading and hope to see you on our blog next week.

412 comments

Thank you for this sharing

A VERY BIG THANKS .

I need the Excel formula number combination

One hundred and ten units (HTF) : 345,345,678,890,567

Summary of analysis results from 5 data If there is no incorrect information 036-037-046-047-056-057-058-158-258-358 368-369-378-379-458-468-469-478-479-558 568-569-578-579-588-589 (26 sets / total 26 sets)

Sorry, I have no idea exactly what the task is. It's hard to tell exactly what you're asking for as it's currently written.

For me personally It's clear that actually "seeing" something written down is easier to understand and remember than "hearing" it, but both together is even better.

Mastering Formulas In Excel: What Is Ka Formula

Introduction.

Mastering formulas in Excel is crucial for anyone looking to efficiently analyze and manipulate data. One key formula that is often used in Excel is the ka formula . In this blog post, we'll provide a brief overview of this formula and explore its significance in Excel.

Key Takeaways

Mastering formulas in Excel is crucial for efficient data analysis and manipulation.
Understanding the basics of Excel formulas, such as SUM, AVERAGE, and MAX, is important for building a foundation.
The "ka" formula in Excel has significant functions and can be used in various scenarios.
Practicing and utilizing online resources are essential for mastering the "ka" formula.
Avoiding common mistakes and exploring advanced applications of the "ka" formula can further enhance Excel skills.

Understanding the basics of Excel formulas

When it comes to mastering formulas in Excel, it's essential to start with the basics. Understanding the fundamental concepts of Excel formulas is crucial for utilizing its full potential. Let's delve into the definition of a formula in Excel and explore some examples of basic formulas.

An Excel formula is a mathematical expression that is used to perform calculations on values in a spreadsheet. It begins with an equal sign (=) and can consist of numbers, cell references, arithmetic operators, and functions. Formulas are the backbone of data analysis and manipulation in Excel, allowing users to automate calculations and streamline processes.

Some of the most commonly used basic formulas in Excel include:

SUM: This formula is used to add up a range of cells. For example, =SUM(A1:A5) would add the values in cells A1 through A5.
AVERAGE: The AVERAGE formula calculates the average of a range of cells. For instance, =AVERAGE(B1:B10) would find the average of the values in cells B1 through B10.
MAX: The MAX formula returns the largest value in a range of cells. For example, =MAX(C1:C8) would identify the maximum value in cells C1 through C8.

Understanding the basics of Excel formulas is the first step towards mastering the powerful tools available in this software. By familiarizing yourself with the definition of a formula and exploring examples of basic formulas, you can lay a strong foundation for more advanced formula usage in Excel.

Exploring the "ka" formula in Excel

When it comes to mastering formulas in Excel, the "ka" formula is a valuable tool that can be used to perform various calculations. In this chapter, we will delve into the explanation of the "ka" formula and explore its function. Additionally, we will provide examples of how the "ka" formula can be used in different scenarios to enhance your understanding of its practical applications.

The "ka" formula in Excel is used to calculate a specific value based on given criteria. It is often used in conjunction with other functions and logical operators to perform complex calculations. The "ka" formula can help users automate repetitive tasks and streamline data analysis processes.

1. Syntax of the "ka" formula

The basic syntax of the "ka" formula is =KA(value, criteria_range, [criteria]) , where:

value represents the value to be returned based on the specified criteria.
criteria_range refers to the range of cells that contain the criteria for the calculation.
criteria is an optional argument that allows users to specify additional conditions for the calculation.

Now that we have an understanding of the "ka" formula and its function, let's explore some practical examples of how it can be utilized in Excel.

1. Calculating sales commission based on performance

In a sales organization, the "ka" formula can be used to determine the commission amount earned by each sales representative based on their performance and sales targets. By setting specific criteria for sales thresholds and commission rates, the "ka" formula can automatically calculate the commission for each salesperson, saving time and reducing errors in manual calculations.

2. Analyzing student performance in a classroom

For educators, the "ka" formula can be a powerful tool for analyzing student performance and identifying trends. By applying criteria based on test scores, attendance, and participation, the "ka" formula can help teachers generate reports and insights into the academic progress of their students.

Utilizing the "ka" formula in Excel can significantly improve efficiency and accuracy in data analysis and decision-making processes. By understanding its function and practical applications, users can leverage the power of this formula to enhance their productivity and streamline their workflows.

Tips for mastering the "ka" formula

When it comes to mastering formulas in Excel, the "ka" formula can be a powerful tool for data analysis and manipulation. Here are some tips for mastering this formula:

Understand the syntax: Before diving into using the "ka" formula, it's important to understand its syntax and how it functions. Take the time to familiarize yourself with the structure of the formula.
Work on sample datasets: To gain proficiency in using the "ka" formula, practice on sample datasets. Experiment with different data sets and scenarios to get a better grasp of how the formula works.
Challenge yourself: Push your skills by working on complex datasets that require the use of the "ka" formula. This will help you develop a deeper understanding of its capabilities.
Online tutorials: There are numerous online tutorials and resources available that can provide in-depth explanations and examples of how to use the "ka" formula effectively. Take advantage of these resources to enhance your skills.
Excel forums and communities: Joining Excel forums and communities can be beneficial for seeking advice and tips from experienced Excel users. Engaging with the community can provide valuable insights into using the "ka" formula.
Video tutorials: Visual aids can be extremely helpful when learning complex formulas. Watch video tutorials that demonstrate the application of the "ka" formula in real-world scenarios to gain a better understanding of its practical use.

Common Mistakes to Avoid When Using the "ka" Formula

When working with formulas in Excel, it's important to be mindful of potential mistakes that can affect the accuracy of your calculations. The "ka" formula is a commonly used function in Excel, and there are a few common mistakes that users should be aware of in order to ensure its proper usage.

One common mistake when using the "ka" formula is not understanding the order of operations within the formula. It's important to remember that Excel follows the standard mathematical order of operations, which means that certain operations are performed before others. Failing to understand this can lead to miscalculations and incorrect results.

Another common mistake when using the "ka" formula is forgetting to use the correct cell references. When inputting the formula, it's essential to ensure that the cell references are accurate and point to the correct cells containing the data you want to calculate. Using incorrect cell references can result in errors in the output of the formula.

Advanced applications of the "ka" formula

When it comes to mastering formulas in Excel, the "ka" formula is a powerful tool that can be used in a variety of advanced applications. In this chapter, we will explore the nested "ka" formulas and demonstrate how the "ka" formula can be combined with other functions to further enhance its capabilities.

Discussing nested "ka" formulas

Nested "ka" formulas involve using multiple "ka" formulas within each other to perform complex calculations. This technique allows you to break down a larger problem into smaller, more manageable parts, and then combine the results to achieve the desired outcome.

Example: If you want to calculate the sales tax on a product, which is based on both the product cost and the tax rate, you can use a nested "ka" formula to first calculate the product cost including any additional fees, and then apply the tax rate to arrive at the final amount.
Benefits: Nesting "ka" formulas can help you create more dynamic and flexible calculations, and allows for a more structured and organized approach to complex problems.

Demonstrating how the "ka" formula can be combined with other functions

The "ka" formula can be combined with other functions in Excel to further expand its functionality and create more sophisticated calculations.

Combining with IF function: You can use the "ka" formula in combination with the IF function to perform conditional calculations based on certain criteria.
Combining with SUM function: By integrating the "ka" formula with the SUM function, you can create more advanced and comprehensive calculations that involve adding up multiple values.
Combining with VLOOKUP function: Utilizing the "ka" formula with the VLOOKUP function allows you to perform more complex lookups and retrieve specific information from a dataset.

By mastering the art of combining the "ka" formula with other functions, you can unlock its full potential and use it to solve a wide range of business and financial problems with greater precision and efficiency.

Mastering Excel formulas is essential for anyone who wants to become proficient in using this powerful software. By understanding and utilizing formulas effectively, you can save time, improve accuracy, and increase productivity in your work. As you continue to learn and practice with Excel formulas, you will become more adept at manipulating data and performing complex calculations, giving you a competitive edge in the workplace.

So, keep exploring the world of Excel formulas and never stop learning. The more you familiarize yourself with the various formulas and their functions, the more efficient and skilled you will become at Excel. Your dedication and effort will surely pay off as you become a master of Excel formulas.

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

Mastering Excel Dashboards for Data Analysts

The Benefits of Excel Dashboards for Data Analysts

Exploring the Power of Real-Time Data Visualization with Excel Dashboards

Unlock the Power of Real-Time Data Visualization with Excel Dashboards

How to Connect Your Excel Dashboard to Other Platforms for More Focused Insights

Unlocking the Potential of Excel's Data Dashboard

10 Keys to Designing a Dashboard with Maximum Impact in Excel

Unleashing the Benefits of a Dashboard with Maximum Impact in Excel

Essential Features for Data Exploration in Excel Dashboards

Exploring Data Easily and Securely: Essential Features for Excel Dashboards

Unlock the Benefits of Real-Time Dashboard Updates in Excel

Interpreting Excel Dashboards: From Data to Action

Unleashing the Power of Excel Dashboards

Different Approaches to Excel Dashboard Design and Development

Understanding the Benefits and Challenges of Excel Dashboard Design and Development

Best Excel Dashboard Tips for Smarter Data Visualization

Leverage Your Data with Excel Dashboards

How to Create Effective Dashboards in Microsoft Excel

Crafting the Perfect Dashboard for Excel

Dashboards in Excel: Managing Data Analysis and Visualization

An Introduction to Excel Dashboards

Best Practices for Designing an Insightful Excel Dashboard

How to Create an Effective Excel Dashboard

Choosing a selection results in a full page refresh.

50 Advanced Excel Exam Questions and Answers

In this article, you will find advanced Excel questions and answers to test your skills. You should know the following:

introduction to Excel VBA ,
enable the Developer tab ,
the basics of an Excel spreadsheet ,
use of the PivotTable ,
application of Data Validation ,
use of the Slicers ,
utilization of the PivotTable Timeline feature,
use of the Excel Filter feature,
use of the Excel Chart options,
utilization of the Trendline feature,
the Name Range ,
custom format cells ,
understanding of the Sparkline ,
application of cell border ,
AGGREGATE , AVERAGE , FIND , IFERROR , SUM , SUMIFS , VLOOKUP , LOOKUP, and HLOOKUP functions.

You should use at least Excel 2019 to solve the problems without any issues.

Here is the overview of the top 50 advanced Excel exam questions and answers.

Download the Question Workbook

Advanced MCQs for Exam.xlsx

Problem Overview

The Excel file contains fifty advanced Excel exam questions and their corresponding answers.

The questions are provided in the “Problem” sheet.
The answers are highlighted in the “Solution” sheet.
Provide your answer (by typing or selecting from the dropdown list) in the “I” column.
If it is correct, you will get a green checkmark in the “J” column.

Let’s go through the Excel multiple-choice questions. You can provide your answers either by typing or using the dropdown list in the Excel file containing the advanced exam questions and answers.

(a) Ctrl + F11
(b) Alt + F11
(c) Shift + F11
(d) Shift + Alt + F11
(a) Standard pivot table
(b) Pivot chart
(c) Timeline pivot table
(d) Slicer pivot table
(a) AutoFilter
(b) Advanced Filter
(d) Data validation
(a) OLE DB connection
(b) ODBC connection
(c) HTTPS connection
(d) Text file connection
(a) Absolute reference
(b) Unique reference
(c) Relative reference
(d) External reference
(a) Line chart
(b) Column chart
(c) Pie chart
(d) Open Matrix chart
(a) Right-click the chart and select “Add Trendline”
(b) Click the “Chart Tools” tab and click the “Trendline” button
(c) Click the “Insert” tab and click the “Trendline” button
(d) Click the “Data” tab and click the “Trendline” button
(a) Click the “Data” tab and click the “Filter” button
(b) Click the “Home” tab and click the “Filter” button
(c) Right-click the table and select “Filter”
(d) Press Ctrl + Shift + L
(a) Ctrl + M
(b) Ctrl + Shift + M
(c) Ctrl + C
(d) Alt + H + M + C
(a) =VLOOKUP(value, table, column)
(b) =HLOOKUP(value, table, row)
(c) =LOOKUP(value, table)
(d) =FIND(value, table)
(a) A set of instructions that can be used multiple times in a program
(b) A loop that continues until a condition is met
(c) A conditional statement
(d) None of the above
(a) =AVG(range)
(b) =MEAN(range)
(c) =SUM(range)/COUNT(range)
(d) =AVERAGE(range)
(a) Right-click on the cell and select “Insert Comment”
(b) Go to the “Review” tab and select “New Comment”
(c) Both A and B
(a) It returns a value if a cell contains an error
(b) It hides errors in a cell
(c) It replaces errors in a cell with a specified value
(d) It displays a custom error message in a cell
(a) It searches for a value in the leftmost column of a table and returns a value from the same row in a specified column
(b) It searches for a value in a specified column of a table and returns a value from the same row in the leftmost column
(c) It searches for a value in a specified row of a table and returns a value from the same column in the topmost row
(d) It searches for a value in the topmost row of a table and returns a value from the same column in a specified row
(a) Ctrl + Shift + +
(b) Ctrl + Shift + –
(c) Ctrl + +
(d) Ctrl + –
(a) Select the cells and go to Insert > Name > Define
(b) Select the cells and go to Formulas > Name > Define
(c) Select the cells and go to Data > Name > Define
(d) Select the cells and go to Home > Name > Define
(a) Whole number
(a) Import data from a text file
(b) Import data from a database
(c) Import data from a web page
(d) Import data from a scanner
(a) Right-click the cell and select “Insert Hyperlink”
(b) Click the “Insert” tab and click the “Hyperlink” button
(c) Press Ctrl + K
(d) Press Ctrl + Shift + K
(a) Go to the Insert tab and click on the Subroutine button
(b) Go to the Developer tab and click on the Subroutine button
(c) Right-click on the VBA editor and select Insert > Subroutine
(a) Use the Remove Duplicates button on the Data tab
(b) Use the Unique function
(c) Use the Dedupe function
(d) Use the Remove Duplicates function
(c) A piece of data that can be manipulated in a program
(d) A physical or abstract entity that represents something in the real world
(a) Click the “Formulas” tab and click the “Function Library” button
(b) Press F3
(c) Press Shift + F3
(d) Press Ctrl + Shift + F3
(a) Logical formula
(b) Text formula
(c) Array formula
(d) Graph formula
(a) Data > Pivot Table
(b) Insert > Pivot Table
(c) Home > Pivot Table
(d) Formulas > Pivot Table
(a) A characteristic of an object
(b) A method of an object
(c) An event of an object
(d) All of the above
(b) Bar chart
(d) Word cloud
(a) Use the Data Validation feature
(b) Use the List feature
(c) Use the Drop-Down List feature
(d) Use the Combo Box feature
(a) Right-click on the cell and select “Insert Hyperlink”
(b) Insert > Hyperlink
(c) Data > Hyperlink
(d) Formulas > Hyperlink
(a) Password protection
(b) Data validation
(c) Data filters
(d) Conditional formatting
(a) View > Freeze Panes
(b) Page Layout > Freeze Panes
(c) Formulas > Freeze Panes
(d) Data > Freeze Panes
(b) An action that can be performed on an object
(a) F5:F24 contains text values
(b) F5:F24 contains a mix of text and numeric values
(c) F5:F24 contains only numeric values
(d) F5:F24 is an empty range
(a) Dim variableName As dataType
(b) Var variableName As dataType
(c) Variable variableName As dataType
(d) Set variableName As dataType
(a) A range of cells that has a specific name
(b) A range of cells that has a specific formula
(c) A range of cells that has a specific data validation rule
(c) A trigger that causes a certain action to occur
(a) Click the first cell in the range, then hold down the Shift key and click the last cell in the range
(b) Click the first cell in the range, then hold down the Alt key and click the last cell in the range
(c) Click the first cell in the range, then hold down the Ctrl key and click the last cell in the range
(d) Click the first cell in the range, then hold down the Tab key and click the last cell in the range
(a) Alt + I
(b) Alt + R
(c) Ctrl + N
(d) Ctrl + Shift + N
(a) Select the cell, then click the Custom Format button on the toolbar
(b) Select the cell, then click the Format Cells button on the toolbar
(c) Select the cell, then click the Number Format command in the Format menu
(d) Select the cell, then click the Number command in the Format menu
(a) Press F11
(b) Go to the Insert tab and click on the VBA button
(c) Go to the Developer tab and click on the Visual Basic button
(a) Creating formulas
(b) Sorting and filtering data
(c) Analyzing and summarizing large amounts of data
(b) Automating tasks
(c) Creating charts
(a) It sums the values in a specified range that meet multiple criteria
(b) It calculates the average of the values in a specified range that meets multiple criteria
(c) It counts the number of cells in a specified range that meet multiple criteria
(d) It returns the maximum value in a specified range that meets multiple criteria
(a) Insert > Sparkline
(b) Data > Sparkline
(c) Formulas > Sparkline
(d) Sparklines are not available in Excel
(a) Pick out the desired cell, then click the Border button on the toolbar
(b) After choosing the cell, select Add Border from the Format menu
(c) Choose the cell and then, from the Format menu, select the Cell Borders command
(d) Pick the cell and then select the Borders option from the Format menu

Here’s an overview of how to input the answer in the “Problem” sheet.

What is ExcelDemy?

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio