Users in private browsing 

In Chrome's incognito mode, the language of the spreadsheet is determined by your browser's language. If you want to change the language, please update it here:  chrome://settings/ > languages

Make sure to set your preferred language, the one you wish to use in the spreadsheets, as the top priority.

ℹ️ NOTE: The browser must be closed and reopened for the changes to take effect.

The language cannot be changed directly from the spreadsheet. If you click on File > Settings, an error message will appear. You will need to refresh the browser to dismiss it.

Users with a Google account

The language of the spreadsheet can be changed directly in your Google account or from a Nexam spreadsheet.

  1. Open a spreadsheet.
  2. Click on File > Settings.
  3. Under “General”,
    • Select the language you want in Locale. This affects formatting details such as functions, dates, and currency;
    • Select your Time Zone. Your spreadsheet history will be saved according to your time zone. This will affect all time-related functions;
    • Click on Display language. The language management page for your Google profile will appear;
      • Add the language you want to add in another language; 
      • Use the arrow to move the language to the Preferred language section;
  4. Click on save settings in Nexam.
ℹ️ NOTE : If changing the language of your Google account does not update the language of the Sheets document in the Nexam platform, you must clear your browser history.

Calculation Formulas

To use a calculation formula in the Spreadsheet tab, simply enter the equal sign (=) followed by the formula name.

When a formula is selected, its description appears as it does in Excel and Google Sheets.

All formulas and their descriptions are available under the auto-sum icon ∑. The description of these formulas can be found at the following link: https://support.google.com/docs/table/25273.

Number Format

If English is set as the default language, periods (.) must be used to add decimal points, not commas (,). Using a comma will prevent the calculation from being executed. The period is required for a spreadsheet in English.

Please note that thousands must not be separated by manually added spaces. Number format can be adjusted in the worksheet

  1. Click on Format > Number
  2. Select the desired format
***

Nexam allows conceiving, managing, and correcting secure exams online, in classrooms, and remotely. Nexam is the preferred platform for professional orders, associations, government agencies, and teaching institutes. Visit our website Nexam.io!