MS Excell Exam
.
- 1.
How do you change column width to fit the contents?
- A.
Single-click the boundary to the left of the column heading.
- B.
Double-click the boundary to the right of the column heading
- C.
Press ALT and single-click anywhere in the column
- D.
I don't know
Correct Answer
B. Double-click the boundary to the right of the column heading -
- 2.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
- A.
Click Subtotals on the View menu
- B.
View the sum in the formula bar
- C.
Click the AutoSum button on the Home, then press ENTER
- D.
I don' t Know
Correct Answer
C. Click the AutoSum button on the Home, then press ENTER -
- 3.
Assuming you are working in MS Excel and unfortunately, NEPA took the power and your work has not been saved. UPS is weak. What quickest way can you used to save your job before the UPS goes off?
- A.
Press Ctrl S
- B.
Off the UPS immediately without saving
- C.
Press Control X
- D.
I will Ask Samson Prinz
Correct Answer
A. Press Ctrl S -
- 4.
In order to save a new document in Microsoft Excel 2007, you must select which one of the following options?
- A.
Edit
- B.
Format
- C.
Help
- D.
Office Button
Correct Answer
D. Office Button -
- 5.
What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?
- A.
To add all the data together using addition only
- B.
To tell the person viewing that this is a function and it should be added together
- C.
To calculate all the data correctly without any mistakes
- D.
To inform the computer that an arithmetic function will occur
Correct Answer
A. To add all the data together using addition only -
- 6.
Which of the following INCORRECTLY selects multiple cells?
- A.
(A1:G50)
- B.
(A1, B3:C9)
- C.
(A1:B5:C5)
- D.
(A1:B5#C5)
Correct Answer
D. (A1:B5#C5) -
- 7.
What do you type into an empty cell to start a formula?
- A.
Fx
- B.
An equal sign (=)
- C.
Number
- D.
I will ask Bro. samson
Correct Answer
B. An equal sign (=) -
- 8.
You can use Excel to create budgets, to work with taxes, or to record student grades
- A.
False
- B.
True
- C.
Not Sure
- D.
I dont know
Correct Answer
B. True -
- 9.
You learned in the practice that ###### means
- A.
You've entered a number wrong
- B.
You've misspelled something
- C.
The cell is not wide enough to contain its contents
- D.
Don't know
Correct Answer
C. The cell is not wide enough to contain its contents -
- 10.
You can enter two basic kinds of data into worksheet cells:
- A.
Numbers and text
- B.
Numbers and figures
- C.
None of the above
- D.
I will ask Bro. Samson
Correct Answer
A. Numbers and text -
- 11.
A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
- A.
Click in cell C6, and then press CTRL+SHIFT.
- B.
Click in cell C6.
- C.
Non of the above
- D.
Wait for Bro. Samson to show you
Correct Answer
A. Click in cell C6, and then press CTRL+SHIFT. -
- 12.
___________ are where you get down to business and enter data in a worksheet
- A.
Cells
- B.
Fields
- C.
Tables
- D.
None of the above
Correct Answer
A. Cells -
- 13.
To divide 853 by 16 in a formula in Excel, you would use what math operator?
- A.
+
- B.
=
- C.
%
- D.
/
Correct Answer
D. / -
- 14.
_______, ________ 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
Correct Answer
C. Columns, rows, and cells -
- 15.
Which function will you use to enter current date and time in a woksheet cell?
- A.
=today()
- B.
=now()
- C.
=time()
- D.
=currentTime()
Correct Answer
B. =now() -
- 16.
Formatting a cell in Currency, you can specify
- A.
Decimal Places
- B.
Currency Symbol
- C.
Both of above
- D.
None of above
Correct Answer
C. Both of above -
- 17.
Which of the following is not an option in the spelling dialog?
- A.
Ignore
- B.
Ignore all
- C.
Change
- D.
I dont know
Correct Answer
D. I dont know -
- 18.
Which one do you like?
- A.
Option 1
- B.
Option 2
- C.
Option 3
- D.
Option 4
Correct Answer
A. Option 1 -
- 19.
Which do you press to enter the current date in a cell?
- A.
CTRL+; (semicolon)
- B.
CTRL+SHIFT+: (colon)
- C.
CTRL+F10
- D.
I forgot
Correct Answer
A. CTRL+; (semicolon) -
- 20.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- A.
Right click on the spreadsheet tab and select DELETE
- B.
Go to File-Save As – Save As Type – Excel worksheet
- C.
Right click on the spreadsheet and select Insert – Entire Column
- D.
Uncle Samson did not tell me
Correct Answer
A. Right click on the spreadsheet tab and select DELETE -
- 21.
When you open an Excel workbook, there are__________ sheets by default
- A.
Four
- B.
Three
- C.
Two
- D.
One
Correct Answer
B. Three -
- 22.
Which of the cell pointer indicate that you can move the content to other cell?
- A.
Doctor’s symbol (Big Plus)
- B.
Small thin plus icon
- C.
Mouse Pointer with anchor at the tip
- D.
None of above
Correct Answer
C. Mouse Pointer with anchor at the tip -
- 23.
To apply conditional formatting, you do the following except
- A.
Select the cells you would like to format
- B.
Select the color scales
- C.
Select Home tab
- D.
Locate the styles group
Correct Answer
D. Locate the styles group -
- 24.
Under which Excel Tab can we find "Format Painter"
- A.
Insert
- B.
Home
- C.
Review
- D.
View
Correct Answer
B. Home -
- 25.
What Version of Ms Excel were you taught?
- A.
MS Excel 2000
- B.
MS Excel 2020
- C.
MS Excel 2007, 2010 and 2013
- D.
MS Excel Unnamed
Correct Answer
C. MS Excel 2007, 2010 and 2013 -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Aug 06, 2015Quiz Edited by
ProProfs Editorial Team -
Aug 03, 2015Quiz Created by
SamsonPrinz
Back to top