Create a homework in a form of a quiz. The academic subject for which the text must be created - Computer science. It should be for students...
←
→
HomeworkCreate a homework in a form of a quiz
Which subjectComputer science
What age groupAdult courses
What topicExcel
Question typesMixed
Number of questions20
Number of answers4
Correct answersExactly 1
Show correct answers
Use images (descriptions)
Any other preferences

Welcome to the Excel Quiz. This quiz contains 20 questions, each worth 5 points. Read each question carefully and select the correct answer from the given choices. Good luck!

  1. What is the keyboard shortcut for "copy" in Excel? A. Ctrl+C B. Ctrl+V C. Ctrl+X D. Ctrl+Z

  2. How do you freeze a row or column in Excel? A. Select the row or column, go to "View" tab and click on "Freeze Panes" B. Right-click on the row or column, select "Freeze Panes" C. Press F1 D. Go to "Format" tab and select "Freeze Panes"

  3. What is conditional formatting in Excel used for? A. To format numbers with decimals B. To highlight cells that meet a certain criteria C. To convert text to numbers D. To change font styles

  4. What function is used to find the highest value in a range of cells in Excel? A. MAX B. MIN C. AVERAGE D. COUNT

  5. What is the difference between filtering and sorting in Excel? A. Filtering rearranges the data, while sorting removes data from the worksheet. B. Filtering removes data from the worksheet, while sorting rearranges the data. C. Both sorting and filtering rearrange the data, but sorting is used to sort alphabetically and filtering is used to filter by a set of criteria. D. There is no difference between sorting and filtering in Excel.

  6. What is a chart in Excel used for? A. To create a table B. To store data C. To organize multiple worksheets D. To visualize data

  7. What is the function of the "SUM" function in Excel? A. To find the average of a range of cells B. To add up values in a range of cells C. To find the highest value in a range of cells D. To count the number of cells in a range

  8. How do you insert a new worksheet in Excel? A. Right-click on a worksheet and select "Insert" B. Go to "File" tab and select "Insert Worksheet" C. Press F1 D. There is no way to insert a new worksheet in Excel.

  9. What is a pivot table in Excel used for? A. To sort data alphabetically B. To format cells in a worksheet C. To combine and summarize large amounts of data D. To insert hyperlinks in a worksheet

  10. What is the function of the "COUNTIF" function in Excel? A. To count the number of cells in a range B. To find the highest value in a range of cells C. To add up values in a range of cells D. To count the number of cells in a range that meet a certain criteria

  11. What is a cell reference in Excel? A. A reference to a cell that is outside of the worksheet B. A reference to a cell within the same worksheet C. A reference to a cell on a different worksheet D. There is no such thing as a cell reference in Excel.

  12. How do you create a line graph in Excel? A. Select the data to be graphed and go to "Insert" tab, then select "Line Graph" B. Right-click on the worksheet and select "Chart" C. Press F1 D. There is no way to create a line graph in Excel.

  13. What is a function in Excel? A. A way to format cells in a worksheet B. A way to store data in Excel C. A prewritten formula that performs a particular calculation D. A way to insert pictures in a worksheet

  14. What is the keyboard shortcut for "paste" in Excel? A. Ctrl+C B. Ctrl+V C. Ctrl+X D. Ctrl+Z

  15. How do you merge two cells in Excel? A. Select the two cells, right-click and select "Merge Cells" B. Go to "Format" tab and select "Merge Cells" C. Press F1 D. There is no way to merge cells in Excel.

  16. What is the function of the "VLOOKUP" function in Excel? A. To count the number of cells in a range B. To find the highest value in a range of cells C. To add up values in a range of cells D. To search for a value in a table and return a corresponding value

  17. How do you insert a new column in Excel? A. Right-click on a column and select "Insert" B. Go to "File" tab and select "Insert Column" C. Press F1 D. There is no way to insert a new column in Excel.

  18. What is the "IF" function in Excel used for? A. To format cells in a worksheet B. To convert text to numbers C. To create a range of numbers D. To evaluate a condition and return one value if the condition is true, and another value if the condition is false

  19. What is the purpose of the "AutoFill" feature in Excel? A. To automatically create tables B. To automatically enter a series of numbers or dates C. To filter a range of cells D. To save a copy of a worksheet

  20. How do you change the width of a column in Excel? A. Select the column, go to "View" tab and drag the column boundary to adjust the width B. Right-click on the column and select "Width" C. Press F1 D. There is no way to change the width of a column in Excel.