To verify that the button performs the desired action

To change the button's design

To ensure the button is visible on all slides

To apply animations to the button

When you want the video to play automatically when the slide containing it is displayed. When you want to pause the video

When you want to pause the video.

When you want to play the video in reverse.

When you want to start the video by clicking on it.

They create a passive audience experience.

They make the information less relatable.

They make the information more tangible and relatable.

They reduce the need for audience engagement.

Action Chains

Sound Effects

Animation Pane

Hyperlinks

Increasing font size for readability

Reducing the number of slides

Enhancing slide transitions

Making the presentation more dynamic and interactive

Exit the 'Insert Hyperlink' dialog box

Exit the 'Slide Master' view and return to normal editing

Close the entire PowerPoint application

Delete all hyperlinks in the presentation

By changing the background color of the slides

By adding more slides to the presentation

By increasing the font size of the text

By allowing non-linear navigation between slides

Editing mode

Slide Sorter mode

Slide Sorter mode

Design mode

Slide Show mode

Slide transitions

Font changes

Sound effects

Going to a specific slide, playing a sound, running a program, or opening a hyperlink

Ensure they blend with the background

Use plain, non-customized shapes

Make them as distracting as possible

Align them with the overall theme

By clicking on it.

By clicking on it. Through the 'Playback' tab, selecting 'On Click', 'Automatically', or 'When Triggered'

You can't control the playback timing.

Only by using external media players.

It can elevate the quality and engagement of the presentation..

That media only plays once.

That media is muted.

That media plays randomly.

That media plays in sync with other slide elements.

That media only plays once.

That media is muted.

That media plays randomly.

To adjust the video's playback duration.

To cut off the edges of the video.

To edit the video's content.

To adjust the volume of the video.

It provides design templates.

It controls the slideshow's timing.

It enables the insertion of interactive controls.

It allows you to create animations.

They can make the presentation shorter.

They increase the presentation's file size.

They can replace traditional slides.

They engage the audience and provide valuable insights.

To enhance slide transitions

To play background music

To let the audience choose specific options

To add visual effects

They increase the file size of the presentation.

They invite the audience to actively participate.

They make the presentation longer.

They make the information more abstract.

To limit the number of rows returned

To filter rows based on specified conditions

To order query results

To retrieve all columns from a table

Commands can only be used on small databases

Commands may accidentally modify or delete more data than intended

Commands are irreversible and cannot be undone

Commands require advanced programming skills

Complex animations

Static images

Dynamic and responsive presentations

Audio-only presentations

To create a static presentation

To sequence multiple actions and create a flow of events

To make the presentation shorter

To add complex animations

All of the above

Opening external files

Only hyperlinks to other slides

Launching websites

By right-clicking on an object

From the 'Home' tab

In the 'View' tab

From the 'Insert' tab

SELECT table_name *;

SELECT * FROM table_name;

SELECT Columns FROM table_name;

SELECT All FROM table_name;

COUNT

AVG

SUM

MAX

NOT

COUNT

OR

AND

NOT

AND

SUM

AVG

COUNT

OR

AND

>

UPDATE Books SET title = 'The Windy Night';

UPDATE Books SET title = 'The Windy Day' WHERE title = 'The Windy Night';

UPDATE Books WHERE title = 'The Windy Night' SET title = 'The Windy Day';

UPDATE Books SET title = 'The Windy Night' WHERE title = 'The Windy Day';

SQL commands are irreversible

Commands should be used without verification

Testing commands on a sample database is a best practice

Commands are always safe to use without precautions

Filter rows based on specified conditions

Limit the number of rows returned in the result

Retrieve all columns from a table

Organize data in alphabetical order

SELECT * FROM Books ORDER BY ISBN;

SELECT * FROM Books ORDER BY author;

SELECT * FROM Books ORDER BY title;

SELECT * FROM Books ORDER BY publication_year;

INSERT INTO (Database Essentials, Alex Smith, 2020, 1234567890123) Books (title, author, publication_year, ISBN);

INSERT INTO (Database Essentials, Alex Smith, 2020, 1234567890123) Books (title, author, publication_year, ISBN);

INSERT INTO (title, author, publication_year, ISBN) VALUES ('Database Essentials', 'Alex Smith', 2020, '1234567890123') Books;

INSERT INTO Books (title, author, publication_year, ISBN) VALUES ('Database Essentials', 'Alex Smith', 2020, '1234567890123');

To create web applications

To manage hardware resources

To interact with and manipulate data

To design user interfaces

Separate each row's data with semicolons (;)`

Use the UPDATE command instead

Separate each row's data with commas and enclose all rows in parentheses

Use a separate INSERT INTO statement for each row

The details or attributes of the table

The data rows in the table

The constraints applied to the table

The unique identifiers for the table

UPDATE Students SET major='Mathematics' WHERE student_name='Aisha';

SELECT major FROM Students WHERE student_name='Aisha';

DELETE FROM Students WHERE major='Mathematics' AND student_name='Aisha';

INSERT INTO Students VALUES ('Aisha', 'Mathematics');

A hashtag (#)

An equal sign (=)

A dollar sign ($)

A percentage sign (%)

Insert a new row or column

Insert a chart or graph

Insert a function and complete its arguments

Insert a pivot table

Splits a text string into multiple strings

Converts text to uppercase

Combines several text strings into one string

Removes spaces from text

A single worksheet

A collection of one or more worksheets

A single cell

A single column

Home

Insert

File

Data

Brackets, Exponents, Division, Multiplication, Addition, Subtraction

Brackets, Exponents, Division, Multiplication, Subtraction, Addition

Brackets, Exponents, Addition, Subtraction, Division, Multiplication

None of the above

Z1

A1

1A

0,0

Click 'Home,' then 'Fill Color'

Click 'Insert,' then 'Background Color'

Click 'View,' then 'Background Color'

Click 'Data,' then 'Background Color'

Click 'Formulas' tab and then 'Calculate Now'

Click 'Home' tab and then 'Calculate Now'

Click 'Data' tab and then 'Calculate Now'

Click 'View' tab and then 'Calculate Now'

Video Editing

Spreadsheet Application

Web Browsing

Graphic Design

To show a real-time effect as you scroll through options

To preview a print layout

To preview a formula result

To preview a cell's border

Insert common formulas like Sum, Average, Count Numbers, Max, and Min

Insert hyperlinks

Insert text functions

Insert pivot tables

Manually type A1 + A2 + A3... + A10

Use the SUM function and select the range of cells

Use the AVERAGE function

Use the COUNT function

The day of the week

The sequential serial number representing a date

The month of the year

The year of a date

Click 'Formulas' tab and then 'Calculate Now'

Click 'Home' tab and then 'Calculate Now'

Click 'Data' tab and then 'Calculate Now'

Click 'View' tab and then 'Calculate Now'

CONCATENATE

LEFT

RIGHT

LEN

Alphanumeric text

Numerical values

Dates

All of the above

Finding a specific name in a list

Looking up values in the first row of a table range

Making logical decisions based on criteria

Returning a cell value based on row and column numbers

Excel will automatically resize the cell

Excel will display hash symbols

Excel will truncate the data

Excel will change the font size

'fx' button

Home Tab

Insert Tab

Data Tab

Variables

Parameters

Arguments

Operators

=CONCATENATE(A1; B1)

=CONCATENATE(A1 + " " + B1)

=CONCATENATE(A1; " "; B1)

=CONCATENATE("A1 B1")

Only the zoom level

Information about the workbook

Only the active cell

Only temporary results

Create a new workbook

Edit cell data

Add a new worksheet

Change cell formatting

Home tab

Slide Show tab

Insert tab

Design tab

It helps you avoid data altogether.

It allows you to ask vague questions about data.

It enables you to work with data efficiently and get precise answers.

It helps you create more data.

To work with vast amounts of information

To become a software developer

To design databases

To become a librarian

Insert

Home

Animation

Design

They create a static narrative.

They make the presentation more complex.

They guide the audience through a sequence of events, making the message more compelling.

They add complexity to individual slides.

Design

Insert

Slide Show

Home

Animation Pane

Slide Master

Slide Transitions

Slide Layouts

'Home'

'View'

'Design'

'Insert'

Structured Query Language

System Query Language

Standard Query Language

Structured Query Library

'This Device'

'Stock Videos'

'Online Video'

'Stock Images'

Only medical fields

All fields except engineering

Data science, software development, and business analytics

Only art and humanities

To allow the audience to choose topics or directions

To add decorative elements to slides

To play audio files

To make the presentation more complex

It's only useful for librarians.

It's a difficult language to master.

It's a key to unlock the potential of working with data.

It's not relevant in today's job market.

Search for values vertically in a table range

Search for values horizontally in a table range

Make logical comparisons between values

Perform flexible lookups using INDEX and MATCH

Fast database backups

Efficient data retrieval

High database availability

Secure data storage

By clicking on the 'File' tab

By pressing the 'Alt' key

By right-clicking on a text or object and choosing 'Insert Hyperlink'

By using the 'Shift' key

A chef in a kitchen

A librarian in a library

A musician composing a symphony

A teacher in a classroom

Every row must have a unique identifier

No two rows in the table can have identical values

Every column must have a unique value

The table's name must be unique within the database

It's the language for querying and manipulating data in databases.

It's a tool for managing hardware in a database server.

It's a graphical interface for designing databases.

It's a programming language used to create databases.

Only financial institutions

Almost every industry

Only research labs

Only the tech industry

Separate each row's data with semicolons (;)

Use the UPDATE command instead

Separate each row's data with commas and enclose all rows in parentheses

Use a separate INSERT INTO statement for each row

=VLOOKUP(A1; A2:B100; 2; FALSE)

=VLOOKUP("March"; A1:M12; 2; FALSE)

=VLOOKUP("Pass"; B2; "Fail")

=VLOOKUP("John"; A1:A100; 0)

They enhance the visual appearance of worksheets

They allow for spell-checking documents

They automate repetitive tasks, improving efficiency and accuracy

They provide access to the internet within Excel

To create charts and graphs

To perform complex calculations

To edit cell content

To change the font style

Both are created using the CREATE TABLE command

Both can have unique constraints

Both are used for storing data

Both are part of the database schema

Home

Design

Slide Show

Review

To delete data from a database

To add new data to a database

To retrieve data from a database

To modify existing data in a database

Normal view

Slide sorter view

Reading view

Slide show view

'Email Address'

'Create New Document'

'Existing File or Web Page'

'Place in This Document'

Ribbon interface

Pre-designed themes

Complex animations

Effortless slide creation

It helps protect the macro from unauthorized use.

It allows you to run the macro with a keyboard shortcut.

It ensures the macro is saved securely in Excel.

It activates the macro's security settings.

PRIMARY KEY

CHECK

NOT NULL

UNIQUE

VARCHAR

INT

DATE

BOOLEAN

Creating complex pivot tables

Formatting a weekly report consistently.

Automating the installation of Excel add-ins

Generating random numbers for data analysis

Click 'Run Macro' in the Developer tab

Press 'F12'

Press the assigned shortcut key

Click on the cell where the macro is recorded

It always makes the presentation longer.

It can transform the presentation from informative to unforgettable.

It disrupts the flow of the presentation.

It increases the file size of the presentation.

Change the font style

Modify the recorded code directly

Delete the macro entirely

Add new worksheets

Playback

Animations

Insert

Home

Press 'Ctrl + E'

Click on the Home tab and select 'Macros'

Press 'Alt + F11'

Go to the Insert tab and choose 'Macro'

UPDATE

SELECT

INSERT

DELETE

VLOOKUP

HLOOKUP

IF

INDEX

Gathering responses in real-time

Creating feedback forms

Using a dedicated survey tool within PowerPoint

Designing a survey layout

Click 'Run Macro' in the Developer tab

Press 'F12'

Press the assigned shortcut key

Click on the cell where the macro is recorded

INSERT

SELECT

DELETE

UPDATE

SELECT

DELETE

INSERT

UPDATE

Whenever you want to format a cell

Only for complex calculations

When you have repetitive tasks that need automation

To create pivot tables

Using hyphens (-)

Using commas (,)

Using semicolons (;)

Using colons (:)

Delete data from a table

Add new data to a table

Modify existing data in a table

Retrieve data from a table

Using the WHERE clause

Using the ORDER BY clause

Using the GROUP BY clause

Using the LIMIT clause

At the bottom of the slide

In the ribbon's 'Home' tab

At the top left corner

In the 'Insert' tab

Limit the number of rows returned in the result

Organize data in alphabetical order

Filter rows based on conditions

Retrieve all columns from a table

DELETE

INSERT

SELECT

UPDATE

Searching for values in a table range

Making logical comparisons between values

Returning a cell value based on row and column numbers

Combining functions for complex tasks

Separate sets of values enclosed in parentheses

Multiple INSERT INTO statements

The DELETE keyword

The SELECT keyword

INT

BOOLEAN

DATE

VARCHAR

Font styles

Breakpoints and the Immediate Window

Data validation rules

Page layout options

ORDER BY

WHERE

GROUP BY

LIMIT

SELECT * FROM Books WHERE publication_year = 2019;

SELECT * FROM Books WHERE publication_year > 2019;

SELECT * FROM Books WHERE publication_year < 2019;

SELECT * FROM Books WHERE publication_year >= 2020;

List the column names in parentheses before the VALUES keyword

Use quotation marks around the values

Use the VALUES keyword

Use a semicolon at the end of each value

To retrieve data from a table

To modify existing data in a table

To insert new data into a table

To remove specific entries from a table

Presentation Mode and Print Mode; Presentation Mode

Creation Mode and Presentation Mode; Creation Mode

Slideshow Mode and Editing Mode; Editing Mode

Draft Mode and Review Mode; Draft Mode

To make the presentation longer

To gather ratings and comments for improvement

To encourage the audience to leave negative feedback

To add complexity to the presentation

Painting a picture

Solving a mathematical equation

Filling the pages of a book

Planting seeds in a garden

Avoid using the DELETE command

Use commands only on small databases

Execute commands without double-checking

Always test commands on a sample database first

Use the 'Percentage' option in the 'Number' group of the 'Home' tab

Use the 'Currency' option

Use the 'Accounting Comma' option

Use the 'Custom' option

They add random animations to slides

They reduce the need for hyperlinks

They make the slides more static

They create an interactive and structured experience

SELECT * FROM Books WHERE publication_year > 2019 LIMIT 3;

SELECT * FROM Books WHERE LIMIT 3;

SELECT * FROM Books ORDER BY LIMIT 3;

SELECT * FROM Books LIMIT 3;

Slide Show

Design

Developer

Home