Excel 2010 A
- 1.
True or False: Excel's Find and Replace feature can find words, numbers and formatting.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
This statement is true. You can search for information or formatting.Rate this question:
-
- 2.
When you enter a formula in Excel, what sign must go in front of the formula?
- A.
>
- B.
#
- C.
=
- D.
!
Correct Answer
C. =Explanation
When entering formulas, you need to put an equals (=) sign in front. Otherwise, the formula will merely be text in a cell.Rate this question:
-
- 3.
True or False: Pressing the control key whilst inserting a semi colon enters the current date
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
To insert the current date, press CTRL+; (semi-colon).Rate this question:
-
- 4.
Which of the following can be used for emphasis in all of Rollits' documents?
- A.
Bold
- B.
Underline
- C.
Block capitals
- D.
All of the above
Correct Answer
A. BoldExplanation
Emphasis is to be given by bold typeface. Underlining and block capitals should never be used anywhere in documents. Italics may be used in draft documents.Rate this question:
-
- 5.
What appears in a cell when a column is not wide enough for its numerical contents?
- A.
??????????
- B.
##########
- C.
>>>>>>>>>>
- D.
!!!!!!!!!!
Correct Answer
B. ##########Explanation
####### appear if the cell is too narrow to display the numerical contents.
To widen the column exactly enough to hold the longest entry in it: Double-click the divider between the column headers or choose Home→Cells→Format→AutoFit Column Width.
To widen the column manually: Drag the divider between the column headers.Rate this question:
-
- 6.
True or False: Headers and footers only apply to a specific worksheet not the entire workbook
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.Rate this question:
-
- 7.
True or False: By clicking Control+Home it will take you to the cell in Column A of the current row.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
This statement is false. By clicking Control+Home it will take you to the very first cell of the worksheet (A1).Rate this question:
-
- 8.
What font must be used to comply with our Standard Document Rules?
- A.
Calibri 11 point
- B.
Times New Roman 12 point
- C.
Arial 10 point
- D.
Century Gothic 10 point
Correct Answer
C. Arial 10 pointExplanation
Font should be Arial 10 point.Rate this question:
-
- 9.
If you were asked to double-click something, what would you do?
- A.
Press and release the left mouse button quickly twice
- B.
Press and release the right mouse button quickly twice
- C.
Press and release the left and right mouse buttons together
- D.
Press and release the left and right mouse buttons together quickly twice
Correct Answer
A. Press and release the left mouse button quickly twice -
- 10.
Which of the following tasks can be performed with Excel?
- A.
Create a spreadsheet
- B.
Create a chart
- C.
Summarise numerical data
- D.
All of the above
Correct Answer
D. All of the above -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 06, 2014Quiz Edited by
ProProfs Editorial Team -
Feb 05, 2014Quiz Created by
Zrmzrm
Back to top