DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select File (File) > Exit (Exit).
|
|
|
Click on the x on the command bar.
|
|
|
Go to the Control Menu Bar button, click Close (Close).
|
|
|
right on all counts
|
Detailed explanation-1: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
Detailed explanation-2: -The solution to countifs not working in this scenario is to open the closed workbook and then press F9 on the keyboard so that the formula recalculates the correct parameters.
Detailed explanation-3: -Select your data, right-click on it and choose “Format Cells…”. Now, under the Alignment tab, choose “Right (Indent)” for the Horizontal option and put in the indent number. This will normally be 1 or 2. And press “OK” and see the magic!