黃歆茹excel串接字串concatenate試算表歷史

嵌入embed影片

嵌入網頁電子試算表發展歷史

excel常用函數

https://www.w3schools.com/excel/excel_functions.php 
Function	Description
=AND	Returns TRUE or FALSE based on two or more conditions
=AVERAGE	Calculates the average (arithmetic mean)
=AVERAGEIF	Calculates the average of a range based on a TRUE or FALSE condition
=AVERAGEIFS	Calculates the average of a range based on one or more TRUE/FALSE conditions
=CONCAT	Links together the content of multiple cells
=COUNT	Counts cells with numbers in a range
=COUNTA	Counts all cells in a range that has values, both numbers and letters
=COUNTBLANK	Counts blank cells in a range
=COUNTIF	Counts cells as specified
=COUNTIFS	Counts cells in a range based on one or more TRUE or FALSE condition
=IF	Returns values based on a TRUE or FALSE condition
=IFS	Returns values based on one or more TRUE or FALSE conditions
=LEFT	Returns values from the left side of a cell
=LOWER	Reformats content to lowercase
=MAX	Returns the highest value in a range
=MEDIAN	Returns the middle value in the data
=MIN	Returns the lowest value in a range
=MODE	Finds the number seen most times. The function always returns a single number
=NPV	The NPV function is used to calculate the Net Present Value (NPV)
=OR	Returns TRUE or FALSE based on two or more conditions
=RAND	Generates a random number
=RIGHT	Returns values from the right side of a cell
=STDEV.P	Calculates the Standard Deviation (Std) for the entire population
=STDEV.S	Calculates the Standard Deviation (Std) for a sample
=SUM	Adds together numbers in a range
=SUMIF	Calculates the sum of values in a range based on a TRUE or FALSE condition
=SUMIFS	Calculates the sum of a range based on one or more TRUE or FALSE condition
=TRIM	Removes irregular spacing, leaving one space between each value
=VLOOKUP	Allows vertical searches for values in a table
=XOR	Returns TRUE or FALSE based on two or more conditions
Answer=(4,4,3,4,3,2,3,3,4,2,4,4,4,3,4,2,3,1,1,2,1,2,3,3,1,3,4,4,3,4,1,4,3,2,4,2,2,3,2,4,1,4,1,1,4,3,1,2,4,1,2,1,4,4,4,1,4,2,1,3,3,1,4,4,3,2,2,2,4,4,1,3,3,1,2,4,1,3,4,4,2,4,4,3,4,1,3,2,3,2,3,2,2,2,4,4,4,1,1,2,2,4,4,1,4,1,4,4,4,2,1,1,2,1,2,1,2,2,3,3,3,4,2,1,1,1,1,2,2,1,4,4,4,4,4,4,4,3,4,4,1,1,2,2,3,4,4,3,1,4,2,3,3,2,1,3,4,4,2,4,1,1,3,3,2,2,3,1,2,1,4,3,3,2,2,2,1,4,2,4,3,3,3,1,3,3,2,3,3,1,4,4,3,2,4,2,2,4,1,1,1,3,1,3,2,2,3,4,4,3,2,2,1,2,4,1,1,2,2,1,1,1,3,1,2,2,2,1,1,4,1,3,1,1,1,1,1,3,1,2,3,3,3,2,4,3,3,3,1,2,4,2,3,3,1,4,2,3,3,3,4,1,2,3,2,3,4,2,3,4,4,1,2,4,3,4,4,2,2,3,1,4,3,4,2,1,2,3,2,4,2,1,3,4,1,2,1,1,4,1,2,4,1,4,3,4,4,2,2,1,1,2,3,4,3,3,1,3,1,4,4,3,2,4,4,2,1,1,4,1,1,2,3,2,3,3,4,2,2,4,3,3,3,2,1,1,2,2,4,1,4,1,3,1,1,4,1,4,4,3,1,4,3,3,2,1,1,4,2,4,2,4,1,1,4,1,3,1,2,4,1,1,4,1,3,1,3,4,1,4,2,3,1,3,2,3,3,3,4,2,3,4,3,1,4,1,3,3,4,4,4,4,1,2,3,1,3,3,3,1,3,4,1,3,1,4,1,3,2,4,4,3,1,1,4,2,1,3,1,2,2,1,1,4,3,2,3,4,1,4,1,1,4,2,1,2,1,2,4,3,1,3,3,2,4,3,1,2,1,3,3,3,1,4,3,1,3,2,3,1,3,1,4,1,1,4,4,2,3,1,4,4,3,4,1,3,4,2,3,4,4,2,3,1) for i in Answer: print(i) 4 4 3 4 3 2 3 3 4 2 4 4 4 3 4 2 3 1 1 2 1 2 3 3 1 3 4 4 3 4 1 4 3 2 4 2 2 3 2 4 1 4 1 1 4 3 1 2 4 1 2 1 4 4 4 1 4 2 1 3 3 1 4 4 3 2 2 2 4 4 1 3 3 1 2 4 1 3 4 4 2 4 4 3 4 1 3 2 3 2 3 2 2 2 4 4 4 1 1 2 2 4 4 1 4 1 4 4 4 2 1 1 2 1 2 1 2 2 3 3 3 4 2 1 1 1 1 2 2 1 4 4 4 4 4 4 4 3 4 4 1 1 2 2 3 4 4 3 1 4 2 3 3 2 1 3 4 4 2 4 1 1 3 3 2 2 3 1 2 1 4 3 3 2 2 2 1 4 2 4 3 3 3 1 3 3 2 3 3 1 4 4 3 2 4 2 2 4 1 1 1 3 1 3 2 2 3 4 4 3 2 2 1 2 4 1 1 2 2 1 1 1 3 1 2 2 2 1 1 4 1 3 1 1 1 1 1 3 1 2 3 3 3 2 4 3 3 3 1 2 4 2 3 3 1 4 2 3 3 3 4 1 2 3 2 3 4 2 3 4 4 1 2 4 3 4 4 2 2 3 1 4 3 4 2 1 2 3 2 4 2 1 3 4 1 2 1 1 4 1 2 4 1 4 3 4 4 2 2 1 1 2 3 4 3 3 1 3 1 4 4 3 2 4 4 2 1 1 4 1 1 2 3 2 3 3 4 2 2 4 3 3 3 2 1 1 2 2 4 1 4 1 3 1 1 4 1 4 4 3 1 4 3 3 2 1 1 4 2 4 2 4 1 1 4 1 3 1 2 4 1 1 4 1 3 1 3 4 1 4 2 3 1 3 2 3 3 3 4 2 3 4 3 1 4 1 3 3 4 4 4 4 1 2 3 1 3 3 3 1 3 4 1 3 1 4 1 3 2 4 4 3 1 1 4 2 1 3 1 2 2 1 1 4 3 2 3 4 1 4 1 1 4 2 1 2 1 2 4 3 1 3 3 2 4 3 1 2 1 3 3 3 1 4 3 1 3 2 3 1 3 1 4 1 1 4 4 2 3 1 4 4 3 4 1 3 4 2 3 4 4 2 3 1

留言

張貼留言

這個網誌中的熱門文章

黃歆茹python字串方法in找到特定「題號」和題目

設定網頁的style就是css=cascading style sheets file = open('金融常識.txt','r',encoding='utf-8') lines = file.readlines() file.seek(0) #讀完readlines()記憶體指標回到檔案開頭 reading = file.read() #上個星期read()是讀取所有字元 file.close() total=len(lines) print(total, len(reading)) x = input('金一乙黃歆茹輸入搜尋關鍵詞,列出所有題目: ') n = 0 for i in range(total): #迴圈使用數字0到503 if x in lines[i]: # if line.find(x) != -1: 使用python更強的功能in n += 1 # 被更常使用 print(n, '題號',i+1,lines[i],end="")#預設結束換列 print(f'\n總共{n}題目') 504 37241 金一乙黃歆茹輸入搜尋關鍵詞,列出所有題目: 選擇權 1 題號 38 下列何者不屬於衍生性金融商品？(1)股票選擇權(2)債券期貨(3)組合式股票基金(4)利率交換合約 2 題號 55 期貨交易，指依國內外期貨交易所或其他期貨市場之規則或實務，從事衍生自商品、貨幣、有價證券 、利率、指數或其他利益之下列何種契約之交易？(1)期貨契約(2)選擇權契約(3)期貨選擇權契約(4)以上皆是 3 題號 129 小黃因疫情慘澹失業後，個人經濟遭遇困難、信用紀錄也開始惡化，還好受惠於近年來金融業積極 推動普惠金融服務，請問以下小黃獲得之幫助何者非屬普惠金融相關?(1)小黃得以較低保費取得基本保險保障(2)小黃報名參加某證券商舉辦的期貨商品投資講座，學習投資期貨或選擇權獲利(3)某銀行提供小黃低碳運輸微型 貸款，幫助小黃購置電動機車代步、開啟外送員新人生(4)小黃透過完整的網銀服務，在失業期間為了節省房租 而搬回鄉下老家時，也可以享受 e指理財、從線上進行基金申購 4 題號 210 認購權證之「發行者」相...
閱讀完整內容

黃歆茹w3schools字串str串列list集合set字典dict元組tuple

A="以下有關聯合國永續發展目標（Sustainable Development Goals, SDGs）之敘述，請問何者有誤?(1)SDGs 4是「確保有教無類、公平以及高品質的教育，及提倡終身學習」（Quality Education），包含消除教育上的性別差距不能雙重標準公然性羞辱(2)SDGs 5是「實現性別平等，並賦予婦女權力」（Gender Equality），包含終結所有對婦女和女童的各種形式歧視(3)SDGs 8是「促進包容且永續的經濟成長，讓每個人都有一份好工作」（Decent Work and Economic Growth），包含保護勞工的權益，為所有勞工創造安全有保障的工作環境(4)SDGs 16是「促進和平多元的社會，確保司法平等，建立具公信力且廣納民意的體系」（Peace, Justice and Strong Institutions），包含促進及落實沒有歧視的法律與政策，以實現永續發展" a='字串string串列list集合set字典dict' B=list(A) print('利用A建構串列B',B) print('A的型態',type(A),'B的型態',type(B)) C='Your are not my type.你不是我的菜' C=set(A);print('二指令放在同一列格;',type(C)) D=set(B);print('由串列產生的集合;',type(D)) print('字串A,串列B產生的集合相等?',C==D) print('字串A,串列B產生的集合相等?',C!=D)
閱讀完整內容