Excel Competence (Basic)
This test has been created to test your basic competence in the use of Microsoft Excel. Please complete all the questions in 10 minutes or less. You may keep an Excel worksheet open while completing this test.
- 1.
How should you print a selected area of a worksheet, if you'll want to print a different area next time?
- A.
On the File menu, point to Print Area, and then click Set Print Area
- B.
On the File menu, click Print, and then click Selection under Print what
- C.
On the View menu, click Custom Views, then click Add
Correct Answer
A. On the File menu, point to Print Area, and then click Set Print Area -
- 2.
A fast way to add up this column of numbers is to click in the cell below the numbers and then: Order Amount £ 440.00 £ 834.00 £ 205.00 £ 599.00
- A.
Click Subtotals on the Data menu
- B.
View the sum in the formula bar
- C.
Click the AutoSum button on the Standard toolbar, then press ENTER
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER -
- 3.
What's a quick way to extend these numbers to a longer sequence, for instance 23 through 40? 20 21 22
- A.
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
- B.
Select the range you want, including both cells, point to Fill on the Edit menu, and then click Down
- C.
Copy the second cell, click in the cell below it, on the Standard toolbar click the down arrow on the Paste button, and then click Paste Special
Correct Answer
A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows -
- 4.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
Correct Answer
B. Right click on the spreadsheet tab and select DELETE -
- 5.
Which of these will NOT select all the cells in a document?
- A.
Clicking three times with the right mouse button in the spreadsheet
- B.
Using the Edit - Select All menu item
- C.
Pressing CTRL + A on the keyboard
Correct Answer
A. Clicking three times with the right mouse button in the spreadsheet -
- 6.
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. Sum -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 18, 2022Quiz Edited by
ProProfs Editorial Team -
Nov 30, 2009Quiz Created by
Recruitment
Back to top