Excel MCQs (Multiple Choice Questions)

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

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

A. No

B. Yes

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

B. False

60: True or False: Charts from Excel can be pasted into Power Point.

A. False

B. True

61: Is it possible to determine the day of the week for a particular date?

A. Yes, Excel offers several ways of doing so.

B. No, Excel does not have this capability

C. No, this will result to computer error.

62: True of False? Excel 2013 will let you save a file into a cloud service, like Microsoft OneDrive or Sharepoint.

A.

B. False

C. True

63: Which of the following formats can you decide to apply in the AutoFormat dialog box?

A. All of these

B. Number format

C. Border format

D. Font format

64: True or False: You can customize your toolbars and menus.

A. True

B. False

65: Can you create Macros on excel?

A. true

B. false

66: A formula in Excel must begin with the operator:

A. /

B. --

C. =

D. @

67: True or False: Excel has the capability to sort horizontally from left to right or right to left.

A. False

B. True

68: How to compute a sum?

A. Ask your friend for his calculator

B. Use sum formula and select the relevant cells as argument

69: True or False: There are three worksheets with every new workbook. You can change that automatic number if you want to.

A. False

B. True

70: True or False: A Name can be applied to a single cell or a range of cells.

A. True

B. False

71: Excel can retrieve external data from which of the following sources?

A. Data Connection Wizard

B. All of these

C. SQL Server

D. Microsoft Query

E. XML Data Import

72: How many conditions can be set for an individual cell's conditional formatting?

A. 3

B. Any of these

C. 2

D. 1

E. 0

73: a formula is always started with what symbol?

A. +

B. =

C. -

D. $

E. *

74: What-If analysis functionality in Excel includes:

A. All of these

B. Scenario Manager

C. Data Tables

D. Goal Seek

75: True or False: You can delete data in a cell by hitting the delete key in the keyboard.

A. False

B. True

A. True

B. False

77: The functions AVERAGEIF and SUMIF both use cell values that match specified criteria.

A. False

B. True

78: True or False: It is possible to access Outlook, Word or other Microsoft products through Excel.

A. False

B. True

79: Is SmartArt available in Excel?

A. Yes

B. No, it is only available in Word.

C. No, it is only available in PowerPoint.

80: What does the function DATE(year, month, day) do?

A. Adds the number of days in between dates

B. Extracts the day of the month from the date value

C. Creates a date value for the date represented by the year, month, and day arguements

D. Extracts the year number from the date value

81: True or False: It is possible to sort information both vertically (by columns) and horizontally (by rows)

A. True

B. False

82: Each location in an Excel spreadsheet is called a:

A. Tab

B. Square

C. Cell

D. Cube

83: Can you insert images from ClipArt into Excel?

A. Yes

B. No

84: Where do you find the picture icon?

A. The review tab.

B. The formula tab.

C. The insert tab.

D. The home tab.

E. The data tab.

85: When you write up a lookup formula to look up the text "budget", the formula considers any of the following a match: BUDGET, Budget, or BuDgEt. Is it possible to perform a case-sensitive lookup?

A. Yes

B. No

86: Which symbol is used as a reference operator?

A. All of these can be used

B. A Space

C. A Comma

D. A Colon

87: True or False: When you record a macro in Excel, you are actually creating a VBA program.

A. False

B. True

88: Excel 2003: You can enter three types of data in a cell these are?

A. text, numbers, and formulas.

B. numbers and text only

C. formulas only

D. images, sounds, videos

E. text only

89: True or False: You can convert an existing shape to a Freeform Shape.

A. False

B. True

90: How would you rename the tabs at the bottom of the spreadsheet?

A. Both ways: right click on tab and type new name or double click tab and type new name.

B. Left click tab and type new name.

C. Single click on column header and type new name.

91: lookup _value argument is the value that is searched for in the first column of the table array

A. True

B. False

92: Which of the following is a "Lookup and Reference" function?

A. Sumif

B. Iferror

C. Average

D. VLookup

E. Sum

93: What does the function FV stand for?

A. Current Value

B. Present Value

C. Future Value

D. Future Variety

94: True or False: Frequency is an array function.

A. False

B. True

95: All forumulas in Excel begin with the following symbol

A. +

B. #

C. =

D. %

96: You can change the color of the following in Excel:

A. Background

B. Font

C. Headers/Footers

D. All Listed

E. Borders

97: Which of the following is NOT a way to align a cell?

A. Align Left

B. Align Reverse

C. Align Center

D. Align Right

98: What is the formula used to multiply cell A1 by cell C1?

A. =A1XC1

B. = A*C,1

C. =A1*C1

D. = A1/AC

E. =A1+AC,times

99: The standard name of each cell is based on its _ and

A. Level and priority

B. Row and column

C. Age and sequence

D. Height and width

100: Currency figures in Excel can be changed from US Dollars to the:

A. Yuan

B. Euro

C. None Listed

D. All Listed

E. Rupee

Excel MCQs

Excel MCQs

1: What company distributes Excel?

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?

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

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.

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

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

7: The definition of a macro is:

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

9: The Doughnut chart type

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

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

12: How do you close a formula?

13: How to search text in Excel?

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

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

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

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

18: A pivot table allows you to:

19: What is a cell?

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

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

22: Which is a type of operator?

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

24: Can Excel spreadsheets contain images?

25: Which types of charts can excel produce?

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?

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

50: How do you create a table on excel?

51: True or False: Formulas can be edited across multiple worksheets at the same time.

52: It is possible to password protect content of selected cells so that cannot be modified

53: Can a macro save a file?

54: The following functions are listed when the office button is selected:

55: True or false: To change column width in MS Excel, put cursor on the right side of the cell in that column, in the first row. Click and hold and drag to desired width.

56: How does one change the font style of the selected cell to *bold*.

57: True or False: It is possible to have a folder of templates in Excel to make it easier to access them.

58: Can the Match & Index Functions be combined together to perform a lookup?

59: True or False: You can create a two-input data table.

60: True or False: Charts from Excel can be pasted into Power Point.

61: Is it possible to determine the day of the week for a particular date?

62: True of False? Excel 2013 will let you save a file into a cloud service, like Microsoft OneDrive or Sharepoint.

63: Which of the following formats can you decide to apply in the AutoFormat dialog box?

64: True or False: You can customize your toolbars and menus.

65: Can you create Macros on excel?

66: A formula in Excel must begin with the operator:

67: True or False: Excel has the capability to sort horizontally from left to right or right to left.

68: How to compute a sum?

69: True or False: There are three worksheets with every new workbook. You can change that automatic number if you want to.

70: True or False: A Name can be applied to a single cell or a range of cells.

71: Excel can retrieve external data from which of the following sources?

72: How many conditions can be set for an individual cell's conditional formatting?

73: a formula is always started with what symbol?

74: What-If analysis functionality in Excel includes:

75: True or False: You can delete data in a cell by hitting the delete key in the keyboard.

76: True or false? The Quick Access Toolbar (QAT) is useful for adding popular commands.

77: The functions AVERAGEIF and SUMIF both use cell values that match specified criteria.

78: True or False: It is possible to access Outlook, Word or other Microsoft products through Excel.

79: Is SmartArt available in Excel?

56: How does one change the font style of the selected cell to bold.

99: The standard name of each cell is based on its _ and