Microsoft Excel Skills Assessment

Auto audio on: the next questions will be read aloud when you click Continue.

1. 1

   What is the shortcut to open the Format Cells dialog box in Excel?

   A Ctrl + O B Ctrl + 1 C Ctrl + 9
2. 2

   Which function would you use to find the average of a range of numbers?

   A SUM B COUNT C AVERAGE
3. 3

   Which of these features allows you to arrange data within a spreadsheet by specific criteria?

   A Sort B Filter C Find
4. 4

   What does the VLOOKUP function do?

   A Finds the lowest value in a range B Looks up data vertically in a column C Finds duplicate items
5. 5

   In Excel, what feature allows you to view, edit, and manage multiple worksheets within the same window?

   A Tabs B Links C Workbooks
6. 6

   How do you create a chart from a range of data in Excel?

   A Select data, then click 'Insert Chart' B Select data, then click 'Data Analysis' C Use the 'Find and Select' feature
7. 7

   Which of these is the correct formula to add cells A1 through A10?

   A =SUM(A1:A10) B =ADD(A1:A10) C =A1+A10
8. 8

   What is the function of the 'Freeze Panes' feature?

   A Apply a layer of protection to a worksheet B Lock a cell or range for editing C Keep rows or columns visible while scrolling through data
9. 9

   What is the use of the Filter feature in Excel?

   A To duplicate the data in selected cells B To display only the rows that meet specified criteria C To sort the data alphabetically
10. 10

    How do you perform a simple arithmetic operation like addition in Excel?

    A =A1+A2 B =ADDITION(A1, A2) C =ADD(A1:A2)
11. 11

    Which feature in Excel is used to create complex data models with multiple interrelated data tables?

    A Power Pivot B Conditional Formatting C Data Validation