WorksheetsNSDA COP L-3 (quiz-09) 05.07.25
Total questions: 20
Worksheet time: 10mins
A combination of which shortcut keys to use to split a table?
Ctrl+Shift+enter
Ctrl+enter
Shift+Enter
Ctrl+alt+S
Press __ to open the help window in the MS Word document.
F1
F2
F9
F11
What is gutter Margin?
Margin that is added to the left margin when printing
Margin that is added to the right margin when printing
Margin that is added to the binding side of the page when printing
Margin that is added to the outside of the page when printing
Which bar shows the current position as far as the text goes?
Title bar
Menu bar
Scroll Bar
Status bar
AutoCorrect was originally designed to Replace ______ words as you type
Short, Repetitive
Grammatically incorrect
Misspelled
None of the above
Which of the following is not section break Option?
Next page
Previous Page
Odd Page
Even Page
You can set Page Border in Excel from
From border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You cannot set page border in Excel
When all the numbers between 0 and 100 in a range should be displayed in Red Color , apply
Use =if() function to format the required numbers red
Apply conditional Formatting command on format menu
Select the cells with numbers between 0 and 100, then click Text Color tool and choose red
All of above
Which command will you choose to convert a column of data into row?
Cut and Paste
Past Special> Transpose
Both of above
None of above
which of the following series type is not valid for fill series dialog box?
Linear
Growth
Autofill
Time
Getting data from a cell located in a different sheet is called__
Accessing
Referencing
Updating
Functioning
Which of the following is not a valid data type in excel?
Number
Character
Label
Date/Time
Concatenation of text can be done using
Apostrophe (‘)
Exclamation (!)
Hash (#)
Ampersand (&)
Which of the following section does not exist in a slide layout?
Titles
Lists
Charts
Animations
Which of the following pane is NOT available in Task Pane?
Slide Design
Master Slide
Slide Layout
Slide Transition
Which of the following features should you use when typing in the notes text box
Slide Show
Insert
Slide Master
Zoom
What is the full form of the internet?
Intercontinental Network
Internal Network
Interconnected Network
International network
The Email Filed accepts one email address at a maximum of _________ Character.
254
256
268
155
Which of the following components in an email address separates the username from the email provider’s domain?
Email provider’s domain
Username
User domain
@
What is a “database” best described in spreadsheet software like Microsoft Excel?
A type of chart
A cell reference
A collection of related data
A division of results
