101. Which of the following is a benefit of Caret Browsing?

A. It allows users to navigate through web pages quickly
B. It allows users to navigate through web pages using a keyboard
C. It allows users to navigate through web pages using a mouse
D. It allows users to navigate through web pages using a touchscreen

102. 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.

103. 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)

104. 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

105. Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling?

A. Lock Cells
B. Freeze Panes
C. Hide Rows/Columns
D. Split Window

106. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __ ?

A. Decoration
B. Data appearance
C. Functions
D. Charting

107. How do you enable Caret Browsing in a browser?

A. Press the F7 key
B. Press the F5 key
C. Press the Ctrl key
D. Press the Alt key

108. In MS-Excel__________ short cut key is used for hiding rows.

A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above

109. Which of following is not an element of computer spreadsheet interface?

A. Pencil work
B. Active cell
C. Menu bar
D. Workbook

110. What is the purpose of Caret Browsing?

A. To navigate through web pages quickly
B. To navigate through web pages using a keyboard
C. To navigate through web pages using a mouse
D. To navigate through web pages using a touchscreen