Welcome to your Microsoft Excel Class 3
1.
How can you navigate through a large dataset in Excel?
2.
Which Excel feature automatically extends a series or pattern of data?
3.
What Excel function allows you to combine text from two or more cells into one cell?
4.
Which Excel function evaluates a condition and returns one value if the condition is true and another value if the condition is false?
5.
What is the process of referring to a cell or a range of cells in Excel called?
6.
Which Excel feature arranges data in a specified order, such as alphabetically or numerically?
7.
How can you filter data in Excel to display only certain records that meet specific criteria?
8.
What Excel feature allows you to apply different formatting styles to cells based on specified conditions?
9.
Which of the following is NOT a type of chart available in Excel for data visualization?
10.
Which Excel function allows you to test multiple conditions and returns different results based on those conditions?
11.
What does the Autofill feature in Excel do?
12.
Which Excel function is used to extract a substring from a text string?
13.
What does the Wrap Text feature in Excel do?
14.
How can you quickly copy formatting from one cell to another in Excel?
15.
Which Excel feature allows you to merge multiple cells into one and centre-align the content?
16.
In Excel, what does the function =IF(A1>10, "Yes", "No") do if the value in cell A1 is 8?
17.
How can you freeze rows and columns in Excel to keep them visible while scrolling?
18.
Which Excel feature allows you to quickly identify and highlight specific data points within a range of values?
19.
Which Excel function returns the relative position of an item in a range that matches a specified value?
20.
What does the Filter feature in Excel do?
Leave a Reply