Excel MCQs

Excel MCQs

Answer these 1000+ Excel MCQs and see how sharp is your knowledge of Excel. Scroll down and let's start!

1: What company distributes Excel?

A.   Microsoft

B.   Intel

C.   Turbotax

D.   Intuit

E.   Apple

2: Your PivotTable shows 20 products listed down column A. How can you make only the first 10 visible, and the rest of the products hidden?

A.   Select the rows for the last 10 products, then press Delete on your keyboard. Remember to undo when you're finished.

B.   On the task pane on the right side, drag products 11 through 20 out of the Rows area.

C.   Collapse all products from 11 through 20.

D.   Click the filter button on the header on column A, and deselect the last 10 products.

3: Which button allows you to copy cell formats from one cell to another?

A.   enter

B.   format painter

C.   autofit

D.   esc

4: True or False: If there are duplicate items in a list, the COUNT function will not include the duplicates in the total count of items.

A.   True

B.   False

5: Identify all the arguments and the correct order of arguments needed to execute the IF() function.

A.   logic test, value if false

B.   logic test

C.   logic test, value if true, value if false

D.   logic test, value if false, value if true

6: A red triangle at the top right corner of a cell indicates what?

A.   The cell can’t accept a formula

B.   The font color of the text in cell is red

C.   The cell is connected to another cell

D.   There is a comment associated with the cell

E.   There is an error in the cell

7: The definition of a macro is:

A.   the prevention of unauthorized use.

B.   a feature that allows the user to see how a new font or font size will look before actually applied.

C.   a recording of commands that can be played back at any time.

D.   an anchor which holds that value of a referenced component unchanged.

8: What is the correct forumla to calculate an average between cells B3 and B6?

A.   =AVE(B3:B6)

B.   SUM(B3+B4+B5+B6)/4

C.   =AVE(B3+B4+B5+B6)/4

D.   =AVERAGE(B3:B6)

E.   =AVERAGE(B3+B4+B5+B6)/4

9: The Doughnut chart type

A.   Compares a collection of values from several different data sets

B.   Compares values from different categories. Values are indicated by the height of the columns

C.   Compares relative values of different categories to the whole. Similar to the pie chart except that it can display multiple sets of data.

D.   Compares three sets of values in a three-dimensional chart

10: Which worksheet function converts a time in the form of text to a serial number?

A.   TIMEVALUE

B.   NETWORKDAYS

C.   TIME

D.   NOW

E.   SECOND

11: Are you able to do spell check in Excel?

A.   Yes, but only if there are no charts in the workbook.

B.   No

C.   Depends on Excel version

D.   Yes

12: How do you close a formula?

A.   )

B.   "

C.   ,

D.   (

E.   %

13: How to search text in Excel?

A.   control-S

B.   Control-F

14: How do you ensure that the person using a spreadsheet can always see the column headings?

A.   Use Freeze Panes or Freeze Top Row.

B.   Print to fit on one page.

C.   Re type the headings every few lines.

D.   Reset the view Zoom percentage.

15: The "Merge & Center" button does what?

A.   Merges cells together that are not physically attached

B.   Combines the quantities in two cells and centers the result

C.   Changes the font size on a cell

D.   Merges a cell with text with attached cells and centers the text over the range of cells

16: If you have an error, how can you find ways to fix it?

A.   Left click on the triangle, pause until you see a question mark, click on the arrow, and scroll to " Help on this error."

B.   You cannot request assistance.

C.   Go to "Data" and click on data tools.

17: In the formula =sum(B1:B5), what does the ":" represent?

A.   First Number

B.   Several Numbers

C.   And

D.   All numbers between (if applicable)

E.   Last Number

18: A pivot table allows you to:

A.   Merge columns and rows together

B.   Create a worksheet with data using a filtering window where you can include or exclude desired fields of the original table

C.   Save data within a cell

D.   Maneuver from one application database such as Access to another such as Excel

E.   Import data from MS Word

19: What is a cell?

A.   A series of columns.

B.   A series of rows.

C.   The intersection of a column and row.

D.   The total of two numbers.

E.   A header.

20: Data can be arranged in a worksheet in an easy to understand manner by

A.   Applying Styles

B.   Changing fonts

C.   All of these

D.   Changing decimals

E.   Auto Formatting

21: True or False: A Name can be applied to a range of non-contiguous cells.

A.   True

B.   False

22: Which is a type of operator?

A.   Arithmetic

B.   All of these

C.   Comparison

D.   Text Concatenation

E.   Reference

23: In order to multiply items in Excel, you would use which symbol?

A.   /

B.   *

C.   #

D.   &

E.   !

24: Can Excel spreadsheets contain images?

A.   Only when the Workbook is imported from another file format

B.   Yes

C.   No, Excel files cannot have images

D.   They can be inserted only with Macros

E.   A special add-on must be installed

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

26: You have two columns summing your account totals. The first column looks exactly right but the second one is not displaying the way you want. How do you make the two columns look the same?

A.   Delete both columns. Reytpe values.

B.   Copy the first column. Select the second column. Paste.

C.   Copy the first column. Select the second column. Use "Paste Special" to paste "Formats".

D.   Delete second column. Insert new column. Retype values.

27: Can you print only a selected part of your workbook?

A.   Yes, you can control what part of the workbook is printed.

B.   No, you cannot select parts of a workbook, only the number of pages to print.

28: It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?

A.   Yes

B.   No

29: Which formula below will add the value of B2 to the value of C3

A.   =C3+B3

B.   =B2+C3

C.   =6+4

D.   =B+C

30: What is the short cut for saving a file in Excel?

A.   Shift + C

B.   Ctrl + S

C.   Ctrl + F

D.   Command + K

E.   Shift + S

31: What is one way to get a new workbook?

A.   File, Save

B.   Format, Row

C.   File, New

D.   Edit, Cut

E.   Escape Key

32: Is there a way to share your spreadsheet and allow someone to change it?

A.   Only by email

B.   No

C.   Yes

33: True or False: You can create a connection to a SQL Server Analysis Services Cube in Excel.

A.   False

B.   True

34: True or False: The value in a cell that contains the formula =RAND() changes every time any change is made to the workbook.

A.   True

B.   False

35: How do you change text's alignment within a cell?

A.   You can not align an individual cell

B.   Select auto-fit in the cell

C.   Use the commands in the font group on the Home tab

D.   Select the cell and click the appropriate alignment button in the alignment group on the Home tab

36: True or False: You can save any Excel document as a web page.

A.   True

B.   False

37: A user can sort a maximum of...

A.   3 columns

B.   5 columns

C.   Infinite columns

D.   10 columns

E.   7 columns

38: True or False: A sparkline usually shows trend information.

A.   True

B.   False

39: True or False: The data can be typed in either the cell or in the Formula bar.

A.   False

B.   True

40: You can convert your Excel document into a Google doc.

A.   False

B.   True

41: True or False: Excel will recognize patterns in data and automatically enter formulas where the patterns continue.

A.   True.

B.   False.

42: True or False: You can protect a single worksheet and leave the others with full access.

A.   True

B.   False

43: True or False: Excel has trigonometry functions built into it.

A.   False

B.   True

44: True or False: A pivot table is a "dynamic summary report generated from a database."

A.   False

B.   True

45: True or False: You can add new commands to the QAT.

A.   True

B.   False

46: True or False: Numbers in Excel can assume many different formats: date, time, percentage, or decimals.

A.   False

B.   True

47: Can you save a .xlsx file as a .xls file?

A.   No

B.   Yes

48: Is it possible to sort by the color of a cell in the most recent version of excel?

A.   No

B.   Yes

49: Which of the following is not a term of MS-Excel?

A.   Columns

B.   Document

C.   Rows

D.   Cells

50: How do you create a table on excel?

A.   insert>table

B.   data>table