Simple Excel Test
Settings
-
+
Simple excel test to judge the basic level of understanding use
- 1.On an Excel sheet the active cell is indicated by:
- A.
A dark border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
- 2.To select a column the easiest method is to:
- A.
Double-click any cell in the column
- B.
Drag from the top cell in the column to the last cell in the column
- C.
Click the column heading
- D.
Click the column label
- 3.If you press _____, the cell accepts your typing as its contents but the focus stays in the cell.
- A.
ENTER
- B.
CTRL+ENTER
- C.
TAB
- D.
INSERT
- 4.The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
- A.
B1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
- 5.The view that puts a blue line around each page that would be printed is the
- A.
Print Preview
- B.
Normal
- C.
Page Break Preview
- D.
Split View
- 6.To select several cells or ranges that are not touching each other, you would _____ while selecting
- A.
Hold down the CTRL key
- B.
Hold down the SHIFT key
- C.
Hold down the ALT key
- D.
Hold down CTRL+SHIFT
- 7.A certain spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button:
- A.
Nothing will print because some cells with data have been omitted
- B.
Only the cells with gray background will print
- C.
The whole sheet will print
- D.
Only the cells with white background will print
- 8.To arrange rows in alphabetical order based on column A, you need to use the command
- A.
Tools I Sort
- B.
Data I Sort
- C.
Edit I Data I Sort
- D.
None of the above
- 9.To edit existing data in a cell without having to retype it all, you should
- A.
Double-click the cell
- B.
Click the formula button
- C.
A & B
- D.
None of the above
- 10.If you select a cell with a date in it and drag the fill handle down across several cells, what happens is th
- A.
The date is copied to each cell
- B.
The date is increased by 1 day into each cell
- C.
The date is increased by 1 week into each cell
- D.
Nothing as Auto Fill applies only to numbers
- 11.To print just part of a sheet, you would select what you want to print and
- A.
Click the Print button
- B.
Press the PRINT SCREEN key
- C.
Select Print selection on Page Setup | Sheet and then print
- D.
Select Print selection in the Print dialog and then print
- 12.To remove the contents of several cells at once, you can
- A.
Select the cells and press DELETE
- B.
Select the cells and choose Edit | Clear... | Contents
- C.
Select the cells and drag the fill handle back up over them
- D.
All of the above
- 13.The default orientation for the printed page is
- A.
Portrait
- B.
Landscape
- C.
Whatever was last used
- D.
Vertical
- 14.Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are
- A.
8,16,32
- B.
2,4,2
- C.
2,2,2
- D.
6,8,10
- 15.
- A.
Your formula has a syntax error
- B.
The row is too short to show the number at the current font size
- C.
The column is too narrow to show all the digits of the number
- D.
None of the above
Back to top