Kedis ku xidhan hagaha · Dhexdhexaad Heerka

Sida Loo Qoro Qoraalada Faafinta iyo Macros ee AI Quiz

Tijaabi marka la isticmaalayo scripts qaabab, sida loo qoro ammaan VBA iyo codsiyada Script Apps, iyo sida loo tijaabiyo iimaylka iyo macros nadiifinta adoon lumin xogta.

Wadooyinka haga ee la xidhiidhaSida Loo Qoro Qoraalada Faafinta iyo Macros ee AI
Su'aal 1 ee 8

Hawshee ayaa u baahan qoraal halkii ay ka ahaan lahayd qaacido?

Horudhac su'aal kasta8 su'aalo

Jawaabaha iyo sharraxaadaha waxay soo baxayaan markaad qaadanayso kediska.

  1. Hawshee ayaa u baahan qoraal halkii ay ka ahaan lahayd qaacido?
    • Totaling a column of sales
    • Looking up a price from a table
    • Emailing every person whose status is Approved
    • Formatting a number as currency
  2. Luqadee xaashida Google u isticmaasha qoraalada?
    • VBA
    • Apps Script, which is JavaScript-based
    • Python
    • Office Scripts only
  3. Waa maxay sababta hagaha uu culayska saarayo makrosyada Excel ee nuqul ka mid ah faylka?
    • Macro changes generally cannot be undone with Ctrl+Z
    • Copies run macros faster
    • Excel refuses to run macros on original files
    • The AI cannot read the original file
  4. Waa maxay tijaabada ugu horeysa ee ugu badbaadsan qoraalka soo diraya iimaylada?
    • Send to the whole list at once to save time
    • Turn off the authorization prompt
    • Run it on a sheet with no data
    • Send only to yourself first, or list recipients before sending
  5. Waa maxay sababta makrodu u tirtirto safafka hoose?
    • VBA syntax requires it
    • Deleting from the top shifts row numbers and causes rows to be skipped
    • The bottom rows are always blank
    • It avoids hitting email quotas
  6. What is the most efficient way to process many cells in Apps Script?
    • Call getValue and setValue once for each cell
    • Write a separate script for each row
    • Read with getValues, process in memory, then write back with setValues
    • Refresh the sheet after every change
  7. How can a script avoid redoing work if it stops partway and is run again?
    • Mark each processed row, for example by writing "Sent" in a status column
    • Delete the script after each run
    • Ask Google to raise the quota
    • Hide rows once they are processed
  8. According to the guide, where does the real risk of macros come from?
    • The .xlsm file extension itself
    • Adding comments to the code
    • Using time-driven triggers
    • Running code you do not understand, especially in files from strangers