Microsoft Excel Quiz Questions 9

Are you ready to test your knowledge of Microsoft Excel Quiz Questions and master essential text functions? This post features 20 multiple-choice Microsoft Excel Quiz Questions and Answers designed to help you sharpen your skills in handling text data, reference, range, conditional formatting, and dashboards in Excel. Whether you are a beginner or looking to refresh your knowledge, this quiz covers the basics of MS Excel text functions like UPPER(), LOWER(), and PROPER(), COUNT(), COUNTA(). Let us start with Microsoft Excel Quiz Questions now.

Microsoft Excel Quiz Questions and Answers

1. What does the Flash Fill feature have in common with the UPPER, LOWER, and PROPER functions?

 
 
 
 

2. What is the difference between the functions COUNT and COUNTA?

 
 
 
 

3. Column C contains the named range, shipping_cost. Column D contains the named range, and location. What would be an appropriate formula to calculate the total shipping cost for all orders originating from the location of Sydney, given that location is the named range for column D?

 
 
 
 

4. Which one of the following statements best describes the main purpose of a digital dashboard?

 
 
 
 

5. Which of the following are mixed cell references in Excel?

 
 
 
 

6. Which of the following tasks can Flash Fill do?

 
 
 
 
 
 

7. Which Excel feature helps divide a column that contains <firstname surname> into two columns: <firstname> <surname>?

 
 
 
 

8. After importing a text file into Excel, some columns aren’t showing all the data. How can you fix all column widths at the same time?

 
 
 
 

9. Which of the following file types support macros?

 
 
 
 

10. Which of the following tasks should you perform before creating a dashboard?

 
 
 
 

11. Column B contains the named range, sales_price. Column C contains the named range, shipping_cost. What would be an appropriate formula to obtain the total of columns B and C in a single cell?

 
 
 
 

12. Which of the following are valid sorting orders you can choose when adding sorting levels to your data?

 
 
 
 

13. Why do you need to use the Paste Values option when you paste contents from a helper row to the original row?

 
 
 
 

14. Which of the following file types are not native Excel files but can be easily imported?

 
 
 
 

15. When using a formula to apply conditional formatting to a whole row, how should we refer to cell B34 in our formula?

 
 
 
 

16. What is one of the functions you can use to change the text case in your data?

 
 
 
 

17. Applying named ranges automatically embeds conditional formatting into your spreadsheet.

 
 

18. To quickly create a named range: highlight the data, including the heading, and press:

 
 
 
 

19. Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?

 
 
 
 

20. According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?

 
 
 
 

Microsoft Excel Quiz Questions and Answers

  • What is one of the functions you can use to change the text case in your data?
  • What does the Flash Fill feature have in common with the UPPER, LOWER, and PROPER functions?
  • Which of the following tasks can Flash Fill do?
  • Why do you need to use the Paste Values option when you paste contents from a helper row to the original row?
  • Which of the following are valid sorting orders you can choose when adding sorting levels to your data?
  • Which one of the following statements best describes the main purpose of a digital dashboard?
  • According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?
  • Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?
  • Which of the following tasks should you perform before creating a dashboard?
  • After importing a text file into Excel, some columns aren’t showing all the data. How can you fix all column widths at the same time?
  • Which Excel feature helps divide a column that contains into two columns: ?
  • Which of the following file types are not native Excel files but can be easily imported?
  • Column B contains the named range, sales_price. Column C contains the named range, shipping_cost. What would be an appropriate formula to obtain the total of columns B and C in a single cell?
  • Column C contains the named range, shipping_cost. Column D contains the named range, and location. What would be an appropriate formula to calculate the total shipping cost for all orders originating from the location of Sydney, given that location is the named range for column D?
  • To quickly create a named range: highlight the data, including the heading, and press:
  • Applying named ranges automatically embeds conditional formatting into your spreadsheet.
  • What is the difference between the functions COUNT and COUNTA?
  • Which of the following file types support macros?
  • When using a formula to apply conditional formatting to a whole row, how should we refer to cell B34 in our formula?
  • Which of the following are mixed cell references in Excel?
Microsoft Excel Quiz Questions Answers

R Frequently Asked Questions with Answers

Statistics Software Quiz

Time Series Quiz 5

The post is about the Time Series Quiz. There are 20 multiple-choice questions related to components of time series, Time series analysis, Arima model, Sarima Model, Naive Model, and Autoregression. Let us start the Time Series Quiz now.

Online time Series Quiz with Analysis
Please go to Time Series Quiz 5 to view the test

Online Time Series Quiz

  • Which of the following best describes a time series in Python?
  • What is a crucial step in the forecasting process for improving accuracy?
  • What is the primary purpose of using a power transformation in data analysis?
  • In the Naïve (Persistence) Model for time series forecasting, what is the forecast value for a future time step?
  • When might the Naïve (Persistence) Model be a reasonable choice for time series forecasting?
  • In ARIMA modeling, what is the primary purpose of the “AR” component of the model?
  • What does the “S” represent in the acronym SARIMA?
  • In the ARIMA modeling framework, what does the “I” represent in the acronym ARIMA?
  • When dealing with time-series data, what is the typical format of a timestamp column in a dataset?
  • In SARIMA modeling, what does the “AR” component focus on?
  • What is the primary limitation of the Naïve (Persistence) Model for time series forecasting?
  • In the Naïve (Persistence) Model, how does the forecast change when applied to a different time series with the same historical values?
  • In an AutoRegression (AR) model, what does the “order p” represent?
  • Which statistical technique is used in AutoRegression (AR) models to estimate the coefficients that relate a variable to its past values?
  • In SARIMA modeling, what is the primary purpose of the “MA” component?
  • What is the role of the “I” component in SARIMA modeling?
  • Which of the following is an example of time series data?
  • Aslam is interested in examining the occupational mobility of women in Pakistan.  Aslam believes that people’s first job affects their second job and that job in turn affects their third job, and so on. To analyze the data Aslam should use
  • Analysis based on study of price fluctuations, production of commodities and deposits in banks is classified as
  • A time series changes at an exact constant percentage and then

R Programming Frequently Asked Questions

Basics of Probability

In this post, I will discuss the Basics of Probability theory. First I will start with the concept of Set and Event.

Set

In statistical theory, a set is a well-defined collection of distinct events. For example, whenever a coin is tossed or die rolled, something (event) will happen. Distinct events comprise the set, that is when a coin is tossed, either Hear or Tail. It can be denoted with a Set.

$$A=\{Head, \, Tail\}$$

Similarly, for a fair die, the distinct events can be represented as set $B$, that is,

$$B = \{1, 2, 3, 4, 5, 6\}$$

When two fair dice are rolled, there will be 36 events that can be represented in a set say $C$.

\begin{align*}
\Big\{ (1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), \\
\,\, &(2, 1), (2, 2), (2, 3), (2, 4), (2, 5), (2, 6), \\
\,\, &(3, 1), (3, 2), (3, 3), (3, 4), (3, 5), (3, 6), \\
\,\, &(4, 1), (4, 2), (4, 3), (4, 4), (4, 5), (4, 6), \\
\,\, &(5, 1), (5, 2), (5, 3), (5, 4), (5, 5), (5, 6), \\
\,\, &(6, 1), (6, 2), (6, 3), (6, 4), (6, 5), (6, 6)\Big\}
\end{align*}

Basics of Probability

Probability is the chance of occurrence of an event described in a set (or sample space). For example, what is the chance of rain today? what is the chance that Pakistan will win the T20 World Cup? Probability is the estimation of chance and it deals with the occurrence of an event in the future. The estimates are presented numerically. For example, (i) There is a 75% chance of rain today, (ii) The insurance industry requires precise knowledge about the risk of loss to calculate premiums, and (iii) The chances of winning the lottery game are 1 in 2.3 million.

Random Experiment

Regarding probability, it is important to understand the concept of random experiments. It is a planned process/activity that gives different results known as outcomes. For example, as discussed earlier, when a coin is tossed, there may be two possible outcomes, Head or Tail. Any experiment or planned process which has only one outcome cannot be regarded as a random experiment. A random experiment has at least a minimum of two outcomes. Outcomes are the results of the experiment. The random experiment has the following properties:

  1. It can be repeated any number of times practically or theoretically.
  2. Each experiment has a minimum of two possible outcomes.
  3. All the outcomes are known in advance but each outcome is unpredictable.

So, we can say that probability is the measure of the degree of uncertainty or quantification of uncertainty.

Sample Space

When we collect all possible outcomes, it is known as sample space, and represented by $S$. For example,

$S=\{H, T\}$ sample space for tossing a single coin

$S=\{HH, HT, TH, TT\}$ sample space when tossing two coins simultaneously

Each outcome of a sample space is called a sample point.

Event

The individual outcome from a sample space in which one is interested is called an event. Events may be based on a single sample point or more than one sample point. For example, Let the even be even numbers when a single dice is thrown, that is, $A=\{2, 4, 6\}$, or even maybe $T$ (Tail) when tossing a coin. $B=\{T\}$. When we throw two dice the event may be the same number on the upper face of the dice, $C=\{(1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6)\}$

Similarly, the sum of dots on the top face of two dice is 4 is another event, that is, $D=\{(2, 2), (1, 3), (3, 1)\}$

Types of Events

The probability of an event lies between 0 and 1 inclusive. If the probability of an event is 1, it is known as a sure event. If the probability of an event is zero it is an impossible event. When two or more events cannot occur at the same time it is called a mutually exclusive event. For example, in the coin tossing example, either $H$ will occur or Tail, both head and tail cannot occur at the same time.

Events are equally likely when events have the same chance of occurrence. For example, either a student will pass or fail, there is a 50% chance for both events. Collectively Exhaustive Events are events whose union is equal to the sample space.

Random Variable

A random variable is that which takes values randomly. A random variable may be represented by $X$, $Y$, and $Z$, etc. Random variables can be classified as discrete random variables or continuous random variables. A discrete random variable is based on a counting procedure, while a continuous random variable is based on measurements.

A random variable is a variable that takes values randomly. These values may be integers for discrete variables and real for continuous variables. When we toss a coin there may be $H$ or $T$. Suppose, you are interested in Head then the random variable may be denoted by $X$ for various numbers of heads (for example, 0 head and 1 head)

x(Heads)$P(X)$
0 head$\frac{1}{2}$
1 head$\frac{1}{2}$
Total$1.0$

The sample space is $S=\{H, T\}$.

For two coins

x(Heads)$P(X)$
0 head$\frac{1}{4}$
1 head$\frac{2}{4}$
2 heads$\frac{1}{4}$
Total$1.0$

The sample space is $S=\{HH, Ht, TH, TT\}$.

MS Excel Quiz

Basics of Probability Theory