MS Excel 2000 Test
This
question is based upon the figure shown below
The
figure shows an Excel worksheet. If you want to freeze the row showing the
months (row 1) and the column showing the products (column A), what should you
do?
a. Select
the cells A2 to A6 and cells B1 to F1 and click on Freeze Panes under the menu
Window->Freeze Panes
b. Select
the cell B2 and click on Freeze Panes under the menu Window->Freeze Panes
c. Select
the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes
d. Select
the cells F1 and A6 and click on Freeze Panes under the menu Window->Freeze
Panes
e. None of the above
You
define a print area in your worksheet, but later you select a smaller range of
cells to print and then click Selection under the menu File->Print->Print
What->Selection. What will happen?
a. The
print area will be printed
b. The selected area will be printed
c. Excel
will prompt you to de-select the selected area
This
question is based upon the figure shown below
The
figure shows a view of the Standard Toolbar. What function is performed by the
button marked by the letter 'Y'?
a. It
calculates the mean deviation of the numbers in the selected cells
b. It
calculates the average value of the selected numbers
c. It adds up the values in the selected
cells
d. It
merges the selected cells
This
question is based upon the figure shown below
Which
toolbar is shown in the figure?
a. Forms toolbar
b. Standard
toolbar
c. Formatting
toolbar
d. Chart
toolbar
e. WordArt
toolbar
This
question is based upon the figure shown below
The
figure shows a view of the Standard Toolbar. What function is performed by the
button marked by the letter 'J'?
a. It
calculates the mean deviation of the numbers in the selected cells
b. It
calculates the average value of the selected numbers
c. It
adds up the values in the selected cells
d. It displays a list of functions and allows
you to set values
How
can you select all the blank cells in your worksheet?
a. This must be done manually as it is not
automated through any built-in feature
b. Choose
Edit->Select->Blank under the main menu
c. Choose
blank in the Edit->Go To->Special menu option
d. Choose
blank in the View->Go To->Special menu option
State
whether True or False.
When
you clear the contents from a cell, the formatting of the cell is also lost.
a. True
b. False
This
question is based upon the figure shown below
The
figure shows the Calculation tab under the Tools->Options menu. The option
under Calculation has been checked as Automatic. What does this mean?
a. Excel
will calculate the values for all formulas entered into cells when you click
Calc Now on the calculation tab
b. Excel
will automatically calculate the values for all formulas before saving
c. Excel will automatically calculate the
values for all formulas as you change the values within cells
In
Microsoft Excel, you select the row headings 10, 11 and 12 and then choose the
menu option Insert -> Rows. What will happen?
a. 3
new rows will be inserted after row 12
b. 1
new row will be inserted after row 12
c. 3 new rows will be inserted after row 9
d. 1
new row will be inserted after row 9
What
value is displayed if the formula =2+"$9.00" is entered into a cell?
a. $11
b. 11
c. 2+$9.00
d. $11.00
Which
of the following are appropriate date format when you want to enter data into a
cell in Microsoft Excel?
a. 2/3/2003
b. 6-aug-2003
c. 5th-aug-2003
d. 5-8-03
This
question is based upon the figure shown below
The
figure shows a view of the Standard Toolbar. What function is performed by the
button marked by the letter 'A'?
a. It
is used to publish the worksheet on a web browser for viewing over the Internet
b. It
is used to make the worksheet universally shareable
c. It is used to add a hyperlink
This
question is based upon the figure shown below
The
figure shows an Excel worksheet. You are about to create a new column called
Avg Sales in column G which will display the average sales for Jan to April.
Which of the following are correct formulas for cell G2?
a. =sum(avg(B2.E2))
b. =sum(B2-E2)/4
c. =sum(B2.E2)/4
d. =sum(F2/4)
What
is the quickest way to select all the columns of a worksheet in Microsoft
Excel?
a. Click
on the column heading of the first column, press Shift, and then click on the column
heading of the last column
b. Click
on the column heading of the first column, press Ctrl, and then click on the
column heading of the last column
c. Choose
Edit->Select all from the main menu
d. Click on the gray rectangle on the upper
left corner of the worksheet where the column headings and row headings meet
Which
of the following statements about the AutoCorrect feature in Excel are correct?
a. It
can suggest other words for the word you are typing
b. It
can correct two initial capitals
c. It can
correct common typing errors as you type
d. It can capitalize the first letter of the
sentence
State
whether True or False.
We
can change the color of the worksheet tabs in our workbook?
a. True
b. False
How
does the AutoComplete feature in Excel help you save time?
a. It automatically completes abbreviated
words
b. It
completes text and numeric entries that match an existing entry in the same
column
c. It
completes text entries that match an existing entry in the same worksheet
d. It
completes text entries that match an existing entry in the same column
You
are making a sales performance report in Excel which you would like to present
to the top management. Some of the column headings are too large and look out
of place in their cells. You decide to display the headings as slanted text to
save space.How can this be achieved?
a. By
selecting Slanted Text on the Font tab
b. By
altering the Text Orientation on the Alignment tab
c. By
selecting Superscript on the Font tab
d. By
choosing Center Across selection on the Alignment tab
Which
of the following statements is true if the cell B1 contains the formula =$A$1?
a. The
value of cell B1 contains the same number of characters as the value of cell B2
b. There
is an absolute reference to cell A1 so that the formula =$A$1 can be copied to
other cells without changing the reference to A1
c. There
is a relative reference to cell A1 so the formula will change each time it is
copied to other cells
d. The value of cell B1 is equal to the value
of the function in cell A1
This
question is based upon the figure shown below
The
figure shows the Text to Column menu option. What function does it perform?
a. It
allows you to add comma separated text into various cells automatically
b. It converts the selected text to a table
c. It
automatically resizes the cell size whenever a large text is added to the cell
What
should you add before a fraction to avoid entering it as a date, e.g. 1/3, in
Excel?
a. F
b. //
c. 0 (zero)
d. FR
e. =
If
you enter a Part Number for a product in Excel e.g. 6776736, and want Excel to
treat it as text and not a number, what should you do?
a. Place
the character T before the number e.g. T6776736
b. Place
the characters TX before the number e.g. TX6776736
c. Enclose
the number is brackets e.g. (6776737)
d. Apply
the Text Format to empty cells, and then type the numbers
Which
of the following statements about the AutoFormat feature in Excel are correct?
a. AutoFormat
can help you automatically convert your numerical data into graphs
b. AutoFormat
can automatically capitalize the first letters of the text you enter into cells
c. AutoFormat
resizes your Excel worksheets so that they become easy to print
d. AutoFormat applies a distinctive format to
the various elements in the range on a worksheet.
This
question is based upon the figure shown below
The
figure shows a view of the Standard Toolbar. What function is performed by the
button marked by the letter 'Z'?
a. It
is used to add a background color to the selected cell
b. It
is used to add a colored boundary around the selected cell
c. It copies the format of a selected cell
for applying to another cell
d. It
deletes the values of all the selected cells
You
would like to restrict the values that can be entered into a cell so that only
whole numbers between 1 and 100 can be entered. Which option in the menu allows
you to accomplish this?
a. The Settings tab under the menu
Data->Validation
b. The
Settings tab under the menu Data->Filter->Advanced Filter
c. The
Settings tab under the menu Format->Cells
d. The
Settings tab under the menu Format->Conditional Formatting
This
question is based upon the figure shown below
The
figure shows the AutoFit Selection menu option. What function does it perform?
a. It
automatically resizes the column width to the minimum necessary to fit the
contents of the selected cell
b. It
automatically resizes the column height to the minimum necessary to fit the
contents of the selected cell
c. It automatically resizes the column height
and width to the minimum necessary to fit the contents of the selected cell
d. It
automatically compacts the text to fit into the original column size
What
is conditional formatting used for? (It is available under the menu
Format->Conditional Formatting)
a. It can format a cell depending upon
whether the cell contains text or numeric characters
b. It
can format a cell depending upon the size of content in the cell
c. It
can format a cell depending upon values of the content in the cell
d. It
can format a cell depending upon the results of a function
This
question is based upon the figure shown below
The
figure shows an Excel worksheet. What does the red triangle in cell C2 signify?
a. The
cell is locked
b. The
data entered in the cell will be validated to see if it matches the criteria
set
c. The
cell has been marked so that it can be referred to in case of need
d. There is a comment associated with the
cell
You
have a worksheet that contains the first names of customers in column A and
last names in column B. You want to enter a formula in column F that combines
the first name and the last name and at the same time want to ensure that there
is a space between the first and the last name. What would the correct formula
be
a. =A1 & " " & B1
b. =A1
&" "& B1
c. =A1
+ " " + B1
d. =A1
& SPC & B1
Which
of the following formats will you use to enter the time, 3 P.M., in a cell?
a. 3:00
b. 3:00
PM
c. 3:00
P
d. 3:00PM
What
Function does the ‘Compare Side by Side With’ command on the window menu
perform?
Ans: It
allows you to scroll through two or more workbooks simultaneously
Which
of the following functions would return a value of 8?
Ans:
round(8.4999,0)
Which
of the following function you will use to find the highest number in a series
of numbers?
Ans:
MAX(B1:B3)
State
Whether True or false.
Ans:
True
This
question is based upon the figure bellow
What
does the purple triangle at the bottom right corner of the cell signify?
Ans:
Smart Tag
What
should you add before a fraction to avoid it as a date, e.g.1/3, in Excel?
Ans:
You
start Microsoft Excel and you do not want it to automatically run a macro upon
starting. What will you do?
Ans:
Hold down the CTRL key during startup
Which
of the following options would be used if you need to insert a
77889867810070809 number in a cell?
Ans:
Apply the Text Format to empty cells, and then type the numbers
Suppose
the value in cell A1 is John and B1 is Smith then which of the following
function you will use to get the John_Smith in C1 cell?
Ans:
A_B
Which
of the following errors appears when an invalid argument is passed while
converting a number from one number system to another system?
Ans:
#N/A
Which
of the following function you will use to find the highest number in a series
of numbers?
Ans:
MAX(B1:B3)
You
have entered 4/6 as data in a cell without applying any formats to it. By
default, Excel will treat this data entry as a:
Ans:
Date]
What
will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it
is applied to the data series given below?
Ans:
#N/A
AutoFilter
drop-downs are automatically added in the header row of a list when the list is
created.
Ans:
TRUE
A
relative cell reference changes when a formula is copied or moved to other
locations.
Ans:
True
If
cell entries are changed, the formula will automatically recalculate the values
and insert the result in the cell containing the formula.
Ans:
True
The
Merge button on the Formatting toolbar will merge selected cells and right
align data within the cells.
Ans:
False
To
move the insertion point down to the next cell, press:
Ans:
Enter
To
insert a row, click Insert and then Rows
Ans:
True
The
Split option causes the worksheet to be split into two window panes.
Ans:
False
A
column is inserted immediately to the left of the column containing the active
cell unless you choose otherwise
Ans:
True
To
delete a specific cell as well as the text within it, make the cell active and
then
Ans:
click Edit and then Delete
To
apply page numbering to a worksheet page, which option in the Page Setup dialog
box should you choose
Ans:
Header/Footer
If a
function is included in an argument within a function, it is called a
Ans:
Nested Function
Selected
cells and cell contents can be moved or copied within a worksheet but not
between worksheets.
Ans:
False
Time
in a cell in Excel is stored as a decimal fraction representing a portion of
the day
Ans:True
You
can double-click a chart element to display the appropriate formatting dialog
box.
Ans:
True
You
can change the size of an image by using the white sizing handles.
Ans:
True
To
make the image taller or shorter, use the middle sizing handle at the left or
right side of the image.
Ans:
False
Which
of the following is not a tab on the Chart Options dialog box?
Ans:
Patterns
What
will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it
is applied to the data series given bellow?
B1:27
B2:22
B3:28
B4:21
Ans: 0
How
can you select all the blank cells in your worksheet?
Ans:
Choose blank in the Edit->Go to->special Menu option
The
question is based upon the figure shown
You
have entered test in a cell which is too big for the cell. You want the text to
appear in multiple lines inside the same cell. What will you do?
Ans:
Use the wrap txt option in the Format->Cells>Alignment Menu
You
have created a worksheet which consists a confidential data. You want that
these values, although present in the worksheet, should remain hidden and as a
result the cells containing this data should appear blank in the worksheet.
Which method will help you do this?
Ans:
Select the cells, open the Window menu and click on Hide
You
select the row headings 10, 11 and 12 and then choose the menu option
Insert->Rows. What will happen?
Ans: 3
new rows will be inserted after row 9
Which
of the following statements regarding the QUARTILE function is not true?
Ans:
The function MEDIAN(array) and QUARTILEarray,2) will return different values
when applied to the same array.
You
have entered 4/6 as data in a cell without applying any formats to it. By
default, Excel will treat this data entry as a:
Ans:
Date
This
question is based upon the figure shown below
What
will be the value in the cell C2 as shown in the figure when we use formula = A2+B2?
Ans:
120
The
figure shows an Excel worksheet. If you want to F the row showing the months
(row 1) and the column showing the products (column A), what should you do?
Ans:
Select the cell A1 and click on Freeze Panes under the menu Window->Freeze
Panes
Which
of the following functions would return a value of 8?
Ans: b
and c
The
figure shows a view of the Drawing Toolbar. What function is performed by the
button marked by the letter X ?
Ans: It
inserts a Diagram or Organization Chart in the worksheet
When
using Document Workspaces, you cannot work directly on the Document Workspace
copy, but you can work on your own copy which you can update periodically with
changes that have been saved to the copy on the Document Workspace site.
Ans:
TRUE
What
does the NOW() function returns?
Ans:
Returns the serial number of the current date and time
The
multiplication arithmetic operator is represented by which of the following
symbols
Ans: *
You
can select the current row by pressing
Ans:
Shift + Spacebar
Donelp
you do this?
Ans:
Select the cells, open the Window menu and click on Hide
You
define a print area in your worksheet, but later you select a smaller range of
cells to print and then click Selection under the menu File->Print->Print
What->Selection. What will happen?
Ans:
The selected area will be printed
The
cell range A3 through G3 should be keyed in as:
Ans:
A3:G3
A
document created in Excel is referred to as a
Ans:
workbook
Use
this handle to automatically insert the next month in the series, January:
Ans:
Fill
Which
of these operators are in the correct order of operations?
Ans:
^,*,-
To
select nonadjacent cells, columns, or rows, you must
Ans:
hold down the Ctrl key while clicking column, row header, or specific cells
When
copying selected cells to a new location, you must position the mouse pointer
on any border around the selected cells until it turns into a(n)
Ans:
arrow pointer
When
data is linked, a change made in a linked cell is automatically made to other
cells in the link.
Ans:
True
An
Excel workbook saved in HTML format allows Internet or intranet users to have
access to workbook data even if they do not have Excel installed
Ans:
True
Once
the chart is created, data can only be changed in a chart located in the same
worksheet as the changed cells
Ans:
False
Certain
chart elements automatically inserted in a chart created by Chart Wizard
include a chart legend, labels for the x-axis and y-axis, and a chart title
Ans:
False
A
worksheet is an individual page or tab in the workbook.
Ans:
True
You
can copy cell formats from one cell to another by using the
Ans:
Format Painter
Which
of the following errors appears when an invalid argument is passed while
converting a number from one number system to another system?
Ans:
#N/A
Suppose
the value in cell A1 is John and B1 is Smith then which of the following
function you will use to get John_Smith in Cell C1?
Ans: =
A1&”_”&B1
Which
of the following date and time function will you use to return the serial
number of the last day of the month before or after specified number of months?
Ans: EOMONTH
Which
of the following shortcuts can be used to insert a new line in the same cell?
Ans:
Alt+Enter
What
does the NOW() function returns?
Ans:
Returns the serial number of the current date and time
A
smart tag will be removed from a cell whenﾅﾅﾅﾅﾅﾅ.
Ans:
The data in the cell is changed or deleted
You
have created a worksheet which consists of confidential data. You want that
these values, although present in the worksheet, should remain hidden and as a
result the cells containing this data should appear blank in the worksheet.
Which method will help you do this?
Ans:
Select the cells, open the Window menu and click on Hide
Which
of the following Date and Time function you will use to return the serial
number of the last day of the month before or after a specified number of
months?
Ans:
DATEVALUE
By
default, how is text horizontally aligned inside a cell in Excel?
Ans:
Left aligned
When
using the AutoFill handle to quickly fill a range of cells with the same or
consecutive data, the cells need not be adjacent as long as they are within the
same sheet.
Ans:
False
When
the AutoSum button is clicked, Excel first looks for a range of numbers above
the active cell.
Ans:
True
If
the text you entered into a cell does not fit, Excel will display ##### to
indicate that the text is too long
Ans:
True
By
default, data in a cell is centered
Ans:
False
When
a new row is added into an Excel worksheet, by default, this row will be
inserted just below the active cell.
Ans:
True
Which
of the following is an absolute cell reference
Ans:
$B3
The
gridlines that appear on your worksheet will print as displayed.
Ans:
False
The
FV function is used to calculate the future value of an investment based on a
periodic constant payment and interest rate
Ans: True
The
PMT function is used to calculate a loan payment based on a variable interest
rate, payment, and the time period.
Ans:
False
If
you want row and column headings to print, which tab do you click from the Page
Setup dialog box?
Ans:
Header/Footer
A
new workbook initially contains this many sheets
Ans:
Three
This
chart is the default chart
Ans:
Column Chart
Which
of the following displays the contents of the active cell?
Ans:
Formula bar
