NEW
Font size
Worksheets641-680
Total questions: 40
Worksheet time: 20mins
Which feature in MS Word allows you to divide a document into sections with different layouts (e.g., portrait and landscape)?
Page Break
Section Break
Line Spacing
Line Break
You want to check if a cell is empty. Which function should you use?
=ISNUMBER ()
=IFERROR ()
=ISEMPTY ()
=ISBLANK ()
What is the result of =ROUND(12.789, 2)?
12.78
12.7
12.79
13
What does the formula =IF(B2>100,"Pass", "Fail") do?
Compares B2 to 100 and displays "Pass" if less
B2 100 then Return "Pass" or "Fail".
Returns "Pass" if B2 is greater than 100, otherwise "Fail"
Returns "Fail" if B2 is greater than 100, otherwise "Pass"
You want to prevent users from entering a number greater than 10 in a cell. Which feature will you use?
Conditional Formatting
Protect Sheet
Data Validation
Error Checking
You need to apply different headers and footers for different chapters in your document. What should you use?
Page Break
Table of Contents
Section Breaks
Next Page
You want the first row (headers) to repeat at the top of each printed page. What should you do?
Select the row and change page Setting
Use the "Repeat Header Rows" option
Use "Rows to repeat at top"
Insert a new row on every page
Which is relation Operator in the Excel?
&
<>
*
&&
Which view in PowerPoint displays the slide thumbnails on the left and the current slide in the main window?
Slide Sorter View
Normal View
Reading View
Printing View
Which of the following file types is most likely to be blocked by email servers due to security risks?
.html
.zip
.exe
.tif
What is the primary purpose of a device driver?
To protect the computer from viruses
To increase the system's internet speed
To allow hardware to communicate with the operating system
To clean up unused files
Which is not a file format/extension of word document?
.rtf
.docx
.txl
.rtdoc
Workbook is a collection of
Page set-up
Worksheet
Buttons
Diagrams
Press _____ to close an open menu or submenu, dialog box or message window.
Tab+ctrl+6
Esc
Alt+5
Ctrl+1
To remove the content of selected cells you must issue _______ command.
Delete
Clear Contents
Clear all
Clear Delete
The background style of PowerPoint presentation is known as-
Animation
Theme
Transition
Effects
Which is a valid file format in PowerPoint?
pptx
PowerPT
.docx
The ALU performs ______ operation.
Logarithm
Algorithm
Arithmetic
ASCII
The command we will choose to convert a column of data into row is
Cut and paste
Paste Special > Transpose
Formatting
Value
Which of the following keyboard command is used to increase font size by 1 point?
Ctrl + +
Ctrl + ]
Ctrl + [
Ctrl+ -
One of the text functions to join two or more text strings into one string.
CONCATENATE
COUNTA
Count
INT
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 processor is measured in-
Megahertz and gigahertz
Nanosecond
Micro Hertz
Milliseconds
In Microsoft PowerPoint, two kinds of sound effects file 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
What does CountA () function do?
Count cells having alphabets
Count empty cells
Count cells having number
Count non-empty cells
Which chart type is used to visually compare values across a few categories?
Area Chart
Bar Chart
Doughnut
Hierarchy Chart
Which format represents the numbers with the dollars ($) sign? [For example, $1,000,00]
Automatic
Number
Time
Currency
What is URL?
An acronym for Unlimited Resources for Learning
The address of an document or “page” on the World Wide Web
A type of programming object
A computer software program
How can you start a PowerPoint slide show from the beginning?
Click on the slide sorter button
Press F5
Use the Slide Show tab and click on “Start Slide Show”.
Right-click and select “Start from Beginning”
Which function in Excel is used to find the highest value in range of cells?
=MAX
=MIN
=SUM ()
=COUNT ()
A combination of which shortcut keys to use to split a table?
Ctrl+Shift+Enter
Ctrl+Enter
Shift+Enter
Alt+Enter
Press ________ to open the help window in the MS Word document.
F1
F2
F3
F4
AutoCorrect was originally designed to replace______ words as you type
Common
Long
Misspelled
Technical
Which of the following is not section break Option?
Next Page
Previous Page
Continuous
Even Page
You can set Page Border in Excel from
Page Layout tab
Insert tab
Home tab
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
Font Color Red
Apply Conditional Formatting command on Format menu
Cell Style Red
Number Format Red
Which command will you choose to convert a row?
Copy > Paste
Paste Special > Transpose
Cut > Paste
Format Painter
Which of the following series type is not valid for fill series dialog box?
Linear
Growth
Date
Time
Getting data from a cell located in a different sheet is called_________
Copying
Referencing
Pasting
Moving
