MS Excel — Set 7
Computers · MS Excel · Questions 61–70 of 80
What is the primary function of MS Excel?
Correct Answer: B. Spreadsheet and Data Analysis
MS Excel is a powerful software used for calculations, budgeting, and data organization. It organizes data in rows and columns to form a grid. It is the industry standard for financial modeling and simple accounting.
Which tab contains the 'AutoSum' button in the MS Excel ribbon?
Correct Answer: C. Home
The AutoSum button is located in the Editing group of the Home tab. It automatically creates a formula to total the numbers in a range. This is one of the most frequently used shortcuts for basic math.
What is the shortcut key for 'Saving' a workbook in Excel?
Correct Answer: B. Ctrl + S
Ctrl + S is the universal shortcut to save the progress in the current file. For 'Save As', the F12 key is used. Frequent saving helps prevent data loss during unexpected system shutdowns.
In Excel, a 'Worksheet' is a collection of?
Correct Answer: B. Cells
A worksheet is the actual grid of cells where you enter your data. One workbook can contain multiple worksheets represented by tabs at the bottom. Each sheet is independent but can be linked via formulas.
Which function is used to add the values in a specific range of cells?
Correct Answer: C. SUM
The SUM function is the most basic mathematical function in Excel. It can add individual values, cell references, or entire ranges. It automatically ignores non-numeric data in the selected range.
What is the shortcut key to 'Select All' data in the current worksheet?
Correct Answer: B. Ctrl + A
Ctrl + A selects the entire dataset if the active cell is within a table. If pressed twice, it selects the entire worksheet including empty cells. This is helpful for applying uniform formatting to the whole sheet.
How are Rows identified in an Excel worksheet?
Correct Answer: B. Numbers (1, 2, 3...)
In Microsoft Excel, Rows are identified using Numbers (1, 2, 3...) on the left side of the worksheet. The rows start from 1 and go up to 1,048,576 in modern Excel versions. Numbers are used for rows while letters (A, B, C...) are used for columns, creating a grid reference system like A1, B5, etc.
Which tool is used to quickly arrange data in a specific order, such as A to Z?
Correct Answer: C. Sort
Sorting allows users to reorganize rows based on the values in one or more columns. You can sort data numerically, alphabetically, or by date. This is essential for making sense of large lists.
What is the shortcut key to 'Find' specific text or numbers in a workbook?
Correct Answer: B. Ctrl + F
Ctrl + F opens a dialog box that allows you to search for specific content. To 'Find and Replace', the shortcut Ctrl + H is used. This is a vital tool for auditing large spreadsheets for specific entries.
Which tab allows you to add Charts and Tables to your worksheet?
Correct Answer: C. Insert
The Insert tab is the hub for adding external elements like charts, shapes, and pivot tables. It also contains tools for adding headers, footers, and hyperlinks. This tab helps in enhancing the visual appeal of data.