Microsoft Office User Specialistcertification

how to add small logo using slide master

Which of the following is an example of an application software? Select answer from the options below MacOS Android OS Microsoft Office Windows

Based on the values in Cell A51: A55, what formula can you copy and paste in to Cells B51: B55 to return the values shown? # 10.11.11 10.11.11 10.11.11 10.11.11 10.11.11 10.11.11 10.11.11 | | A | B | | --- | --- | --- | | 51 | Red | Yes | | 52 | Red | Yes | | 53 | Red | Yes | | 54 | Blue | No | | 55 | Red | Yes | 0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

"QUESTION 1/15 What does clicking the + sign below do? O Adds a new Function O Adds a new Column O Adds a new Row O Adds a new Worksheet O Adds a new Chart"

What value would be returned in Excel cell A49?

"Based on the values in Cells B77:B81, which function can automatically return the value in Cell C77? A. =Lowest B. =Min C. =Floor D. =Smallest E. =Bottom"

How do I calculate weight loss percentage in Excel?

"In cell C2 of an Excel worksheet, what formula should you enter to return ""yes"" if the value in cell E8 is greater than or equal to the value in cell B2, or ""no"" if it is not? A. =IF(E8>=B2, ""yes"", ""no"") B. =COMPARE(E8, B2, ""yes"", ""no"") C. =GREATEROR(E8, B2, ""yes"", ""no"") D. =CHECKVALUE(E8, B2, ""yes"", ""no"") "

What is represented by the small, black square in the lower-right corner of an active cell or range? A. Border B. Fill handle C. Copy handle D. None of the above

What is the purpose of the function labeled "Continue From Previous Section"? A. It links one section of a document to another section and ensures a Header or Footer is the same as the previous section. B. It links page number formatting from one section and ensures it is the same as the previous section. C. It links Section Breaks by creating "Continuous Section Breaks" which ensures page numbering is the same as the previous section. D. It continues the value of the page numbering from one section to another section without restarting the numbers.