NEW
Font size
WorksheetsKnowledge test
Total questions: 35
Worksheet time: 18mins
Identify the name of the software
MS Excel
MS Word
A blank sheet in a MS Excel is known as -----------
canvas
document
spreadsheet
Each cell has a different name.
true
false
Identify the name of the cell
A3
B3
C3
Identify the name of the red cell
A11
A10
A12
__________ run from left to right and are identified by numbers.
Rows
Columns
Worksheets
Files
Which of the images below represent Microsoft Excel work environment ?
Identify the name of the software
MS Excel
MS Word
A blank sheet in a MS Excel is known as -----------
canvas
document
spreadsheet
The name of a cell is made up of a column letter and row number
TRUE
FALSE
Rectangular boxes in Excel spreadsheet are called CELLS.
true
false
Each cell in a spreadsheet has a different name.
true
false
Name of a cell is also known as Cell reference
TRUE
FALSE
Which SQL function is used to count the number of rows in a SQL query?
COUNT NUMBER()
NUMBER()
SUM()
COUNT(*)
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
ASC
DESC
There is no default value
None of the mentioned
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
What does the ALTER TABLE clause do?
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
The SQL ALTER TABLE clause is used to insert data into database table
THE SQL ALTER TABLE deletes data from database table
The SQL ALTER TABLE clause is used to delete a database table
SQL query to find all the cities whose humidity is 95.
SELECT city WHERE humidity = 95
SELECT city FROM weather WHERE humidity = 95
SELECT humidity = 89 FROM weather
SELECT city FROM weather
SQL query to find the temperature in increasing order of all cities.
SELECT city FROM weather ORDER BY temperature
SELECT city, temperature FROM weather
SELECT city, temperature FROM weather ORDER BY temperature
SELECT city, temperature FROM weather ORDER BY city
How many records would be returned by the following SQL "SELECT * FROM songs WHERE TimesPlayed >=3
0
2
3
4
A science of collection, presentation of data.
Population
Statistics
Analysis of Data
None of the above
Refers to the collection of facts where the researcher gets information.
Collection of Data
Organization of Data
Analysis of Data
None of the above
Refers to the organization of data into tables, graphs and charts.
Collection of Data
Collation of Data
Presentation of Data
None of the above
Refers to drawing of conclusions or generalizations from the analysed data.
Analysis of Data
Collection of Data
Interpretation of Data
Non Parametric
Each and every element of a large group of data.
Population
Sample
Variable
Data
Process of extracting relevant information from a set of data.
Analysis of Data
Collection of Data
Interpretation of Data
Non Parametric
What are the three basic elements of Power BI?
Power BI Desktop, Power BI Report Server, Power BI Service
Power BI Desktop, Power BI Service, Power BI Mobile
Power BI Service, Power BI Mobile, Power BI Report Builder
Power BI Report Server, Power BI Report Builder, Power BI Service
