Electronic Spreadsheet – Set 2

Computer Operator

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

Happy Learning!

1 / 50

1. Which of the following is not What IF analysis tool in Excel?

Goal seek

Scenarios

Macros

None of these

2 / 50

2. You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

F11

3 / 50

3. Which of the following you can paste selectively using Paste Special command?

Validation

Formats

Formulas

All of these

4 / 50

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

Tool >> Options >> View tab

Tools >> Options >> Calculation tab

Tool >> Option >> Edit Tab

Tool >> Option >> Transition tab

5 / 50

5. To protect a worksheet , you can choose protection and the protect sheet from the menu

Edit

Format

Tools

Data

6 / 50

6. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Edit menu choose Clear and then formats

From Edit menu choose Delete

Click on Remove Formatting tool on standard Toolbar

Double click the Format painter and then press Esc key in keyboard

7 / 50

7. It is acceptable to let long text flow into adjacent cells on a worksheet when

data will be entered in the adjacent cells

no data will be entered in the adjacent cells

There is no suitable abbreviation for the text

there is not time to format the text

8 / 50

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

Edit

Format

Tools

Data

9 / 50

9. To apply Goal Seek command your cell pointer must be in

The changing cell whose value you need to find

The Result Cell Where formula is entered

The cell where your targeted value is entered

None of these

10 / 50

10. The Trace Dependence in auditing shows

Which cells are used in current formula

In which formula the current cell is used

Which cells are used in this formula and in which formula this cell is used

None of these

11 / 50

11. To remove the content of selected cells you must issue ——— command .

Edit >> Delete

Edit >> Clear >> Content

Edit >> clear >> All

Data >> delete

12 / 50

12. By default excel provides 3 worksheets. you need only two of them , how will you delete the third one ?

Right click on sheet tab of third sheet and choose Delete from the context menu

Click on Sheet 3 and from Edit menu choose Delete

Both of these

None of these

13 / 50

13. Paste special allows some operation while you paste to new cell. Which of the following operation is valid?

Squre

Percentage

Goal Seek

Divide

14 / 50

14. Which of the following is tool you will use in Excel to see what must be the value of a cell to get required result ?

Formula Auditing

Research

Track change

Goal seek

15 / 50

15. The minimum and maximum value you can set for save AutoRecovery Info in Excel are

1 and 120 minutes

0 and 120 minutes

2 and 60 minutes

1 and 10 minutes

16 / 50

16. Which of the following action removes a sheet from worksheet ?

Select the sheet , then choose Edit >> Delete sheet

Select the sheet then choose Format >> Sheet >> Hide

Both of these

None of these

17 / 50

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

This will remove row heading and column heading of your data

This will remove the column heading (A,B,C,

This will remove row and column heading of chart

This will remove row and column heading of table

18 / 50

18. The arrows create by Auditing can be removed by

Click on the arrow and press Delete

Click on Remove All of arrows on Formula Auditing toolbar

Both of these

None of these

19 / 50

19. Whats is the short cut key to replace a data with another in sheet?

Ctrl + R

Ctrl + Shift + R

Ctrl + H

Ctrl + F

20 / 50

20. You can move a sheet from one workbook into new book by

From Edit menu choose move or copy , mark the Create a copy and Click ok

From Edit menu choose Move or Copy then choose (Move to end) and click ok

From Edit menu choose Move or Copy then select (new books) from to Book list and click ok

None of these

21 / 50

21. you want to set such that when you type Baishakh and drag the fill handle , excel should produce Jestha , Aashdh and soon . what will you set to affect that

Custom List

Auto Fill Options

Fill Across Worksheet

Fill Series

22 / 50

22. The……..in Excel 2007 replaces the menus and toolbars found in earlier versions of Excel?

Office button

Ribbon

Quick Access toolbar

None of these

23 / 50

23. We can make a cell address an absolute cell address by placing a sign in front of the row and column identifiers?

Doctor sign(+)

Rate sign (@)

Dollar sign ($)

Hash sign(#)

24 / 50

24. Which of the following cannot be hidden from Tools >> Options then View tab ?

Startup Task pane

Formula bar

Status bar

Scroll Bar

25 / 50

25. You can open the highlight changes dialog box by choosing track changes from the menu

Edit

Insert

Format

Tools

26 / 50

26. The default and maximum number of sheets for a new worksheet in Excel 2003 is

3 and 255

3 and 256

1 and 255

1 and 256

27 / 50

27. How many recent files you can display on file menu at maximum ?

28 / 50

28. Paste Special allows some operation while you paste to new cell . which of the following operation is valid ?

Square

Percentage

Goal Seek

Divide

29 / 50

29. While Finding and Replacing some data in Excel , which of the following statement is valid ?

a. you can find and replace within the sheet or workbook

b. Excel does not have option to match case for find

c. Both(a) and (b) are valid

d. None are valid

30 / 50

30. Which tool you will use to join some cells and place the content at the middle of joined cell ?

From Format cells dialog box click on merge cells check box

From Format Cells dialog box select the Cantered alignment

From Format cells dialog box choose merge and centre check box

Click on Merge and centre tool on formatting toolbar

31 / 50

31. The default font used in Excel is?

Arial

Algerial

Times New Roman

Calibri

32 / 50

32. When a row of data is to be converted into columns

Copy the cells in row , select the same number of cells in row and paste

Copy the cells in column then choose Edit >> paste Special , then click Transpose and ok

Copy the cells then go to Format >> cells then on Alignment tab click Transpose check box and click ok

Select the cells then place the cell pointer on new cell and choose Edit >> paste Special , mark Transpose check box and click ok

33 / 50

33. MS Excel provides the default value for step in fill series dialog box

34 / 50

34. Which of the following option is not available to remove arrows of Formula Auditing

remove all precedent arrows

Remove all dependent arrows

Remove all arrows

Remove all arrows for this cell

35 / 50

35. The Trace precedence in auditing shows

Which cells are used in current formula

In Which formula the current cell is used

Which cells are used in this formula and in which formula this cell is used

None of these

36 / 50

36. Each file in a MS Excel is known as?

Work sheet

Data sheet

EX Book

Work Book

37 / 50

37. When you start typing the same value as of some cells on same column, Excel automatically shows that text, This feature is known as?

AutoFill

AutoCorrect

AutoComplete

AutoFormat

38 / 50

38. The default font size in Excel worksheet is

10 points

12 points

14 points

None of these

39 / 50

39. The command edit >> Fill Across Worksheet is active only when

One sheet is selected

When many sheets are selected

When no sheet is selected

None of these

40 / 50

40. you can auto fit the width of column by

Double clicking on the column the name on column header

Double click on the cell pointer in worksheet

Double clicking on column right border on column header

Double clicking on the column left border of column header

41 / 50

41. The default font size in Excel worksheet is?

10 Points

12 Points

14 Points

None of these

42 / 50

42. If you need to remove only the formatting done in a range (number and formula typed should not be removed) , you must

From Edit menu choose Clear and then Format

From Edit menu choose delete

Click on Remove Formatting tool on standard Toolbar

Double click the Format Painter and then press Esc key in keyboard

43 / 50

43. When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?

AutoComplete

AutoFormat

Custom List

Calculation Automatic

44 / 50

44. Which of the following is invalid regarding the protection in Excel?

Protect sheet

Protect workbook

Protect Workspace

All of these

45 / 50

45. Edit>> Delete command ?

Delete the content of a cell

Deletes formats of cell

Deletes the command of cell

Deletes selected cells

46 / 50

46. Which of the following is not an option in the spelling dialog box ?

Edit

Ignore

Ignore all

Change

47 / 50

47. By default there are……….worksheets in an Excel file?

48 / 50

48. Which of the following is not true about Find and Replace in Excel

you can search for bold and replace with italics

you can decide whether to look for whole word or not

You can search in formula too

you can search by rows or columns or sheets

49 / 50

49. Excel is a good application for what IF analysis. Which of the following tool help you for this?

Formula Auditing

Research

Track change

Goal seek

50 / 50

50. What happens when you press Ctrl + x after selecting some cells in Excel ?

The cell content of selected cells disappear from cell and stored in clipboard

The cells selected are marked for cutting

The selected cells are deleted and cells are shifted left

The selected cells are deleted and cells are shifted up

Your score is

Exit

Happy Learning!

Share this Quiz with your friends!

Follow Us @