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

2 / 50

2. Which of the following is not a valid data type in excel

a) Number

b) Character

c) Label

d) Date/time

3 / 50

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

4 / 50

4. Which would you choose to create a bar diagram?

a) Edit Chart

b) Insert Chart

c) Tools Chart

d) Format Chart

5 / 50

5. How can you show or hide the gridlines in Excel Worksheet?

a) Go to Tools > Options > View tab and mark or remove the check box named Gridline

b) Click Gridline tool on Forms toolbar

c) Both of above

d) None of above

6 / 50

6. Which of the following is the purpose of AutoSum?

a) Display the sum of the selected cells directly after the selected cells

b) Display the sum of the selected cells directly before the selected cells

c) Donâ€™t add the grand total

d) All of these

7 / 50

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

8 / 50

8. How do you rearrange the data in ascending or descending order?

a) Data Sort

b) Data Form

c) Data Table

d) Data Subtotals

9 / 50

9. In Excel, Columns are labelled as ___

a) A, B, C, etc

b) 1,2,3 etc

c) A1, A2, etc.

d) $A$1, $A$2, etc.

10 / 50

10. What setting do you need to change to print a spreadsheet with the header?

a) Document

b) Margin

c) Page layout

d) Orientation

11 / 50

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

a) Input cells

b) Constraints

c) Target cell

d) Changing cells

12 / 50

12. This type of software is similar to an accountants worksheet

a) Word processing

b) Database

c) Spreadsheets

d) Graphics

13 / 50

13. The auto calculate feature

a) Can only add values in a range of cells

b) Provides a quick way to view the result of an arithmetic operation on a range of cells

c) Automatically creates formulas and adds them to a worksheet

d) All

14 / 50

14. Which of the following setup options can not be set in the page setup dialog box?

a) Printer selection

b) Vertical or horizontal placement

c) Orientation

d) Row and column titles

15 / 50

15. You can use the horizontal and vertical scroll bars to

a) Split a worksheet into two panes

b) View different rows and columns

c) Edit the contents of a cell

d) View different worksheets

16 / 50

16. Each excel file is called a workbook because

a) It can contain text and data

b) It can be modified

c) It can contain many sheets including worksheets and chart sheets

d) You have to work hard to create it

17 / 50

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

a) 256

b) 1024

c) 32000

d) 65535

18 / 50

18. The cell level F5 refers to

a) Row F and Column %

b) Column F and Row 5

c) Function available in cell

d) Function key F5

19 / 50

19. Which menu option can be used to split windows into two?

a) Review > Window

b) View > Window > Split

c) Window > Split

d) View > Split

20 / 50

20. MS Excel 2019 has row limit of __________

a) 1,048,576

b) 4,81,0576

c) 16384

d) 1,57,648

21 / 50

21. Multiple calculations can be done in a single formula using _______

a) Standard formulas

b) Table formula

c) Complex formulas

d) Smart formula

22 / 50

22. You can enter which types of data into worksheet cells?

a) Labels, values, and formulas

b) Labels and values but not formulas

c) Values and formulas but not labels

d) Formulas only

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. What is the shortcut to select the whole column?

a) Ctrl + C

b) Ctrl + Enter

c) Ctrl + R

d) Ctrl + Space bar

25 / 50

25. How can you arrange to get a quick alert if a cell contains a value below a specific amount?

a) Apply conditional formatting to the call

b) Apply a modified percent style to the cell

c) Apply validation rule

d) All of the above

26 / 50

26. Which of the cell pointer indicate that you can move the content to other cell?

a) Doctor’s symbol (Big Plus)

b) Small thin plus icon

c) Mouse Pointer with anchor at the tip

d) None of above

27 / 50

27. What symbol is used before a number to make it a label?

a) ” (quote)

b) = (equal)

c) _ (underscore)

d) ‘ (apostrophe)

28 / 50

28. Merge cells option can be applied from?

a) Format Cells dialog box Alignment Tab

b) Formatting toolbar

c) Both of above

d) None of above

29 / 50

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

a) Cell

b) Graph

c) Function

d) Range

30 / 50

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

31 / 50

31. To center worksheet titles across a range of cell, you must

a) Select the cells containing the title text and use the fill handle to center the text across a range of cells

b) Widen the columns

c) Select the cells containing the title text and use the fill handle to center the text across a range of cells

d) Widen the column

32 / 50

32. You can open the scenario Manager dialog box by choosing scenarios from the .......... menu.

a) View

b) Insert

c) Format

d) Tools

33 / 50

33. When you group worksheets

a) You can enter variable data on multiple worksheets at one time

b) You can print more than one worksheet at a time

c) You can enter common data, formats, and formulas on multiple worksheets at one time

d) Both (B & C)

34 / 50

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

a) Previous state

b) Next state

c) Current state

d) All of the above

35 / 50

35. Which of the following is used to move an active cell to the first column on the current row?

a) Page up

b) Ctrl + Home

c) Page down

d) Home

36 / 50

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

37 / 50

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

38 / 50

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

a) Insert

b) Format

c) Tools

d) Data

39 / 50

39. How can you view two workbooks simultaneously to compare sales figures?

a) Use the Split command

b) Use the Arrange command

c) Use the New Window command

d) All of the above

40 / 50

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

41 / 50

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

a) Accessing

b) Referencing

c) Updating

d) Functioning

42 / 50

42. Press _____ to bring up search box.

a) Shift + F3

b) Shift + F4

c) Shift + F5

d) Shift + F6

43 / 50

43. Which function do you use to display the current date and time in MS Excel?

a) =DATE()

b) =TODAY()

c) =NOW()

d) =TIME()

44 / 50

44. You can auto fit the width of column by

a) Double clicking on the column name on column header

b) Double click on the cell pointer in worksheet

c) Double clicking on column right border on column header

d) Double clicking on the column left border of column header

45 / 50

45. In MS Excel spreadsheet, Data can be sorted using ________.

a) Filter function

b) ARRAY function

c) Lookup function

d) Operator function

46 / 50

46. When you insert an excel file into a word document. The data are

a) Hyperlinked placed in a word table

b) Linked

c) Embedded

d) Use the word menu bar and toolbars

47 / 50

47. How are data organized in a spreadsheet?

a) Lines and spaces

b) Layers and planes

c) Rows and columns

d) Height and width

48 / 50

48. The keyboard shortcut for creating a chart from selected cells in excel is

a) F3

b) F5

c) F12

d) F11

49 / 50

49. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

a) Use Ctrl to select all three cells, then click the paste button on the standard toolbar

b) Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

c) Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

d) All of above

50 / 50

50. Which shortcut key is used to copy the selected cells in MS Excel ?

a) Ctrl + A

b) Ctrl + B

c) Ctrl + C

d) Ctrl + D

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 Operator Quiz-3

HTML Quiz -BICT, BCA

Microsoft Access Quiz

Leave a Reply Cancel reply

IT Assistant KUKL

Tribhuvan University (TU) IT Officer Subjective Question