Thread: MOS Certification for Excel assistance

Hi psettle,

1. Specify that the cell address currently in the edit line will NOT change even if copied to another cell.

Perhaps using absolute references, e.g. $A$1 instead of A1

2. Select and insert the worksheet function that will return the smallest number (including numbers, logical values and text) in a specified range of cells.

I would think the MINA() function would do this. However, if there's text in the range of arguments MINA will return 0. If only numbers and logical values, MINA will return the proper answer.

3. Select and insert the worksheet function that will display the current date & time as a serial date/time number.

=NOW()

4. Type a formula that will add the contents of cell D5 on the sheet named Sheet 1 and cell E5 on the sheet named Sheet 2. Both sheets are in the current workbook.

=Sheet1!D5+Sheet2!E5

5. Change all occurrences of the currency cell format (for example $5.01) to General at the same time.
Thanks

1. Select entire sheet
2. Click Edit -> Replace
3. To the right of 'Find What', click Format
4. Click 'Choose Format From Cell' button and select any cell with the Currency format
5. To the right of 'Replace With, click Format
6. Choose 'General' and click OK
7. Click 'Replace All', then click OK at the message saying how many replacements were made. Click 'Close' to close the Replace window.

Code:

Possible error on this on:
=Sheet1!D5+Sheet2!E5

Both sheet names in the question contain a space: "Sheet 1" and "Sheet 2".
Consequently, single quotes around the sheet names are required:
='Sheet 1'!D5+'Sheet 2'!E5

I hope that helps.