Unit 8: MS Excel - Practice Quiz

1 Which symbol is used to begin a formula in MS Excel?

2 Which formula adds the values in cells A1 through A5?

3 Which formula calculates the average of values in cells B1 through B4?

4 What does the formula =A1+B1 do?

5 What is the main purpose of a graph in Excel?

6 Which part of a graph usually displays categories along the bottom?

7 What should you usually do before inserting a chart in Excel?

8 What does a chart legend identify?

9 Which chart type is commonly used to compare values across categories?

10 Which chart type is best for showing a trend over time?

11 Which chart type displays parts of a whole as slices?

12 Which chart type normally displays data using horizontal bars?

13 When do chart tools or the chart toolbar usually become available?

14 Which task can be performed using chart tools?

15 Which feature shows how a worksheet will look before it is printed?

16 Which keyboard shortcut commonly opens the Print screen in Excel?

17 Which page orientation prints a worksheet with the page wider than it is tall?

18 Which Page Layout setting controls the blank space around the edges of a printed page?

19 Where does a header appear on a printed worksheet page?

20 Which item is commonly inserted into a worksheet footer?

21 Cell F1 contains a fixed tax rate. In row 2, quantity is in B2 and unit price is in C2. Which formula calculates the total including tax and can be copied down correctly?

22 A student passes when the score in C2 is at least 50. Which formula displays Pass or Fail correctly?

23 Values are listed in B2:B20. Which formula entered in C2 creates a running total when copied downward?

24 Column A contains regions, column B contains sales, and E2 contains a selected region. Which formula totals sales only for that region?

25 A formula =B2/C2 should display 0 instead of an error when C2 is zero or blank. Which formula is most suitable?

26 You need to investigate whether advertising cost is related to sales revenue across 40 branches. Which graph setup is most appropriate?

27 Two graphs display the same monthly sales data, but one graph starts its vertical axis at 95 instead of 0. What is the likely effect?

28 A chart uses data from A1:B6. After a new value is entered in B4, what normally happens to the chart?

29 A chart was created from A1:B12, and a new month was added in row 13. The chart does not show it. What should you do?

30 A manager wants to show how website visits changed month by month over two years. Which chart type is most suitable?

31 A budget consists of rent, salaries, transport, utilities, and supplies. Which chart type best shows each category's share of the total for one month?

32 Product names are long, and you need to compare sales among 12 products. Which chart type will usually make the category labels easiest to read?

33 You need to compare monthly revenue and profit while also showing the profit-margin percentage on a different scale. Which approach is most appropriate?

34 A selected chart is a column chart, but you want to display the same data as a line chart. Which chart toolbar control is intended for this task?

35 You want the worksheet values to appear in a grid directly below the chart. Which chart toolbar command should you use?

36 A chart contains several elements, and selecting the value axis with the mouse is difficult. Which toolbar feature helps select it directly?

37 A worksheet contains notes in columns F:H, but only the table in A1:E40 should be printed. What is the best action?

38 A long table prints on several pages, and row 1 contains the column headings. How can you make those headings appear on every printed page?

39 A worksheet has many columns and only a few rows. Which page-layout change is most likely to fit the columns across the printed page?

40 Which custom footer entry automatically prints the current page number and the total number of pages in the form Page 2 of 5?

41 Cell C2 contains the formula =$A2*B$1. If it is copied to cell E4, which formula will appear in E4?

42 Which formula counts cells in A2:A50 whose text ends with a literal asterisk (*), rather than treating the asterisk as a wildcard?

43 Column A contains date-time values, column B contains regions, and column C contains sales. Which formula sums West sales from January through March 2025 while safely excluding every value on or after April 1?

44 A filtered worksheet also contains several manually hidden rows. Which formula totals only the visible cells in C2:C100?

45 A graph must display the unmodified values , , , and on one vertical axis. Which axis configuration is valid in Excel?

46 Two departmental graphs display the same metric, but one vertical axis spans 95–105 and the other spans 0–200. What change best supports a fair visual comparison?

47 A chart uses monthly data, and new records will be appended directly beneath the source range. Which design most reliably makes the chart include new rows automatically without editing its source each month?

48 A line chart should show a genuine zero as a plotted zero but omit a measurement that is unavailable. What should the unavailable source cell return?

49 Rows hidden by filtering are still being plotted in a chart. Which chart setting should be disabled so that only visible worksheet rows are plotted?

50 An experiment records responses at numeric input values 0.1, 0.2, 1.5, and 10. The horizontal spacing must represent the actual numerical distances. Which chart type is most appropriate?

51 A report must compare monthly revenue in dollars with profit margin percentages. Both trends must remain readable despite their different scales. Which chart design is most suitable?

52 A 100% stacked column chart compares product shares across regions. Which information cannot be determined reliably from this chart alone?

53 In a chart where months are currently separate series and products are category labels, what does the Switch Row/Column command primarily do?

54 A chart's series must be reordered so that Actual is drawn after Forecast, but the worksheet data order must remain unchanged. Which chart command should be used?

55 Rows 1:3 contain column headings that must appear at the top of every printed page, while remaining ordinary worksheet cells. Which printing feature should be configured?

56 Two nonadjacent ranges are defined together as the worksheet's print area. What is the usual printing result in Excel?

57 A worksheet has many rows and six columns. All six columns must fit on one page horizontally, but the report may use as many pages vertically as needed. Which Scale to Fit settings are appropriate?

58 A narrow print area should be centered between the left and right paper edges without changing cell alignment or vertical placement. Which Page Layout setting should be used?

59 Which custom footer code displays text such as Page 3 of 12, using the current page number and total page count automatically?

60 A report's first printed page must have no header, while pages 2 onward must display the same standard header. Which configuration satisfies this requirement?