Answer:
Top/bottom conditional formatting
Explanation:
The top/bottom conditional formatting automatically carries out the task of finding the highest, lowest and even average values.
Conditional formatting formatting gives one the opportunity to enhance reports and dashboards as they work on excel.
You use the too/bottom formatting to highlight cells whose values of highest in a dataset and lowest in a dataset
Most word-processing programs allow the user to select a command from the menu to insert a graphic. Clicks in the document where you want your file, choose insert and picture click from file select the image the press open and you picture will become inserted in to the document.
Answer:
The "a" Option is correct.
Explanation:
The "COUNTIF" function counts every cell that, given a condition (value), suits into it. As you want to know the number of cells that contain a value of at least 50, the condition must be properly written to get the correct answer. Unless it is a cell value (e.g. B3), the condition must always be written with quotes (""). So, the options b and c are automatically discarded.
The d option appears to be correct, but it's not. If the condition is written ">50", the function will count every cell with a value above 50. But we're searching values at least (including) 50. So the correct answer is the a option.
The elements in a string type array will be initialized to "Null".
Answer:
a)
Explanation:
Since the worksheet contains most of the data that you need, there is a decent possibility that it also contains the data that you are missing. Therefore, you should check for data you have previously hidden. Sometimes, some data in a worksheet may become irrelevant in a given moment, and instead of deleting it since it may be useful later most people tend to make that data hidden. So checking for previously hidden data may be the best solution in this scenario.
