NEW
Font size
WorksheetsFormative Assessment CO Q-02
Total questions: 30
Worksheet time: 15mins
Which logical function returns TRUE if all arguments evalute TRUE; FALSE if not?
OR
AND
IF
ANDIF
Which function is used to find the sum of complex numbers in MS Excel?
SUM ()
ADD ()
CSUM ()
IMSUM ()
A Processor unit, a memory unit, and an I/O system form a/an:
Central Processing Unit
Arithmetic Logic Unit
Control Unit
Microcomputer
Zoom, Google Meet, Microsoft Team etc. are the:
Validates sources for customer requirements
Way of communication
Channels of communication
Procedure and Matters
is used to customize how your presentation will look as a printed handout.
Slide Master View
Handout Master View
Notes Mater View
None of the above
Which option/feature is used to avoid showing all of the elements of a slide at once?
Hide slide
Turn off animations
Build slide
Normal view mode
To set the transition speed, select.
Transitions > Timing Group > Duration Box
Transitions > Transitions Duration
Transitions > Transitions Timing Duration Box
None of the above
Which key is used to insert the current time?
Shift+F7
Shift+Alt+D
Ctrl+Shift+;
Shift+F12
Which key is used with CTRL to insert a hyperlink?
K
H
D
F
Which software can be used for giving presentations (e.g. product demo)?
MS Word
MS Excel
MSPowerPoint
MSAccess
In which view Headers and Footers are visible
Normal View
Page Layout View
Print LayoutView
DraftView
Which items are placed at the end of a document?
Footer
Foot Note
End Note
Header
We can insert a page number at
Header
Footer
Both A and B
None
The direction of a rectangular page for viewing and printing is called
Orientation
Direction
Print Layout
Preview
Which Function in Excel tells how many numeric entries are there?
NUM
COUNT
SUM
CHKNUM
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Filtering
Pivot
Statistical calculations and preparation of tables and graphs can be done using
Adobe Photoshop
Excel
Notepad
Power Point
Which one is not a Function in MS Excel?
SUM
AVG
MAX
MIN
The Greater Than sign (>) is an example of operator.
Arithmetic
Logical
Conditional
Greater
The process of arranging the items of a column in some sequence of order is known as:
Arrengin
Autofill
Sorting
Filtering
Which function key is used to spell check?
F6
F7
F1
F5
Which one is not an Ergonomic requirement?
Chair height, seat and back adjustment
Workstation height and layout
Document holder
Enough lighting
What is the PowerPoint Template Extension?
.pptx
.potx
.ppx
.pptem
Which key is shortcut to delete current slide in PowerPoint?
Delete
Backspace
Enter
Both A & B
Which year Microsoft PowerPoint was introduced?
1989
1990
1987
1996
Which one is not a type of document in MS-Excel?
Calendar
Monthly budget
Salary Sheet
Business Latter
To write the formula in Excel, which symbol is needed first?
>
$
=
;
The feature of MS Excel quickly completes a series of data
Auto Complete
Auto Fill
Fill Handle
Sorting
What do you use to create a chart?
Pie Wizard
Excel Wizard
Line Chart
Chart Wizard
How many sheets are there, by default, when we create a new Excel file?
1
3
5
10
