Microsoft Excel Basic Quiz - Execu-TrainExecu-Train

Please enter your email:

1. 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

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

none of the above

3. What range selection is selected

C3+E7

C3,E7

C3:E7

4. 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

5. 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

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

0.5

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

8. What is the correct structure of the SUM function

=SUM(B2:B6)

=SUM(B2;B6)

=SUMB2:B6

=B2+B3+B4+B5+B6

9. What is the correct symbol for multiplication?

Multiply

10. 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

11. What is the name of the circled icon

Auto Sum

Auto Multiply

Auto Fill

Auto Correct

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

AB6

AB1:AB6

13. 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

Question 1 of 13