NEW
Font size
WorksheetsINFORMATIKA X DKV
Total questions: 15
Worksheet time: 8mins
What is the primary purpose of Microsoft PowerPoint?
To create and edit text documents.
To manage databases and spreadsheets.
To edit photos and images.
To create and deliver presentations.
Which feature in PowerPoint allows you to add animations to text and images?
Design tab
Animations tab
Insert tab
Review tab
How can you change the background color of a slide in PowerPoint?
Go to the 'View' tab and select 'Slide Master' to change the background color.
Use the 'Animations' tab to apply a background color effect.
Click on the slide and select 'Insert Image' to change the background.
Right-click on the slide, select 'Format Background', choose 'Solid Fill', and pick a color.
What is the shortcut key to start a slideshow in PowerPoint?
Ctrl+S
F1
Alt+P
F5
In PowerPoint, what is a 'slide master'?
A slide master is a tool for creating charts and graphs in PowerPoint.
A slide master is a template that defines the design and layout for slides in a PowerPoint presentation.
A slide master is a feature that allows for video embedding in slides.
A slide master is a type of animation effect in PowerPoint.
What is the function of the 'Insert' tab in PowerPoint?
To set up slide transitions and animations.
To change the slide layout and design.
To add elements like images, shapes, charts, and tables to slides.
To review and edit the presentation notes.
How do you add a hyperlink to a PowerPoint presentation?
Select text or object, right-click, choose 'Hyperlink', enter URL, click 'OK'.
Use the 'Insert' tab and select 'Link' to add a hyperlink.
Drag and drop the URL onto the slide to create a hyperlink.
Click on the slide, then press 'Ctrl + K' to add a hyperlink.
What is the primary use of Microsoft Excel?
Creating presentations
Data organization and analysis
Editing videos
Managing email communications
Which function in Excel is used to calculate the average of a range of cells?
AVERAGE
SUM
MAX
COUNT
What does the 'VLOOKUP' function do in Excel?
The 'VLOOKUP' function calculates the sum of a range of cells.
The 'VLOOKUP' function deletes rows in a table.
The 'VLOOKUP' function formats cells in a spreadsheet.
The 'VLOOKUP' function looks up a value in a table and retrieves corresponding data from another column.
How can you create a chart in Excel?
Click on 'File' and select 'New' to create a chart.
Select data, go to 'Insert' tab, choose chart type, and customize.
Right-click on the chart area and select 'Delete' to create a new chart.
Use the 'View' tab to change chart styles.
What is the purpose of the 'SUM' function in Excel?
To add a range of numbers in Excel.
To count the number of cells in a range that contain text in Excel.
To find the maximum value in a range of numbers in Excel.
To calculate the average of a range of numbers in Excel.
How do you freeze panes in an Excel worksheet?
Select the cell, go to 'View' > 'Freeze Panes' > 'Freeze Panes'.
Select the cell, go to 'File' > 'Save As' > 'Save'
Right-click the cell and choose 'Insert' > 'Freeze'
Select the cell, go to 'Home' > 'Format' > 'Freeze Panes'
What is conditional formatting in Excel?
Conditional formatting is a feature in Excel that changes the appearance of cells based on specified conditions.
A method to create charts in Excel.
A feature that automatically saves your work in Excel.
A tool for data entry in Excel.
How can you protect a worksheet in Excel from being edited?
Use the 'Protect Sheet' feature in the 'Review' tab.
Use the 'Format Cells' feature in the 'Home' tab.
Change the font color to hide the text.
Save the file as a PDF to prevent editing.
