Question

2. A number format that puts a dollar symbol before each value by default
a percent
C. comma
b. accounting
d. date/time
3. A function that adds a range of cells
a. ADD
b. PUUS
d. TOTAL
4. This is the tab in the Format Cells dialog box where you can change the orientati
a. alignment
b. orientation
d. view
5. A function that gets the average of a range of cells
a AVERAGE
C. MEAN
b. SUM
d. MEAN
6. Which among the following is not part of the syntax for AVERAGEIF
a. average range
c. logical test
b. range
d. criteria
7. A function used to count the number of cells that contains something in them if
met
a. COUNT
C. COUNTING
b. COUNTDOWN
d. COUNTIF
8. A function used to add a certain range of cells if a condition is met
a. SUMIF
C. TOTALIF
b. ADDIF
d. PLUSIF
9. The shortcut key for the Format Cells dialog box
a. Ctrl+ F
c. Ctrl+ 1
b. Shift+F
d. Ctrl+ 1
10. A syntax in the AVERAGEIF function that includes the value or label that detem
is part of the range to be averaged.
a. Range
b.criteria
c.average
d. Logical Test​

Answer 1

Answer:

hiii

Explanation:

have a great day dear

Answer 2

2. b. accounting

3. a. ADD

4. a. Alignment

5. a. AVERAGE

6. c. logical test

7. d. COUNTIF

8. a. SUMIF

9. d. Ctrl+1

10. a. range

• All these above functions are of Microsoft Excel.
• Microsoft Excel is a spreadsheet used for accounting, calculating, and compiling financial data.
• The file extension used in MS Excel is .xlsx
• It allows a user to form tables, add graphic tools, apply formulas in an easy manner.