EXCEL TEST - 1
1. What is the primary function of Excel?______________________________________________
A) Word processing
B) Database management
C) Spreadsheets and calculations
D) Presentations
2. What is the shortcut to save a file in Excel?
A) Ctrl + S
B) Ctrl + P
C) Ctrl + C
D) Ctrl + Z
3. Which Excel function calculates the sum of a range of cells?
A) AVERAGE
B) SUM
C) COUNT
D) MAX
4. What is the purpose of the formula bar in Excel?
A) To display cell coordinates
B) To edit formulas and functions
C) To format cells
D) To insert charts
5. How do you select an entire Row in Excel?
A) Ctrl + Space
B) Shift + Space
C) Ctrl + A
D) Shift + Click
6. What is the purpose of the IF function in Excel?
A) To perform arithmetic operations
B) To perform logical tests
C) To format cells
EXCEL TEST - 1
D) To insert charts
7. How do you create a pivot table in Excel?
A) Go to Insert > PivotTable
B) Go to Data > PivotTable
C) Go to Tools > PivotTable
D) Go to Formulas > PivotTable
8. What is the function of the VLOOKUP function in Excel?
A) To look up values vertically
B) To look up values horizontally
C) To perform arithmetic operations
D) To format cells
9. Which Excel function calculates the sum of a range of cells?
A) AVERAGE
B) SUM
C) COUNT
D) MAX
10. What is the function of the MAXIFS function in Excel?
A) To return the maximum value based on multiple criteria
B) To return the minimum value based on multiple criteria
C) To perform arithmetic operations
D) To format cells
[Link] is the function of the Conditional Formatting feature in Excel?
A- To format cells based on conditions
B- To format cells based on formulas
C- To format cells based on values
D- To format cells based on formatting
EXCEL TEST - 1
12. What is the function of the FILTER function in Excel?
A) To filter data based on criteria
B) To filter data based on formulas
C) To perform arithmetic operations
D) To format cells
13. What is the function of the IFS function in Excel?
A) To test multiple conditions
B) To test single conditions
C) To perform arithmetic operations
D) To format cells
14. How do you create a bar chart?
A) Insert > Bar chart
B) Insert > Pie chart
C) Insert > Line chart
D) Insert > Scatter chart
15. What is the purpose of the "Filter" feature?
A) Filters data
B) Sorts data
C) Groups data
D) Analyzes data
16. How do you reference a cell in another worksheet?
A) =SheetName!CellReference
B) =WorkbookName!CellReference
C) =Range!CellReference
D) =CellReference!SheetName
17. How do you select an entire column in Excel?
EXCEL TEST - 1
A) Ctrl+Space
B) Shift+Space
C) Ctrl+A
D) Ctrl+Shift+Space
18. What is the shortcut to Save As a workbook in Excel?
A) Ctrl+Shift+S
B) Ctrl+s
C) F12
D) F11
19. How do you create a pivot table in Excel?
A) Go to Insert > PivotTable
B) Go to Data > PivotTable
C) Go to Tools > PivotTable
D) Go to Formulas > PivotTable
20. What is the function of the HLOOKUP function in Excel?
A) To look up values vertically
B) To look up values horizontally
C) To perform arithmetic operations
D) To format cells
[Link] is the shortcut to undo an action in Excel?
A-Ctrl + Z
B-Ctrl + Y
A-Ctrl + X
A-Ctrl +Shift+ Y
22. What is the shortcut to select all cells in Excel?
A) Ctrl + A
B) Ctrl + Shift + A
C) Ctrl + Alt + A
D) Ctrl + Space
23. How do you create a dropdown list in Excel?
A-Using the Data Validation feature
B- Using the Formula Bar
C-Using the Chart Wizard
D-Using Conditional Formatting
EXCEL TEST - 1
24. Choose from the following which is not the correct method editing the excel the cell content?
A- Press the alt key
B- press the F2 key
C- Double click the cell
D-Click the formula bar
25. What type of chart is good for single series of data?
A- Column chart
B-Line chart
C- Pie chart
D-Cone chart
26. An excel workbook is a collection of?
A- workbook
B- Worksheet
C-chart
D-worksheet chart sheet
27-In order to perform a calculation in a spreadsheet you need to use ?
A- Table
B- Formula
C- Field
D- Variable
28-What function displays row data in a column or column data in row?
A-Drawing
B-Index
C-Row
D-Transpose
29-How are data organized ina spreadsheet?
A-Lines and spaces
B-Layers and planes
C-Row and columns
D-Height and width
30-_____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE
otherwise.
A) OR
B) AND
C) IF
D) ANDIF