WorksheetsExcel Basic Level QUIZ
Total questions: 45
Worksheet time: 23mins
Name
Class
Date
1.
Which of the following Ribbons appear when you open Excel?
a)
a) Home, Insert, Page Layout, Formulas, Data, Review, View
b)
b) Home, Insert, Page Setup, Formulas, Data, Review, View
c)
c) Design, Layout, Formulas, Data, Review, View
d)
d) Edit, Insert, Formatting, Data, Review, View
2.
Which of the following commands appear under the Home Ribbon?
a)
a) PivotTables, Slicers, Filters
b)
b) Insert Table, Chart, Picture
c)
c) Cell Styles, Conditional Formatting, Sort & Filter
d)
d) AutoSum, Insert Function, Name Manager
3.
Which of the following commands does the Page Layout Ribbon contain?
a)
a) Font, Alignment, Number Format
b)
b) Margins, Orientation, Page Setup
c)
c) Themes, Colors, Fonts
d)
d) Sort, Filter, Subtotal
4.
When will you use the DATA Ribbon?
a)
a) To insert charts and pictures
b)
b) To format cells and apply styles
c)
c) To perform calculations and use formulas
d)
d) To import, export, and analyze data
5.
What is the most common file extension in Excel?
a)
a) .docx
b)
b) .pptx
c)
c) .xlsx
d)
d) .pdf
6.
What is the difference between a workbook and worksheet?
a)
a) A workbook contains multiple worksheets, while a worksheet contains multiple workbooks
b)
b) A workbook is a file that contains one or more worksheets
c)
c) A worksheet is a file that contains one or more workbooks
d)
d) A workbook and a worksheet are the same thing
7.
What happens if you delete a worksheet?
a)
a) The worksheet is permanently deleted and cannot be recovered
b)
b) The worksheet is moved to the Recycle Bin and can be restored if needed
c)
c) The data in the worksheet is deleted, but the worksheet itself remains in the workbook
d)
d) Nothing happens, you cannot delete a worksheet in Excel
8.
What is the shortcut key to save a workbook/Excel file?
a)
a) Ctrl + S
b)
Alt + S
c)
c) Ctrl + C
d)
d) Ctrl + X
9.
What is the shortcut key to insert a new worksheet in a workbook?
a)
a) Ctrl + N
b)
b) Ctrl + Shift + N
c)
c) Ctrl + W
d)
d) Ctrl + Shift + W
10.
From which group can you apply number, text, and accounting formatting?
a)
a) Font
b)
b) Alignment
c)
c) Styles
d)
d) Number
11.
What is the difference between the DATE and NOW function?
a)
a) DATE returns the current date and time, while NOW returns only the current date
b)
b) DATE returns only the current date, while NOW returns the current date and time
c)
c) DATE and NOW are the same function
d)
d) Neither DATE nor NOW are functions in Excel
12.
What is the purpose of the VLOOKUP function?
a)
a) To count the number of cells that meet certain criteria
b)
b) To find the highest or lowest value in a range of cells
c)
c) To search for a specific value in the first column of a table and return a corresponding value from another column
d)
d) To calculate the average of a range of cells
13.
What is the correct syntax for the IF function?
a)
a) =IF(logical_test, value_if_true, value_if_false)
b)
b) =IF(value_if_false, value_if_true, logical_test)
c)
c) =IF(value_if_true, logical_test, value_if_false)
d)
d) =IF(logical_test, value_if_false, value_if_true)
14.
You want to count the number of cells in a range that meet a certain condition. Which formula should you use?
a)
a) =COUNTIF(range, criteria)
b)
b) =SUMIF(range, criteria)
c)
c) =AVERAGEIF(range, criteria)
d)
d) =MAXIF(range, criteria)
15.
You have a table of employee data and you want to find the salary of a specific employee based on their ID number. Which formula should you use?
a)
a) =LOOKUP(lookup_value, table_array, col_index_num)
b)
b) =MATCH(lookup_value, lookup_array, match_type)
c)
c) =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
d)
d) =HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)
16.
What is the difference between a formula and a function in Excel?
a)
a) There is no difference, the terms are interchangeable.
b)
b) A formula performs a specific task, while a function is a user-created expression.
c)
c) A function performs a specific task, while a formula is a user-created expression.
d)
d) A formula always starts with an equal sign, while a function does not.
17.
What is the main difference between COUNT and COUNTA in Excel?
a)
a) COUNT counts only cells that contain numeric values or dates, while COUNTA counts all non-empty cells.
b)
b) COUNT counts all non-empty cells, regardless of their content, while COUNTA counts only cells that contain numeric values or dates.
c)
c) COUNT counts cells with values greater than a specific number, while COUNTA counts cells with values less than a specific number.
d)
d) COUNT and COUNTA are the same function, and there is no difference between them.
18.
Which chart type would be best to display changes over time?
a)
a) Scatter chart
b)
b) Line chart
c)
c) Bar chart
d)
d) Pie chart
19.
What type of chart would be best to compare the distribution of data across different categories?
a)
a) Scatter chart
b)
b) Line chart
c)
c) Bar chart
d)
d) Pie chart
20.
What chart type would be best to display the relationship between two sets of numerical data?
a)
a) Scatter chart
b)
b) Line chart
c)
c) Bar chart
d)
d) Pie chart
21.
Which chart type would be best to display parts of a whole?
a)
a) Scatter chart
b)
b) Line chart
c)
c) Bar chart
d)
d) Pie chart
22.
Which chart type would be best to show the composition of a single data set?
a)
a) Scatter chart
b)
b) Line chart
c)
c) Bar chart
d)
d) Donut chart
23.
What are the steps to insert a chart in Excel?
a)
a) Select the Chart ribbon, click on the Insert Chart icon, and customize the chart design
b)
b) Select the Home ribbon, click on the Chart icon, and select the chart type from the drop-down menu
c)
c) Select the Data ribbon, click on the Insert Chart icon, and customize the chart design
d)
d) Select the data you want to include in the chart, select the Chart ribbon, click on the Insert Chart icon, and select the type of chart you want to use from the drop-down menu
24.
You want to copy a range of cells in Excel, but you only want to copy the values, not the formulas. What is the quickest way to do this?
a)
a) Right-click and select "Paste Values"
b)
b) Press "Ctrl + V" to paste, then select "Values" from the drop-down menu
c)
c) Press "Ctrl + Shift + V" to paste only values
d)
d) Copy the cells as usual, then select "Paste Values" from the "Paste Special" option
25.
What is the keyboard shortcut for saving an Excel file?
a)
a) Ctrl + S
b)
b) Ctrl + O
c)
c) Ctrl + P
d)
d) Ctrl + N
26.
What is the keyboard shortcut for copying cells in Excel?
a)
a) Ctrl + X
b)
b) Ctrl + C
c)
c) Ctrl + V
d)
d) Ctrl + Z
27.
What is the keyboard shortcut for pasting cells in Excel?
a)
a) Ctrl + X
b)
b) Ctrl + C
c)
c) Ctrl + V
d)
d) Ctrl + Z
28.
What is the keyboard shortcut for opening the "Find and Replace" dialog box in Excel?
a)
a) Ctrl + F
b)
b) Ctrl + H
c)
c) Ctrl + G
d)
d) Ctrl + A
29.
What is the keyboard shortcut for undoing the last action in Excel?
a)
a) Ctrl + X
b)
b) Ctrl + C
c)
c) Ctrl + V
d)
d) Ctrl + Z
30.
What is the keyboard shortcut for opening the "Go To" dialog box in Excel?
a)
a) Ctrl + F
b)
b) Ctrl + H
c)
c) Ctrl + G
d)
d) Ctrl + A
31.
What is the keyboard shortcut for formatting cells as currency in Excel?
a)
a) Ctrl + Shift + $
b)
b) Ctrl + Shift + %
c)
c) Ctrl + Shift + #
d)
d) Ctrl + Shift + @
32.
Which keyboard shortcut can you use to move to the beginning of the worksheet in Excel?
a)
A) Home
b)
B) Ctrl+Home
c)
C) Ctrl+End
d)
D) Shift+Home
33.
Which keyboard shortcut can you use to go to the last cell in your data set in Excel?
a)
a) Ctrl + Home
b)
b) Ctrl + End
c)
c) Ctrl + Alt + End
d)
d) Shift + End
34.
What information does the keyboard shortcut "Ctrl + End" provide in Excel?
a)
a) The total number of cells in the worksheet
b)
b) The row number of the last row in the data set
c)
c) The column number of the last column in the data set
d)
d) The total number of rows and columns in the data set
35.
What is the keyboard shortcut for applying a filter to a range of cells in Excel, and showing the filter menu?
a)
A) Control + F
b)
B) Control + Shift + L
c)
C) Control + Shift + F
d)
D) Control + Alt + F
36.
What are sparklines in Excel?
a)
a) Small charts that fit in a single cell
b)
b) A type of formula used for data analysis
c)
c) A type of formatting used for highlighting cells
d)
d) A tool for merging and splitting cells
37.
Which of the following types of data is best suited for a sparkline?
a)
a) Highly detailed data with many variables
b)
b) Large data sets with hundreds of rows and columns
c)
c) Simple data sets with a few variables
d)
d) Data sets with complex calculations and formulas
38.
What is the advantage of using sparklines over traditional charts in Excel?
a)
a) Sparklines allow for more detailed analysis of data
b)
b) Sparklines take up less space on the worksheet
c)
c) Sparklines can be customized with more formatting options
d)
d) Sparklines can handle larger data sets than traditional charts
39.
Which of the following types of sparklines is best suited for showing trends over time?
a)
a) Line sparklines
b)
b) Column sparklines
c)
c) Win/Loss sparklines
d)
d) Pie sparklines
40.
What is the correct way to use .CSV file in Excel?
a)
A) Simply open the .CSV file in Excel and start working with it.
b)
B) Use the Text Import Wizard to import the .CSV file into Excel.
c)
C) Convert the .CSV file into an Excel file format before opening it in Excel.
d)
D) None of the above.
41.
Which of the following statements is true about Flash Fill in Excel?
a)
A) Flash Fill is a feature that can only be used for numerical data.
b)
B) Flash Fill is a feature that automatically formats cells based on pre-defined formats.
c)
C) Flash Fill is a feature that can be used to automatically fill data based on patterns recognized by Excel.
d)
D) Flash Fill is a feature that is only available in older versions of Excel.
42.
What is the keyboard shortcut for using Flash Fill in Excel?
a)
A) Ctrl + E
b)
B) Ctrl + Shift + F
c)
C) Alt + F5
d)
D) Alt + F10
43.
How would you select non-contiguous cells?
a)
Hold Ctrl & left-click on each cell
b)
Hold Shift & left-click on each cell
c)
Right-click on each cell
d)
Hold Alt & left-click on each cell
44.
Which of the following commands doesn't affect the text font?
a)
Bold
b)
Underline
c)
Borders
d)
Italics
45.
How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?
a)
=A1x6/4
b)
=A1*6/4
c)
A1X4/6
100 %
