WorksheetsComputer and IT
Total questions: 40
Worksheet time: 20mins
In which view Headers and Footers are visible
Normal View
Page Layout View
Print Layout View
Draft View
The process of removing unwanted part of an image is called
Hiding
Cropping
Bordering
Cutting
To apply center alignment to a paragraph we can press
Ctrl + S
Ctrl + A
Ctrl + C
Ctrl + E
Text-styling feature of MS word is
WordColor
WordFont
WordArt
WordFill
Which items are placed at the end of a document
Footer
Foot Note
End Note
Header
A number of letter that appears little above the normal text is called :
Superscript
Subscript
Supertext
Toptext
A number of letter that appears little below the normal text is called :
Superscript
Subscript
Supertext
Toptext
We can insert a page number at
Header
Footer
Both Header and Footer
None
Which item appears dimly behid the main body text
Watermark
Watercolor
Background
Back color
What item contains detailed information about something in the text ?
Footer
Footnote
Endnote
Header
Footnotes appear at:
Bottom of each page
End of the document
At the end of the document and at the bottom of each page
Either bottom of each page or end of document
The intersection of a coloumn and a row in a spreadsheet is called:
Cell
Address
Formula bar
Value
Statistical calculations and preparation of tables and graphs can be done using
MSExcel
MSWord
MS PowerPoint
MS Access
Which function in Excel checks whether a condition is true or not ?
SUM
IF
AVG
COUNT
In MS Excel columns are labelled as:
A, B, C...
1, 2, 3...
$A1, $A2
$A1, $B2
What do you use to create a chart in Excel
Chart Wizard
Data Wizard
Chart and Data Wizard
Excel Wizard
How many sheets are there, by default, when we create a new Excel file ?
1
3
2
4
_______ is a collection of data that is stored electronically as a series of records in a table.
Database
Spreadsheet
MSWord
Presentation
What type of chart will you use to compare performance of sales of two products ?
Column Chart
Pie Chart
Line Graph
Histogram
The basic unit of a worksheet for data entry is called
Cell
box
table
column
How to insert video in MS Word
Click on Insert video media
Click on insert video
Add video URL
Add hyperlink to video
Which functionality of MS word allows you to collapse or expand sections of the document
Heading
Header
Title
Sectiom
The shortcut to create hyperlink:
Ctrl + K
Ctrl + H
Alt + K
Alt + H
The short cut to move the insertion point to the beginning of the document:
<Ctrl> + <Home>
<Ctrl> + <H>
<Alt> + <Home>
<Alt> + <H>
The short cut key to insert a page break
<Ctrl> + <Enter>
<Ctrl> + <E>
<Ctrl> + <P>
<Ctrl> + <Page>
The command to label the values of individual chart elements:
Add “ data labels ”
Add “ Chart labels ”
Add “ data elements”
Add “ chart labels ”
Command to show/hide ribbon in MS Office:
CTRL+F1
CTRL+F2
ALT+F1
ALT+F2
How many data formats are available in Excel
11
12
15
10
Macros are used for iterating over a group of tasks
True
False
Excel spreasheets can be password protected
Yes
No
Which among the following are the 'Index Matching' functions in Excel:
VLOOKUP
INDEX MATCH
IF
False
Shortcut to resize all columns in Excel
ALT+HOI
CTRL+ HOI
ALT+C
CTRL+ CL
Which are the three report formats in Excel
Compact
Report
Tabular
Spreadsheet
Is it possible to make Pivot table using multiple sources of data?
Yes
No
Yes, if the multiple data sources are present in different spreadsheets of the same workbook
Yes, if the multiple data sources are present in different spreadsheets of the different workbooks
Freeze panes are used to lock any row or coloumn.
True
False
The return results of logical operators in Excel are:
TRUE
FALSE
1
0
The shortcut to move to the previous worksheet in Excel:
Ctrl + PgUp
Ctrl + PgDown
Alt + PgUp
Alt + PgDown
The shortcut to move to the next worksheet in Excel:
Alt+ PgDown.
Ctrl + PgDown
Alt + PgUp
Ctrl + PgUp
Data validation is used to:
Assess data
Reject data
Sort data
Validate data
Which function is used to determine the day of the week for a date?
WEEKDAY ()
WEEK ()
DAY ()
WEAKDAY ()
