Unit 7: MS Excel - Practice Quiz

1 Which part of the Excel window displays the contents or formula of the active cell?

2 What is the horizontal group of commands and tabs at the top of Excel called?

3 Which command creates a new blank workbook in Excel?

4 Which keyboard shortcut creates a new workbook in Excel?

5 Which keyboard shortcut opens an existing workbook?

6 Which file extension is commonly used for a modern Excel workbook?

7 Which keyboard shortcut saves the current Excel workbook?

8 Which command lets you save a workbook with a different name?

9 What does the cell range A1:A5 include?

10 Which symbol is used between the first and last cell references in a continuous range?

11 Which formatting option makes text appear darker and thicker?

12 Which number format is most suitable for displaying money values?

13 Which Excel function adds a group of numbers?

14 Which formula calculates the average of the values in cells B1 through B5?

15 Which Excel function returns one value when a condition is true and another value when it is false?

16 What does the AND function return when all its conditions are true?

17 Which Excel function returns the current date?

18 Which Excel function returns both the current date and current time?

19 Which function does the AutoSum command usually insert?

20 Which symbol commonly represents the AutoSum command in Excel?

21 After selecting several numerical cells, you want to view their Sum, Average, and Count without entering a formula. Which part of the Excel environment should you use?

22 You need to create a new monthly budget workbook with predefined headings, formulas, and formatting. What is the most efficient method?

23 A workbook listed under Recent was moved to a different folder, so its recent link no longer works. How should you open it?

24 You edited Sales.xlsx but want to keep the original unchanged and store the edited version as Sales_Updated.xlsx. Which command should you use?

25 How many cells are included in the range B2:F6?

26 You want to select the two nonadjacent ranges A2:A8 and D2:D8. Which method should you use?

27 A cell contains the number 42, but it must appear as 00042 while remaining numeric. Which number format should be applied?

28 Cell A1 contains 0.25. What will it display when the Percentage format with zero decimal places is applied?

29 Cells A1:A4 contain 10, a blank cell, the text N/A, and 20. What result will =SUM(A1:A4) return?

30 What is the result of the Excel formula =ABS(-12)+SQRT(16)?

31 What will =ROUND(12.345,2) return?

32 Cell B2 contains a student's score. Which formula displays Pass for a score of at least 50 and Fail otherwise?

33 An employee receives a bonus only if sales in B2 are at least 10000 and attendance in C2 is at least 90%. Which formula correctly returns Bonus or No Bonus?

34 A customer receives a discount if membership in C2 is Gold or purchases in D2 are at least 1000. Which formula is correct?

35 Assuming the result is formatted as a date, what does =DATE(2025,2,28)+1 return?

36 What type of value does the formula =NOW() return?

37 What result does =DATE(2025,3,15)-DATE(2025,3,10) return when the cell uses General format?

38 Cells B2:B6 contain numbers, and B7 is selected. What formula will AutoSum normally insert in B7?

39 Cells B2:D6 contain three columns of values. If you select B7:D7 and click AutoSum, which formulas are normally inserted?

40 A workbook contains formulas, cell formatting, charts, and three worksheets. Which file type should you choose to preserve these features?

41 Several workbooks are open, and the active workbook contains multiple worksheets. Which shortcut pair first moves to the next worksheet in the current workbook and then moves to the next open workbook?

42 After a keyboard shortcut is pressed, every formula cell displays its formula instead of its calculated result, but the underlying calculations remain unchanged. What most likely occurred?

43 A department needs to create many macro-free workbooks containing the same formulas, styles, and worksheet structure while preventing accidental changes to the master design. Which approach is most appropriate?

44 While working in a workbook containing three worksheets, a user presses Shift+F11 and then Ctrl+N. What is the expected result?

45 An .xlsx workbook downloaded from the internet opens with editing disabled and a security warning, although no password was assigned. What is the most likely cause and appropriate action if the file is trusted?

46 A CSV file contains identifiers such as 001234 and 03-04, which must remain literal text. Which opening method best prevents Excel from automatically removing zeros or converting values to dates?

47 A workbook containing VBA code is saved as .xlsm. The user then uses Save As, selects .xlsx, accepts the feature-loss warning, and closes the new file. Which statement is correct?

48 A workbook has three worksheets, formulas, cell colors, and custom number formats. It is saved as CSV while the second worksheet is active. What is retained in the CSV?

49 Cell B2 contains the formula =$A2*B$1. If it is copied to D4, which formula appears in D4?

50 What value is returned by =ROWS(B2:D6 C4:F8)*COLUMNS(B2:D6 C4:F8)?

51 A cell contains -12.3 and uses the custom number format 0.00;[Red](0.00);-;@. How will the value be displayed?

52 Cell A1 contains the numeric value 0.256 and is formatted as 0%, so it displays 26%. Cell B1 contains =A1*100 and uses General format. What does B1 display?

53 Cells A1:A4 contain, respectively, the number 5, the text value "7", the logical value TRUE, and a blank. What does =SUM(A1:A4,"7",TRUE) return?

54 What is the result of =ROUND(-250,-2)+ROUND(249,-2) in Excel?

55 Cell A1 contains the formula ="", which returns an empty string. What does =IF(ISBLANK(A1),"A",IF(A1="","B","C")) return?

56 If A1=0 and B1=5, what does =IFERROR(IF(AND(A1<>0,B1/A1>2),"Yes","No"),"Error") return?

57 Assuming the standard Excel date system, what date is returned by =DATE(2024,14,0)?

58 Cell A1 contains 23:30, and B1 contains 01:15 for the following day, but neither cell includes a date. If C1 uses the format [h]:mm, what does =MOD(B1-A1,1) display?

59 A numeric list has an active filter that hides several rows. When AutoSum is used beneath the filtered list, which behavior is normally intended?

60 Cells B2:D4 contain numbers, column A contains labels, and E2:E4 are empty. If E2:E4 are selected together and AutoSum is clicked, which formula is inserted into E3?