ADVANCE EXCEL

1.   Subtract the Following---->46 liter 200 ml - 38 liter 750 ml
(A)   7 liter 350 ml
(B)   7 liter 650 ml
(C)   7 liter 550 ml
(D)   7 liter 450 ml
Answer:    (D)
2.   Subtract the Following---->35 kg 150 g - 26 kg 470 g
(A)   8 kg 680 gm
(B)   8 kg 480 gm
(C)   8 kg 180 gm
(D)   8 kg 780 gm
Answer:    (A)
3.   Subtract the Following---->40 km 255 m - 17 km 960 m
(A)   22 km 260 m
(B)   22 km 160 m
(C)   22 km 265 m
(D)   22 km 266 m
Answer:    (C)
4.   Subtract the Following---->20 m 30 cm - 17 m 60 cm
(A)   2 m 40 cm
(B)   2 m 70 cm
(C)   2 m 20 cm
(D)   2 m 80 cm
Answer:    (B)
5.   Subtract the Following---->24 cm 2 mm - 3 cm 8 mm
(A)   20 cm 2 mm
(B)   20 cm 1 mm
(C)   20 cm 7 mm
(D)   20 cm 4 mm
Answer:    (D)
6.   Subtract the Following---->₹ 19.50 paise - ₹ 12.60 paise
(A)   ₹6.10 Paise
(B)   ₹6.40 Paise
(C)   ₹6.90 Paise
(D)   ₹6.20 Paise
Answer:    (C)
7.   Adding the Following---->19 liter 840 ml + 25 liter 250 ml
(A)   45 liter 90 ml
(B)   45 liter 50 ml
(C)   45 liter 60 ml
(D)   45 liter 10 ml
Answer:    (A)
8.   Adding the Following---->25 kg 650 g + 29 kg 770 g
(A)   52 kg 420 gm.
(B)   52 kg 320 gm.
(C)   55 kg 420 gm.
(D)   55 kg 120 gm.
Answer:    (C)
9.   Adding the Following---->15 km 740 m + 13 km 950 m
(A)   28 km 690 m
(B)   29 km 690 m
(C)   29 km 390 m
(D)   29 km 620 m
Answer:    (B)
10.   Adding the Following---->22 m 50 cm + 25 m 75 cm
(A)   28 m 25 cm
(B)   48 m 35 cm
(C)   48 m 20 cm
(D)   48 m 25 cm
Answer:    (D)
11.   Adding the Following---->6 cm 5 mm + 7 cm 9 mm
(A)   14 cm 4 mm
(B)   13 cm 4 mm
(C)   14 cm 6 mm
(D)   12 cm 4 mm
Answer:    (A)
12.   Adding the Following---->₹ 9.50 paise + ₹ 14.60 paise
(A)   ₹24.20 Paise
(B)   ₹24.30 Paise
(C)   ₹24.10 Paise
(D)   ₹24.40 Paise
Answer:    (C)
13.   If the Maharashtra Express leaving from Kolhapur at 15:30 arriaves at Gondia the next day at 20:15 , how long is the journey from Kolhapur to Gondia?
(A)   28 Hours 35 Minutes
(B)   28 Hours 45 Minutes
(C)   28 Hours 35 Minutes
(D)   28 Hours 37 Minutes
Answer:    (B)
14.   If a shop is open from 9:30 am to 10 pm, how long is it open?
(A)   3 Hours 10 Minutes
(B)   12 Hours 60 Minutes
(C)   12 Hours 30 Minutes
(D)   12 Hours 10 Minutes
Answer:    (C)
15.   If a bank is open for business from 10 in the morning to 4:30 p.m. in the evening, How long is it open?
(A)   3 Hours 10 Minutes
(B)   6 Hours 30 Minutes
(C)   4 Hours 20 Minutes
(D)   4 Hours 10 Minutes
Answer:    (B)
16.   Geeta tought in the classroom fro 2 hours and 25 minutes in the morning and 1 hour and 45 minutes in the afternoon . How long was she teaching inall?
(A)   3 Hours 10 Minutes
(B)   4 Hours 20 Minutes
(C)   4 Hours 20 Minutes
(D)   4 Hours 10 Minutes
Answer:    (D)
17.   Rambhau Started the water pump at ten thirty at night and put it off the same night at a quarter to twelve. How long was the water pump on?
(A)   1 Hours 15 Minutes
(B)   1 Hours 10 Minutes
(C)   1 Hours 12 Minutes
(D)   1 Hours 17 Minutes
Answer:    (A)
18.   Sakharam was ploughing the field from 8 in the morning. At 12.30 in the afternoon he stopped and started for home. He reached home at 1.30 . How long was he ploughing the field? How long did it take him to reach home from the field?
(A)   4:50 Hours
(B)   4:40 Hours
(C)   4:30 Hours
(D)   4:10 Hours
Answer:    (C)
19.   A Movie starts at 45 minutes past 3 in the afternoon and finishes two and a half hours later. At what time does the movie end?
(A)   5: 15 in the Evening
(B)   6: 25 in the Evening
(C)   6: 25 in the Evening
(D)   6: 15 in the Evening
Answer:    (D)
20.   A Govrnment office opens at 7 in the morning and closes at 3 in the afternoon. How long is this office open?
(A)   2 Hours
(B)   6 Hours
(C)   8 Hours
(D)   8 Hours
Answer:    (C)
21.   Subtract the Following--->6 Hours 15 minutes - 2 Hours 45 Minutes
(A)   3 Hours 30 Minutes
(B)   3 Hours 10 Minutes
(C)   2 Hours 45 Minutes
(D)   2 Hours 35 Minutes
Answer:    (A)
22.   Subtract the Following--->4 Hours 25 minutes - 1 Hours 55 Minutes
(A)   8 Hour 10 Minutes
(B)   2 Hours 30 Minutes
(C)   8 Hour 20 Minutes
(D)   2 Hours 10 Minutes
Answer:    (B)
23.   Subtract the Following--->5 Hours 20 minutes - 2 Hours 35 Minutes
(A)   2 Hours 35 Minutes
(B)   2 Hours 40 Minutes
(C)   2 Hours 45 Minutes
(D)   2 Hours 60 Minutes
Answer:    (C)
24.   Subtract the Following--->3 Hours 10 minutes - 2 Hours 40 Minutes
(A)   30 Minutes
(B)   50 Minutes
(C)   20 Minutes
(D)   10 Minutes
Answer:    (A)
25.   Additing the Following--->4 Hours 15 minutes + 2 Hours 50 minutes
(A)   7 hours 25 minutes
(B)   2 Hours 30 Minutes
(C)   7 hours 13 minutes
(D)   7 Hours 5 Minutes
Answer:    (D)
26.   Additing the Following--->3 Hours 45 minutes + 1 Hours 35 minutes
(A)   2 Hours 30 Minutes
(B)   7 hours 25 minutes
(C)   5 Hours 20 Minutes
(D)   8 Hour 10 Minutes
Answer:    (C)
27.   Additing the Following--->3 Hours 50 minutes + 4 Hours 20 minutes
(A)   8 Hour 10 Minutes
(B)   7 hours 20 minutes
(C)   2 Hours 30 Minutes
(D)   7 hours 13 minutes
Answer:    (A)
28.   Additing the Following--->2 Hours 30 minutes + 4 Hours 55 minutes
(A)   7 hours 20 minutes
(B)   7 hours 25 minutes
(C)   7 hours 50 minutes
(D)   7 hours 13 minutes
Answer:    (B)
29.   Subtract the Following---->46 liter 200 ml - 38 liter 750 ml
(A)   7 liter 350 ml
(B)   7 liter 650 ml
(C)   7 liter 550 ml
(D)   7 liter 450 ml
Answer:    (D)
30.   Subtract the Following---->35 kg 150 g - 26 kg 470 g
(A)   8 kg 680 gm
(B)   8 kg 480 gm
(C)   8 kg 180 gm
(D)   8 kg 780 gm
Answer:    (A)
31.   Subtract the Following---->40 km 255 m - 17 km 960 m
(A)   22 km 260 m
(B)   22 km 160 m
(C)   22 km 265 m
(D)   22 km 266 m
Answer:    (C)
32.   Subtract the Following---->20 m 30 cm - 17 m 60 cm
(A)   2 m 40 cm
(B)   2 m 70 cm
(C)   2 m 20 cm
(D)   2 m 80 cm
Answer:    (B)
33.   Subtract the Following---->24 cm 2 mm - 3 cm 8 mm
(A)   20 cm 2 mm
(B)   20 cm 1 mm
(C)   20 cm 7 mm
(D)   20 cm 4 mm
Answer:    (D)
34.   Subtract the Following---->₹ 19.50 paise - ₹ 12.60 paise
(A)   ₹6.10 Paise
(B)   ₹6.40 Paise
(C)   ₹6.90 Paise
(D)   ₹6.20 Paise
Answer:    (C)
35.   Adding the Following---->19 liter 840 ml + 25 liter 250 ml
(A)   45 liter 90 ml
(B)   45 liter 50 ml
(C)   45 liter 60 ml
(D)   45 liter 10 ml
Answer:    (A)
36.   Adding the Following---->25 kg 650 g + 29 kg 770 g
(A)   52 kg 420 gm.
(B)   52 kg 320 gm.
(C)   55 kg 420 gm.
(D)   55 kg 120 gm.
Answer:    (C)
37.   Adding the Following---->15 km 740 m + 13 km 950 m
(A)   28 km 690 m
(B)   29 km 690 m
(C)   29 km 390 m
(D)   29 km 620 m
Answer:    (B)
38.   Adding the Following---->22 m 50 cm + 25 m 75 cm
(A)   28 m 25 cm
(B)   48 m 35 cm
(C)   48 m 20 cm
(D)   48 m 25 cm
Answer:    (D)
39.   Adding the Following---->6 cm 5 mm + 7 cm 9 mm
(A)   14 cm 4 mm
(B)   13 cm 4 mm
(C)   14 cm 6 mm
(D)   12 cm 4 mm
Answer:    (A)
40.   Adding the Following---->₹ 9.50 paise + ₹ 14.60 paise
(A)   ₹24.20 Paise
(B)   ₹24.30 Paise
(C)   ₹24.10 Paise
(D)   ₹24.40 Paise
Answer:    (C)
41.   If the Maharashtra Express leaving from Kolhapur at 15:30 arriaves at Gondia the next day at 20:15 , how long is the journey from Kolhapur to Gondia?
(A)   28 Hours 35 Minutes
(B)   28 Hours 45 Minutes
(C)   28 Hours 35 Minutes
(D)   28 Hours 37 Minutes
Answer:    (B)
42.   If a shop is open from 9:30 am to 10 pm, how long is it open?
(A)   3 Hours 10 Minutes
(B)   12 Hours 60 Minutes
(C)   12 Hours 30 Minutes
(D)   12 Hours 10 Minutes
Answer:    (C)
43.   If a bank is open for business from 10 in the morning to 4:30 p.m. in the evening, How long is it open?
(A)   3 Hours 10 Minutes
(B)   6 Hours 30 Minutes
(C)   4 Hours 20 Minutes
(D)   4 Hours 10 Minutes
Answer:    (B)
44.   Geeta tought in the classroom fro 2 hours and 25 minutes in the morning and 1 hour and 45 minutes in the afternoon . How long was she teaching inall?
(A)   3 Hours 10 Minutes
(B)   4 Hours 20 Minutes
(C)   4 Hours 20 Minutes
(D)   4 Hours 10 Minutes
Answer:    (D)
45.   Rambhau Started the water pump at ten thirty at night and put it off the same night at a quarter to twelve. How long was the water pump on?
(A)   1 Hours 15 Minutes
(B)   1 Hours 10 Minutes
(C)   1 Hours 12 Minutes
(D)   1 Hours 17 Minutes
Answer:    (A)
46.   Sakharam was ploughing the field from 8 in the morning. At 12.30 in the afternoon he stopped and started for home. He reached home at 1.30 . How long was he ploughing the field? How long did it take him to reach home from the field?
(A)   4:50 Hours
(B)   4:40 Hours
(C)   4:30 Hours
(D)   4:10 Hours
Answer:    (C)
47.   A Movie starts at 45 minutes past 3 in the afternoon and finishes two and a half hours later. At what time does the movie end?
(A)   5: 15 in the Evening
(B)   6: 25 in the Evening
(C)   6: 25 in the Evening
(D)   6: 15 in the Evening
Answer:    (D)
48.   A Govrnment office opens at 7 in the morning and closes at 3 in the afternoon. How long is this office open?
(A)   2 Hours
(B)   6 Hours
(C)   8 Hours
(D)   8 Hours
Answer:    (C)
49.   Subtract the Following--->6 Hours 15 minutes - 2 Hours 45 Minutes
(A)   3 Hours 30 Minutes
(B)   3 Hours 10 Minutes
(C)   2 Hours 45 Minutes
(D)   2 Hours 35 Minutes
Answer:    (A)
50.   Subtract the Following--->4 Hours 25 minutes - 1 Hours 55 Minutes
(A)   8 Hour 10 Minutes
(B)   2 Hours 30 Minutes
(C)   8 Hour 20 Minutes
(D)   2 Hours 10 Minutes
Answer:    (B)
51.   Subtract the Following--->5 Hours 20 minutes - 2 Hours 35 Minutes
(A)   2 Hours 35 Minutes
(B)   2 Hours 40 Minutes
(C)   2 Hours 45 Minutes
(D)   2 Hours 60 Minutes
Answer:    (C)
52.   Subtract the Following--->3 Hours 10 minutes - 2 Hours 40 Minutes
(A)   30 Minutes
(B)   50 Minutes
(C)   20 Minutes
(D)   10 Minutes
Answer:    (A)
53.   Additing the Following--->4 Hours 15 minutes + 2 Hours 50 minutes
(A)   7 hours 25 minutes
(B)   2 Hours 30 Minutes
(C)   7 hours 13 minutes
(D)   7 Hours 5 Minutes
Answer:    (D)
54.   Additing the Following--->3 Hours 45 minutes + 1 Hours 35 minutes
(A)   2 Hours 30 Minutes
(B)   7 hours 25 minutes
(C)   5 Hours 20 Minutes
(D)   8 Hour 10 Minutes
Answer:    (C)
55.   Additing the Following--->3 Hours 50 minutes + 4 Hours 20 minutes
(A)   8 Hour 10 Minutes
(B)   7 hours 20 minutes
(C)   2 Hours 30 Minutes
(D)   7 hours 13 minutes
Answer:    (A)
56.   Additing the Following--->2 Hours 30 minutes + 4 Hours 55 minutes
(A)   7 hours 20 minutes
(B)   7 hours 25 minutes
(C)   7 hours 50 minutes
(D)   7 hours 13 minutes
Answer:    (B)
57.   The address of the last cell in the a worksheet of Excel is
(A)   HZ10000
(B)   IV65536
(C)   ZA65535
(D)   ZZ66666
Answer:    (B)
58.   This Function is used to calculate the numbers within the list of arguments.
(A)   COUNTIF()
(B)   CALCUATE()
(C)   COUNT(_)
(D)   IF()
Answer:    (C)
59.   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)
60.   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)
61.   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)
62.   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)
63.   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)
64.   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)
65.   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)
66.   Which is the category of the round() function ?
(A)   Financial
(B)   Statistical
(C)   Math and trig
(D)   Date and Time
Answer:    (C)
67.   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)
68.   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)
69.   Which Symbol is used in the formula for divide in excel ?
(A)   /
(B)   x
(C)   D
(D)   *
Answer:    (A)
70.   Which Symbol is used in the formula for multiplication ?
(A)   ^
(B)   *
(C)   x
(D)   /
Answer:    (B)
71.   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)
72.   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)
73.   Renaming of the excel worksheet is done by how many ways ?
(A)   4
(B)   1
(C)   3
(D)   2
Answer:    (C)
74.   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)
75.   A worksheet till Excel 2003 can have a maximum of number of rows ?
(A)   32000
(B)   256
(C)   1024
(D)   65536
Answer:    (D)
76.   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)
77.   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)
78.   from which menu you can access Picture, Text Box, Chart etc. ?
(A)   Insert
(B)   File
(C)   Edit
(D)   View
Answer:    (A)
79.   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)
80.   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)
81.   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)
82.   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)
83.   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)
84.   In Excel, one workbook may contain more than one
(A)   Formula Sheets
(B)   Worksheets
(C)   Web pages
(D)   Work pages
Answer:    (B)
85.   In Excel, this Function returns number rounded up to the nearest even integer.
(A)   EVENT()
(B)   EVEN ()
(C)   ROUND2 ()
(D)   ROUNDEVEN()
Answer:    (B)
86.   A Function inside another function cell move is called a _____ Function
(A)   SUM
(B)   Round
(C)   Text
(D)   Nested
Answer:    (D)
87.   The Format Cell Number can has an option to show negative numbers in
(A)   Green
(B)   Blue
(C)   Quote
(D)   Red
Answer:    (D)
88.   In Excel, Header and Footer facility is available in
(A)   File Menu
(B)   Insert Menu
(C)   Style Menu
(D)   Format Menu
Answer:    (B)
89.   Select entire row, click mouse on the
(A)   Formula bar
(B)   First cell of the row
(C)   Column name
(D)   Row Number
Answer:    (D)
90.   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)
91.   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)
92.   Shortcut key for Opening a spreadsheet from whithin MS-EXCEL ?
(A)   ALT + P
(B)   CTRL+ O
(C)   CTRL+ P
(D)   ALT + P
Answer:    (C)
93.   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)
94.   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)
95.   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)
96.   Area, Scatter and column are all examples of
(A)   Chart Category
(B)   Clip Art Category
(C)   Auto Shape categories
(D)   PPT building
Answer:    (A)
97.   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)
98.   The first cell in EXCEL Worksheet is labled as
(A)   AA
(B)   Aa
(C)   A0
(D)   A1
Answer:    (DA)
99.   From the given list which function is not part of excel function category ?
(A)   Date & time
(B)   Logical
(C)   Ghraphic
(D)   Text
Answer:    (C)
100.   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)
101.   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)
102.   Which of the following is not a valid arithmetic operator?
(A)   Average Deviation
(B)   Subtraction
(C)   Multiplication
(D)   Exponentiation
Answer:    (A)
103.   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)
104.   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)
105.   For calculation in a spreadsheet, you need to use a
(A)   filed
(B)   Formula
(C)   Variable
(D)   Table
Answer:    (B)
106.   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)
107.   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)
108.   Which Menu is only available in MS Excel and not in MS Word?
(A)   Data
(B)   Window
(C)   File
(D)   Tools
Answer:    (A)
109.   Which of this tab in not part of page Setup Wizard?
(A)   Margin
(B)   Cell
(C)   Page
(D)   Sheet
Answer:    (B)
110.   Which command is used to select entire word sheet?
(A)   Ctrl+C
(B)   Ctrl+V
(C)   Ctrl+X
(D)   Ctrl+A
Answer:    (D)
111.   is the process of finding and correcting errors in a worksheet.
(A)   Fixing
(B)   Checking
(C)   Debugging
(D)   Editing
Answer:    (B)
112.   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)
113.   In Excel , one workbook may contain more than one
(A)   Formula sheets
(B)   Worksheets
(C)   Web pages
(D)   Work pages
Answer:    (B)
114.   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)
115.   Last number of row is ?
(A)   65536
(B)   100000
(C)   65535
(D)   65538
Answer:    (A)
116.   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)
117.   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)
118.   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)
119.   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)
120.   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)
121.   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)
122.   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)
123.   _______, ________ 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)
124.   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)
125.   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)
126.   WHICH SYMBOL MUST ALL FORMULA BEGIN WITH?
(A)   A. =
(B)   B. +
(C)   C. (
(D)   D. @
(G)   D.
(H)   Filtering
Answer:    (A)
127.   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)
128.   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)
129.   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)
130.   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)
131.   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)
132.   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)
133.   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)
134.   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)
135.   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)
136.   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)
137.   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)
138.   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)
139.   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)
140.   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)
141.   EXCEL FILES HAVE A DEFAULT EXTENSION OF
(A)   A. XLS
(B)   B. XLW
(C)   C. WK1
(D)   D. 123
Answer:    (A)
142.   AN EXCEL WORKBOOK IS A COLLECTION OF
(A)   A. WORKBOOKS
(B)   B. WORKSHEETS
(C)   C. CHARTS
(D)   D. WORKSHEETS AND CHARTS
Answer:    (D)
143.   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)
144.   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)
145.   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)
146.   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)
147.   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)
148.   HYPERLINKS CAN BE
(A)   A. TEXT
(B)   B. DRAWING OBJECTS
(C)   C. PICTURES
(D)   D. ALL OF ABOVE
Answer:    (D)
149.   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)
150.   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)
151.   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)
152.   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)
153.   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)
154.   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)
155.   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)
156.   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)
157.   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)
158.   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)
159.   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)
160.   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)
161.   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)
162.   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)
163.   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)
164.   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)
165.   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)
166.   AN EXCEL FILE IS GENERALLY CALLED A / AN :
(A)   E-SPREADSHEET
(B)   WOORKSHEET
(C)   WORKBOOK
(D)   SHEET
Answer:    (C)
167.   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)
168.   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)
169.   THE ____ FEATURE OF MS EXCEL QUICKLY COMPLETES A SERIES OF DATA
(A)   AUTO COMPLETE
(B)   AUTO FILL
(C)   FILL HANDLE
(D)   SORTING
Answer:    (B)
170.   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)
171.   THE GREATER THAN SIGN (>) IS AN EXAMPLE OF _____ OPERATOR.
(A)   ARITHMATIC
(B)   LOGICAL
(C)   CONDITIONAL
(D)   GREATER
Answer:    (B)
172.   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)
173.   WHICH FUNCTIONIN EXCEL CHECKS WHETHER A CONDITION IS TRUE OR NOT ?
(A)   SUM
(B)   COUNT
(C)   IF
(D)   AVERAGE
Answer:    (C)
174.   FUNCTIONS IN MS EXCEL MUST BEGIN WITH ___
(A)   AN () SIGN
(B)   AN EQUAL SIGN
(C)   A PLUS SIGN
(D)   A > SIGN
Answer:    (B)
175.   WHICH ONE IS NOT A FUNCTION IN MS EXCEL ?
(A)   SUM
(B)   AVG
(C)   MAX
(D)   MIN
Answer:    (B)
176.   A FEATURES THAT DISPLAYS ONLY THE DATA IN COLUMN (S) ACCORDING TO SPECIFIED CRITERIA
(A)   FORMULA
(B)   SORTING
(C)   FILTERING
(D)   PIVOT
Answer:    (C)
177.   WHICH FUNCTIONIN EXCEL TELLS HOW MANY NUMERIC ENTRIES ARE THERE ?
(A)   NUM
(B)   COUNT
(C)   SUM
(D)   CHKNUM
Answer:    (B)
178.   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)
179.   WHAT IS THE INTERSECTION OF A COLUMN AND A ROW ON A WORKSHEET CALLED ?
(A)   COLUMN
(B)   VALUE
(C)   ADDRESS
(D)   CELL
Answer:    (D)
180.   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)
181.   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)
182.   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)
183.   “NEW COMMENT” OPTION CAN BE FOUND UNDER _________ TAB
(A)   A. INSERT
(B)   B. DATA
(C)   C. REVIEW
(D)   D. VIEW
Answer:    (C)
184.   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)
185.   WHICH ONE IS THE LAST COLUMN HEADER IN EXCEL 2007?
(A)   A. XFD
(B)   B. XFX
(C)   C. XFL
(D)   D. XFT
Answer:    (A)
186.   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)
187.   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)
188.   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)
189.   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)
190.   WHICH SYMBOL MUST ALL FORMULA BEGIN WITH?
(A)   A. =
(B)   B. +
(C)   C. (
(D)   D. @
(G)   D.
(H)   Filtering
Answer:    (A)
191.   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)
192.   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)
193.   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)
194.   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)
195.   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)
196.   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)
197.   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)
198.   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)
199.   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)
200.   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)