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. Excel uniquely identifies cells within a worksheet with a cell name

a) Cell names

b) Column numbers and row letters

c) Column letters and row numbers

d) Cell locator coordinates

2 / 50

2. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result.

a) IF

b) AND

c) OR

d) NOT

3 / 50

3. The chart wizard term data series refers to

a) A chart legend

b) A collection of chart data markers

c) A set of values you plot in a chart

d) A data label

4 / 50

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

5 / 50

5. Which of the following formulas will Excel Not be able to calculate?

a) =SUM(Sales)-A3

b) =SUM(A1:A5)*.5

c) =SUM(A1:A5)/(10-10)

d) =SUM(A1:A5)-10

6 / 50

6. How many characters can be typed in a single cell in Excel?

a) 256

b) 1024

c) 32000

d) 65535

7 / 50

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

8 / 50

8. When you see a cell with a red triangle in the top right corner, what does this signify?

a) There is an error in the cell

b) There is a comment associated with the cell

c) The font color for text in the cell is red

d) A formula cannot be entered into the cell

9 / 50

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

a) From Edit menu choose Move or Copy sheet mark the Create a ccopy and Click OK

b) From Edit menu choose Move of Copy then choose (Move to end) and click OK

c) From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

d) None of above

10 / 50

10. Which elements of worksheet can be protected from accidental modification

a) Contents

b) Objects

c) Scenarios

d) All of above

11 / 50

11. Getting data from a cell located in a different sheet is called …

a) Accessing

b) Referencing

c) Updating

d) Functioning

12 / 50

12. What happens when the dollar sign ($) is entered in a cell address? (ex. $B$2:$B$10)

a) An absolute cell address is created.

b) The address of the cell will change when it is copied to another cell.

c) The sheet’s tab is changed.

d) The state-bar does not display the cell address.

13 / 50

13. Multiple calculations can be made in a single formula using ________

a) Standard Formulas

b) Array Formula

c) Complex Formulas

d) Smart Formula

14 / 50

14. Which of the following is not an MS-Excel term?

a) Cells

b) Lines

c) Columns

d) Document

15 / 50

15. Which function display current data and time in excel?

a) =today()

b) =time()

c) =data()

d) =Now()

16 / 50

16. What term refers to a specific set of values saved with the workbook?

a) Range

b) Scenario

c) Trend line

d) What-if analysis

17 / 50

17. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a) Pie chart

b) Row chart

c) Line chart

d) Column chart

18 / 50

18. MS-EXCEL is based on _____?

a) WINDOWS

b) DOS

c) UNIX

d) OS/2

19 / 50

19. Edit > Delete command

a) Deletes the content of a cell

b) Deletes Formats of cell

c) Deletes the comment of cell

d) Deletes selected cells

20 / 50

20. If 10/2 entered in a cell without applying any formats, excel will treat this as

a) Fraction

b) Number

c) Date

d) Text

21 / 50

21. Excel is a program that is used to prepare a

a) Slide presentation

b) Spreadsheet

c) Text document

d) Database

22 / 50

22. When you link data maintained in Excel workbook to a Word document

a) The Word document cannot be edited

b) The Word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

23 / 50

23. In EXCEL, you can add up a wide range of data by simply selecting a button called ________?

a) Fill in

b) Correction

c) AutoSum

d) Format

24 / 50

24. Which types of charts can excel produce?

a) Line graphs and pie charts only

b) Only line graphs

c) Bar charts, line graphs and pie charts

d) Bar charts and line graphs only

25 / 50

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

a) Insert

b) Format

c) Tools

d) Data

26 / 50

26. Which of following is Not one of Excel’s what-if function?

a) Goal seek

b) Solver

c) Scenario manager

d) Auto Outline

27 / 50

27. Comments can be added to cells using

a) Edit > Comments

b) Insert > Comments

c) File > Comments

d) View > Comments

28 / 50

28. What happens when you press Ctrl + X after selecting some cells in Excel?

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

b) The cells selected are marked for cutting

c) The selected cells are deleted and the cells are shifted left

d) The selected cells are deleted and cells are shifted up

29 / 50

29. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

a) Unfreeze panes command on the window menu

b) Freeze panes command on the window menu

c) Hold titles command on the edit menu

d) Split command on the window menu

30 / 50

30. Which of the following formulas is not entered correctly?

a) =10+50

b) =B7*B1

c) =B7+14

d) 10+50

31 / 50

31. What do you mean by a Workspace?

a) Group of Columns

b) Group of Worksheets

c) Group of Rows

d) Group of Workbooks

32 / 50

32. _____ are equations that perform calculations on values in your worksheet.

a) Functions

b) References

c) Formulas

d) Constants

33 / 50

33. To select an entire column in MS-EXCEL, press?

a) CTRL + C

b) CTRL + Arrow key

c) CTRL + S

d) None of the above

34 / 50

34. What is the maximum height of a row in MS Excel 2010?

a) 255 points

b) 100 points

c) 409 points

d) 128 points

35 / 50

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

a) Previous state

b) Next state

c) Current state

d) All of the above

36 / 50

36. The Name box

a) Shows the location of the previously active cell

b) Appears t the left of the formula bar

c) Appears below the status bar

d) Appears below the menu bar

37 / 50

37. Another name for a pre-programmed formula in Excel is

a) Cell

b) Graph

c) Function

d) Range

38 / 50

38. What does COUNTA () function do?

a) Counts cells having alphabets

b) Counts empty cells

c) Counts cells having number

d) Counts non-empty cells

39 / 50

39. Which of the following option is not available in Paste Special dialog box?

a) Add

b) Subtract

c) Divide

d) SQRT

40 / 50

40. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

a) Press Ctrl +Home

b) Press Home

c) Press Shift + Home

d) Press Alt + Home

41 / 50

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

a) Input cells

b) Constraints

c) Target cell

d) Changing cells

42 / 50

42. To edit data in an embedded Excel worksheet object in a Word document

a) Use the Excel menu bar and toolbars inside the word application

b) Edit the hyperlink

c) Edit the data in a Excel source application

d) Use the Word menu bar and toolbars

43 / 50

43. In a formula, which symbol specifies the fixed columns or rows?

a) $

b) *

c) %

d) &

44 / 50

44. Cuts the selected cells

a) Ctrl + X

b) Ctrl + C

c) Ctrl + V

d) Ctrl + B

45 / 50

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

a) From Edit menu choose Clear and then Formats

b) From Edit menu choose Delete

c) Click on Remove Formatting tool on Standard Toolbar

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

46 / 50

46. How can you remove borders applied in cells?

a) Choose None on Border tab of Format cells

b) Open the list on Border tool in Format Cell toolbar then choose first tool (none)

c) Both of above

d) None of the above

47 / 50

47. Excel displays the current cell address in ______

a) Formula bar

b) State bar

c) Field Name

d) Title bar

48 / 50

48. Which command will you choose to convert a column of data into row?

a) Cut and Paste

b) Paste Special > Transpose

c) Both of above

d) None of above

49 / 50

49. To copy cell contents using drag and drop press the

a) End key

b) Shift key

c) Ctrl key

d) Esc key

50 / 50

50. To remove the content of selected cells you must issue ______ command

a) Delete

b) Clear Contents

c) Clear All

d) Clear Delete

Your score is

0%

Leave a Reply Cancel reply

Categories

Recent post

Cyber Security Policy 2080