MS Excel 2007 Test
How
will you reverse the direction of a SmartArt graphic?
a.
Right-click on the SmartArt graphic, select Reverse
b.
Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
c. Under SmartArt Tools, on the Design tab,
in the Create Graphic group, click on Right to Left
d. All
of the above
Which
of the following is not a valid file extension in which an Excel file can be
saved'?
a. XLSB
b. XLSM
c. XLSX
d. All of the above are valid
This
question is based upon the figure shown below
Refer
to the given image what is the purpose of the cell denoted as 'A' in the
worksheet?
a. It selects all the cells in the worksheet
b. It
selects a large range of cells in the worksheet
c. It
selects non-adjacent cells in the worksheet
d. It
selects an entire row in the worksheet
Which
of the following is a default method of a PivotTable report for scoping the
conditional format of fields in the values area?
a. By
selection
b. By
corresponding field
c. By value field
d. By
number field
Which
database function estimates variance based on a sample from selected database
entries'?
a.
DSTDEV
b. DSUM
c. DVAR
d.
DVARP
Which
of the given methods would you follow to add an alternative text to a picture?
a. Right-click on the picture, click on Size
and Properties Click on the Alt text tab, and then in the alternative text box,
enter your text
b.
Right-click on the picture, click on Format Click on the Alt text tab, and then
in the alternative text box, enter your text
c. Both
a and b
d. None
of the above
How
would you assign a Macro to a graphic?
a. On
the Developer tab, in the Controls group, select Macro name
b. On the View tab, click on Macros and then
click 'Assign Macro' on the shortcut menu In the Macro name box, click on the
macro that you want to assign
c. On a
worksheet, right-click on the graphic, then click 'Assign Macro'" on the
shortcut menu In the Macro name box, click on the macro that you want to assign
d. All
of the above
State
whether true or false
Deleting
the PivotChart report automatically deletes the associated PivotTable report
a. True
b. False
How
will you find cells with data validation?
a. On
the Home tab, in the Editing group, click the arrow next to Find & Select,,
then click Go To Special Click on Data Validation, and then click All
b. On the View tab, in the Windows group,
click Data Validation
c. Both
a and b
d. None
of the above
Which
of the following is not true regarding naming a cell'?
a. Names are case sensitive
b. A
name can contain up to 255 characters
c.
Names can contain uppercase and lowercase letters
d. Some keyboard characters can cause
unexpected results if used in cell names
Which
of the given Document properties includes both file system properties and
statistics that are maintained by Office programs for the user?
a. Automatically updated properties
b.
Standard properties
c.
Custom properties
d.
Properties for the organization
Which
Consolidate option would you choose when you want to arrange the data in all
the worksheets in identical order and location?
a. Consolidate by position
b.
Consolidate by category
c.
Consolidate by formula
d. None
of the above
State
whether true or false
No
data is deleted when an outline is hidden or removed
a. True
b.
False
State
whether true or false
Case-sensitive
sorting of text in Excel2007 can be performed
a. True
b.
False
This
question is based upon the figure shown below
Refer
to the given image Which formula should be written on the given table to
display "Nancy Davolio"?
a.
=UPPER(A2)
b.
=L0WER(A2)
c. =PR0PER(A2)
d. None
of the above
State
whether true or false
A
Macro project can be digitally signed
a. True
b.
False
Where
can the 'Show All Comments' command be found?
a. On the Page Layout tab
b. On
the View tab
c. On
the Review tab
d. All
of the above
This
question is based upon the figure shown below
What
is the purpose of using the Keep text flat option, as shown in the picture?
a. It
prevents the text inside the WordArt from rotating when rotate- WordArt is
rotated
b. It prevents the text from blurring
c. It
moves the WordArt or text backward
d. Both
b and c
This
question is based upon the figure shown below
Refer
to the given image What will be the result if the formula =B3&",
"&A3 is applied on the given table?
a. It
will display Nancy Davoho
b. It will display Fuller Andrew
c. It
will display Fuller, Andrew
d. Both
b and c
Which
of the following is not true regarding column widths?
a. If
the column width is set to 0,the column is hidden
b. A column width between 0 to 255 can be
specified
c. The
default column width is 8 43 characters
d. All
of the above are true
This
question is based upon the figure shown below
What
would be the result, when =T(A4) is applied on the given table?
a. The
text True is returned
b. The
text Rainfall is returned
c.
Empty text is returned
d. None
of the above
State
whether true or false
If a
SmartArt graphic was converted to individual shapes, it is not possible to
convert them back to the SmartArt graphic
a. True
b.
False
This
question is based upon the figure shown below
Which
of the following options should be used to create a connection to a shared
network folder, as shown in the picture?
a. A
b. B
c. C
d. D
State
whether true or false
When
you freeze panes, you select specific rows or columns that remain visible when
scrolling in the worksheet?
a. True
b.
False
How
will you display the Go To dialog?
a. You
will press F4
b. You will press F5
c. You
will press F6
d. You
will press F7
This
question is based upon the figure shown below
What
does the red icon indicate, as shown in the given picture?
a. It
tells the user that macro is enabled
b. It tells the user that the document
contains Signatures
c. It
tells the user that macro is disabled
d. None
of the above
Which
of the following charts have no axes?
a.
Doughnut charts
b. Pie
charts
c. Both a and b
d. None
of the above
This
question is based upon the figure shown below
Refer
to the given image Which line style option should be used to specify the style
used for the end of the line?
a. A
b. B
c. C
d. D
Which
method will you use to update table data from a Share point list?
a. On
the Data tab, in the Data Tools group, click Refresh
b. On
the View tab, in the Show/Hide group, click Refresh
c. On the Design tab, in the External Data
group, click Refresh
d. None
of the above
How
would you locate the last filled cell on a worksheet?
a.
Click anywhere in the worksheet, and then press CTRL+HOME
b.
Click anywhere in the worksheet, and then press CTRL+INSERT
c. Click anywhere in the worksheet, and then
press CTRL+END
d. None
of the above
How
should blank cells be inserted on a Worksheet?
a.
Select the cell or the range of cells Then on the Home tab, in the Cells group,
click Insert Cells'
b.
Select the cell or the range of cells Then right-click on the selected cells
and click on Insert in the shortcut menu
c. Both a and b
d. None
of the above
Which
chart displays axes but cannot display axis titles'?
a.
Radar chart
b.
Doughnut chart
c. Pie chart
d. All
of the above
This
question is based upon the figure shown below
Refer
to the given picture Which option causes the last row in the table to appear
and displays the word Total in the leftmost cell?
a. A
b. B
c. C
d. D
How
would you selection entire PivotTable report?
a. On
the Home tab, in the Editing group, select the 'Entire PivotTable' option
b. On the Options tab, in the Actions group,
click on Select, and then click 'Entire PivotTable'
c. On
the Analyze tab, in the Data group, click on 'Select Entire PivotTable' option
d. None
of the above
Which
scoping method should be used to conditionally format a set of fields in the
values area for all levels in the hierarchy of data?
a.
Scoping by selection
b. Scoping by corresponding field
c.
Scoping by value field
d. All
of the above
Which
keyboard shortcut should be used to enter the current time in a cell in an
excel sheet using a QWERTY computer keyboard?
a.
CTRL+SHIFT+"
b. CTRL+SHIFT+
c.
CTRL+,
d. None
of the above
State
whether true or false
When
you sign the stamp signature line in an Office document, you add both a visible
stamp and a digital signature.
a. True
b.
False
Which
of the following is not true about the Watch Window?
a. The
Watch Window makes it convenient to inspect, audit, or confirm formula
calculations
b. When
cells are not visible on the worksheet, those cells and their formulae can be
seen in the Watch Window
c. There can be two Watch Windows per cell
When
'a' or 'p' is not typed after the time in Worksheet cells, what does Excel
enter the default time as?
a. It
displays the prompt box and asks the user to type 'a' or 'p'
b. It
displays an error message
c. It
enters the time as PM
d. It enters the time as AM
e. None
of the above
This
question is based upon the figure shown below
Which
Chart type is displayed in the given picture?
a. A
stock chart
b. A
surface chart
c. An XY (Scatter) chart