Microsoft Excel - Basic

Please enter your email:

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

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

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

4. What range selection is selected

C3+E7

C3,E7

C3:E7

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

-30

6. What is the correct structure of the SUM function

=SUM(B2:B6)

=SUM(B2;B6)

=SUMB2:B6

=B2+B3+B4+B5+B6

7. What is the correct symbol for multiplication?

Multiply

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

0.5

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. What is the cell reference of the selected cell:

AB6

AB1:AB6

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

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

13. What is the name of the circled icon

Auto Sum

Auto Multiply

Auto Fill

Auto Correct

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

Question 1 of 14

GET IN TOUCH