83. What symbol is used to enter number as text?....
(b) "
(d)
84. Data can be arranged in ascending or descending order by
using..
(a) Sort command from Table menu
Sort command from Data menu
(c) Sort command from Tools menu
(d) None of these
85. Which of the following is concatenating operator?
ta) Apostrophe (") (b) Exclamation (!)
Ampersand (&) (d) Hash (#)
86. Red triangle at the top right corner of a cell
indicates...
(a) There is an error in the cell
associated with the cell
There is a comment
(c) The font color of the text in cell is red
(d) The cell can't accept formula
87 Cell E23 has a date value and you wish to place that date
on an invoice preface with the text located in B15. What is the
command to do that? (a)-B15&E23
dd.yyyy")
PROPER(B15)&&text(E23,"mmmm
(d) -join(B15&E23)
(c) B15&&E23
88. How many sheets are there in Excel Workbook by default?
(a) 23 (c) 4 (d) 5
89. Which of the following component displays the
contents of active cell? (a) Name box
ch) ftatuc har
92.The process of identifying specific rows and columns so
that certain columns and rows are always visible on the screen
is called......
freezing
(b) locking
(c) selecting (d) fixing
93. To keep specific rows and columns from scrolling off the
screen you first must position the cell pointer.
(a) to the right of the column you want to remain on the screen
(b) below the tow you want to remain on the screen
(c) on the row you want to remain on the screen
both below and right of the row and column you want to
remain on the screen
94.If you requere more than two conditions or if you want to
analyze a list osing Excel 2003's database functions, you must
define which filter
(a) Auto Filter
(b) Update Filter (c) Advantage Filter
Advanced Criteria Filter
95. A quick way to return to a specific area of a worksheet is
(b) Formula bar
to type in the
(c) Zoom box
(d) None of these
Name box
96. Which keboard shortcut opens the Go To dialog box
(a) Ctrl + B
(0) F25
(b) Ctrl+Shift+B
97. Which of these terms do we use when an image in a clip
art changes the direction that it was originally facing?
c. Flip d. Group
a. Mirror
Rotate
98. Which of these refers to the PowerPoint view used for
displaying only the text (title and bullets)?
a. Slide sorter show
Outline view
b. Slide view
d. Notes page view