Welcome to your Microsoft Excel Class 2
1.
What is the keyboard shortcut to open the Format Cells dialog box in Excel?
2.
Which Excel function is used to find the largest value in a range?
3.
Which function is used to count the number of cells in a range that contain numbers?
4.
What does the IF function in Excel do?
5.
Which function is used to extract a specified number of characters from the start of a text string?
6.
What does the DATE function in Excel do?
7.
Which function is used to format a number as text with a specific format?
8.
What does the FIND function in Excel do?
9.
Which function is used to find one text string within another text string (case-insensitive)?
10.
What does the LEN function in Excel do?
11.
Which function is used to count the number of cells in a range that meet a specified condition?
12.
What symbol is used to represent a decimal point in Excel formulas?
13.
Which function always returns the logical value TRUE?
14.
What does the OR function in Excel do?
15.
Which function is used to convert text to lowercase?
16.
Which function is used to convert text to uppercase?
17.
What does the TRIM function in Excel do?
19.
Which function is used to capitalize the first letter of each word in a text string?
20.
What is the result of the following formula: =LOWER(PROPER("hello world"))?
Leave a Reply