Gent - Excel Test 1

Gent Technologies - www.gent.ie - Free Online Practice Tests

Return to Gent Technologies - Online Tests page

Microsoft Excel Test 1

Test Instructions
You should have Excel open and a blank spreadsheet visible to do this test. You should not use notes or books. Only use Excel and its associated help files.

Answer the questions IN ORDER, click on only one answer per question

1. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

2. What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?

F3 F5 F7 F9 F11 F13

3. 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?

Count Average Sum

4. Which of these will NOT select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet
Using the Edit - Select All menu item
Pressing CTRL + A on the keyboard

5. When you see a cell with a red triangle in the top right corner, what does this signify?

There is an error in the cell
There is a comment associated with the cell
The font colour for text in the cell is red
A formula cannot be entered into the cell

6. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values ?

7. Which of the following will NOT set text in selected cells to ITALICS ?

Pressing CTRL + I on the keyboard
Using the Tools - Wizard - Web Form menu item
Using the Format - Cells - Font menu item

8. Is it possible to insert an image from a file into an Excel spreadsheet ?

Yes No

Your Test Result is %

Return to Gent Technologies - Online Tests page