Electronic Spreadsheet – Set 6

0%

Report a question

You cannot submit an empty report. Please add some details.

Electronic Spreadsheet – Set 6

Dear ! This is Electronic Spreadsheet – Set 6 Quiz and it contains 50 questions.


Keep Learning!

1 / 50

1) In Excel financial function, NPER is?

2 / 50

2) When you create two or four separate windows containing part of the spreadsheet that can be viewed , you have created

3 / 50

3) The accounting style shows negative numbers in

4 / 50

4) The cell reference for a range of cells that starts cell B1 and goes over to column G and down to row 10 is …..

5 / 50

5) To create an  interactive pivot Table for the Web , you use a Microsoft office web component called

6 / 50

6) Which of the following is not an option in the spelling dialog box ?

7 / 50

7) The number of row in a worksheet is

8 / 50

8) To keep specific rows and columns from scrolling off the screen you first must position the cell pointer

9 / 50

9) The minimum and maximum value you can set for save AutoRecovery  Info in Excel are

10 / 50

10) …………In Excel is used to get a particular result when you’re not too sure of the starting value?

11 / 50

11) When a formatted number does not fit within a cell , it displays

12 / 50

12) Which of the following is concatenating operator ?

13 / 50

13) …………calculates the interest paid during a specific period of an investment ?

14 / 50

14) To select multiple non adjacent cells in a worksheet you will click them holding

15 / 50

15) To move to the previous worksheet press

16 / 50

16) How do you rearrange the data in ascending or descending order ?

17 / 50

17) You can edit existing Excel data by pressing the

18 / 50

18) What symbol is used to enter number as text ?

19 / 50

19) Which of the following is not a worksheet design criterion

20 / 50

20) To apply Goal Seek command your cell pointer must be in

21 / 50

21) To protect a worksheet , you can choose protection and the protect sheet from the menu

22 / 50

22) What is the keyword shortcut(button or buttons to be pressed ) for creating a chart from the selected cells

23 / 50

23) In Excel financial function, PMT means?

24 / 50

24) The default and maximum number of sheets for a new worksheet in Excel 2003 is

25 / 50

25) The process of identifying specific rows and columns so that certain columns are always visible on the screen is called

26 / 50

26) You can open the highlight changes dialog box by choosing track changes from the menu

27 / 50

27) What term describes a background that appears as a grainy , non – smooth surface

28 / 50

28) The auto fill features

29 / 50

29) ………function is used to calculate the amount paid as interest on a loan during a period of the lifetime of a loan or an investment ?

30 / 50

30) How many recent files you can display on file menu at maximum ?

31 / 50

31) Which of the following component displays the content of active cell ?

32 / 50

32) A……….in Excel offers you different ways to view a set of figures, and allows you to switch between them quite easily ?

33 / 50

33) What feature enables you to adjust or back solve the value in a cell to reach a desire outcome in a formula ?

34 / 50

34) To copy all content using drag and drop , press the

35 / 50

35) If you press …… the cell accepts your typing as its contents

36 / 50

36) “Qtr 1, Qtr 2 , Qtr 3” is an example of a

37 / 50

37) Cell E23 has a data value and you wish to place that date on an invoice prefaced with the text located in B15 . what is the command to do that ?

38 / 50

38) What happens if you remove the check mark from Row and Column headers on options dialog box ?

39 / 50

39) you can quickly change the appearance of your work by choosing Auto Format from the …….. Menu

40 / 50

40) What pivot Table toolbar button updates the data in a pivot table or pivot chart  report if the source data has changed ?

41 / 50

41) Which of the following is not a statistical function in Excel?

42 / 50

42) How many sheets are there in excel workbook by default ?

43 / 50

43) Which of the following cannot be hidden from Tools >> Options then View tab ?

44 / 50

44) Data can be arranged in ascending or descending order by using

45 / 50

45) What is an expression that tells how the number in a determined set of cells are to be calculated ?

46 / 50

46) If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest) , which of the following would be the correct order of the list

47 / 50

47) The default font size in Excel worksheet is

48 / 50

48) By default the cell pointer moves down when you press Enter . From where can you change this setting ?

49 / 50

49) Red triangle at the top right corner of a cell indicates

50 / 50

50) A user wishes to remove a spreadsheet from a workbook. which is the correct sequence of events that will do this ?

Your score is

The average score is 0%

🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥
LinkedIn Facebook
0%

Exit

We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌

🌟 Thank you for your support! Your feedback means the world to us. 🙏💖

You cannot copy content of this page