What is the purpose of the "Find and Replace" feature?

To find and replace specific text

How can you adjust the width of multiple columns at once in a spreadsheet?

Select the columns and then drag the right border of any selected column

What does Conditional Formatting allow you to do?

Automatically format cells based on specific conditions

To bring out the effect of sunset in a photo using Paint.NET, what should you do?

Add a new layer of amber colour as a filter

What is the purpose of a script in video production?

To provide a detailed plan of the video content

How do you add a caption to an image in Word?

Right-click the Image > Insert Caption

Which of the following best describes the concept of digital privacy?

The right to control personal information and how it is used

How can you add a hyperlink to text in a document?

Right-click the text > Hyperlink

What does the MAX function do in Excel?

Returns the largest value in a range of cells

What is the purpose of the "AutoFit" feature in a table?

Automatically adjusts the column width to fit content

What is the role of music in video production?

To enhance the emotional impact

How can you apply artistic effects to an image in Word?

Picture Format > Artistic Effects

What does the "Wrap Text" option do in a spreadsheet cell?

Makes text fit within the cell by displaying it on multiple lines

What is the role of an ISP (Internet Service Provider)?

To provide internet access to users

studbud

kailas cool228

79 termsStudBud Administration4 plays

Imported from external platform

Flashcards79 cardsFPractice quizPHost liveL

Questions 79

Answers

1
What is the purpose of the "Find and Replace" feature?
To find and replace specific text
To locate and replace formatting
To find synonyms for selected words
To replace an image with text
2
How can you adjust the width of multiple columns at once in a spreadsheet?
Select the columns and then drag the right border of any selected column
Select the columns, then right-click and choose "Resize Columns"
Use the "Merge Cells" option to resize multiple columns simultaneously
Apply the "AutoFit" option to the entire sheet
3
Which formula would you use to find the maximum value in cells A1 to A10?
II. =MAX(A1:A10 )
I. =MAX(A1:A10 )
None of the above
III. =MAXIMUM(A1:A10 )
4
Define the type of website with the primary purpose of selling products or services online.
Social media
Blog
Portfolio
E-commerce
5
What does Conditional Formatting allow you to do?
Automatically format cells based on specific conditions
Change the size of cells based on their content
Create formulas that auto-calculate values
Merge multiple sheets into one
6
How can you change the case of selected text (e.g., to UPPERCASE, lowercase)?
Layout > Change Case
Design > Text Case
Home > Change Case
Insert > Change Case
7
The term for the visual effect when moving from one slide to another is called a "Transition."
True
False
8
What is the main function of DaVinci Resolve in video production?
Interview and recordings
Video editing
Script creation
Story selection
9
Which formula correctly adds the values in cells A1 and B1?
None of the above
III. =ADD(A1,B1)
I. =A1+B1
II. =SUM(A1,B1)
10
To bring out the effect of sunset in a photo using Paint.NET, what should you do?
Adjust the RGB curve towards the red hue
Adjust the colour wheel towards the red area
Adjust the brightness level in the Glow effect
Add a new layer of amber colour as a filter
11
The "Home" tab allows you to add a new slide.
True
False
12
What is the purpose of a script in video production?
To provide a detailed plan of the video content
To outline the project timeline
To select the story
To edit the video
13
How do you add a caption to an image in Word?
Insert > Caption
Layout > Caption
Design > Insert Caption
Right-click the Image > Insert Caption
14
Which of the following is NOT a type of animation effect in PowerPoint?
Layout
Emphasis
Entrance
Exit
15
Which of the following cell formatting options is used to display numbers as percentages?
Currency Format
Percentage Format
Custom Format
Number Format
16
Which of the following best describes the concept of digital privacy?
The obligation to use only public Wi-Fi networks
The requirement to share personal data with all websites
The right to control personal information and how it is used
The ability to access any website without restrictions
17
Google Drive and Dropbox use cloud storage for online file access.
Network storage
Local storage
External storage
Cloud storage
18
Which phase involves finalizing the video by combining all elements together?
Story selection
Video editing
Project timeline
Script creation
19
How can you insert an image from your computer into a Word document?
Layout > Picture > Insert from Computer
Insert > Picture > Online Pictures
Insert > Picture > This Device
Design > Insert Image > From Computer
20
The "Insert" tab allows you to insert images into a slide.
False
True
21
How can you add a hyperlink to text in a document?
Insert > Hyperlink
Layout > Insert Hyperlink
Design > Hyperlink
Right-click the text > Hyperlink
22
How can you add a table to a slide?
View tab > Table
Insert tab > Table
Design tab > Table
Home tab > Table
23
You add bullet points to a list using the "Home > Bullets" option.
True
False
24
What does the MAX function do in Excel?
Returns the largest value in a range of cells
Returns the smallest value in a range of cells
Counts the number of non-empty cells
Calculates the average of values in a range
25
What is the purpose of the "AutoFit" feature in a table?
Automatically adjusts the table size to fit the page
Automatically adjusts the column width to fit content
Automatically adjusts the row height to fit content
Automatically adjusts the table to fit the margins
26
How can you change the border style of a table?
Layout > Borders
Review > Borders
Insert > Borders
Table Design > Borders
27
15. What happens when you mix equal amounts of red, green, and blue light?
You get yellow light
You get black light
You get white light
You get yellow light
28
Which formula would you use to find the maximum value in cells A1 to A10?
non of the above
=MAX(A1;A10)
=MAX(A1:A10)
=maximum(A1:A10)
29
The key feature of Web 4.0 is its ability to grant users access to information on any device.
Smartwatch
Tablet
Mobile device
Desktop computer
30
Mixing a primary color with its complement creates a neutral color.
Secondary colour
Primary colour
Neutral colour
Tertiary colour
31
What should you use when using public Wi-Fi networks for sensitive transactions?
Antivirus
Firewall
VPN
Encryption
32
How do you create a bulleted list?
Layout > Bullet List
Design > Bullets
Home > Bullets
Insert > Bullet Points
33
To create a new presentation, you click on "New Presentation."
True
False
34
The "Insert" tab is used to add tables to slides.
True
False
35
What allows users to navigate from one web page to another by clicking on the link?
URL
Hyperlink
Browser
Search Engine
36
Which tab in PowerPoint allows you to create a new slide?
Animation
Transitions
Home
Design
37
Which of the following statements about merging cells in Excel is true?
I, II only
II, III only
I, III only
None of the above
38
Which tab would you use to insert an image from your computer?
Home
Transitions
Insert
Design
39
Firewall controls network traffic based on security rules.
Router
Switch
Modem
Firewall
40
The primary function of a web browser is to display:
Images
Documents
Videos
Web pages
41
Which tab contains the options for slide transitions?
Insert
Animations
Home
Transitions
42
What is the role of music in video production?
To fill in gaps in the script
To provide background noise
To enhance the emotional impact
To replace dialogue
43
How can you apply artistic effects to an image in Word?
Insert > Artistic Effects
Layout > Artistic Effects
Picture Format > Artistic Effects
Design > Artistic Effects
44
Microsoft Excel is categorized as what type of application?
Presentation software
Database management
Spreadsheet
Word processor
45
Which of the following is NOT typically included in the music and graphics phase?
Designing graphics
Adding background music
Writing the script
Creating visual effects
46
Which of the following is NOT a standard number format option in spreadsheets?
Currency
Comic Sans
Percentage
Scientific
47
The area where you can add notes for each slide is called the "Notes Pane."
True
False
48
What does the "Wrap Text" option do in a spreadsheet cell?
Changes the font style
Makes text fit within the cell by displaying it on multiple lines
Changes the cell background color
Merges multiple cells into one
49
What is crucial in typography because it ensures that the text can be easily read and understood by the audience?
Font size
Readability
Color contrast
Line spacing
50
What is the role of an ISP (Internet Service Provider)?
To create digital content
To develop software applications
To manufacture electronic devices
To provide internet access to users
51
The "Insert > Pictures" tool is used to add images to slides
True
False
52
The "Animations" feature allows you to animate text or objects on a slide.
True
False
53
Which function would you use to find the average of a range of cells in Excel?
AVERAGE
SUM
MAX
COUNT
54
Which menu option is used to change the background color of a cell in Microsoft Excel?
Home > Fill Color
Insert > Cell Color
View > Background Color
Data > Cell Styles
55
Which option allows you to wrap text around an image?
Design > Text Wrapping
Layout > Wrap Text
Home > Wrap Text
Insert > Wrap Text
56
What is the purpose of slide transitions in PowerPoint?
To add visual effects when moving from one slide to another
To add text to slides
To insert images
To change the layout of slides
57
Which of the following is a valid method to add text to a slide?
Insert tab > Text Box
Click on a text box and start typing
Both A and B
None of the above
58
Summarize in one word the marketing that promotes products or services digitally using formats like banners and videos.
Traditional advertising
Content marketing
Digital advertising
Social media
59
Which of the following is NOT a standard number format option in spreadsheets?
Currency
Percentage
Scientific
Comic Sans
60
To create a balanced composition in a poster design, which approach should you take?
Distribute elements evenly across the poster
Use only one type of element (text or image) in the design
Place all text on one side and images on the other
Center all elements in the middle of the poster
61
What is the primary purpose of encryption in digital security?
To compress data for storage
To protect data from unauthorized access
To organize data in databases
To speed up data transmission
62
In Microsoft Excel, which tab contains the option to create a new chart?
Data
Insert
Formulas
Home
63
Which options are available for aligning text within a cell in Excel?
horizontal and vertical and marginal
horizontal and vertical
horizontal and vertical and diagonal
vertical and marginal
64
Which menu option is used to change the background color of a cell in Microsoft Excel?
View > Background Color
Insert > Cell Color
Home > Fill Color
Data > Cell Styles
65
What is the main function of a search engine like Google?
To manage email accounts
To create websites
To find and retrieve information on the internet
To stream live events
66
The "Insert" tab is used to insert text boxes.
True
False
67
What does the MAX function do in Excel?
Counts the number of non-empty cells
Returns the smallest value in a range of cells
Returns the largest value in a range of cells
Calculates the average of values in a range
68
To align text vertically in the center of a cell, which alignment option would you use?
middle
bottom
top
right
69
Which tool helps you resize an image proportionally in Word?
Dragging the corner handle of the image
Dragging the side handle of the image
Using the "Text Box" tool
Clicking "Auto Resize"
70
The "Insert" tab contains the option to add charts.
True
False
71
What color combination best conveys energy and excitement for packaging design?
Soft pastels and neutrals
Bright reds, yellows, and oranges
Dark blues and purples
Greens and browns
72
Which of the following statements about merging cells in Excel is true?
b) Merging cells creates separate smaller cells
a) Merging cells combines them into a single larger cell and removes the
d) Merging cells applies conditional formatting
c) Merging cells automatically sorts the data in ascending order
73
Good readability ensures clear communication, reduces eye strain, and improves user experience.
Experience
Interaction
Interface
Design
74
Which formula will return the total value in cells from the range A1 to A10?
=MAX(A1:A10)
=AVERAGE(A1:A10)
=COUNT(A1:A10
=SUM(A1:A10)
75
How can you change the font style of selected text in Word?
Layout > Font
Design > Font Style
Home > Font
Home > Font Style
76
The "Transitions" tab contains the options for slide transitions.
True
False
77
What does the "Wrap Text" option do in a spreadsheet cell?
Merges multiple cells into one
Changes the cell background color
Makes text fit within the cell by displaying it on multiple lines
Changes the font style
78
What could lead to the loss of sensitive information, financial loss, reputational damage, and legal consequences for
Data breach
Firewall
Phishing
Malware
79
What is the default slide layout when you create a new slide?
Title Slide
Blank
Title and Content
Two Content

kailas cool228 Flashcards | StudBud