Please enter your email:

1. What is the correct structure of the SUM function

=SUM(B2:B6)

=SUM(B2;B6)

=SUMB2:B6

=B2+B3+B4+B5+B6

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

AB6

AB1:AB6

3. How would you insert a new sheet?

Right click on a cell and select insert

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

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 current column

To the bottom of the current column

To the left of the current column

To the top of the current column

6. What is the correct symbol for multiplication?

Multiply

7. What is the name of the circled icon

Auto Sum

Auto Multiply

Auto Fill

Auto Correct

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

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

10. When inserting rows where do they appear

To the right of the row

To the bottom of the current row

To the left of the row

To the top of the current row

11. What range selection is selected

C3+E7

C3,E7

C3:E7

12. What does the $ sign represent in a formula e.g.: = B4*$G$4

Currency format will be applied

When auto filling the formula down the reference of G4 will not move nor change

Used to name the cell reference so that it can be used in other formulas

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

none of the above

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

0.5

Question 1 of 14

Microsoft Excel Basic Quiz

Microsoft Excel
Basic Quiz