Simple Excel Test
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
Correct Answer
A. A dark border -
- 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
Correct Answer
C. Click the column heading -
- 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
Correct Answer
B. CTRL+ENTER -
- 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
Correct Answer
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
Correct Answer
A. Print Preview -
- 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
Correct Answer
A. Hold down the CTRL key -
- 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
Correct Answer
B. Only the cells with gray 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
Correct Answer
B. Data I Sort -
- 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
Correct Answer
C. A & B -
- 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
Correct Answer
B. The date is increased by 1 day into each cell -
- 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
Correct Answer
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
Correct Answer
A. Select the cells and press DELETE -
- 13.
The default orientation for the printed page is
- A.
Portrait
- B.
Landscape
- C.
Whatever was last used
- D.
Vertical
Correct Answer
A. Portrait -
- 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
Correct Answer
C. 2,2,2 -
- 15.
If a cell shows ####### , it means that
- 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
Correct Answer
C. The column is too narrow to show all the digits of the number -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Apr 23, 2018Quiz Edited by
ProProfs Editorial Team -
Dec 15, 2011Quiz Created by
Kristiallen15
Back to top