Wsi
Test Your Knowledge: Word, SQL, and Excel Fundamentals
Welcome to our comprehensive quiz designed to evaluate your understanding of essential topics in Word, SQL, and Excel. This quiz will cover various concepts such as formatting, relational database management, and Excel fun
Each question includes multiple-choice options, allowing you to select the correct statements. Here’s what you can expect:
- Challenging questions across key areas
- Immediate feedback on your answers
- Engaging format to keep you motivated
What is the most important thing when we want to create a proper table of contents within our Word document?
We simply have to type the table of contents by ourselves(just like a standard page)
Table of contents can be generated, but we must remember to add proper formatting of all the titles and subtitles within our document.
Table of contents can be generated, but we must remember about adding a visible page number on each page of our document
Table of content is the same thing as list of figures
Which statements are true according to relational database model?
There may be only one primary key in a table.
There may be many foreign keys in a table.
Primary key is an unique identifier of every record.
Foreign key is an unique identifier of every record.
What is the best way to add page numbers within footer of each page in our Word document?
Type in the page number at the bottom of each page by ourselves
Use special formatting option within Word which allows us to add the page number automatically to each page within our document
Firstly, we must add text box and then place it at the bottom of the page. Finally we can type in the page number within created text box. Then we have to copy this text box on each page.
Unfortunately for this functionality we won't find any built-in solutions within Word
What is the best way to add complex mathematical equations to Word document?
Create an image file and embed it within the document
Use built-in functionality within Word which allows us to create editable mathematical equations
There is no such possibility in Word
Embed within the document URL to webpage which contains discussed equations
Which of the following statements are true about Excel?
Excel does not provide any additional functionalities except basic arithmetic calculations on data within cells
Excel can be directly connected to various data sources like relational databases or files with structured data.
Excel allows us to easly populate cells in rows/columnts with formulas based on only one sample cell
Excel allows us to create graphical representation of our data - charts, graphs, etc.
Which of the following statements are true about Excel?
Excel is able to import and export data in various format - for example CSV files
Excel is able to calculate various formulas
Excel is based on spreadsheets comprising of rows and columns
=$A10+ B10 -this represents a proper formula in Excel
Which statements are true in SQL language?
FROM clause defines conditions which records must meet to be displayed.
WHERE clause defines conditions which records must meet to be displayed.
FROM clause defines tables from which the data will be retrieved.
ORDER BY clause defines tables from which the data will be retrieved.
The requirements specification contains the following entry: Each student can be in many groups; in one group there are many students. On which diagrams this requirement is modeled correctly?
1
2
3
4
Which WHERE statement will match patientName which has at least 5 characters (PL/SQL)?
WHERE patientName like '_____'
WHERE patientName like '*_____*'
WHERE patientName like '_____%'
WHERE patientName like '%_____%'
Mark the correct result for each logical operation
FALSE AND NULL => FALSE
NOT NULL => NULL
NULL OR NULL => FALSE
TRUE AND TRUE => FALSE
Mark the correct statements describing following diagram
According to the diagram single student group can be assigned to multiple students
According to the diagram, student is always assigned to a single student group
According to the diagram, student can be assigned to multiple students groups at the same time
According to the diagram, FirstName and LastName could be set a primary keys for Student table
Select valid statements about one-to-many relationships on ERD:
Can be used to indicate association to exactly one item (student belongs to one group")
It's the best approach to keep track of all changes (eg history of assigned statuses)
FK in such relationship appears on side "one".
Can be used to reference entity to itself (Employee supervised by another employee)
Which statements are true in SQL language?
FROM clause defines tables from which the data will be retrieved.
ORDER BY clause defines tables from which the data will be retrieved.
WHERE clause allows us to sort the data.
ORDER BY clause allows us to sort the data.
The table does not specify the primary key
The data type for the "Date" field seems incorrect. We should use predefined "date" and "time" related datatypes for storing any date or time related information
The diagram does not seem to be fully correct
The diagram is correct and does not contain any visible errors
Which statements are true in SQL language?
SELECT statement allows us to read record from the database.
SELECT statement allows us to insert record to the database.
SELECT statement allows us to delete record from the database.
SELECT statement allows us to update record in the database.
According to the diagram single student group can be assigned to multiple students
According to the diagram, student is always assigned to a single student group
According to the diagram, student can be assigned to multiple students groups at the same time
According to the diagram, FirstName and LastName could be set a primary keys for Student table
Which statements correctly describes pivot tables in Excel?
There is no such thing as "pivot tables" within Excel
Pivot tables allow us to represent data in table
Pivot tables are great way to dynamically represents aggregated values
When using pivot tables - user can dynamically change rows, columns, and grouping function which is being used to calculate the results
Which of the following statements are true about Excel?
Excel allows us to easly populate multiple cells in rows/columnts with formulas based on only one sample cell
Excel allows us to create graphical representation of our data - charts, graphs, etc.
Excel allows us to create rules, that apply custom formatting to cells.
Excel allows us to type in Java code directly within spreadsheets' cells. Excel will automatically compile and run such code.
Mark all correct statements about many-to-many relationship.
It's useful when we want to keep the history of changes (for example all statuses assigned to a student).
It requires an additional entity between two entities (associative entity).
There is no visible difference on the diagram between one-to-many and many-to-many relationships.
There is no such thing as many-to-many relationship.
Which of the following statements are true about Excel?
Excel allows us to use various built-in functions which helps us to solve more complex problems by using the spreadsheets (for ex. COUNT(), SUM(), etc.)
Excel provides built-in "IF" function which allows us to provide different calculation based on the result of the logic function
Excel can be directly connected to various data sources like relational databases or data warehouses
Excel does not provide any additional functionalities except basic arithmetic calculations on data within cells
Which WHERE statement will match patientName which has at least 5 characters (PL/SQL)?
WHERE patientName like '_%__%__%'
WHERE patientName like '_____'
WHERE patientName like '*_____*'
WHERE patientName like '_____%'
Which of the following statements are true about Word?
Word allows us to create complex formatting rules which ensure proper look when printed on paper
Word does not allow any complex formatting options except basic formatting: font size, font color, etc.
We can use section breaks to assign different page headers in a document.
Word has a build-in functionality to draw shapes.
Mark the correct result for each logical operation
NOT TRUE => FALSE
NOT NULL => NULL
NULL OR NULL => FALSE
FALSE OR FALSE => TRUE
This icon allows us to display all the hilden formatting elements within our Word document
This icon allows us to turn on spellchecking against whole document
This icon allows to check how the document is divided into sections.
This icon allows us to display page numbers within footer of our page
Which statements are true about SQL
DELETE statement is used to remove records from database
SELECT statements doesn't perform data changes
There are many different dialects of SQL language. Each relational database usually has its own dialect.
DELETE statement is used for updating and removing records from the database
{"name":"Wsi", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to our comprehensive quiz designed to evaluate your understanding of essential topics in Word, SQL, and Excel. This quiz will cover various concepts such as formatting, relational database management, and Excel functionalities to help you assess your skills.Each question includes multiple-choice options, allowing you to select the correct statements. Here’s what you can expect:Challenging questions across key areasImmediate feedback on your answersEngaging format to keep you motivated","img":"https:/images/course5.png"}