User developed instruction for excel are called__________?
A. Programs
B. Macros
C. Procedures
D. All of these
Which function calculates the largest value in a set of numbers in Excel?
A. Average
B. Count
C. Minimum
D. Maximum
What displays the content of active cell?
A. Name box
B. Row headings
C. Formula bar
D. None of these
In a computer spreadsheet, block of cells is called __________ ?
A. Workbook
B. Function
C. Column
D. Range
Microsoft Excel 2019 files have a default extension of___________?
A. .Xlsx
B. .Xls
C. .excel
D. .123
In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?
A. Calculations
B. Formulas
C. Functions
D. Relative addressing
In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?
A. =LARGE(A:A, 2)
B. =LARGE(UNIQUE(A:A), 2)
C. =INDEX(SORT(UNIQUE(A:A), , -1), 2)
D. =SMALL(UNIQUE(A:A), 2)
In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?
A. TRIM
B. SUBSTITUTE
C. CLEAN
D. REPT
What is the function of Vlookup formula in Excel ?
A. VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
B. VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
C. VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
D. VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria
In Excel, Conditional formatting is in: ______________?
A. Insert Tab
B. Page layout
C. View Tab
D. Home Tab
In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?
A. Length
B. Counter
C. Count
D. None of These