Microsoft Excel Basic Quiz - ExecutrainExecutrain

Please enter your email:

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

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

0.5

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

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

AB6

AB1:AB6

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

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

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

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

none of the above

10. What is the name of the circled icon

Auto Sum

Auto Multiply

Auto Fill

Auto Correct

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

12. What is the correct symbol for multiplication?

Multiply

13. What is the correct structure of the SUM function

=SUM(B2:B6)

=SUM(B2;B6)

=SUMB2:B6

=B2+B3+B4+B5+B6

14. What range selection is selected

C3+E7

C3,E7

C3:E7

Question 1 of 14