FREE MOS Excel 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?

Accepted Answer

Double-click the Fill Handle after selecting the cell to copy.

Answer

To copy a cell, double-click it, hold down the Shift key, then click the Fill Handle.

Answer

To copy a cell, click it, then hold down the Control key and click the Fill Handle.

Answer

After selecting a cell, double-click it to make a copy of it.

Question 2

Which group of commands and ribbon menu will the Find & Select tool be located under?

Accepted Answer

Home > Editing

Answer

Data > Editing

Answer

Insert > Editing

Answer

Home > Sorting

Question 3

Which field or box would you enter "California" into if you wished to replace out "Boulder" with "Anaheim"?

Accepted Answer

Replace With:

Answer

Replace All:

Answer

Find What:

Answer

Find Next:

Question 4

A dialogue box will open after you've finished a Find and Replace. What information is it providing?

Accepted Answer

It will provide the number of replacements made.

Answer

Click OK to start the process.

Answer

Click OK to complete the process.

Answer

It will provide the number of instances found.

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"?

Accepted Answer

Options > Within > Workbook

Answer

Options > Match case

Answer

Options > Search > By rows

Answer

Options > Look in > Formulas

Question 6

Which of these opens a new Excel for Mac workbook?

Accepted Answer

Command + N

Answer

Alt + N

Answer

Control + N

Answer

Command + Z

Question 7

If you select the "Options" button in the "Find" dialogue box, what additional Find options will appear?

Accepted Answer

All of the above

Answer

Match entire cell contents

Answer

Match case

Answer

Search workbook

Answer

Search worksheet

Question 8

What is the name of the small square located in the lower right corner of a selected cell or range?

Accepted Answer

The Fill Handle

Answer

The Grab Bar

Answer

The Black Box

Answer

The Fill Tool

Question 9

Where should you look if the Excel drop-down menu doesn't have the Quick Access Toolbar option?

Accepted Answer

More Commands' at the bottom of the drop-down menu

Answer

The file menu

Answer

The home ribbon

Answer

All of the above

Question 10

Do the following to make your spreadsheet like the example above:

Task 1 – design column D as in the image.
Task 2 – define the print area to columns D:I
Task 3 – add page breaks between the data cells of each university.

What is not true in the design of the texts in cells D3:D22?

Accepted Answer

The text was designed to be vertical.

Answer

It is centered.

Answer

The alignment is in the middle.