Result for: Anand komiripalem
Exam Name: Excel_test
Download Result (PDF)Email: [email protected]
Total Marks: 50.0
Score: 0.0
Percentage: 0.00%
Question Answers
| Sr. No. | Question | Selected Answer | Correct Answer |
|---|---|---|---|
| 1 | Which of the following is the default file extension for Excel 2016/2019/365? | No answer selected | .xlsx |
| 2 | Which symbol is used before a formula in Excel? | No answer selected | = |
| 3 | What function adds the values in a range? | No answer selected | SUM |
| 4 | Which of the following is NOT a valid Excel data type? | No answer selected | Character |
| 5 | How do you start a new line within a cell? | No answer selected | Press Alt + Enter |
| 6 | What is the shortcut to bold text in Excel? | No answer selected | Ctrl + B |
| 7 | Which tab contains options for inserting charts in Excel? | No answer selected | Insert |
| 8 | How do you freeze the top row in Excel? | No answer selected | View > Freeze Panes > Freeze Top Row |
| 9 | What feature copies formatting from one cell to another? | No answer selected | Format Painter |
| 10 | What does the COUNT function do? | No answer selected | Counts only numbers |
| 11 | Which function returns the highest value in a range? | No answer selected | MAX |
| 12 | Which function combines text from multiple cells? | No answer selected | Both A and C |
| 13 | What is the result of =5+3*2 in Excel? | No answer selected | 11 |
| 14 | What does the IF function return? | No answer selected | Values based on a condition |
| 15 | What is the shortcut to save an Excel workbook? | No answer selected | Ctrl + S |
| 16 | What is the shortcut to insert a new worksheet? | No answer selected | Shift + F11 |
| 17 | What is the shortcut key to delete selected cells? | No answer selected | Ctrl + - (minus) |
| 18 | Which key allows you to edit the contents of a selected cell? | No answer selected | F2 |
| 19 | What is the shortcut to open the Find dialog box? | No answer selected | Ctrl + F |
| 20 | Which chart is best for showing parts of a whole? | No answer selected | Line chart |
| 21 | Where can you find the Sort & Filter options? | No answer selected | View Tab |
| 22 | Which feature is used to remove duplicate values? | No answer selected | Remove Duplicate |
| 23 | Which function returns today's date? | No answer selected | TODAY() |
| 24 | What does conditional formatting do? | No answer selected | Deletes duplicates |
| 25 | What is the default row height in Excel? | No answer selected | 15 |
| 26 | What is the maximum number of rows in Excel 2016? | No answer selected | 1,048,576 |
| 27 | Which menu is used to protect a sheet? | No answer selected | Review |
| 28 | How many worksheets are there in a new Excel file by default? | No answer selected | 1 |
| 29 | What does .CSV stand for? | No answer selected | Comma Separated Value |
| 30 | What is Flash Fill used for? | No answer selected | Predictive filling of data |
| 31 | What does AutoSum do? | No answer selected | Adds data |
| 32 | What does a red triangle in a cell corner indicate? | No answer selected | Comment is added |
| 33 | What does the Fill Handle do? | No answer selected | Fills data automatically |
| 34 | What is the name of the Excel file with macros? | No answer selected | .xlsm |
| 35 | What is the use of VLOOKUP? | No answer selected | Lookup vertical data |
| 36 | Which function returns the cell reference of a value? | No answer selected | ADDRESS |
| 37 | Which function helps to search data both vertically and horizontally? | No answer selected | XLOOKUP |
| 38 | What function returns the position of a value? | No answer selected | MATCH() |
| 39 | Which of the following is NOT a lookup function? | No answer selected | FIND |
| 40 | What is used to restrict what users can enter in a cell? | No answer selected | Data Validation |
| 41 | Which option is used to change cell number formats? | No answer selected | Format Cells |
| 42 | What does #DIV/0! mean? | No answer selected | Division by zero |
| 43 | What does #N/A indicate? | No answer selected | Value not available |
| 44 | What does Ctrl + Z do? | No answer selected | Undo |
| 45 | What is the main purpose of Data Validation in Excel? | No answer selected | To restrict the type of data entered in a cell |
| 46 | Where can you find the Data Validation feature in Excel? | No answer selected | Data tab |
| 47 | Which of the following is NOT a Data Validation option? | No answer selected | Chart |
| 48 | What can you use Data Validation for? | No answer selected | Creating drop-down lists |
| 49 | What is the primary purpose of Conditional Formatting in Excel? | No answer selected | To highlight specific cells based on rules |
| 50 | Which of the following can be highlighted using Conditional Formatting? | No answer selected | All of the above |
Page 1