呂婭鈮w3shools的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
計算機，有STYLE下面的BODY{....}的設定刪掉，然後就會出現計算機。 簡易網頁計算機

留言

張貼留言

這個網誌中的熱門文章

呂婭鈮輸入方塊的Return事件

圖片
import tkinter #輸入tkinter繪圖模組 #財金程式設計602 class Financial: #類別用於建構504道金融常識題目 def __init__(self, number, q, a, b, c, d, ans): self.number, self.q, self.ans = number, q, ans self.a, self.b, self.c, self.d = a, b, c, d def check(choice): choice = reply.get() #以字串存'1'...'4' temp = number.get() - 1 #題號 if choice == '1': LBa.config(bg="#a4abc1") if choice == List[temp].ans: LBa.config(bg='blue',fg='white') if choice == '2': LBb.config(bg="#a4abc1") if choice == List[temp].ans: LBb.config(bg='blue',fg='white') if choice == '3': LBc.config(bg="#a4abc1") if choice == List[temp].ans: LBc.config(bg='blue',fg='white') if choice == '4': LBd.config(bg="#a4abc1") if choice == List[temp].ans: LBd.config(bg...
閱讀完整內容

甲班呂婭鈮PYTHON特色:維基百科

維基百科PYTHON 網址前後加上引號'(可以單引號'SINGLE QUOTATION MARK也可以雙引號"DOUBLE QUOTATION MARK)，命令SRC=SOURCE來源，嵌入框架中FRAME這些都是HTML=HyperText Markup Language=超文件標記語言。告訴大家你也學過CSS 縮排INDENTATION Python uses whitespace indentation(使用空白鍵縮排), rather than curly brackets or keywords(而不是使用大括號捲的括號或關鍵字), to delimit blocks(來分隔區段). An increase in indentation comes after certain statements; a decrease in indentation signifies the end of the current block.[82] Thus, the program's visual structure accurately represents its semantic structure.[83] This feature is sometimes termed the off-side rule. Some other languages use indentation this way; but in most, indentation has no semantic meaning. The recommended indent size is four space. Python語法中的複合語句，包含了一些其他語句，它們以某種方式影響或控制這些其他語句的執行。Python的複合語句包含一個或多個子句（clause），子句構成自一個頭部（header）和一個套件（suite）。特定複合語句的子句頭部都在同樣的縮排層級上，每個子句頭部開始於一個唯一標識關鍵字，並結束於一個冒號。套件即語法意義上的塊，是這個子句所控制的一組語句。
閱讀完整內容

呂婭鈮甲班期末考為python貪吃蛇增加速度

圖片
from tkinter import * import random GAME_WIDTH,GAME_HEIGHT = 1000, 400 SPEED = 1000 #時間單位千分之一 SPACE_SIZE, BODY_PARTS= 50, 3 #左邊變數 assigning value SNAKE_COLOR = ["red","orange","yellow","green","blue","indigo", "purple"] FOOD_COLOR = "white" BACKGROUND_COLOR = "black" class Snake: def __init__(self): self.body_size = BODY_PARTS self.coordinates = [] self.squares = [] for i in range(0, BODY_PARTS): self.coordinates.append([0, 0]) for x, y in self.coordinates: i = random.randint(0,6) square = canvas.create_rectangle(x, y, x + SPACE_SIZE, y + SPACE_SIZE, fill=SNAKE_COLOR[i], tag="snake", width=20,outline='blue') self.squares.append(square) class Food: def __init__(self): x = random.randint(0, int(GAME_WIDTH / SPACE_SIZE)-1) * SPACE_SIZE y = random.randint(0, int(GAME...
閱讀完整內容