1301 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? Computer Science Medium Full question → 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)
1302 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? Computer Science Medium Full question → A TRIM B SUBSTITUTE C CLEAN D REPT
1303 Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling? Computer Science Medium Full question → A Lock Cells B Freeze Panes C Hide Rows/Columns D Split Window
1304 What is the function of Vlookup formula in Excel ? Computer Science Medium Full question → 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.
1305 How do you enable Caret Browsing in a browser? Computer Science Medium Full question → A Press the F7 key B Press the F5 key C Press the Ctrl key D Press the Alt key
1306 What is the purpose of Caret Browsing? Computer Science Medium Full question → 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
1307 Which of the following is a benefit of Caret Browsing? Computer Science Medium Full question → 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
1308 What is the function of a firewall in computer networking? Computer Science Medium Full question → A Monitor website traffic B Block unwanted email C Protect against unauthorized access and threats D Increase internet speed
1309 Which is an item of storage medium in the form of circular plate? Computer Science Medium Full question → A Disk B CPU C Printer D ALU
1310 In Excel, Conditional formatting is in: ______________? Computer Science Medium Full question → A Insert Tab B Page layout C View Tab D Home Tab
1311 The purpose of Thesaurus tool is used in MS word? Computer Science Medium Full question → A Grammar options B Spelling Checking C Synonyms and Antonyms D Replace
1312 In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ? Computer Science Medium Full question → A Length B Counter C Count D None of These
1313 UTP stands for Computer Science Medium Full question → A Unshielded Transmission Protocol B Unshielded Twisted Pair C Unshielded Transfer Pair D Unshielded T-line Protocol
1314 In microprocessor terminology, what does DMA stand for? Computer Science Medium Full question → A Direct Memory Access B Direct Module Access C Direct Memory Allocation D None of These
1315 What does the term “filter” refer to in Excel? Computer Science Medium Full question → A To permanently delete rows or columns B To format the appearance of cells C To temporarily hide certain data based on specific criteria D To create a chart
1316 What are the small squares arranged in rows and columns called in Excel? Computer Science Medium Full question → A Cells B Columns C Blocks D Rows
1317 Which key deletes the character to the right of the cursor in Ms Word? Computer Science Medium Full question → A End B Backspace C Home D Delete
1318 In Ms Excel Ready made templates are available under _______ tab ? Computer Science Medium Full question → A File B Insert C Design D None of Above
1319 “Ctrl + End” Shortcut key is used in Ms Word to____________? Computer Science Medium Full question → A Moves the cursor to the end of Line B Moves the cursor to the end of Document C Moves the cursor to the end of Paragraph D None of the Above
1320 A light sensitive device that converts drawing, printed text or other images into digital form is___________? Computer Science Medium Full question → A Keyboard B Scanner C OMR D None of these