Test your MS Excel skills with this 20-question Trend-Based Conditional Formatting Excel Quiz! Learn how to highlight data trends, use icon sets, color scales, and sparklines, and master custom formatting rules. Ideal for Excel users who want to visualize patterns, analyze data efficiently, and automate formatting tasks. Can you answer all questions correctly? Take the Conditional Formatting Excel Quiz now and level up your spreadsheet expertise! Let us start with the Trend-Based Conditional Formatting Excel Quiz now.
Online conditional formatting excel quiz with Answers
Trend Based Conditional Formatting Excel Quiz
Conditional formatting allows you to automatically apply formatting to one or more cells based on the cell value. This means that conditional formatting can automatically change the cell colour, font, border, or even show a different number of decimal places.
What does trend-based formatting do?
When applying Icon Sets, the original values still appear in the cell.
Which of the following methods allows us to remove conditional formatting (more than one may apply)?
Which would be the appropriate Conditional Formatting set if you wanted to highlight all values over 300?
Conditional formatting can be used to highlight duplicate values.
Conditional formatting by using a formula is advantageous over other conditional formatting because:
Excel allows us to record macros to automate difficult or repetitive procedures. Which of the following is true of recording macros?
What is the key difference between a sparkline and a chart in Excel?
Sparklines are a useful data visualisation tool for which of the following cases (more than one may apply):
After creating a sparkline, we can drag the fill handle to create multiple sparklines.
If you use the fill handle to create multiple sparklines, the sparklines will form a set of connected charts, meaning if you change one, you change all of them. It is possible to unlink sparklines if you do not wish them to behave this way.
Custom number formats can be accessed in which of the following ways:
When customising a number format:
When customising a number format, which character acts as the separator for specifying different formats for different types of values?
What type of brackets should we use when specifying colours for our custom number formats?
If a cell contains the value 0, what will be displayed when we apply the following custom number format: [Red]▲;[Green]▼;
What is the primary purpose of trend-based conditional formatting in Excel?
Which conditional formatting option is specifically designed to show trends?
When using color scales for trend analysis, what does a red-yellow-green color scale typically represent?
Are you an MS Excel pro or just getting started with dashboard creation? This 35-question MS Excel Dashboard MCQs Quiz will test your knowledge on MS Excel Dashboards. The MS Excel Dashboard MCQs Test covers the topics:
Who Should Take This MS Excel Dashboard MCQs Quiz? ✔ Data Analysts looking to refine dashboard skills ✔ Excel Users who want to build professional reports ✔ Students & Professionals preparing for interviews ✔ Anyone who loves Excel challenges!
What are some usual considerations regarding the size of a dashboard?
If your cells in Excel are white with a thin grey outline, one quick way to create a dashboard with a white background is to turn off the gridlines.
Coloured shapes are more useful placeholders of information in dashboards than colouring the background of cells, as shapes are not restricted to the column width and row height proportions.
When using an Align tool, such as Align Right, how does Excel determine the alignment of the elements we have highlighted?
You can place a chart into a dashboard by going to our PivotChart Design tab and selecting Move Chart.
It is important to edit or format your chart before you move into your dashboard.
One difference between Pivot Charts and normal charts is that you cannot edit a Pivot Chart to be linked to a different data set.
You can link a regular chart to a PivotTable.
If you want to cut/copy, and paste multiple elements, a useful tool is
Dragging the fill handle down to create multiple charts from one that you have already created is possible if you are using
One way to add interactivity to your dashboards is by adding
What will copying and pasting a shape to one of the columns or bars in a chart do?
It is not good practice to use Pivot Charts based on calculated fields to a dashboard
To create a slicer, you need to select
The number of slicers that Excel will allow us to create depends on the
To make your dashboard interactive, each element of your dashboard will need to have its own slicer.
The slicer style has to be the same style as you have chosen for your Excel worksheets to appear. For example, if your worksheet windows have grey outlines, so will your slicer.
If you want to link your slicer to multiple dashboard elements, you should go to:
How can we choose not to display the Column letters: “A, B, C…” and Row numbers “1, 2, 3…”?
Suppose that you place a shape to cover an entire chart. Now, what would happen if you changed the outline and fill to No Outline and No Fill, and you activate a link/hyperlink for the shape?
It is best practice to add a refresh button to a dashboard that contains pivots because
Once a dashboard has been created, it is best practice to change colours using Colors rather than Themes because:
When assigning macros to a dashboard, each macro can relate to only one element of the dashboard.
What is an Excel Dashboard?
Which Excel feature is most commonly used to create interactive dashboards?
What type of chart is best for showing trends over time in a dashboard?
Which tool in Excel allows users to filter dashboard data interactively?
What is the purpose of using Conditional Formatting in a dashboard?
Which Excel function is useful for summarizing data in dashboards?
What does a KPI (Key Performance Indicator) represent in a dashboard?
Which feature helps in creating mini-charts within a cell for dashboards?
Why is it important to avoid clutter in an Excel dashboard?
Which tool connects a dashboard to external data sources?
What is the primary benefit of using Excel Tables (Ctrl + T) as a data source for dashboards?
This comprehensive Q&A-style guide about PROC in SAS Software breaks down fundamental SAS PROCs used in statistical analysis and data management. Learn: ✔ What PROCs do and their key functions. ✔ Differences between PROC MEANS & SUMMARY. ✔ When to use PROC MIXED for mixed-effects models. ✔ CANCORR vs CORR for multivariate vs bivariate analysis. ✔ Sample PROC MIXED code with required statements. ✔ How PROC PRINT & CONTENTS help inspect data.
Ideal for students learning SAS Programming and statisticians performing advanced analyses. Includes ready-to-use code snippets and easy comparisons!
Table of Contents
Q&A PROC in SAS Software
Explain the functions of PROC in SAS.
PROC (Procedure) is a fundamental component of SAS programming that performs specific data analysis, reporting, or data management tasks. Each PROC is a pre-built routine designed to handle different statistical, graphical, or data processing operations. The key functions of PROC in SAS are:
Data Analysis & Statistics: PROCs perform statistical computations, including:
Identifying Missing Data (PROC FREQ with MISSING option)
Sampling Data (PROC SURVEYSELECT)
Advanced Analytics & Machine Learning
Cluster Analysis (PROC CLUSTER)
Time Series Forecasting (PROC ARIMA)
Text Mining (PROC TEXTMINER)
PROCs are the backbone of SAS programming, enabling data analysis, manipulation, and reporting with minimal coding. Choosing the right PROC depends on the task—whether it’s statistical modeling, data cleaning, or generating business reports.
Explain the Difference Between PROC MEANS and PROC SUMMARY.
Both PROC MEANS and PROC SUMMARY in SAS compute descriptive statistics (e.g., mean, sum, min, max), but they differ in default behavior and output:
Default Output PROC MEANS: Automatically prints results in the output window. PROC SUMMARY: Does not print by default; requires the PRINT option.
Dataset Creation Both can store results in a dataset using OUT=.
Handling of N Observations PROC MEANS: Includes a default N (count) statistic. PROC SUMMARY: Requires explicit specification of statistics.
Usage Context Use PROC MEANS for quick interactive analysis. Use PROC SUMMARY for programmatic, non-printed summaries.
The PROC MEANS is more user-friendly for direct analysis, while PROC SUMMARY in SAS offers finer control for automated reporting.
Under the PROC MEANS, there is only a subgroup that is created only when there is a BY statement that is being used, and the input data is previously well-sorted out with the help of BY variables.
Under the PROC SUMMARY in SAS, there is a statistic that gets produced automatically for all the subgroups. It gives all sorts of information that runs together.
What is the PROC MIXED Procedure in SAS STAT used for?
The PROC blended system in SAS/STAT fits specific blended models. The Mixed version can allow for one-of-a-kind assets of variation in information, it allows for one-of-a-kind variances for corporations, and takes into account the correlation structure of repeated measurements.
PROC MIXED is essential for analyzing data with correlated observations or hierarchical structures. Its flexibility in modeling random effects and covariance makes it a cornerstone of advanced statistical analysis in SAS.
PROC MIXED is a powerful SAS procedure for fitting linear mixed-effects models, which account for both fixed and random effects in data. It is widely used for analyzing hierarchical, longitudinal, or clustered data where observations are correlated (e.g., repeated measures, multilevel data).
What is the Difference Between CANCORR and CORR Procedures in SAS STAT?
Both procedures analyze relationships between variables, but they serve distinct purposes:
PROC CORR (Correlation Analysis): Computes simple pairwise correlations (e.g., Pearson, Spearman). It is used to examine linear associations between two or more variables or when there is no distinction between dependent/independent variables. The output from different statistical software is in the form of the correlation matrix, p-values, and descriptive statistics. The code below tests how height, weight, and age are linearly related.
PROC CORR DATA=my_data; VAR height weight age; RUN;
PROC CANCORR (Canonical Correlation Analysis): Analyzes multivariate relationships between two sets of variables. It is used to find linear combinations (canonical variables) that maximize correlation between sets. It is also useful for dimension reduction (e.g., linking psychological traits to behavioral measures). The output from different statistical software is Canonical correlations, coefficients, and redundancy analysis.
PROC CANCORR DATA=my_data; VAR set1_var1 set1_var2; /* First variable set */ WITH set2_var1 set2_var2; /* Second variable set */ RUN;
Key Differences Summary
Feature
PROC CORR
PROC CANCORR
Analysis Type
Bivariate correlations
Multivariate (set-to-set)
Variables
Single list (no grouping)
Two distinct sets (VAR & WITH)
Output Focus
Pairwise coefficients (e.g., r)
Canonical correlations (ρ)
Complexity
Simple, descriptive
Advanced, inferential
Write a sample program using the PROC MIXED procedure, including all the required statements
proc mixed data=SASHELP.IRIS plots=all;
class species;
model petallength= /;
run;
Describe what PROC PRINT and PROC CONTENTS are used for.
PROC contents displays the information about an SAS dataset, while PROC print ensures that the data is correctly read into the SAS dataset.
PROC CONTENTS: Displays metadata about a SAS dataset (structure, variables, attributes). Its key uses are:
Check variable names, types (numeric/character), lengths, and formats.
Identify dataset properties (e.g., number of observations, creation date).
Debug data import/export issues (e.g., mismatched formats).
The general syntax of PROC CONTENTS is
PROC CONTENTS DATA=your_data;
RUN;
PROC PRINT: Displays raw data from a SAS dataset to the output window. Its key uses are:
View actual observations and values.
Verify data integrity (e.g., missing values, unexpected codes).
Quick preview before analysis.
The general Syntax of PROC PRINT is
PROC PRINT DATA=your_data (OBS=10); /* Prints first 10 rows */
VAR var1 var2; /* Optional: limit columns */
RUN;
