1.
The address of the last cell in the a worksheet of Excel is
(A)
HZ10000
(B)
IV65536
(C)
ZA65535
(D)
ZZ66666
Answer:
(B)
2.
This Function is used to calculate the numbers within the list of
arguments.
(A)
COUNTIF()
(B)
CALCUATE()
(C)
COUNT(_)
(D)
IF()
Answer:
(C)
3.
In excel, which function is usde to convert hours, minute & seconds
given as numbers to an Excel serial number, formatted with a time format
(A)
TIME(hours,minute, second)
(B)
TIMECONV(hours,minute, second)
(C)
TODAY(hours,minute, second)
(D)
CONVTIME(hours,minute, second)
Answer:
(A)
4.
How do you select an entire column in a spreadsheet ?
(A)
Hold Down the Ctrl key as you click anywhere in the column
(B)
Select Edit > Select > Column From the menu
(C)
Hold down the Ctrl key s you click anywhere in the colomn
(D)
Click the column heading letter
Answer:
(D)
5.
Alt + page down key is used to move to _____
(A)
Right One Screen
(B)
The first cell in the row
(C)
To the First cell on the worksheet
(D)
Left one screen
Answer:
(A)
6.
The setting for printing comment is found on ____________
(A)
The Print tab of the page setup
(B)
Tols Option Dialog
(C)
The Sheet Tab Of The Page setup Dialog
(D)
Print Preview Dialog
Answer:
(C)
7.
In Excel, to diplay Indian currency in the cell which option is provided by
format cells – Number Tab ?
(A)
Rs.
(B)
Rs.
(C)
Rupee
(D)
INR
Answer:
(B)
8.
In a conditional format you must say any of the folloewing :
(A)
font, font style, font size, fill color, border
(B)
font, font style, font size
(C)
font, font size, font color, fill color, border
(D)
font, font style, font size, fill color, border
Answer:
(C)
9.
Which method cannot be used to enter data in a cell of Excel sheet ?
(A)
Press TAB key
(B)
Press Arrow key
(C)
Press ESC key
(D)
Press Enter key
Answer:
(C)
10.
Which is the category of the round() function ?
(A)
Financial
(B)
Statistical
(C)
Math and trig
(D)
Date and Time
Answer:
(C)
11.
How can non – contigous worksheets be grouped ?
(A)
The Group button on the standard toolbar
(B)
The shift key and mouse
(C)
the alt key + enter key
(D)
The ctlr key and mouse
Answer:
(D)
12.
The shortcut key used in EXCEL for copying selected text is
(A)
Shift + C
(B)
Shift + A
(C)
Ctrl + A
(D)
Ctrl + C
Answer:
(D)
13.
Which Symbol is used in the formula for divide in excel ?
(A)
/
(B)
x
(C)
D
(D)
*
Answer:
(A)
14.
Which Symbol is used in the formula for multiplication ?
(A)
^
(B)
*
(C)
x
(D)
/
Answer:
(B)
15.
In Excel, which facility is available to print a specific row on each page
of the sheet in printing ?
(A)
Rows to Print
(B)
Rows repeated
(C)
Rows to repeat at top
(D)
Repeat row in print
Answer:
(C)
16.
What is the result of the following formula ? = ( 2+3) -1*6+(12/2)^2
(A)
60
(B)
24
(C)
35
(D)
36
Answer:
(C)
17.
Renaming of the excel worksheet is done by how many ways ?
(A)
4
(B)
1
(C)
3
(D)
2
Answer:
(C)
18.
Except for the function, a formula with a logical function shows the word
“TRUE” or “FALSE” as a result
(A)
=NOT()
(B)
=COUNT()
(C)
=AND()
(D)
=OR()
Answer:
(B)
19.
A worksheet till Excel 2003 can have a maximum of number of rows ?
(A)
32000
(B)
256
(C)
1024
(D)
65536
Answer:
(D)
20.
which of the following shortcut keys inserts current date in document ?
(A)
There is no Shortcut key defined for insert current date
(B)
Ctrl + Shift + D
(C)
Alt + Shift + D
(D)
Ctrl + D
Answer:
(A)
21.
In a workbook , appears bold indicating that you can work in it.
(A)
Intersection
(B)
Sheet tab
(C)
Referance cell
(D)
Active sheet
Answer:
(D)
22.
from which menu you can access Picture, Text Box, Chart etc. ?
(A)
Insert
(B)
File
(C)
Edit
(D)
View
Answer:
(A)
23.
you are editing an worksheet that you had previously saved. If you want to
save the edited sheet without losing the original one, which command should you
use ?
(A)
Edit
(B)
New
(C)
Save
(D)
Save as
Answer:
(D)
24.
how can we clear the entire cell including data, formula, format and values
in Excel ?
(A)
In file menu- properties option
(B)
No such facility is available in Excel
(C)
In Edit menu – Clear Option
(D)
In Edit menu – Clear – all option
Answer:
(D)
25.
The fill color to a cell range.
(A)
to insert a background
(B)
to select a distribution of figures
(C)
to add shading or color to cell range
(D)
to add border
Answer:
(C)
26.
Formatting of a block of text can be cleared by
(A)
Selecting Autoformat
(B)
right clicking mouse
(C)
using key combo CTRL+ F
(D)
using Edit – Clear formats
Answer:
(D)
27.
What is the formula of the justification buttons on the toolbar ?
(A)
to display the four option for the aligning text
(B)
to display a drop down list of justification option
(C)
ot open the justification option dialog box
(D)
to center the current line
Answer:
(A)
28.
In Excel, one workbook may contain more than one
(A)
Formula Sheets
(B)
Worksheets
(C)
Web pages
(D)
Work pages
Answer:
(B)
29.
In Excel, this Function returns number rounded up to the nearest even
integer.
(A)
EVENT()
(B)
EVEN ()
(C)
ROUND2 ()
(D)
ROUNDEVEN()
Answer:
(B)
30.
A Function inside another function cell move is called a _____ Function
(A)
SUM
(B)
Round
(C)
Text
(D)
Nested
Answer:
(D)
31.
The Format Cell Number can has an option to show negative numbers in
(A)
Green
(B)
Blue
(C)
Quote
(D)
Red
Answer:
(D)
32.
In Excel, Header and Footer facility is available in
(A)
File Menu
(B)
Insert Menu
(C)
Style Menu
(D)
Format Menu
Answer:
(B)
33.
Select entire row, click mouse on the
(A)
Formula bar
(B)
First cell of the row
(C)
Column name
(D)
Row Number
Answer:
(D)
34.
When is dispiayed in the status bar of the workbook window, you can move
around the workbook, enter data, use function keys, or choose a command.
(A)
Format
(B)
Style
(C)
Ready
(D)
Enter
Answer:
(C)
35.
in Excel you can sum a large range of data by simply selecting a tool
button called ?
(A)
Auto fill
(B)
Auto formate
(C)
Auto sum
(D)
Auto Correct
Answer:
(C)
36.
Shortcut key for Opening a spreadsheet from whithin MS-EXCEL ?
(A)
ALT + P
(B)
CTRL+ O
(C)
CTRL+ P
(D)
ALT + P
Answer:
(C)
37.
you can insert an Excel worksheet into a MS- Word document by option from
menu bar.
(A)
Insert –> file
(B)
Insert –> Object
(C)
Insert –> filed
(D)
Insert –> frame
Answer:
(B)
38.
What does the microsoft excel Status bar display ?
(A)
indicate the current status of key on the keyboard
(B)
current status messages such as if the Caps lock is on.
(C)
Display the name of the of spreadsheet im use.
(D)
provide Functions for different display modes.
Answer:
(D)
39.
What is represented by the small, black square in the lower-right corner of
an active cell or range ?
(A)
Border
(B)
Copy Hadle
(C)
Fill Handle
(D)
Insert Handle
Answer:
(C)
40.
Area, Scatter and column are all examples of
(A)
Chart Category
(B)
Clip Art Category
(C)
Auto Shape categories
(D)
PPT building
Answer:
(A)
41.
Which of the folloeing moves the insertion point to the previous cell ?
(A)
Shift + Tab
(B)
Ctrl + Tab
(C)
Tab
(D)
Alt +Tab
Answer:
(A)
42.
The first cell in EXCEL Worksheet is labled as
(A)
AA
(B)
Aa
(C)
A0
(D)
A1
Answer:
(D)
43.
From the given list which function is not part of excel function category ?
(A)
Date & time
(B)
Logical
(C)
Ghraphic
(D)
Text
Answer:
(C)
44.
In Excel when a cell is deleted the other cells move
(A)
Left or Down
(B)
Up or Left
(C)
Right or Up
(D)
Up or Down
Answer:
(B)
45.
In Excel, file menu has an option Print area. This feature provides option:
(A)
Set Print Pages and Clear Print Pages
(B)
Set Print Preview and Clear Print Preview
(C)
Set Printer and Clear Printer
(D)
Set Print area and Clear Print area
Answer:
(D)
46.
Which of the following is not a valid arithmetic operator?
(A)
Average Deviation
(B)
Subtraction
(C)
Multiplication
(D)
Exponentiation
Answer:
(A)
47.
Where one should click to select the entire column in Excel?
(A)
Column Heading
(B)
Last cell of the Column
(C)
First cell of the column
(D)
Formula bar
Answer:
(A)
48.
If you need help using Excel, you can type a question in the in the
upper-right corner of the window.
(A)
Office Assistant box
(B)
Ask Office box
(C)
Ask a Question box:
(D)
Help box
Answer:
(B)
49.
For calculation in a spreadsheet, you need to use a
(A)
filed
(B)
Formula
(C)
Variable
(D)
Table
Answer:
(B)
50.
Which of the following moves the insertion point to the previous cell?
(A)
Ctrl+Tab
(B)
Shift+Tab
(C)
Tab
(D)
Alt+ Tab
Answer:
(B)
51.
display the names of each sheet at the bottom of the file.
(A)
Sheet Tabs
(B)
Sheets Buttons
(C)
Sheets Sections
(D)
Sheet Titles
Answer:
(A)
52.
Which Menu is only available in MS Excel and not in MS Word?
(A)
Data
(B)
Window
(C)
File
(D)
Tools
Answer:
(A)
53.
Which of this tab in not part of page Setup Wizard?
(A)
Margin
(B)
Cell
(C)
Page
(D)
Sheet
Answer:
(B)
54.
Which command is used to select entire word sheet?
(A)
Ctrl+C
(B)
Ctrl+V
(C)
Ctrl+X
(D)
Ctrl+A
Answer:
(D)
55.
is the process of finding and correcting errors in a worksheet.
(A)
Fixing
(B)
Checking
(C)
Debugging
(D)
Editing
Answer:
(B)
56.
Which of the Following formulas will Excel Not be able to calculate?
(A)
SUM (Sales)-A3
(B)
SUM(A1:A5)*.5
(C)
SUM(A1:A5)/(10-10)
(D)
SUM(A1:A5)-10
Answer:
(C)
57.
In Excel , one workbook may contain more than one
(A)
Formula sheets
(B)
Worksheets
(C)
Web pages
(D)
Work pages
Answer:
(B)
58.
What chart object is a horizontal / vertical line extending across the plot
area aiding reading values
(A)
Grid Line
(B)
Category Axis
(C)
Data Marker
(D)
Data Point
Answer:
(A)
59.
Last number of row is ?
(A)
65536
(B)
100000
(C)
65535
(D)
65538
Answer:
(A)
60.
Adress of the first cell in the worksheet is
(A)
A1
(B)
A-1
(C)
ONE A
(D)
1A
(E)
C.
(F)
5
(G)
D.
(H)
10
Answer:
(A)
61.
If the following arithmetic operations all are found in a formula with no
paretheses, which one is completed late ?
(A)
/
(B)
^
(C)
*
(D)
.+
(E)
C.
(F)
5
(G)
D.
(H)
10
Answer:
(C)
62.
Which of the following methods can be used to edit the content of cell ?
(A)
Double clicking the cell
(B)
Pressing F2 key
(C)
Clicking the formula bar
(D)
Pressing the Alt key
(E)
C.
(F)
5
(G)
D.
(H)
10
Answer:
(D)
63.
In Excel what combination of command are used for cut and past ?
(A)
CTRL + C AND CTRL + V
(B)
CTRL + X And CTRL + V
(C)
CTRL + C AND CTRL + V
(D)
CTRL + C AND CTRL + P
(E)
C.
(F)
5
(G)
D.
(H)
10
Answer:
(B)
64.
How can you remove borders applied in cells?
(A)
Choose None on Border tab of Format cells
(B)
Open the list on Border tool in Format Cell toolbar then choose first
tool (none)
(C)
Both of above
(D)
None of above
(E)
C.
(F)
5
(G)
D.
(H)
10
Answer:
(C)
65.
Which is the correct formula?
(A)
#REF!+#REF!
(B)
AmCm
(C)
A9(B9
(D)
A7=a8
(E)
C.
(F)
5
(G)
D.
(H)
10
Answer:
(A)
66.
Microsoft Excel is a powerful ________
(A)
Word processing package
(B)
Spreadsheet package
(C)
Communication S/W Package
(D)
DBMS package
(G)
D.
(H)
10
Answer:
(B)
67.
_______, ________ and _______ are what you see when you open Excel
(A)
Columns, rows, and charts
(B)
Columns, rows, and formulas
(C)
Columns, rows, and cells
(D)
Non of the above
(G)
D.
(H)
10
Answer:
(C)
68.
Which of the following format you can decide to apply or not in AutoFormat
dialog box?
(A)
Number format
(B)
Border format
(C)
Font format
(D)
All of above
(G)
D.
(H)
column
Answer:
(D)
69.
WHICH OF THE FOLLOWING FORMULAS IS NOT ENTERED CORRECTLY?
(A)
A. =10+50
(B)
B. =B7*B1
(C)
C. =B7+14
(D)
D. 10+50
(G)
D.
(H)
Sorting
Answer:
(D)
70.
WHICH SYMBOL MUST ALL FORMULA BEGIN WITH?
(A)
A. =
(B)
B. +
(C)
C. (
(D)
D. @
(G)
D.
(H)
Filtering
Answer:
(A)
71.
WHAT SYMBOL IS USED BEFORE A NUMBER TO MAKE IT A LABEL?
(A)
A. ” (QUOTE)
(B)
B. = (EQUAL)
(C)
C. _ (UNDERSCORE)
(D)
D. ‘ (APOSTROPHE)
(G)
D.
(H)
Greater
Answer:
(D)
72.
THE AUTOSUM FEATURE
(A)
A. EXTENDS A SEQUENTIAL SERIES OF DATA
(B)
B. AUTOMATICALLY ADDS RANGE OF CELL VALUES
(C)
C. APPLIES A BOARDER AROUND THE SELECTED CELLS
(D)
D. NONE OF THE ABOVE
(G)
D.
(H)
$A$1, $A$2, etc.
Answer:
(B)
73.
TO COPY CELL CONTENTS USING DRAG AND DROP PRESS THE
(A)
A. END KEY
(B)
B. SHIFT KEY
(C)
C. CTRL KEY
(D)
D. ESC KEY
(G)
D.
(H)
AVERAGE
Answer:
(A)
74.
COMMENTS CAN BE ADDED TO CELLS USING
(A)
A. EDIT > COMMENTS
(B)
B. INSERT > COMMENTS
(C)
C. FILE > COMMENTS
(D)
D. VIEW > COMMENTS
(G)
D.
(H)
A > Sign
Answer:
(B)
75.
YOU CAN USE THE DRAG AND DROP METHOD TO
(A)
A. COPY CELL CONTENTS
(B)
B. MOVE CELL CONTENTS
(C)
C. ADD CELL CONTENTS
(D)
D. A AND B
(G)
D.
(H)
MIN
Answer:
(D)
76.
YOU CAN EDIT A CELL BY
(A)
A. CLICKING THE FORMULA BUTTON
(B)
B. DOUBLE CLICKING THE CELL TO EDIT IT IN-PLACE
(C)
C. SELECTING EDIT>EDIT CELL FROM THE MENU
(D)
D. NONE OF ABOVE
(G)
D.
(H)
Power Point
Answer:
(B)
77.
TO SAVE A WORKBOOK YOU:
(A)
A. CLICK THE SAVE BUTTON ON THE STANDARD TOOLBAR FROM THE MENU
(B)
B. PRESS CTRL+F5
(C)
C. CLICK SAVE ON THE WINDOWS START BUTTON
(D)
D. SELECT EDIT>SAVE
(G)
D.
(H)
Pivot
Answer:
(A)
78.
TO VIEW A CELL COMMENT
(A)
A. CLICK THE EDIT COMMENT COMMAND ON THE INSERT MENU
(B)
B. CLICK THE DISPLAY COMMENT COMMAND ON THE WINDOW MENU
(C)
C. POSITION THE MOUSE POINTER OVER THE CELL
(D)
D. CLICK THE COMMENT COMMAND ON THE VIEW MENU
(G)
D.
(H)
Dot Graph
Answer:
(C)
79.
IF YOU BEGIN TYPING AN ENTRY INTO A CELL AND THEN REALIZE THAT YOU DON’T
WANT YOUR ENTRY PLACED INTO A CELL
(A)
A. PRESS THE ERASE KEY
(B)
B. PRESS ESC
(C)
C. PRESS THE ENTER BUTTON
(D)
D. PRESS THE EDIT FORMULA BUTTON
(G)
D.
(H)
Cell
Answer:
(B)
80.
WITHOUT USING THE MOUSE OR THE ARROW KEYS WHAT IS THE FASTEST WAY OF
GETTING TO CELL A1 IN A SPREADSHEET?
(A)
A. PRESS CTRL +HOME
(B)
B. PRESS HOME
(C)
C. PRESS SHIFT + HOME
(D)
D. PRESS ALT + HOME
Answer:
(A)
81.
WHICH OF THE FOLLOWING OPTIONS IS NOT LOCATED IN THE PAGE SETUP DIALOG BOX?
(A)
A. PAGE BREAK PREVIEW.
(B)
B. PAGE ORIENTATION
(C)
C. MARGINS
(D)
D. HEADERS AND FOOTERS
Answer:
(A)
82.
WHICH OF THE FOLLOWING IS NOT A VALID DATA TYPE IN EXCEL
(A)
A. NUMBER
(B)
B. CHARACTER
(C)
C. LABEL
(D)
D. DATE/TIME
Answer:
(B)
83.
THE NUMBERS IN OUR WORKSHEET LOOK LIKE THIS: YOU WANT THEM TO LOOK LIKE
THIS: $1000.HOW CAN YOU ACCOMPLISH THIS?
(A)
A. NONE OF THESE
(B)
B. SELECT FORMAT > MONEY FROM THE MENU
(C)
C. CLICK THE CURRENCY STYLE BUTTON ON THE FORMATTING TOOLBAR
(D)
D. YOU HAVE TO RETYPE EVERYTHING AND MANUALLY ADD THE DOLLAR SIGNS
Answer:
(C)
84.
THE PASTE SPECIAL COMMAND LETS YOU COPY AND PASTE:
(A)
A. MULTIPLY THE SELECTION BY A COPIED VALUE
(B)
B. CELL COMMENTS
(C)
C. FORMATTING OPTIONS
(D)
D. THE RESULTING VALUES OF A FORMULA INSTEAD OF THE ACTUAL FORMULA
Answer:
(D)
85.
EXCEL FILES HAVE A DEFAULT EXTENSION OF
(A)
A. XLS
(B)
B. XLW
(C)
C. WK1
(D)
D. 123
Answer:
(A)
86.
AN EXCEL WORKBOOK IS A COLLECTION OF
(A)
A. WORKBOOKS
(B)
B. WORKSHEETS
(C)
C. CHARTS
(D)
D. WORKSHEETS AND CHARTS
Answer:
(D)
87.
YOU CAN COPY DATA OR FORMULAS
(A)
A. WITH THE COPY
(B)
B. WITH COMMANDS ON THE SHORTCUT MENU
(C)
C. WITH BUTTONS ON THE STANDARD TOOLBARS
(D)
D. ALL OF THE ABOVE
Answer:
(D)
88.
TO HOLD ROW AND COLUMN TITLES IN PLACE SO THAT THEY DO NOT SCROLL WHEN YOU
SCROLL A WORKSHEET CLICK THE
(A)
A. UNFREEZE PANES COMMAND ON THE WINDOW MENU
(B)
B. FREEZE PANES COMMAND ON THE WINDOW MENU
(C)
C. HOLD TITLES COMMAND ON THE EDIT MENU
(D)
D. SPLIT COMMAND ON THE WINDOW MENU
Answer:
(B)
89.
WHICH AREA IN AN EXCEL WINDOW ALLOWS ENTERING VALUES AND FORMULAS
(A)
A. TITLE BAR
(B)
B. MENU BAR
(C)
C. FORMULA BAR
(D)
D. STANDARD TOOLBAR
Answer:
(C)
90.
WHEN YOU LINK DATA MAINTAINED IN AN EXCEL WORKBOOK TO A WORD DOCUMENT
(A)
A. THE WORD DOCUMENT CANNOT BE EDIT
(B)
B. THE WORD DOCUMENT CONTAINS A REFERENCE TO THE ORIGINAL SOURCE
APPLICATION
(C)
C. THE WORD DOCUMENT MUST CONTAIN A HYPERLINK
(D)
D. THE WORD DOCUMENT CONTAINS A COPY OF THE ACTUAL DATA
Answer:
(B)
91.
IN A WORKSHEET YOU CAN SELECT
(A)
A. THE ENTIRE WORKSHEET
(B)
B. ROWS
(C)
C. COLUMNS
(D)
D. ALL OF THE ABOVE
Answer:
(D)
92.
HYPERLINKS CAN BE
(A)
A. TEXT
(B)
B. DRAWING OBJECTS
(C)
C. PICTURES
(D)
D. ALL OF ABOVE
Answer:
(D)
93.
MULTIPLE CALCULATIONS CAN BE MADE IN A SINGLE FORMULA USING
(A)
A. STANDARD FORMULAS
(B)
B. ARRAY FORMULA
(C)
C. COMPLEX FORMULAS
(D)
D. SMART FORMULA
Answer:
(B)
94.
YOU CAN USE THE HORIZONTAL AND VERTICAL SCROLL BARS TO
(A)
A. SPLIT A WORKSHEET INTO TWO PANES
(B)
B. VIEW DIFFERENT ROWS AND COLUMNS EDIT THE CONTENTS OF A CELL
(C)
C. EDIT THE CONTENTS OF A CELL
(D)
D. VIEW DIFFERENT WORKSHEETS
Answer:
(B)
95.
WHICH IS USED TO PERFORM WHAT IF ANALYSIS?
(A)
A. SOLVER
(B)
B. GOAL SEEK
(C)
C. SCENARIO MANAGER
(D)
D. ALL OF ABOVE
Answer:
(D)
96.
THE NAME BOX
(A)
A. SHOWS THE LOCATION OF THE PREVIOUSLY ACTIVE CELL
(B)
B. APPEARS TO THE LEFT OF THE FORMULA BAR
(C)
C. APPEARS BELOW THE STATUS BAR
(D)
D. APPEARS BELOW THE MENU BAR
Answer:
(B)
97.
WHEN A LABEL IS TOO LONG TO FIT WITHIN A WORKSHEET CELL
(A)
A. SHORTEN THE LABEL
(B)
B. INCREASE THE COLUMN WIDTH
(C)
C. DECREASE THE COLUMN WIDTH
(D)
D. ADJUST THE ROW HEIGHT
Answer:
(B)
98.
HOW CAN YOU FIND SPECIFIC INFORMATION IN A LIST?
(A)
A. SELECT TOOLS > FINDER FROM THE MENU
(B)
B. CLICK THE FIND BUTTON ON THE STANDARD TOOLBAR
(C)
C. SELECT INSERT > FIND FROM THE MENU
(D)
D. SELECT DATA > FORM FROM THE MENU TO OPEN THE DATA FORM DIALOG BOX AND
CLICK THE CRITERIA BUTTON
Answer:
(D)
99.
HOW DO YOU DELETE A COLUMN?
(A)
A. SELECT THE COLUMN HEADING YOU WANT TO DELETE AND SELECT THE DELETE ROW
BUTTON ON THE STANDARD TOOLBAR
(B)
B. SELECT THE COLUMN HEADING YOU WANT TO DELETE AND SELECT INSERT DELETE
FROM THE MENU
(C)
C. SELECT THE ROW HEADING YOU WANT TO DELETE AND SELECT EDIT>DELETE FROM
THE MENU
(D)
D. RIGHT CLICK THE COLUMN HEADING YOU WANT TO DELETE AND SELECT DELETE FROM
THE SHORTCUT MENU
Answer:
(D)
100.
TO CENTER WORKSHEET TITLES ACROSS A RANGE OF CELLS YOU MUST
(A)
A. SELECT THE CELLS CONTAINING THE TITLE TEXT PLUS THE RANGE OVER WHICH THE
TITLE TEXT IS TO BE CENTERED
(B)
B. WIDEN THE COLUMNS
(C)
C. SELECT THE CELLS CONTAINING THE TITLE TEXT PLUS THE RANGE OVER WHICH THE
TITLE TEXT IS TO BE ENFETTERED
(D)
D. FORMAT THE CELLS WITH THE COMMA STYLE
Answer:
(A)
101.
TO CREATE A FORMULA YOU FIRST:
(A)
A. SELECT THE CELL YOU WANT TO PLACE THE FORMULA INTO
(B)
B. TYPE THE EQUALS SIGN (=) TO TELL EXCEL THAT YOU’RE ABOUT TO ENTER A
FORMULA
(C)
C. ENTER THE FORMULA USING ANY INPUT VALUES AND THE APPROPRIATE
MATHEMATICAL OPERATORS THAT MAKE UP YOUR FORMULA
(D)
D. CHOOSE THE NEW COMMAND FROM THE FILE MENU
Answer:
(A)
102.
HOW CAN YOU PRINT THREE COPIES OF A WORKBOOK?
(A)
A. SELECT FILE>PROPERTIES FORM THE MENU AND TYPE 3 IN THE COPIES TO
PRINT TEXT BOX.
(B)
B. SELECT FILE >PRINT FROM THE MENU AND TYPE 3 IN THE NUMBER OF COPIES
TEXT BOX.
(C)
C. CLICK THE PRINT BUTTON ON THE STANDARD TOOLBAR TO PRINT THE DOCUMENT
THEN TAKE IT TO KINKO’S AND HAVE 2 MORE COPIES MADE
(D)
D. PRESS CTRL+P+3
Answer:
(B)
103.
HOW DO YOU SELECT AN ENTIRE COLUMN?
(A)
A. SELECT EDIT > SELECT > COLUMN FROM THE MENU
(B)
B. CLICK THE COLUMN HEADING LETTER
(C)
C. HOLD DOWN THE SHIFT KEY AS YOU CLICK ANYWHERE IN THE COLUMN.
(D)
D. HOLD DOWN THE CTRL KEY AS YOU CLICK ANYWHERE IN THE COLUMN
Answer:
(B)
104.
WHICH OF THE FOLLOWING IS NOT A BASIC STEP IN CREATING A WORKSHEET?
(A)
A. SAVE WORKBOOK
(B)
B. MODIFIY THE WORKSHEET
(C)
C. ENTER TEXT AND DATA
(D)
D. COPY THE WORKSHEET
Answer:
(D)
105.
HOW DO YOU INSERT A ROW?
(A)
A. RIGHT-CLICK THE ROW HEADING WHERE YOU WANT TO INSERT THE NEW ROW AND
SELECT INSERT FROM THE SHORTCUT MENU
(B)
B. SELECT THE ROW HEADING WHERE YOU WANT TO INSERT THE NEW ROW AND SELECT
EDIT >ROW FROM THE MENU
(C)
C. SELECT THE ROW HEADING WHERE YOU WANT TO INSERT THE NEW ROW AND CLICK
THE INSERT ROW BUTTON ON THE STANDARD TOOLBAR
(D)
D. ALL OF THE ABOVE
Answer:
(A)
106.
4. YOU CAN ACTIVATE A CELL BY
(A)
A. PRESSING THE TAB KEY
(B)
B. CLICKING THE CELL
(C)
C. PRESSING AN ARROW KEY
(D)
D. ALL OF THE ABOVE
Answer:
(D)
107.
WHICH OF THE FOLLOWING IS NOT A WAY TO COMPLETE A CELL ENTRY?
(A)
A. PRESSING ENTER
(B)
B. PRESSING ANY ARROW KEY ON THE KEYBOARD
(C)
C. CLICKING THE ENTER BUTTON ON THE FORMULA BAR
(D)
D. PRESSING SPACEBAR
Answer:
(D)
108.
WHICH OF THE FOLLOWING WILL NOT CUT INFORMATION?
(A)
A. PRESSING CTRL + C
(B)
B. SELECTING EDIT>CUT FROM THE MENU
(C)
C. CLICKING THE CUT BUTTON ON THE STANDARD
(D)
D. PRESSING CTRL+X
Answer:
(A)
109.
WHICH OF THE FOLLOWING METHODS CANNOT BE USED TO ENTER DATA IN A CELL
(A)
A. PRESSING AN ARROW KEY
(B)
B. PRESSING THE TAB KEY
(C)
C. PRESSING THE ESC KEY
(D)
D. CLICKING ON THE FORMULA BAR
Answer:
(C)
110.
AN EXCEL FILE IS GENERALLY CALLED A / AN :
(A)
E-SPREADSHEET
(B)
WOORKSHEET
(C)
WORKBOOK
(D)
SHEET
Answer:
(C)
111.
THE BASIC UNIT OF A WORKSHEET INTO WHICH YOU ENTER DATA IN EXCEL IS CALLED
A
(A)
CELL
(B)
TABLE
(C)
BOX
(D)
COLUMN
Answer:
(A)
112.
ROWS ARE LABELLED AS ______ IN EXCEL
(A)
A,B,C ETC
(B)
1.2.3 ETC
(C)
A1,A2,ETC
(D)
$A$1, $A$2, ETC
Answer:
(B)
113.
THE ____ FEATURE OF MS EXCEL QUICKLY COMPLETES A SERIES OF DATA
(A)
AUTO COMPLETE
(B)
AUTO FILL
(C)
FILL HANDLE
(D)
SORTING
Answer:
(B)
114.
THE PROCESS OF ARRENGING THE ITEMS OF A COLUMN IN SOME SEQUENCE OR ORDER IS
KNOWN AS :
(A)
ARRENGIN
(B)
AUTOFILL
(C)
SORTING
(D)
FILTERING
Answer:
(C)
115.
THE GREATER THAN SIGN (>) IS AN EXAMPLE OF _____ OPERATOR.
(A)
ARITHMATIC
(B)
LOGICAL
(C)
CONDITIONAL
(D)
GREATER
Answer:
(B)
116.
IN EXCEL COLUMNS ARE LABELLED AS ___ .
(A)
A,B,C ETC
(B)
1.2.3 ETC
(C)
A1,A2,ETC
(D)
$A$1, $A$2, ETC
Answer:
(A)
117.
WHICH FUNCTIONIN EXCEL CHECKS WHETHER A CONDITION IS TRUE OR NOT ?
(A)
SUM
(B)
COUNT
(C)
IF
(D)
AVERAGE
Answer:
(C)
118.
FUNCTIONS IN MS EXCEL MUST BEGIN WITH ___
(A)
AN () SIGN
(B)
AN EQUAL SIGN
(C)
A PLUS SIGN
(D)
A > SIGN
Answer:
(B)
119.
WHICH ONE IS NOT A FUNCTION IN MS EXCEL ?
(A)
SUM
(B)
AVG
(C)
MAX
(D)
MIN
Answer:
(B)
120.
A FEATURES THAT DISPLAYS ONLY THE DATA IN COLUMN (S) ACCORDING TO SPECIFIED
CRITERIA
(A)
FORMULA
(B)
SORTING
(C)
FILTERING
(D)
PIVOT
Answer:
(C)
121.
WHICH FUNCTIONIN EXCEL TELLS HOW MANY NUMERIC ENTRIES ARE THERE ?
(A)
NUM
(B)
COUNT
(C)
SUM
(D)
CHKNUM
Answer:
(B)
122.
WHAT TYPE OF CHART IS USEFUL FOR COMPARING VALUES OVER CATEGORIES ?
(A)
PIE CHART
(B)
COLUMN CHART
(C)
LINE CHART
(D)
DOT GRAPH
Answer:
(B)
123.
WHAT IS THE INTERSECTION OF A COLUMN AND A ROW ON A WORKSHEET CALLED ?
(A)
COLUMN
(B)
VALUE
(C)
ADDRESS
(D)
CELL
Answer:
(D)
124.
WHICH OF THE FOLLOWING SYNTAX IS CORRECT REGARDING TO SUM FUNCTION IN
EXCEL?
(A)
A. =SUM (A1
(B)
B. =SUM (A1:B9)
(C)
C. =SUM (A1:A9
(D)
D. ALL OF THE ABOVE
Answer:
(B)
125.
TO SHOW/HIDE THE GRID LINES IN MICROSOFT EXCEL 2007
(A)
A. PAGE LAYOUT -> GRID LINES -> VIEW
(B)
B. INSERT -> GRID LINES -> VIEW
(C)
C. VIEW -> GRID LINES -> VIEW
(D)
D. EDIT -> GRID LINES -> VIEW
Answer:
(A)
126.
IN EXCEL BY DEFAULT NUMERIC VALUES APPEARS IN
(A)
A. LEFT ALIGNED
(B)
B. RIGHT ALIGNED
(C)
C. CENTER ALIGNED
(D)
D. JUSTIFY ALIGNED
Answer:
(B)
127.
“NEW COMMENT” OPTION CAN BE FOUND UNDER _________ TAB
(A)
A. INSERT
(B)
B. DATA
(C)
C. REVIEW
(D)
D. VIEW
Answer:
(C)
128.
IN MAXIMUM HOW MANY SHEETS CAN BE SET AS DEFAULT WHILE CREATING NEW
WORKBOOK?
(A)
A. 254
(B)
B. 255
(C)
C. 256
(D)
D. NO LIMIT
Answer:
(B)
129.
WHICH ONE IS THE LAST COLUMN HEADER IN EXCEL 2007?
(A)
A. XFD
(B)
B. XFX
(C)
C. XFL
(D)
D. XFT
Answer:
(A)
130.
WHAT IS THE SHORTCUT KEY TO INSERT NEW SHEET IN CURRENT WORKBOOK?
(A)
A. F11
(B)
B. ALT + F11
(C)
C. CTRL + F11
(D)
D. SHIFT + F11
Answer:
(D)
131.
12-2. WHICH OPTION ALLOWS YOU TO BOLD ALL THE NEGATIVE VALUES WITHIN THE
SELECTED CELL RANGE:
(A)
A. ZERO FORMATTING
(B)
B. CONDITIONAL FORMATTING
(C)
C. COMPARE FORMATTING
(D)
D. NEGATIVE FORMATTING
Answer:
(B)
132.
WHAT IS THE SHORTCUT KEY TO INSERT A NEW COMMENT IN A CELL?
(A)
A. F2
(B)
B. ALT + F2
(C)
C. CTRL + F2
(D)
D. SHIFT + F2
Answer:
(D)