USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A spreadsheet contains 50 rows with pet records. Column A is “Breed", column B is “Name", and column C is “Gender". To determine the number of animals that are female, what is the range when using the COUNTIF function?
|
A2:A50
|
|
A2:C50
|
|
B2:B50
|
|
C2:C50
|
Explanation:
Detailed explanation-1: -Spreadsheet data types include values (numbers), labels, formulas and functions.
Detailed explanation-2: -A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations. X locations, the columns, are normally represented by letters, “A, ” “B, ” “C, ” etc., while rows are normally represented by numbers, 1, 2, 3, etc.
Detailed explanation-3: -You need to use DCOUNT in Excel. One field to count F, one to count F. Or =COUNTIF(B85:AA85, "=F") counts the “F"s in row 85, between columns B and AA.
There is 1 question to complete.