Table Analysis MCQ

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

Which of the following functions would you use, if you wished to quickly create smaller lists out of a much larger list on an Excel worksheet?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

If you knew a company had a fax number but didn't have it on hand, what type of value would you use as a placeholder in that table column?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

What is the difference between number of boys in College A and number of female students in College B?

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

Question:

What is the ratio between numbers of girls passed from School A in year 2007 and number of boys passed from School C in year 2006?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

The number of girls in Telecom stream of College D is what percent of its total students in telecom stream in college D?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

What factors should you keep in mind when you translate entities from your ER diagram into relational notation?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

While using a pivot table in Excel, when you drop information into the "Values" area in the lower-right corner, the default summarization is by summation. Which of the following tools will you use to change the default summarization?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

While using a pivot table in Excel, you drop the fields of information that you want in the interior of the pivot table in which of the following areas?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

The Custom Filter box allows the entry of how many criteria for creating a filtered list?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

 Question:

Which of the following Excel tools works backward from an objective to compute an unknown value?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

What is the ratio of number of boys of IT stream of College C to that of College D?

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

Question:

Which of the following Excel tools would you use, if you wish to highlight, not hide, some information in a worksheet, because it meets some criteria you specify?

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

Question:

In year 2010 number of boys passed from School D is what percentage of total passed students in that year from college D?

Following table shows the total number of students and percentage of boys among them of different branches of five engineering colleges. Answer the following question based on this table.

Question:

Number of boys of Civil stream of College A is how much percentage more than that of the number of girls in Electronics stream of College C?

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

Question:

What is the sum of total students passed from School A and School C during these five years?

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

Question:

Which of the following Excel tools enables you to group and summarize information?

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

 Question:

In set theory, a table is referred to as a

Following table shows the total number of students passed and ratio of boys and girls among them of four different schools A, B, C and D during year 2006-2010.

Question:

What is the approximate average number of girls on college A?