Font size
WorksheetsCAP II Part 3
Total questions: 85
Worksheet time: 43mins
The larger and more complicated a system, the more difficult it is to achieve goal..........
congession
decision
conflict
congruence
Which of the following is not a basic step in creating the worksheet?
Save the work book
Modify the worksheet
Enter text and data. Enter text and data
Copy the worksheet
The undo command is useful for?
Restoring to disk the last file deleted
Reversing the most recent action or command
Clearing the contents of the clipboard
Clears the document windows
The relationships. is a database model conceived as a flexible way of representing objects and their
Hierarchical data
Network model
static model
DATA model
When you want to create an animation effect in Ms PowerPoint that moves in a custom path defined by you, you use
Custom move
Strategic move
Custom path
Motion path
What is a hash total?
The number of document processed
The number of lines of data entered
The grand total of all rows and columns processed
None of the above
To select one hyperlink after another during a slide presentation, what do you press?
Tab
Ctrl + K
Ctrl + h
All of above
The selection bar is
below the title bar
to the far left of your document
used to open other office applications
none of the above
The special characters word inserts into you document are called
removable characters
non printing characters
printing characters
hidden characters
The special characters word inserts into you document are called
removable characters
non printing characters
hidden characters
hidden characters
The best way to work with large documents is:
Use document style for text and paragraph style
Work in MS Excel instead because it supports upto 1048576 rows
Use Format Painter for document formatting
Divide the document in as many sections as possible
Office automation refers to:
Automatically runs the Microsoft Office 2007
The varied computer machinery and software
Automatic transmission of data
Office payroll
Switching rows and columns of data to work with it better is called..........
Transposing
Tracking
Formatting
Querying
. While animations are used in text and objects, transactions are used in
Pictures
Drawings
Slides
Charts
In Microsoft Word 2007, options of First line, Hanging, Left, Right comes under.
Table
Line numbers
Indent paragraphs
Break
we want our presentation loops continuously, which tab do we use?
Design
Animations
Slide-show
Review
A DBMS sometimes called a.............
Database
Database manager
DB management
RDBMS
. Which of the following is the correct If formula syntax?
. =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})
When you work with large worksheets you may need to
Size the worksheet to fit on the specific number of pages
Add and remove page breaks
Specify only certain print areas
All of the above
. What are the individual dots which make up a picture on the monitor screen called?
Coloured spots
Pixels
Pixies
............... runs on computer hardware and serve as platform for other software to
run on:
Operating system
Application software
System software
....... allows word to break lines between the syllables of words. Books and magazines use this feature in order to have more uniform spacing between the words.
Indentation
Justification
Hyphenation
Drop Cap
is a special effect as one slide replaces or changes to the next slide when we are in slide show view.
Animation
Design
Themes
Transition
Which tab/s do we find Macros?
Developer
Insert
Review
View
The option allows you to change the appearance of the cell, depending on certain conditions.
Validation
Formatting
Conditional formatting
Hyperlinks
Using the F11 shortcut key to create a chart or chart sheet creates
A default chart
A 2-dimensional column chart
A 2-dimensional bar chart
A 3-dimensional line chart
We have just created a chart which we spent a lot of time and effort. We have edited it, modified it, to make it almost perfect. If we want to create same chart again in the future but with different data, without having to repeat the same steps over again until we reach to the final. We can save our chart as:
Chart style
Template
Chart layout
Chart type
Listed below are the four characteristics that makes information useful and meaningful. Pick the characteristic that relates to information's ability to reduce uncertainty.
Relevant
Reliable
Complete
Timely
Which file starts MS word?
Winword.exe
Word.exe
...... are design templates that can be applied to an entire presentation that allows for consistency throughout the presentatored
Animations
Background
Design
Themes
How can you increase the font size of selected text by one point every time?
By pressing Ctrl+]
By pressing Ctrl + [
By pressing Ctrl + {
By pressing Ctrl +}
Quick Access Toolbar
Can't be customised
Can be customised
Can only be customised with Visual Basic for Applications
There is no quick access toolbar in office 2007
. Indenting paragraphs allows you to set text within a paragraph at different Controls the left boundary of every line in a paragraph except the margins...... first one.
First line
Hanging
Left
Right
. =A1+A2+A3+A4 will add all the values of the cells, which can also be done using Formula in MS Excel,
=total(A1:A4)
=sum(A1:A4)
=sumif(A1:A4)
=sumall (A1:A4)
The correct syntax of SUMIF formula is:
SUMIF (range, criteria)
SUMIF (range, sum_range, (criteria]
SUMIF (range, criteria, [sum_range])
Any of the above
We can create our own layout by the help of............
Notes master
Handout master
A workbook allows multiple users on a network to view and make changes to the workbook at the same time.
Distributing
Sharing
E-mailng
Copying
Keyboard shortcut to open Save As dialog box is F12 which can also be obtain by using. Keyboard keys
Ctrl+A
ALt +F. A
Ctrl+S
Use the... to return the present value of an investment.
PV function
Goal seek command
Amortisation schedule
Data Table Command
Data validation is added to cells by using the......... ribbon button on the data tab on the
Trace precedent
Validation
Remove precedent
Data validation
We can't enter data through..........
Table
Form
Query
Report
Shortcut in Microsoft Excel is insert, Module.new module appears. to open the Visual Basic Editor, arid then click
Alt+ F11
Alt+F4
Ctrl+W
None of the above
Which of the following is not essential component to perform a mall merge operation?
Main document
Data source
Merge fields
Word fields
The ability to combine name and addresses with a standard document is called
Document forinatting
Database management
Mail merge
What value will display if the formula = $55.00"+5 is entered into a cell?
560
60
560.00
What is the default font used in MS Word Document 2007?
Times New Roman
Calibri
What is the purpose of inserting Header
To make large document more readable
To allow page headers and footers appear on document when printed
The keystrokes Ctrl + I is used to:
Applies italic format to the selected text
. Insert a line break
What feature will you use to apply motion effect in between a slide exits and another enters
Slide Transaction
Slide Design
From which menu you can insert Header and Footer?
Insert Menu
View Menu
What feature emphasizes you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
Goal Seek
Scenario summary report
Forecasting
Trend line
Which one can be used as the watermark in word document?
Text
Image
What is the default font size of a new word document based on normal template?
12 pt
14 pt
None
A new presentation can be created from
Blank Presentation
From Existing Presentation
From Design Template
All of the above
You can use the horizontal and vertical scroll bars to
View different rows and columns
Split a worksheet into two pieces
View different worksheets
Which of the following setup options can't be set in the page setup dialog box?
Printer selection
Vertical or horizontal placement
Where can you find go to special?
Home>Find and Select
Home>Sort and Filter
When integrating MS-word and Excel, Word is usually the
Server
Source
Client
To select one hyperlink after another during a slide presentation, what do you press?
Tab
Ctrl+K
It is possible to a data source before performing a merge
Create
Modify
Sort
None of the above
Which menu provides you options like Animation scheme, custom animation, and side sition?
Slide Show Menu
Format Menu
presentations are widely used as PowerPoint
Note outlines for teachers
Project presentations by students
Communication of planning
All
The comparison operator...........means not equal to or does not match text.
<>
><
Which of the following is not valid version of MS Office?
Office Vista
Office 2007
When you choose the..... option, the movie clip will not show until you click the slide during slide show.
On click
Off click
A foreign key imposes a specific kind of integrity to related tables. What is the name of this integrity?
Schema
Referential
Expatriate
Data
To protect a worksheet, you can choose Protection and the Protest Sheet from the....
menu
Edit
Format
Tools
Data
Excel is a
A spreadsheet
Graphic program
What are the keyboard shortcut for Italic, bold and underline styles?
Ctrl+i, ctrl+b, ctrl+u
Alt+t, alt+b, alt+u
None
When the formula bar is activated, you can see
The Edit Formula button
The Cancel Button
None
In which view headers and footers are visible?
Print layout view
Page layout view
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
Which of the following are word processing software?
Word perfect
Easy word
MS word
All
You can set page border in Excel from:
From life style tool in Drawing toolbar
You can't set page border in Excel
The default slide layout is in orientation.
Portrait
Landscape
If you use the multiple ledger creation features in tally
You can create multiple ledger at once.
Tally makes the task easier by saving the setting of that ledger as default for the
ledgers you create in
None
You can open the sort dialog box by choosing from the. ......menu
Format
Data
Accounting on the internet refers to the accounting software that is hosted on
Remote servers
Cloud
You can add an image to a template by clicking the insert picture from file button on the .........Toolbar
Picture
Drawing
Samsung Galaxy S4 uses a
Android based operating system
Mobile based operating system
The default way for animation to start is.............
On click
Loop
....key is always unique.
Primary
Foreign
During the.... .........process, a program stored in ROM tells the hard disk to load the operating system into RAM.
boot
start-up
load
CPU
Excel doesn't recognize text in the formula or function, such as when the function name is misspelled. The resulting error message will be
#NAME!
#VALUE!
......when the computer is turned on and the operating system is loading. (Imp)
Booting
Tracking
