NEW
Font size
WorksheetsNSDA_CO_L3_Preparation_01
Total questions: 53
Worksheet time: 27mins
What is the Shortcut for New Slide in MS Powerpoint
Ctrl + M
-------------is a web page address
URL
HTML
DNS
All OF THESE
Full form of URL IS -----------
Uniform Resource Locator
Universal resource Locator
Uninterrrupted resource locator
None
Workbook is a collection of-
Page set-up
Worksheet
Buttons
Diagrams
Press____ to close an open menu of submenu, dialog box or message window.
Tab+ctrl+6
Esc
Alt+5
Ctrl+l
Which one can be used as watermark in a word document
Text
Image
Text & Image Both
None
To remove the content of selected cells you must issue____ command.
Delete
Clear Contents
Clear all
Clear Delete
Which function key is used to spell check?
F6
F7
F5
F1
The background style of PowerPoint presentation is known as-
Animation
Theme
Transition
Effects
Which one is not a Channel of communication?
Zoom
Google Meet
Verbal
Microsoft Team
The ALU performs ____ operation.
Logarithm
Algorithm
Arithmetic
ASCII
Which one is not a file attribute?
Date
Size
Time
Font Format
The command we will choose to convert a column of date into row is _____
Cut and past
Paste Special> Transpose
Formatting
Value
Which one is not a Unicode font?
Sutonny MJ
Nikosh
Kalpurush
Sonar Bangla
Which of the following keyboard command is used to increase font size 1 point?
Ctrl++
Ctrl+]
Ctrl+[
Ctrl+-
The process of transferring files from a computer on the Internet to your computer is called_____
Uploading
Forwarding
FTP
Downloading
Verification of a login name and password is known as:
Configuration
Authentication
Accessibility
Logging in
One of the text function to join two or more text strings into one string
CONCATENATE
COUNTA
COUNT
INT
Which of the function bellow is used to send same letter to different recipient.
Macros
Template
Mail merge
Bibliography
Which of the following provides a printed copy of your presentation ?
Outline
Speaker notes
Audience Handouts
All
Which of the following is not an example of application software?
MS PowerPoint
Linux
MS Word
MS Excel
The clock rate of a processor is measured in-
Megahertz or gigahertz
Nanosecond
Micro hertz
Milliseconds
What is the default file name of Microsoft Excel File?
In addition to password protection, what other security feature can be used in Microsoft Word to restrict editing?
Read-only mode
Document Encryption
Track Changes
Watermark
In Microsoft PowerPoint, two kinds of sound effects files that can be added to the presentation is-
.jpg files and .gif files
.wav files and .jpg files
.wav files and .gif files
.wav files and .mid files
In Google sheet, Columns are represented by____
Number
Letter
Letter and Number
Cells
Which of these font effects is NOT available in the PowerPoint Font dialogue box?
Shadow
Shadow
Strikethrough
Emboss
To create an ID card using word processing software. Which is most impornt?
Insert & Modify shape
Page layout
Insert Header & footer & modify them
Insert and Modify Picture
What does CountA () function do?
Counts cells having alphabets
Counts empty cells
Count cells having number
Count non-empty cells
In addition to password protection, what other security feature can be used in Microsoft Word to restrict editing?
Read-only mode
Track Change
Document Encryption
Watermark
Which of the following is automatically counted in MS Word
Number of Words
Number of Pages
Number of Characters
All of the above
Which chart type is used to visually compare values across a few categories?
Area Chart
Bar Chart
Doughnut
Hierarchy Chart
Which types of templated provides all the users with a design concept, colour scheme, and fonts for presentation?
Content
Format
Normal
Design
PowerPoint presentations are widely used as:
Note outlines for teachers
Project presentation by students
Communication of planning
All of the above
What is a motion path?
A Type of animation entrance effect
A method of advancing slides
A method of moving items on a slide
All of the above
Which is not a Text function in MS Excel?
Code ( )
Clean ( )
Char ( )
DB ( )
Microsoft word is a ____ software.
Word Processing
Compiler
System
Programming
Which is not an edition of MS Word?
MS Word 2019
MS Word 2010
MS Word 2007
MS Word 1206
What is the blank space outside the printing area on a page called?
Shapes
Margins
Header
Footer
_____ logical function indicates TRUE only if all arguments are assessed as TRUE otherwise FALSE
OR
AND
IF
ANDIF
The intersection of a column and a row in a worksheet is called____
Column
Address
Value
Cell
____ is the correct syntax of IF( ) Function.
=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
=IF (logical_test, [value_if_true], [value_if_false])
=IF (logical_test, {[value_if_true]}, {[value_if_false]})
=IF (logical_test: [value_if_true], [value_if_false])
____ type of chart is good for a single series of data.
Column chart
Cone chart
Line chart
Pie chart
In MS PowerPoint presentations, the designs regulate the layout and formatting of the slides. These are commonly known as
Blueprints
Placeholders
Templates
Design Plates
To prepare a presentation/slide show which application is commonly used?
Photoshop
Powerpoint
Outlook Express
Internet Explorer
We can replace a font on all slides with another font using the …........ option?
Edit, Fonts
Tools, Fonts
Tools, Replace Fonts
Format, Replace Fonts
Which option can be used to create a new slide show with the current slides but, presented in a different order?
Rehearsal
Custom slider show
Slide show setup
Slide show view
Which one of the following is not a file format for a picture?
.jpeg
.zip
.png
.bmp
Which menu tab do you use to change the page orientation in MS Word?
Home
Design
Insert
Layout
In MS Excel, the keyboard shortcut “Ctrl+S” can be used to_______
Save As
Save
Start new workbook
Switch between the opened tab
What must a professional interpret and adhere to within a specific organizational or digital platform to ensure appropriate and professional behavior?
The latest market trends
The clients personal preferences
The company’s financial reports
The code of conduct of communication
Which shortcuts key inserts a new worksheet?
AIt + F1
Ctrl + N
Shift + F11
Ctrl + Shift + N
What is the purpose of secondary axis a chart?
To compare data series with different scales
To add more labels
To display totals
To format gridlines
