NEW
Font size
WorksheetsMIS & TABLEAU FINAL ASSESSMENT
Total questions: 25
Worksheet time: 13mins
How to remove borders applied in Cells?
Select None on Border tab of Format cells
Open the list on Border tool in Format Cell toolbar then choose first tool (none)
Both of above
None of above
_____ is not a valid data type in MS-Excel.
Number
Character
Label
Date/ Time
_____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise.
OR
AND
IF
ANDIF
The Greater Than sign (>) exemplifies a/an _____ operator.
Arithmetic
Conditional
Logical
Greater
____ type of chart is good for a single series of data.
Column chart
Cone chart
Line chart
Pie chart
What do Excel formulas start with?
/
f
=
-
Why is the =COUNTIF function in Excel used?
Counts cells as specified
Counts blank cells in a range
Counts cells with numbers in a range
Returns values based on a TRUE or FALSE condition
___ is the programming language used to write a Macro in MS Excel.
Visual basic
C+
Java
C++
What is the shortcut key to switch between worksheets in Excel?
Ctrl+Tab
Ctrl+Page Up
Ctrl+Page Down
Alt+Tab
Which of the following functions is used to calculate the average of a range of cells, ignoring zero values?
AVERAGE
AVERAGEIF
AVERAGEIFS
AGGREGATE
What does VBA stand for?
Visual Basic Analysis
Visual Basic Application
Visual Basic Algorithm
Visual Basic Automation
What is a macro in VBA?
A type of variable
A set of instructions to automate a task
A data structure
A loop
Which of the following is the correct syntax for a function in VBA?
FunctionName()
Function Name()
Function_Name()
functionName
Which of the following is NOT a VBA operator?
+
*
%
&
Which of the following is the correct syntax for an If-Then-Else statement in VBA?
If condition Then statement Else statement
If condition Then statement ElseIf condition Then statement Else statement
If condition statement ElseIf condition statement Else statement
If condition Then the statement
Which keyword is used to retrieve data from a table in SQL?
RETRIEVE
SELECT
GET
FETCH
Which keyword is used to sort data in a table in SQL?
ORDER
SORT
ARRANGE
SEQUENCE
Which keyword is used to set a condition in SQL?
WHERE
IF
THEN
ELSE
Which operator is used to check for inequality in SQL?
=
==
!=
<>
Which operator is used to test whether a value is within a specified range in SQL?
EXISTS
IN
NOT IN
BETWEEN
Which one of the following is not a valid data type in Tableau?
String
Integer
Boolean
Complex
What is a hierarchy in Tableau?
A type of chart that displays values as bars.
A grouping of related dimensions that can be navigated hierarchically.
A type of data source that is optimized for live connections to data.
A type of join used to combine data from multiple tables.
What is the difference between a worksheet and a dashboard in Tableau?
A worksheet is a single chart or table, while a dashboard is a collection of worksheets.
A worksheet is a collection of worksheets, while a dashboard is a single chart or table.
A worksheet is used for data exploration, while a dashboard is used for data analysis.
There is no difference between a worksheet and a dashboard in Tableau.
What is the term used in Tableau to represent individual data elements such as text, numbers, and dates?
Rows
Columns
Dimensions
Measures
What is the purpose of using “Hierarchies” in Tableau?
To create animations for visualizations
To organize data into levels of detail for drilling down and analysis
To import and export data from other sources
To perform advanced analytics on data
