M1 MIDTERM TEST (EXCEL)

Excel is part of

• Access
• Microsoft Office
• PowerPoint

เครื่องหมายคำนวณทางคณิตศาสตร์ข้อใด ที่ใช้สำหรับการคูณ

• *
• x
• +
• &

• =if(D3<80,"A","F")
• =if(D3>80,"A","F")
• =if(D3>=80,"A","F")
• =if(D3<=80,"A","F")

เมื่อต้องการใช้สูตรคำนวณ จะต้องเริ่มด้วยเครื่องหมายใด เสมอ

• =
• -
• +
• ==

When numbers are added together the answer is called the

• Product
• Sum
• Quotient

The name of the cell located at the intersection of column F and row 223 is:

• 223F
• F223
• F222
• 22F3

Tags

CCSS.3.MD.B.3

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

What kind of software is Excel?

• Spreadsheet software
• Word Processing
• Drawing

True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?

• false
• true

What is the name of this cell?

• B10
• 5B
• B5
• A5