Microsoft Excel Quiz

Created on August 11, 2023 By

gyanchautari

Microsoft Excel Quiz

Welcome to Computer Operator Quiz

Microsoft Excel Quiz Section मा 500+ Question हरु Upload गरिएकाे छ । र एक पटक Quiz खेल्दा 50 Question मात्र आउने छ । र अन्य Question Practice गर्नकाे लागि पेजलाई रिलाेड (Reload) गर्नुहाेला ।

NameEmailPhone Number

1 / 50

1. Which one would you choose to create a bar chart?

a) Edit, chart

b) Insert, chart

c) Tools, chart

d) Format, chart

2 / 50

2. What is the short cut key to highlight the entire column?

a) Ctrl + C

b) Ctrl + Enter

c) Ctrl + Page Up

d) Ctrl + Space Bar

3 / 50

3. when you use the fill effects in the format data series dialog box, you can not

a) rotate text on the chart

b) select a fore ground color

c) select a pattern

d) select a background color

4 / 50

4. Concatenation of text can be done using

a) Apostrophe (')

b) Exclamation (!)

c) Hash (#)

d) Ampersand (&)

5 / 50

5. In MS Excel, Page border option is available under _______ tab.

a) Insert

b) Page Layout

c) View

d) None of the above

6 / 50

6. To view a cell comment

a) click the edit comment command on the insert menu

b) click the display comment command on the window menu

c) position the mouse pointer over the cell

d) click the comment command on the view menu

7 / 50

7. You can use the drag and drop method to

a) Copy cell contents

b) Move cell contents

c) Add cell contents

d) Both Move & Copy

8 / 50

8. Which Chart can be created in Excel?

a) Area

b) Line

c) Pie

d) All of the above

9 / 50

9. The first cell of the EXCEL worksheet is labelled as __

a) AA

b) A1

c) Aa

d) A0

10 / 50

10. Rounding errors can occur

a) When you use multiplication, division or exponentiation in a formula

b) When you use addition and subtraction in a formula

c) Because Excel uses hidden decimal places in computation

d) When you show the results of formulas with different decimal places than the calculated results

11 / 50

11. You can use the formula palette to

a) Format cells containing numbers

b) Create and edit formulas containing functions

c) Enter assumptions data

d) Copy a range of cells

12 / 50

12. While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.

a) Alt

b) Ctrl

c) Shift

d) Insert

13 / 50

13. How do you change the number 200 into $200?

a) Click the currency style button

b) Select Format> Money

c) Click to dollar style

d) None of these

14 / 50

14. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20.

a) Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows

b) Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

c) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

d) All of above

15 / 50

15. Right clicking something in Excel:

a) Deletes the object

b) Nothing the right mouse button is there for left handed people

c) Opens a shortcut menu listing everything you can do to the object

d) Selects the object

16 / 50

16. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ?

a) 5430

b) 5436.80

c) 5436.8

d) 6.8

17 / 50

17. What is the value of the following MS-Excel function?

=FLOOR(14, 4)

a) 10

b) 13

c) 14

d) 12

18 / 50

18. Where can you change automatic or manual calculation mode in Excel?

a) Double CAL indicator on status bar

b) Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button

c) Both of above

d) None of above

19 / 50

19. MS-EXCEL is based on _____?

a) WINDOWS

b) DOS

c) UNIX

d) OS/2

20 / 50

20. Macros are “run” or executed from the ….. Menu.

a) Insert

b) Format

c) Tools

d) Data

21 / 50

21. A numeric value can be treated as label value if ……………. precedes it.

a) Apostrophe (ʼ)

b) Exclamation (!)

c) Hash (#)

d) Tilde (~)

22 / 50

22. What is the shortcut key to replace a data with another in sheet?

a) Ctrl + R

b) Ctrl + Shift + R

c) Ctrl + H

d) Ctrl + F

23 / 50

23. You can add an image to a template by clicking the Insert Picture From File button on the ............. Toolbar.

a) Standard

b) Formatting

c) Drawing

d) Picture

24 / 50

24. To activate the previous cell in a pre-selected range, press

a) the Alt key

b) the Tab key

c) the Enter key

d) none of above

25 / 50

25. You can convert existing excel worksheet data an charts to an HTML document by using

a) FTP wizard

b) Internet assistant wizard

c) Intranet wizard

d) Import wizard

26 / 50

26. Long text can be broken down into many lines within a cell. You can do this through

a) rap Text in Format > Cells

b) Justify in Edit > Cells

c) Text Wrapping in Format > Cells

d) All of above

27 / 50

27. Paste Special allows some operation where you paste to new cell. Which of the following operation is valid?

a) Square

b) Percentage

c) Goal Seek

d) Divide

28 / 50

28. Which of the following absolute cell reference

a) A

b) A$1

c) $A$1

d) A$1$

29 / 50

29. To select an entire column in MS-EXCEL, you click on ________?

a) CTRL + C

b) CTRL + Arrow

c) CTRL + S

d) None of the above

30 / 50

30. How do you wrap the text in a cell?

a) Format cells font

b) Format cells protection

c) Format cells number

d) Format cells alignment

31 / 50

31. A worksheet range is a

a) A command used for data modeling

b) A range of values such as from 23 to 234

c) A group of cells

d) A group of worksheets

32 / 50

32. Which of the following is a correct order of precedence in formula calculation?

a) Multiplication and division exponentiation positive and negative values

b) Multiplication and division, positive and negative values, addition and subtraction

c) Addition and subtraction, positive and negative values, exponentiation

d) All of above

33 / 50

33. Shortcut for Auto sum function in excel is

a) Alt + S

b) Alt + A

c) Alt + =

d) Alt + F2

34 / 50

34. You can create hyperlink from an excel workbook to

a) A web page on a company intranet

b) A web page on the intranet

c) Other excel workbooks

d) All of the above

35 / 50

35. The “Spelling” dialog box can be accessed by choosing “Spelling” from the ________.

a) Insert

b) File

c) Review

d) View

36 / 50

36. A features that displays only the data in column (s) according to specified criteria

a) Formula

b) Sorting

c) Filtering

d) Pivot

37 / 50

37. Shortcut key for line break is

a) CTRL+ENTER

b) SHIFT+SPACEBAR

c) CTRL+SHIFT+ENTER

d) ALT+ENTER

38 / 50

38. How can you delete a record?

a) Delete the column from the worksheet

b) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

c) Select Data > Delete Record from the menu

d) Click the Delete button on the Standard toolbar

39 / 50

39. The Chart wizard term data categories refers to;

a) A chart plot area

b) A horizontal axis

c) The organization of individual values with a chart’s data series

d) The data range that supply chart data

40 / 50

40. The active cell:

a) Is defined by a bold border around the cell.

b) Receives data entered by the user.

c) It is the formula bar.

d) Both A and B

41 / 50

41. Which of the following is an absolute cell reference in MS Excel?

a) !A!2

b) $B$8

c) #A#1

d) A1

42 / 50

42. When you insert an Excel file into a Word document, the data are

a) Hyperlinked

b) Placed in a word table

c) Linked

d) Embedded

43 / 50

43. Which of the following is not a term pertaining to spreadsheets?

a) Cell

b) Character

c) Browser

d) Formula

44 / 50

44. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

a) Work sheet

b) Chart sheet

c) Macro sheet

d) Data sheet

45 / 50

45. Which of the following is not information you can specify using the solver?

a) Input cells

b) Constraints

c) Target cell

d) Changing cells

46 / 50

46. When the CPU detects an interrupt, then it saves its

a) Previous state

b) Next state

c) Current state

d) All of the above

47 / 50

47. Data marker on a chart are linked to data points in a worksheet, therefore,

a) You can automatically apply formatting to a data series

b) You can change the position of a data marker and automatically change the data point value in the worksheet

c) You can change a data print value and automatically are draw the chart

d) Both( A & B)

48 / 50

48. __________ is a grid with labeled columns and rows.

a) Dialog box

b) Worksheet

c) Clipboard

d) Toolbar

49 / 50

49. Which of the following is not a valid data type in Excel?

a) Number

b) Character

c) Label

d) Date/Time

50 / 50

50. Which of the following identifies a cell in Excel?

a) Address

b) Formula

c) Name

d) Label

Your score is

0%

Leave a Reply Cancel reply

Categories

Recent post

IT Assistant KUKL

Tribhuvan University (TU) IT Officer Subjective Question

Important Links

Related Posts

Computer Networking Quiz

Old is Gold Quiz -BICT, BCA

NEB Computer Operator Practice Set 5

Leave a Reply Cancel reply

IT Assistant KUKL

Tribhuvan University (TU) IT Officer Subjective Question