MS Excel Basics: Exam! Trivia

20 Questions | By Bunty.suman1991 | Last updated: Mar 20, 2022 | Total Attempts: 86

Questions

Settings

Create your own Quiz

Questions and Answers

1.

How many transactions take place in the month of January of all the three years combined?
- A.
  
  145
- B.
  
  150
- C.
  
  157
- D.
  
  161
2.

How many transactions take place for the product “eyeliner” in the year 2006?
- A.
  
  126
- B.
  
  128
- C.
  
  130
- D.
  
  132
3.

Which of the following has more no. of transactions for the east location in the year 2006?
- A.
  
  Ashley
- B.
  
  Betsy
- C.
  
  Cici
- D.
  
  Colleen
4.

If we use multilevel sorting by sorting the data first by no. of units (smallest to largest) and then by date (oldest to newest), what is the transaction no. of the first entry after sorting?
- A.
  
  582
- B.
  
  856
- C.
  
  1428
- D.
  
  1764
5.

After using multilevel sorting in the order- units (smallest to largest), product (A to Z), Date (Oldest to Newest), Location (A to Z), what is the transaction no. of the last entry?
- A.
  
  719
- B.
  
  1013
- C.
  
  1256
- D.
  
  1578
6.

What is the minimum income in the dataset?
- A.
  
  41
- B.
  
  30
- C.
  
  27
- D.
  
  29
7.

What is the difference in the average income of females between the age group of 30 to 50 in urban vs the same in semi-urban
- A.
  
  4.89
- B.
  
  5.02
- C.
  
  4.96
- D.
  
  4.73
8.

A total number of males who earn more than 100?
- A.
  
  203
- B.
  
  204
- C.
  
  199
- D.
  
  201
9.

Which of the following has maximum sales?
- A.
  
  Q4, 2009
- B.
  
  Q4, 2010
- C.
  
  Q3, 2011
- D.
  
  Q1, 2007
10.

Which Quarter has the maximum sales?
- A.
  
  Quarter 1
- B.
  
  Quarter 2
- C.
  
  Quarter 3
- D.
  
  Quarter 4
11.

What is the polynomial equation of the demand curve with respect to the Price of the Product (Hint -Demand - y-axis & Price - x-axis)?
- A.
  
  0.410x^2 - 23.42x + 763.24
- B.
  
  0.410x^2 - 18.44x + 890.33
- C.
  
  0.233x^2 - 15.54x + 778.15
- D.
  
  0.391x^2 - 16.25x + 763.24
12.

Plot a Line Graph of yearly sales. How does it look like?
- A.
- B.
- C.
- D.
  
  Option 4
13.

In which of the following cases, the price of the product is maximum?
- A.
  
  Q4, 2011
- B.
  
  Q3, 2008
- C.
  
  Q3, 2010
- D.
  
  Q1, 2011
14.

Make a Pie-Chart of the sales in each Quarter of the year 2007, 2008 and 2009. How does it look like?
- A.
- B.
- C.
- D.
15.

Promotion tends to increase the sales of which of the following products?
- A.
  
  Cookies
- B.
  
  Cakes
- C.
  
  Smoothies
- D.
  
  All of the Above
16.

You have an Excel workbook that contains many different formulas. You want to copy the values, but not the formulas into another tab. What functionality would you use to do this?
- A.
  
  Copy -- Paste
- B.
  
  Copy -- Paste Special --Values
- C.
  
  Copy -- Paste Special -- Formulas
- D.
  
  Copy -- Insert Copied Cells
17.

Which of the following functions would you use to display the name of the Product purchased with transaction number 99?
- A.
  
  HLOOKUP(“Product”,A2:G1893,4,FALSE)
- B.
  
  HLOOKUP(“Product”,$A$2: $D$1893,3,FALSE)
- C.
  
  VLOOKUP(99,A2:G1893,4,FALSE)
- D.
  
  VLOOKUP(99,$A$2: $D$1893,3,FALSE)
18.

Draw a bar graph of the average sales of smoothies each weekday. How does it look like?
- A.
  
  Option 1
- B.
  
  Option 2
- C.
  
  Option 3
- D.
  
  Option 4
19.

Which of the formula can’t be used to count rows that contain specific values?
- A.
  
  MMULT
- B.
  
  COLUMN
- C.
  
  TRANSPOSE
- D.
  
  CONCAT
20.

Which of the following items has the maximum percentage increase as a result of promotion on average?
- A.
  
  Coffee
- B.
  
  Smoothies
- C.
  
  Cakes
- D.
  
  Pies