1) ________ and _______ are two types of data in Excel. a) Constants and Formulas b) Variables and Alphabets c) Constants and Functions d) Formulas and Functions 2) Cells are identified by a specific column_____ and row________. a) Number, Letter b) Letter, Number c) Heading, Heading d) Row, Column 3) A group of related cells in a worksheet is called _________. a) cell bunch b) cell group c) cell range d) cell relation 4) ________ operators are used to perform mathematical calculations. a) Calculative b) Comparison c) Reference d) Arithmetic 5) The order in which Excel performs operations in formulas is called _________________. a) Parantheses b) Order of Calculation c) Order of performance d) Order 6) The _________________ will quickly copy formulas across rows or columns in the worksheet. a) Autofill b) Autofit c) Autorefill d) Autocut 7) _________ separates cell references in a function. a) SemiColon (;) b) Comma (,) c) Colon (:) d) Dash (-) 8) Functions in Excel always begin with the __________ sign. a) Parantheses () b) Colon (:) c) Slash (/) d) Equal to(=) 9) The _____________function in Excel is used to display the highest value in a range. a) MAXIMUM b) MAX c) HIGHEST d) HIGH 10) A formula using the ________ cell reference keeps the cell reference constant. a) Absolute b) Mixed c) Relative d) Constant

Excel : Formula and Function

In
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

Bạn có muốn khôi phục tự động lưu: không?