MS EXCEL Multiple Choice Questions and Answers

41. Which setting you must modify to print a worksheet using letterhead?

1. Paper
2. Margin
3. Layout
4. Orientation

42. What type of chart is useful for comparing parts of a whole ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

43. What type of chart is useful for comparing vaues over categories ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

44. What type of chart is useful for showing trends or changes over time ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

45. What do you use to create a chart?

1. Pie Wizard
2. Excel Wizard
3. Data Wizard
4. Chart Wizard

46. Which function is not available in the Consolidate dialog box?

1. Pmt
2. Average
3. Max
4. Sum

47. Which of the following methods will not enter data in a cell?

1. Pressing the Esc key
2. Pressing an arrow key
3. Pressing the tab key
4. Clicking the enter button to the formula bar

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

1. Referencing
2. Accessing
3. Functioning
4. None of the above

49. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

1. Re-format the spreadsheet
2. Insert a row
3. Increase the column width
4. Use the spacebar

50. Text formula:

1. Replace cell references
2. Return ASCII value of chracters
3. Concatenate and manipulate text
4. None of the above