Q 01. What will be the output of COUNTIFS(A1:A10,"<>red") if A1 to A10 contains different colour names? Ops: A. Cells containing red except first cell B. Cells not containing red C. Cells only containing red D. All cells Q 02. To find the number of alphabets in a sentence written in cell A1, which out of the following options is precise? Ops: A. TRIM(LEN(A1)) B. LEN(A1) C. LEN(A1)(TRIM(A1) D. LEN(TRIM(A1))
Question
Q 01. What will be the output of COUNTIFS(A1:A10,"<>red") if A1 to A10 contains different colour names? Ops: A. Cells containing red except first cell B. Cells not containing red C. Cells only containing red D. All cells
Q 02. To find the number of alphabets in a sentence written in cell A1, which out of the following options is precise? Ops: A. TRIM(LEN(A1)) B. LEN(A1) C. LEN(A1)(TRIM(A1) D. LEN(TRIM(A1))
Solution
Q 01. The correct answer is B. Cells not containing red. The COUNTIFS function in Excel counts the number of cells in a range that meet one or multiple criteria. In this case, the criteria is "<>red", which means it will count all cells that do not contain "red".
Q 02. The correct answer is D. LEN(TRIM(A1)). The LEN function in Excel returns the length of a text string (i.e., the number of characters in a text string). The TRIM function removes leading, trailing, and double spaces in a text string. So, LEN(TRIM(A1)) will return the number of characters in a text string after removing unnecessary spaces.
Similar Questions
To find the number of alphabets in a sentence written in cell A1, which out of the following options is precise? Ops: A. LEN(A1) B. LEN(TRIM(A1)) C. TRIM(LEN(A1)) D. LEN(A1)(TRIM(A1)
What does = COUNT() function do?Counts cells having alphabetsCounts empty cellsCounts cells having numberCounts non-empty cell
In cell D16, enter a formula using a counting function to count the number of blank cells in the Billable? Column (cells D2:D14).Font Size
Spelling of how many colours can be found hidden in the grid given below?TAGREYPRUPLEWHITEGASTOPBLUENote: The letters should occur in a straight sequence or all the letters of the word should occur together in the same order in which they are in the word.
Write a function called count_capitals that takes a string argument and returns the number of capital (upper case) letters in the string. The function should look very similar to the one you wrote for Exercise 1(a) in Lab 4.For this problem, you will need to determine if a letter is a capital. It will be helpful to know that in the unicode character encoding, the capital letters (of the English alphabet) are ordered sequentially; that is ord('A') + 1 == ord('B'), ord('A') + 2 == ord('C'), etc, up to ord('A') + 25 == ord('Z'). (Alternatively, have a look at the documentation of python's string methods; there are several that help you do things with letter case.)
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.