MS Office Excel
What is the difference between an AutoFiltered range of records in a list and a table?
None.
A table maintains its sort order after you close and re-open it.
A table given a title enables its field names to be used in formulas in place of cell references.
A table enables special subtotal functions for total rows.
A table given a title enables its field names to be used in formulas in place of cell references.
Related posts
Which tool you will use to join some cells and place the content at the middle of joined cell?A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
A(n) _________ is a prewritten formula that is built into EXCEL.
A. function
B. problem
C. equation
D. equal sign
The design of text.
A. Font
B. Cell
C. Range
D. Merge
You can print only an embedded chart by
A. Moving the chart to a chart sheet before you print.
B. Formatting the chart before you print
C. Selecting the chart before you print
D. a and c
Colton is calculating his GPA. If he uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
A. Values
B. Formulas
C. Labels
D. Functions
Which of the following is the oldest spreadsheet package?
A. VisiCalc
B. Lotus 1-2-3
C. Excel
D. StarCalc
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cell in that range that contain 100. Wha
A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF
Leave a Reply