Free MOS Excel Questions and Answers — Questions and Answers
Question 1: What steps would you follow if you were to copy the data from the first cell down a whole column, ending at the last row of data in the spreadsheet?
- Double-click the Fill Handle after selecting the cell to copy. (Correct answer)
- To copy a cell, double-click it, hold down the Shift key, then click the Fill Handle.
- To copy a cell, click it, then hold down the Control key and click the Fill Handle.
- After selecting a cell, double-click it to make a copy of it.
Correct answer: Double-click the Fill Handle after selecting the cell to copy.
Explanation: <br> To copy data in the first cell down an entire column, you click on the cell to copy and then double-click on the Fill Handle, which is the small square at the bottom right corner of the selected cell. This action automatically fills the column down to the last row of data in the spreadsheet.
Question 2: Which group of commands and ribbon menu will the Find & Select tool be located under?
- Data > Editing
- Home > Editing (Correct answer)
- Insert > Editing
- Home > Sorting
Correct answer: Home > Editing
Explanation: <br> Home > Editing option provides access to the Find & Select tool in Excel.
Question 3: Which field or box would you enter "California" into if you wished to replace out "Boulder" with "Anaheim"?
- Replace With: (Correct answer)
- Replace All:
- Find What:
- Find Next:
Correct answer: Replace With:
Explanation: <br> When you want to replace one value with another in Excel, you type the new value into the "Replace with:" field. This action helps you quickly update or modify data in your spreadsheet.
Question 4: A dialogue box will open after you've finished a Find and Replace. What information is it providing?
- Click OK to start the process.
- Click OK to complete the process.
- It will provide the number of instances found.
- It will provide the number of replacements made. (Correct answer)
Correct answer: It will provide the number of replacements made.
Explanation: <br> When you perform a Find and Replace operation in Excel, the dialogue box that opens after completion typically provides information about the number of replacements that were made. This helps you confirm that the desired changes have been applied to your data.
Question 5: What would you click under Find and Replace if you wanted to search the whole workbook for all instances of the text "California" and replace it with "Anaheim"?
- Options > Match case
- Options > Within > Workbook (Correct answer)
- Options > Search > By rows
- Options > Look in > Formulas
Correct answer: Options > Within > Workbook
Explanation: <br> "Options: Within: Workbook” option allows you to search for the text "California" and replace it with "Anaheim" throughout the entire workbook. It ensures that your search covers all sheets and cells within the workbook, enabling comprehensive text replacement.
Question 6: Which of these opens a new Excel for Mac workbook?
- Alt + N
- Control + N
- Command + N (Correct answer)
- Command + Z
Correct answer: Command + N
Explanation: <br> On Excel for Mac, pressing "Command + N" creates a new workbook. This keyboard shortcut allows users to quickly open a new Excel file without navigating through the menu options.
Question 7: If you select the "Options" button in the "Find" dialogue box, what additional Find options will appear?
- Match entire cell contents
- Match case
- Search workbook
- Search worksheet
- All of the above (Correct answer)
Correct answer: All of the above
Explanation: <br> Clicking on the Options button in the Find dialogue box in Excel allows you to access additional find options such as "Match case," "Search workbook," "Match entire cell contents," and "Search worksheet." These options provide more flexibility and precision when searching for specific data within your Excel file.
Question 8: What is the name of the small square located in the lower right corner of a selected cell or range?
- The Grab Bar
- The Black Box
- The Fill Handle (Correct answer)
- The Fill Tool
Correct answer: The Fill Handle
Explanation: <br> It's called the Fill Handle because it allows you to fill cells with data or formulas quickly by dragging them across adjacent cells.
Question 9: Where should you look if the Excel drop-down menu doesn't have the Quick Access Toolbar option?
- The file menu
- The home ribbon
- More Commands' at the bottom of the drop-down menu (Correct answer)
- All of the above
Correct answer: More Commands' at the bottom of the drop-down menu
Explanation: <br> "More Commands" at the bottom of the drop-down menu option allows you to customize the Quick Access Toolbar by adding commands that aren't initially displayed in the drop-down menu.
Question 10: Do the following to make your spreadsheet like the example above: <br><br> Task 1 – design column D as in the image. <br> Task 2 – define the print area to columns D:I <br> Task 3 – add page breaks between the data cells of each university. <br><br> What is not true in the design of the texts in cells D3:D22? <br>
- It is centered.
- The alignment is in the middle.
- The text was designed to be vertical. (Correct answer)
Correct answer: The text was designed to be vertical.
Explanation: <br> It is not a vertical text. The letters in a "vertical text" design appear one over the other rather than rotated: <br> B <br> r <br> o <br> w <br> n <br>
Question 11: Do the following: <br> Task 1 - Completely remove the formatting of cells A1:C1 <br> Task 2 - Apply the formatting of cells A2:C2 to cells E1:I1 <br><br> What is not true regarding the above?
- Use “Paste > Keep Source Formatting” to do Task 2. (Correct answer)
- The formatting of cells A1:C1 can be cleared.
- Use “Format Painter” to do Task 2.
Correct answer: Use “Paste > Keep Source Formatting” to do Task 2.
Explanation: <br> Using "Paste > Keep Source Formatting" will additionally copy the data in cells A2:C2 to cells E1:I1. <br> <br> Using the "clear formats" function found in the "Home" tab is the most effective way to do Task 1. <br> <br> Using the "format painter" option found in the "Home" tab is the most effective way to complete Task 2.
Free MOS Excel Questions and Answers
What steps would you follow if you were to copy the data from the first cell down a whole column, ending at the last row of data in the spreadsheet?