Excel Basics
Version: 3.0
WARNING: The content of this document is for evaluation purpose only and cannot be used commercially, unless such an agreement has been reached with eCSP Products and Services.
- 1.
What button will open the contextual Help?A) B) C) D)
- A.
A
- B.
B
- C.
C
- D.
D
Correct Answer
C. C -
- 2.
When creating a formula what is the first thing to be entered in the cell?
- A.
@
- B.
&
- C.
=
- D.
$
Correct Answer
C. = -
- 3.
What is the quickest method of getting to cell AC60?
- A.
[END] and enter the cell address
- B.
F5 and enter the cell address
- C.
[CTRL-HOME] and enter the cell address
- D.
None of the above
Correct Answer
B. F5 and enter the cell address -
- 4.
What is the default alignment of numbers entered in a cell?
- A.
Center
- B.
Right
- C.
Left
- D.
None of the above
Correct Answer
B. Right -
- 5.
How do you switch from one opened program to another?
- A.
File, Close and open Windows Explorer
- B.
[ALT] [BACKSPACE]
- C.
Minimize Excel to an icon and open Windows Explorer
- D.
Use the Taskbar. Click on the name of the program in the Taskbar
Correct Answer
D. Use the Taskbar. Click on the name of the program in the Taskbar -
- 6.
What command will permit you to cancel your last action or operation once it has been executed?
- A.
[ESC]
- B.
[F1] twice
- C.
Edit, Undo
- D.
A) and d) are both good
Correct Answer
C. Edit, Undo -
- 7.
What does * stand for in a formula?
- A.
Division
- B.
There is a special note in this formula
- C.
Multiplication
- D.
None of the above
Correct Answer
C. Multiplication -
- 8.
What is the use of the X in the formula bar ?
- A.
To confirm the formula entry
- B.
To delete the content of a cell
- C.
To cancel the formula entry bar
- D.
Click it before any multiplication formula
Correct Answer
C. To cancel the formula entry bar -
- 9.
Which function is used to save a workbook under a new name?
- A.
File, Save
- B.
File, Save As
- C.
Create a copy of the file in Explorer under another name
- D.
File rename
Correct Answer
B. File, Save As -
- 10.
In which of the following instances would you get the symbol "#" in a cell?
- A.
When a formatted number is too long to fit in a cell
- B.
When formatted text or numbers are too long to fit in a cell
- C.
When there is an error in a formula within a cell
- D.
None of the above
Correct Answer
A. When a formatted number is too long to fit in a cell -
- 11.
Which function allows you to move text from one cell to another?
- A.
File, Cut
- B.
Edit, Cut & Edit, Paste
- C.
Edit, Paste
- D.
A) & B)
Correct Answer
B. Edit, Cut & Edit, Paste -
- 12.
What is the correct formula to add the following cells A1 to A5?
- A.
=SUM(A1+A5)
- B.
=SUM(A1:A5)
- C.
A1+A2+A3+A4+A5
- D.
It is not possible to add them
Correct Answer
B. =SUM(A1:A5) -
- 13.
When you copy a cell that contains a formula what happens to the formula?
- A.
You get an error message
- B.
It reflects the same amount as in the original cell
- C.
Adjusts the formula to reflect the cell references relative to the new location
- D.
None of the above
Correct Answer
C. Adjusts the formula to reflect the cell references relative to the new location -
- 14.
What is the method used for erasing the contents of a cell or a range of cells?
- A.
Select the cells and choose menu Edit, Delete or press the [DELETE] key
- B.
Select the range and press [BACKSPACE]
- C.
Select the range using the [F4] key and press the [ESC] key
- D.
Both a) and b) are good
Correct Answer
D. Both a) and b) are good -
- 15.
You need to insert a row in a table. How would you do it?
- A.
Edit, Paste
- B.
Edit, Automatic Insertion
- C.
Press the Insert Key
- D.
Insert, Rows
Correct Answer
D. Insert, Rows -
- 16.
What is a method of editing information in a cell?
- A.
Double click on a cell and type
- B.
Click on the cell you want to change and then type in the formula bar
- C.
Press Insert and type your text
- D.
Both a) and b) are correct
Correct Answer
D. Both a) and b) are correct -
- 17.
The command File New is used:
- A.
To open a new sheet within the same work book
- B.
To open a new workbook
- C.
To open a workbook that you have previously worked on
- D.
None of the above
Correct Answer
B. To open a new workbook -
- 18.
What is the method used for changing the amount of decimals within a cell?A) B) C) D)
- A.
A
- B.
B
- C.
C
- D.
D
Correct Answer
C. C -
- 19.
How do you select a whole column?
- A.
Edit, Select column
- B.
[CTRL] Click in the column
- C.
Click on the column heading
- D.
None of the above
Correct Answer
C. Click on the column heading -
- 20.
The button is used to?
- A.
Type text in a text box
- B.
Center text in a cell
- C.
Center text above several cells
- D.
Center text vertically
Correct Answer
C. Center text above several cells -
- 21.
What is the meaning of the following expression: C$52?
- A.
It means 52 dollars
- B.
The row number is an absolute cell address
- C.
The column number is an absolute cell address
- D.
The address is expressed in relative cell address
Correct Answer
B. The row number is an absolute cell address -
- 22.
What is the result of the following expression: =2+2*(2/2)?
- A.
3
- B.
4
- C.
16
- D.
Cannot be calculated
Correct Answer
B. 4 -
- 23.
Which menu allows you to eliminate the merge of cells?
- A.
Format, Cell, Alignment
- B.
Edit, Delete
- C.
Edit, Cut
- D.
Edit, Erase
Correct Answer
A. Format, Cell, Alignment -
- 24.
Can we simultaneously select non-consecutive cells?
- A.
Yes
- B.
No
Correct Answer
A. Yes -
- 25.
What option in the Page Setup dialog box is used to adjust the table to fit on one page?
- A.
100%
- B.
Entire Page
- C.
Fit to :
- D.
Change Size
Correct Answer
C. Fit to : -
- 26.
How would you change the size of a column to fit the entire width of the text?
- A.
The width is limited to 80 characters
- B.
Double click on the right border in the column heading
- C.
Choose Edit, Maximum size
- D.
Click on the letter above the column and choose Format Column
Correct Answer
B. Double click on the right border in the column heading -
- 27.
Can a Save be undone?
- A.
Yes
- B.
No
Correct Answer
B. No -
- 28.
Which menu will tell you how many workbooks are opened?
- A.
File
- B.
View
- C.
Window
- D.
Help
Correct Answer
C. Window -
- 29.
How is the complete content of the selected cell deleted?
- A.
Format menu, delete
- B.
Edit menu, delete
- C.
Data menu, delete
- D.
None of the above
Correct Answer
D. None of the above -
- 30.
When you move a cell containing a formula, the formula:
- A.
Changes to reflect it’s new position
- B.
Remains the same
- C.
Adds both the new and old positions
- D.
Subtracts both the new and old positions
Correct Answer
B. Remains the same -
- 31.
Which of the following tools is used to copy the format of one cell to another?A) B) C) D)
- A.
A
- B.
B
- C.
C
- D.
D
Correct Answer
C. C -
- 32.
How is a table centered both Horizontally and Vertically?
- A.
Format menu, Table, Center, Center Vertically, Center Horizontally
- B.
Edit menu, Table, Center, Center Vertically, Center Horizontally
- C.
File menu, Page Setup, Margins, Center Vertically, Center Horizontally
- D.
It can’t be done
Correct Answer
C. File menu, Page Setup, Margins, Center Vertically, Center Horizontally -
- 33.
How is the format in a cell deleted while leaving the contents?
- A.
Edit, Clear, Format
- B.
Edit, Clear, All
- C.
Select the cell and press Delete
- D.
Type over cell
Correct Answer
A. Edit, Clear, Format -
- 34.
Using the menus how is the workbook closed but Excel kept opened?
- A.
File, Exit
- B.
File, Close
- C.
Window, Close
- D.
Window, Exit
Correct Answer
B. File, Close -
- 35.
Which of the following is not considered a number in Excel?
- A.
+24
- B.
24+2
- C.
-21+2
- D.
They are all considered numbers
Correct Answer
B. 24+2 -
- 36.
What are the modes in Excel?
- A.
Ready, Enter, Edit
- B.
Enter, Edit
- C.
Waiting, Enter, Formula
- D.
Waiting, Enter, Formula Enter, Formula
Correct Answer
A. Ready, Enter, Edit -
- 37.
When an Auto-complete appears in a cell, how do you accept the information?
- A.
Enter or tab
- B.
Spacebar
- C.
Backspace
- D.
Any arrow key
Correct Answer
A. Enter or tab -
- 38.
The results from an Auto-calculate can be added to a cell?
- A.
True
- B.
False
Correct Answer
B. False -
- 39.
If you select 3 Columns before inserting columns it will...
- A.
Insert a column after your selection
- B.
Insert a column before your selection
- C.
Insert 3 columns after your selection
- D.
Insert 3 columns before your selection
Correct Answer
D. Insert 3 columns before your selection -
- 40.
It is possible to add column headings to each printed page?
- A.
Yes
- B.
No
Correct Answer
A. Yes -
- 41.
An absolute cell reference means...
- A.
The cell reference will change when copying the formula
- B.
The cell reference will not change when copying the formula
- C.
All references to a cell stay static
- D.
None of the above
Correct Answer
B. The cell reference will not change when copying the formula -
- 42.
The next 8 questions are based on the following table:What is the result to =sum(B1,B5)?
- A.
8
- B.
26
- C.
18
- D.
You cannot perform this action
Correct Answer
A. 8 -
- 43.
Based on the following table:What is the result to =average(C1:C5)?
- A.
4
- B.
5
- C.
1.5
- D.
3
Correct Answer
A. 4 -
- 44.
Based on the following table:What is the result to =D3+D4*D5/4?
- A.
20
- B.
8
- C.
11
- D.
10
Correct Answer
B. 8 -
- 45.
Based on the following table:What is the results to =min(A1:A5)?
- A.
1
- B.
3
- C.
2
- D.
5
Correct Answer
A. 1 -
- 46.
Based on the following table:What is the results to =max(D1:D5)?
- A.
1
- B.
2
- C.
8
- D.
7
Correct Answer
C. 8 -
- 47.
Based on the following table:What is the results to =E1*E5+1?
- A.
11
- B.
10
- C.
31
- D.
30
Correct Answer
A. 11 -
- 48.
Based on the following table:The formula =$A$2*A5 is found in cell A6, when copied to cell E6 the result is:
- A.
20
- B.
12
- C.
16
- D.
8
Correct Answer
D. 8 -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 04, 2013Quiz Edited by
ProProfs Editorial Team -
Sep 06, 2009Quiz Created by
Eveillet
Back to top