1.
What function is used to look up a value in a table and return a corresponding value?
2.
Which Excel feature allows you to summarize large sets of data by creating calculated fields?
3.
What is the purpose of the CONCATENATE function in Excel?
4.
Which Excel function is used to count the number of cells within a range that meet a specific condition?
5.
In Excel, what function would you use to calculate the future value of an investment based on a constant interest rate?
6.
Which keyboard shortcut is used to create a new worksheet in Excel?
7.
What does the Excel function IFERROR do?
8.
Which Excel feature is used to automate a series of repetitive tasks by recording and running macros?
9.
What is the purpose of the Excel function HLOOKUP?
10.
In Excel, what does the term "data validation" refer to?
11.
Which Excel function would you use to round a number to the nearest integer?
12.
What is the purpose of the Excel function INDEX-MATCH combination?
13.
Which Excel feature allows you to filter data based on specified criteria and display only the relevant information?
14.
In Excel, what is the purpose of the TRANSPOSE function?
15.
Which Excel function calculates the net present value of an investment based on a series of cash flows?
16.
What does the Excel function PMT do?
17.
In Excel, what is the purpose of the SUBTOTAL function?
18.
Which Excel feature allows you to create visual representations of your data, such as charts and graphs?
19.
What is the purpose of the Excel function TEXT?
20.
In Excel, what function can be used to count the number of cells in a range that meet multiple conditions?
Leave a Reply