Microsoft Excel Basic Quiz - Execu-TrainExecu-Train

Please enter your email:

1. What is the cell reference of the selected cell:

AB6

AB1:AB6

2. How do you make headings repeat at the top of every printed page?

Copy and paste the heading where the page would begin

Click insert tab > repeat heading at top of page

Page layout tab > print titles > rows to repeat at top

3. How do you insert a Chart?

Select relevant data > click insert tab > choose chart

Select Relevant data > push ctrl and c on the keyboard

Select only the headings of the columns > click insert tab > choose chart

Select entire spreadsheet and click create chart

4. What is the correct symbol for multiplication?

Multiply

5. What is the answer for the following equation: 3*2+1-(2+4)/2

0.5

6. When inserting rows where do they appear

To the right of the row

To the bottom of the Row

To the left of the row

To the top of the row

7. What range selection is selected

C3+E7

C3,E7

C3:E7

8. What is the answer for the following equation: 6 – 6 x 6

none of the above

9. What is the correct structure of the SUM function

=SUM(B2:B6)

=SUM(B2;B6)

=SUMB2:B6

=B2+B3+B4+B5+B6

10. How would you insert a new sheet?

How would you insert a new sheet?

Click the insert tab then click insert worksheet

Click the Insert Worksheet button next to the current sheets tabs

Right click on any ribbon tab and select new sheet

11. How would you format Cells to the Rand Currency?

Right click selection > Format Cells > Currency > Select Rand symbol

You cannot do so

Type the R in front of numbers

Select selection > Home Tab > Click the down arrow of number category > choose Percentage

12. What is the name of the circled icon

Auto Sum

Auto Multiply

Auto Fill

Auto Correct

13. When inserting Columns where do they appear

To the right of the column

To the bottom of the column

To the left of the column

To the top of the column

Question 1 of 13